示例#1
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            for (int i = 0; i < GridView1.Rows.Count; i++)
            {
                CheckBox chk = ((CheckBox)(GridView1.Rows[i].FindControl("CheckBox1")));
                if (chk.Checked)
                {
                    GridViewRow gr = GridView1.Rows[i];
                    int id_1 = int.Parse(((Label)(gr.FindControl("Label1"))).Text);
                    int id = int.Parse(((Label)(gr.FindControl("Label3"))).Text);
                    int x = int.Parse(((Label)(gr.FindControl("Label2"))).Text);
                    order_dealer_keeper odk = new order_dealer_keeper();
                    odk.update_status(id_1);
                    dealer_manager dm = new dealer_manager();
                    dealer_keeper dk = new dealer_keeper();
                    int v = dm.add_cylinder(id, x);
                    dk.update_count(id); 
                    GetData();
                    SetData();

                }
            }
        }
        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            TextBox count = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].FindControl("TextBox1")));
            ((DataSet)Session["ds"]).Tables[0].Rows[e.RowIndex][6] = int.Parse (count.Text);

            TextBox idn = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].FindControl("TextBox2")));
            ((DataSet)Session["ds"]).Tables[0].Rows[e.RowIndex][0] = int.Parse(idn.Text);

            int x = int.Parse(count.Text);
            int id = int.Parse(idn.Text);

            dealer_keeper dk = new dealer_keeper ();
            dealer_class dc = dk.GetFullDealerData(id);

            if (x < dc._stock_no)
            {
                Label3.Text = "Error! Cannot update lesser amount!";
            }
            else
            {
                x = x - dc._stock_no; 
                dealer_manager dm = new dealer_manager();
                int v = dm.add_cylinder(id, x);
                dk.update_count(id); 
                if (v == 0) Label3.Text = "Sorry. Stock Empty! Refill Stock Now!";
                else
                {

                    SqlCommandBuilder cb = new SqlCommandBuilder((SqlDataAdapter)Session["da"]);
                    ((SqlDataAdapter)Session["da"]).Update((DataSet)Session["ds"], "dealer");
                }
            }
            GetData(Session["city"].ToString());
            GridView1.EditIndex = -1;
            SetData();

        }