예제 #1
0
        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();

        }
예제 #2
0
        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();
                    }
                }
            }
        }