namespace StudioManagement
{
    public partial class updatestudio : Form
    {
        public updatestudio()
        {
            InitializeComponent();
        }
        private readonly inter _form1;
        public updatestudio(inter form1)
        {
            _form1 = form1;
            InitializeComponent();

        }
        string sno, name, c1, c2, c3,t1,t2,t3;
        DateTime tdate, ddate;
        int amt = 0, paid, dues, piece, rate;
        Boolean dorn=false;

        OleDbConnection connect = new OleDbConnection();
        private void torder_Click(object sender, EventArgs e)
        {
            sno = comboBox2.Text;
            name = textBox2.Text;
            tdate = Convert.ToDateTime(dateTimePicker1.Text);
            ddate = Convert.ToDateTime(dateTimePicker2.Text);
            c1 = textBox1.Text;
            c2 = comboBox1.Text;
            c3 = textBox6.Text;
            rate =Convert.ToInt32(textBox3.Text);
            piece = Convert.ToInt32(textBox4.Text);
            paid = Convert.ToInt32(textBox5.Text);
            amt = Convert.ToInt32(label12.Text);
            dues = Convert.ToInt32(label13.Text);


            try
            {

                //OleDbCommand cmd1 = new OleDbCommand("UPDATE studios SET ddate=@ddate,dorn=@dorn WHERE Serialno=@sno");
                OleDbCommand cmd1 = new OleDbCommand("UPDATE studios SET name=@pname,tdate=@tdate,ddate=@ddate,c1=@c1,c2=@c2,c3=@c3,rate=@rate,piece=@piece,amt=@amt,paid=@paid,dues=@dues,dorn=@dorn WHERE Serialno=@sno");
                //OleDbCommand cmd = new OleDbCommand();


                cmd1.Parameters.Add("@pname", OleDbType.VarChar).Value = name;
                cmd1.Parameters.Add("@tdate", OleDbType.Date).Value = tdate;
                cmd1.Parameters.Add("@ddate", OleDbType.Date).Value = ddate;
                cmd1.Parameters.Add("@c1", OleDbType.VarChar).Value = c1;
                cmd1.Parameters.Add("@c2", OleDbType.VarChar).Value = c2;
                cmd1.Parameters.Add("@c3", OleDbType.VarChar).Value = c3;
                cmd1.Parameters.Add("@rate", OleDbType.Integer).Value = rate;
                cmd1.Parameters.Add("@piece", OleDbType.Integer).Value = piece;
                cmd1.Parameters.Add("@amt", OleDbType.Integer).Value = amt;
                cmd1.Parameters.Add("@paid", OleDbType.Integer).Value = paid;
                cmd1.Parameters.Add("@dues", OleDbType.Integer).Value = dues;
                cmd1.Parameters.Add("@dorn", OleDbType.Boolean).Value = dorn;
                cmd1.Parameters.Add("@sno", OleDbType.VarChar).Value = sno;

                cmd1.Connection = connect;
                cmd1.Connection.Open();
                cmd1.ExecuteNonQuery();
                cmd1.Dispose();
                connect.Close();
                MessageBox.Show("Record has been updated successfully", "Updated", MessageBoxButtons.OK);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            _form1.on_update();
        }

        private void updatestudio_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'studioManagementDataSet.studios1' table. You can move, or remove it, as needed.
            this.studios1TableAdapter.Fill(this.studioManagementDataSet.studios1);

        }

        private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
        {
            connect.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\access\studio.mdb";
            OleDbCommand com = new OleDbCommand();

            com.Connection = connect;
            com.Connection.Open();
            com.CommandText = "SELECT * FROM studios";
            OleDbDataReader rs = com.ExecuteReader();
            try
            {
                while (rs.Read())
                {
                    if (rs.GetString(0) == comboBox2.Text)
                    {

                        textBox2.Text = rs.GetString(1);
                        dateTimePicker1.Value = rs.GetDateTime(2);
                        dateTimePicker2.Value = rs.GetDateTime(3);
                        textBox1.Text = rs.GetString(4);
                        comboBox1.Text = rs.GetString(5);
                        textBox6.Text = rs.GetString(6);
                        textBox3.Text = rs.GetString(7);
                        textBox4.Text = rs.GetString(8);
                        label12.Text = Convert.ToString(rs.GetInt32(9));
                        textBox5.Text = Convert.ToString(rs.GetInt32(10));
                        label13.Text = Convert.ToString(rs.GetInt32(11));
                        deliver.Checked = rs.GetBoolean(12);


                    }

                }
                rs.Close();
                com.Dispose();

                connect.Close();

            }
            catch (Exception ex) { }
        }

        private void deliver_CheckedChanged(object sender, EventArgs e)
        {
            if (deliver.Checked == true)
                dorn = true;
            else
                dorn = false;
        }

        private void dateTimePicker2_ValueChanged(object sender, EventArgs e)
        {
            ddate = Convert.ToDateTime(dateTimePicker2.Text);
        }
    }
}