protected void confirmbtb_Click(object sender, EventArgs e) { try { PizzaDbEntities db = new PizzaDbEntities(); //Checking if user already exists User_Table exist = (from x in db.User_Table where x.UserName == nametxt.Text select x).FirstOrDefault(); if (exist != null) { alertlbl.Text = "username already exist"; } //Getting the user information from the user else { User_Table ob = new User_Table(); ob.UserName = nametxt.Text; ob.Phono = phonotxt.Text; ob.Password = passwordtxt.Text; ob.Address = addtext.Text; db.User_Table.Add(ob); db.SaveChanges(); Response.Redirect("Login.aspx"); } } catch (Exception) { Response.Redirect("UserError.aspx"); } }
/// <summary> /// Updating the delivered orders /// </summary> protected void confirmbtn_Click(object sender, EventArgs e) { PizzaDbEntities db = new PizzaDbEntities(); var name = Session["name"].ToString(); Cart_Table c = new Cart_Table(); var ob1 = (from a in db.Cart_Table where a.State == 1 && a.Username == name select a); foreach (var item in ob1) { item.State = 0; } db.SaveChanges(); Response.Redirect("Final.aspx"); }
/// <summary> /// Adding the datas to the cart_table /// </summary> protected void addtochatrbtn_Click(object sender, EventArgs e) { var name = Session["name"].ToString(); int id; int.TryParse(DropDownList1.SelectedValue, out id);//To know the id of selected pizza if (id == 0) { alertlbl.Text = "please select pizza name!!!"; } else { var pname = Session["pizzaname"].ToString(); Cart_Table ob = new Cart_Table(); //Getting the details of the pizza Pizza_Table ob2 = (from y in db.Pizza_Table where y.PizzaName == pname select y).FirstOrDefault(); //Getting the details if the pizza was earlier selected Cart_Table ob3 = (from z in db.Cart_Table where z.Pizza_Table.PizzaName == pname && z.Username == name && z.State == 1 select z).FirstOrDefault(); //If pizza name already present if (ob3 != null) { ob3.Quantity = Convert.ToInt32(quantitytxt.Text) + ob3.Quantity; ob3.Amount = ob3.Quantity * ob2.PizzaPrice; } //If same pizza does not exist else { ob.Username = Session["name"].ToString(); ob.PizzaId = ob2.PizzaId; ob.Quantity = Convert.ToInt32(quantitytxt.Text); ob.Amount = ob.Quantity * ob2.PizzaPrice; ob.State = 1; db.Cart_Table.Add(ob); } // adding the details to the cart db.SaveChanges(); Response.Redirect("Confirm.aspx"); } }