using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace wardia
{
    public partial class BrowseReport : Form
    {
        public BrowseReport()
        {
            InitializeComponent();
        }
        DataSet dataset1 = new DataSet();
        private void button1_Click(object sender, EventArgs e)
        {

            sqlCommand1.Connection = sqlConnection1;
            sqlCommand1.CommandType = CommandType.StoredProcedure;

            sqlCommand1.CommandText = "browsereport";
            sqlConnection1.Open();
            sqlCommand1.Parameters.Clear();
            
            SqlParameter p1 = new SqlParameter("@period", SqlDbType.NVarChar, 50);
            p1.Direction = ParameterDirection.Output;
            sqlCommand1.Parameters.Add(p1);
            SqlParameter p2 = new SqlParameter("@wardia_date", SqlDbType.NVarChar, 50);
            p2.Direction = ParameterDirection.Output;
            sqlCommand1.Parameters.Add(p2);
            



            
            p1.Value = comboBox1.Text;
            p2.Value = dateTimePicker1.Value.ToLongDateString();
            SqlDataAdapter da = new SqlDataAdapter(sqlCommand1.CommandText, sqlConnection1);
            da.Fill(dataset1, "wardiatable");
            dataGridView1.DataSource = dataset1;
            dataGridView1.DataMember = "wardiatable";
            dataGridView1.Columns[0].HeaderText = "اسم الآلة";
            dataGridView1.Columns[1].HeaderText = "جاهزية الآلة";
            dataGridView1.Columns[2].HeaderText = "ملاحظات";
            dataGridView1.Columns[0].Width = 300;
            dataGridView1.Columns[1].Width = 150;
            dataGridView1.Columns[2].Width = 400;
            sqlConnection1.Close();

        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void BrowseReport_Load(object sender, EventArgs e)
        {
             

        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
             
                   
                    
                
        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}