示例#1
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            string             iname = Session["id"].ToString();
            Database1Entities4 db    = new Database1Entities4();
            Item_DB            it    = db.Item_DB.Where(i => i.I_name == iname).FirstOrDefault <Item_DB>();

            if (it != null)
            {
                Session["iid"]  = it.I_id;
                Session["ccid"] = it.cc_id;

                float finalcost;

                float dcost = (float)it.i_cost - (float)((it.i_cost) * (it.i_discount)) / (100);
                finalcost = (float)(Int32.Parse(TextBox1.Text)) + dcost;
                int exd = Int32.Parse(TextBox1.Text) / 30;
                Label3.Text      = "Your final amount after discount is : " + finalcost.ToString();
                Session["fcost"] = finalcost.ToString();
                DateTime t  = System.DateTime.Today;
                DateTime nt = t.AddDays(exd + 1);
                Session["ddate"] = nt.ToShortDateString();

                Label4.Text     = "Estimated Date of delivery: " + nt.ToShortDateString();
                Button2.Enabled = true;
            }
        }
示例#2
0
        protected void Button2_Click(object sender, EventArgs e)
        {
            Database1Entities4 db = new Database1Entities4();

            string date = Session["ddate"].ToString();
            string iid  = Session["iid"].ToString();

            order_details od = new order_details();

            od.i_id     = Session["iid"].ToString();
            od.cc_id    = Session["ccid"].ToString();
            od.c_id     = Session["cid"].ToString();
            od.o_status = "In Process";
            od.o_date   = Session["ddate"].ToString();
            od.o_cost   = Session["fcost"].ToString();
            db.order_details.Add(od);
            db.SaveChanges();

            // Database1Entities4 db1 = new Database1Entities4();
            Item_DB it  = db.Item_DB.Where(i => i.I_id == iid).FirstOrDefault <Item_DB>();
            int     iq  = it.i_quantity;
            int     niq = iq - 1;

            it.i_quantity = niq;

            db.SaveChanges();
            //Label5.Text = iq.ToString();
            //Label6.Text = niq.ToString();

            Button3.Visible = true;
            Label5.Text     = "Your order place successfully";
            Label6.Text     = "your order id is:" + od.o_id.ToString();
            Button1.Enabled = false;
            Button4.Visible = true;
        }
示例#3
0
        protected void Button2_Click(object sender, EventArgs e)
        {
            Database1Entities4 db = new Database1Entities4();
            Item_DB            i  = db.Item_DB.Where(it1 => it1.I_id == TextBox1.Text).FirstOrDefault <Item_DB>();

            if (i == null)
            {
                Item_DB it = new Item_DB();
                it.I_id          = TextBox1.Text;
                it.I_name        = TextBox2.Text;
                it.I_description = TextBox3.Text;
                it.cc_id         = TextBox8.Text;
                it.i_cost        = Int32.Parse(TextBox4.Text);
                it.i_discount    = Int32.Parse(TextBox5.Text);
                it.i_status      = TextBox9.Text;
                it.i_quantity    = Int32.Parse(TextBox6.Text);
                it.i_company     = TextBox7.Text;
                it.i_imagepath   = TextBox10.Text;
                db.Item_DB.Add(it);
                db.SaveChanges();

                Label13.Text    = "Item inserted sucessfully";
                Button3.Enabled = true;
                Button4.Enabled = true;
            }
            else
            {
                Label13.Text = "Item ID is already taken for another Item take another one for this";
            }
        }