protected void Remv_Click(object sender, EventArgs e) { bool t = true; ShoppingDbEntities2 db = new ShoppingDbEntities2(); User user = new User(); var us = from u in db.Users select u; List <User> users = us.ToList(); foreach (var r in users) { if (r.email == em.Value.ToString()) { t = false; db.Users.Attach(r); db.Users.Remove(r); db.SaveChanges(); Lab.ForeColor = System.Drawing.Color.Green; Lab.Text = "User Successfully Removed"; break; } } if (t == true) { Lab.ForeColor = System.Drawing.Color.Red; Lab.Text = "User not Found"; } }
protected void Button1_Click(object sender, EventArgs e) { ShoppingDbEntities2 db = new ShoppingDbEntities2(); bool t = false; var users = from user in db.Users select user; List <User> us = users.ToList(); foreach (var r in us) { if (r.email == em.Value.ToString()) { r.groupid = 1; t = true; Lab.ForeColor = System.Drawing.Color.Green; db.SaveChanges(); Lab.Text = "User Successfully Become Admin"; break; } } if (t == false) { Lab.ForeColor = System.Drawing.Color.Red; Lab.Text = "Sorry It is not an Existing Email"; } }
protected void Button1_Click(object sender, EventArgs e) { if (Page.IsValid) //shoud pass all validation controls { ShoppingDbEntities2 db = new ShoppingDbEntities2(); User user = new User(); user.username = Text1.Value.ToString(); user.fullname = Text2.Value.ToString(); user.email = Text3.Value.ToString(); user.password = Password1.Value.ToString(); user.groupid = 0; db.Users.Add(user); db.SaveChanges(); Label1.ForeColor = System.Drawing.Color.Green; Label1.Text = "Successfully Data Saved"; Text1.Value = ""; Text2.Value = ""; Text3.Value = ""; } else //not run because javascript run in browser should disabled { Label1.ForeColor = System.Drawing.Color.Red; Label1.Text = "Sorry Data not Saved"; } }
protected void Button1_Click(object sender, EventArgs e) { bool t = true; ShoppingDbEntities2 db = new ShoppingDbEntities2(); Product prod = new Product(); if (DropDownList1.SelectedValue.ToString() == "T-Shirts") { prod.catID = 1; } else if (DropDownList1.SelectedValue.ToString() == "Shirts") { prod.catID = 2; } else if (DropDownList1.SelectedValue.ToString() == "Trousers") { prod.catID = 3; } else if (DropDownList1.SelectedValue.ToString() == "Shorts") { prod.catID = 4; } prod.price = Convert.ToDecimal(pricc.Value.ToString()); prod.imageName = Tex1.Value.ToString(); var Prod = from pro in db.Products select pro; List <Product> prodc = Prod.ToList(); foreach (var r in prodc) { if (r.price == prod.price && r.imageName == prod.imageName && r.catID == prod.catID) { t = false; db.Products.Attach(r); db.Products.Remove(r); db.SaveChanges(); Labe.ForeColor = System.Drawing.Color.Green; Labe.Text = "Product Successfully Removed"; break; } } if (t == true) { Labe.ForeColor = System.Drawing.Color.Red; Labe.Text = "Product not Removed"; } }
protected void Button1_Click(object sender, EventArgs e) { if (FileUpload1.HasFile) { FileUpload1.PostedFile.SaveAs(Server.MapPath("~/Images/") + FileUpload1.FileName); ShoppingDbEntities2 db = new ShoppingDbEntities2(); Product prod = new Product(); prod.description = Tex1.Value.ToString(); if (DropDownList1.SelectedValue.ToString() == "T-Shirts") { prod.catID = 1; } else if (DropDownList1.SelectedValue.ToString() == "Shirts") { prod.catID = 2; } else if (DropDownList1.SelectedValue.ToString() == "Trousers") { prod.catID = 3; } else if (DropDownList1.SelectedValue.ToString() == "Shorts") { prod.catID = 4; } prod.price = Convert.ToDecimal(pricc.Value.ToString()); prod.imageName = FileUpload1.FileName.ToString(); db.Products.Add(prod); db.SaveChanges(); Labe.ForeColor = System.Drawing.Color.Green; Labe.Text = "Product Successfully Added"; } else { Labe.ForeColor = System.Drawing.Color.Red; Labe.Text = "Sorry no file uploaded"; } }