namespace StudioManagement
{
    public partial class changestudio : Form
    {
        public changestudio()
        {
            InitializeComponent();
        }

        private void changestudio_Load(object sender, EventArgs e)
        {
            StudioManagementDataSetTableAdapters.passrateTableAdapter prta = new StudioManagementDataSetTableAdapters.passrateTableAdapter();
           btn8pp.Text= Convert.ToString(prta.getpassrate("8pp"));
           btn12pp.Text = Convert.ToString(prta.getpassrate("12ppTT"));
           btn15pp.Text = Convert.ToString(prta.getpassrate("15pp"));
           btn30pp.Text = Convert.ToString(prta.getpassrate("30pp"));
           btn17pp.Text = Convert.ToString(prta.getpassrate("17ppTT"));
           btn4b2.Text = Convert.ToString(prta.getpassrate("4b2"));
           btn8b2.Text = Convert.ToString(prta.getpassrate("8b2"));
           btn8b24.Text = Convert.ToString(prta.getpassrate("8b2(4*6)"));


            StudioManagementDataSetTableAdapters.orderrateTableAdapter orta= new StudioManagementDataSetTableAdapters.orderrateTableAdapter();
            btnpco.Text=Convert.ToString(orta.getorderrate("pc"));
            btn4o.Text = Convert.ToString(orta.getorderrate("4*6"));
            btn5o.Text = Convert.ToString(orta.getorderrate("5*7"));
            btn6o.Text = Convert.ToString(orta.getorderrate("6*9"));
            btn8o.Text = Convert.ToString(orta.getorderrate("8*12"));
            btn10o.Text = Convert.ToString(orta.getorderrate("10*15"));
            btn12o.Text = Convert.ToString(orta.getorderrate("12*15"));
            btn24o.Text = Convert.ToString(orta.getorderrate("20*24"));
            btn30o.Text = Convert.ToString(orta.getorderrate("20*30"));

            StudioManagementDataSetTableAdapters.bigrateTableAdapter brta = new StudioManagementDataSetTableAdapters.bigrateTableAdapter();
            btnpcbp.Text=Convert.ToString(brta.getbprate("pc"));
            btn4bp.Text = Convert.ToString(brta.getbprate("4*6"));
            btn5bp.Text = Convert.ToString(brta.getbprate("5*7"));
            btn6bp.Text = Convert.ToString(brta.getbprate("6*9"));
            btn8bp.Text = Convert.ToString(brta.getbprate("8*12"));


        }

        private void button1_Click(object sender, EventArgs e)
        {
            this.passrateTableAdapter1.updatepass(Convert.ToInt32(btn8pp.Text), "8pp");
            this.passrateTableAdapter1.updatepass(Convert.ToInt32(btn12pp.Text), "12ppTT");
            this.passrateTableAdapter1.updatepass(Convert.ToInt32(btn15pp.Text), "15pp");
            this.passrateTableAdapter1.updatepass(Convert.ToInt32(btn30pp.Text), "30pp");
            this.passrateTableAdapter1.updatepass(Convert.ToInt32(btn17pp.Text), "17ppTT");
            this.passrateTableAdapter1.updatepass(Convert.ToInt32(btn4b2.Text), "4b2");
            this.passrateTableAdapter1.updatepass(Convert.ToInt32(btn8b2.Text), "8b2");
            this.passrateTableAdapter1.updatepass(Convert.ToInt32(btn8b24.Text), "8b2(4*6)");
            MessageBox.Show("Record has been updated successfully", "UPDATED", MessageBoxButtons.OK);
        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.orderrateTableAdapter1.updateorder(Convert.ToInt32(btnpco.Text), "pc");
            this.orderrateTableAdapter1.updateorder(Convert.ToInt32(btn4o.Text), "4*6");
            this.orderrateTableAdapter1.updateorder(Convert.ToInt32(btn5o.Text), "5*7");
            this.orderrateTableAdapter1.updateorder(Convert.ToInt32(btn6o.Text), "6*9");
            this.orderrateTableAdapter1.updateorder(Convert.ToInt32(btn8o.Text), "8*12");
            this.orderrateTableAdapter1.updateorder(Convert.ToInt32(btn10o.Text), "10*15");
            this.orderrateTableAdapter1.updateorder(Convert.ToInt32(btn12o.Text), "12*15");
            this.orderrateTableAdapter1.updateorder(Convert.ToInt32(btn24o.Text), "20*24");
            this.orderrateTableAdapter1.updateorder(Convert.ToInt32(btn30o.Text), "20*30");
            MessageBox.Show("Record has been updated successfully", "UPDATED", MessageBoxButtons.OK);

        }

        private void button3_Click(object sender, EventArgs e)
        {
            this.bigrateTableAdapter1.updatebp(Convert.ToInt32(btnpcbp.Text), "pc");
            this.bigrateTableAdapter1.updatebp(Convert.ToInt32(btn4bp.Text), "4*6");
            this.bigrateTableAdapter1.updatebp(Convert.ToInt32(btn5bp.Text), "5*7");
            this.bigrateTableAdapter1.updatebp(Convert.ToInt32(btn6bp.Text), "6*9");
            this.bigrateTableAdapter1.updatebp(Convert.ToInt32(btn8bp.Text), "8*12");
            MessageBox.Show("Record has been updated successfully", "UPDATED", MessageBoxButtons.OK);
        }
    }
}