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(); }
protected void Page_Load(object sender, EventArgs e) { if (Session.IsNewSession) { Response.Redirect("~/cust_login.aspx"); } else { if (!IsPostBack) { if (Session["logged"] == null) { Session["logged"] = 0; Session["user"] = ""; Session["user_id"] = 0; } if (int.Parse(Session["logged"].ToString()) == 1) { user.Text = Session["user"].ToString(); TextBox1.Text = Session["user_id"].ToString(); customer_keeper ck = new customer_keeper(); customer_class cc = ck.GetData(int.Parse(Session["user_id"].ToString())); Label3.Text = cc._renewal.ToString(); Label5.Text = cc._subsidy_count.ToString(); Label7.Text = cc._booking_count.ToString(); dealer_keeper dk = new dealer_keeper(); dealer_class dc = dk.GetFullDealerData(cc._dealer_id); Label9.Text = dc._name.ToString() + ", " + dc._city + ", " + dc._state; GetData(int.Parse(Session["user_id"].ToString())); SetData(); } } } }