public ActionResult Edit(int id) { lab6_2.Areas.admin.Models.shopEntities db = new Models.shopEntities(); lab6_2.Areas.admin.Models.Product item = db.Product.Find(id); ViewBag.item = item; return(View()); }
public ActionResult Del(int id) { var product = new lab6_2.Areas.admin.Models.Product() { Id = id }; lab6_2.Areas.admin.Models.shopEntities db = new Models.shopEntities(); db.Product.Attach(product); db.Product.Remove(product); db.SaveChanges(); return(RedirectToAction("/admin/Shop/Index")); }
public ActionResult Index(String search = "", String order = "") { lab6_2.Areas.admin.Models.shopEntities db = new Models.shopEntities(); List <lab6_2.Areas.admin.Models.Product> lst = null; if (search == "") { switch (order) { case "Id": lst = db.Product.OrderBy(m => m.Id).ToList(); break; case "Name": lst = db.Product.OrderBy(m => m.Name).ToList(); break; case "Price": lst = db.Product.OrderBy(m => m.Price).ToList(); break; default: lst = db.Product.OrderBy(m => m.StockNum).ToList(); break; } } else { switch (order) { case "Id": lst = db.Product.Where(m => m.Name.Contains(search)).OrderBy(m => m.Id).ToList(); break; case "Name": lst = db.Product.Where(m => m.Name.Contains(search)).OrderBy(m => m.Name).ToList(); break; case "Price": lst = db.Product.Where(m => m.Name.Contains(search)).OrderBy(m => m.Price).ToList(); break; default: lst = db.Product.Where(m => m.Name.Contains(search)).OrderBy(m => m.StockNum).ToList(); break; } } ViewBag.lst = lst; ViewBag.search = search; return(View()); }
public ActionResult Check(string LoginName, string PWD) { lab6_2.Areas.admin.Models.shopEntities db = new Models.shopEntities(); List <lab6_2.Areas.admin.Models.User> lst = db.User.Where(m => m.LoginName == LoginName && m.PWD == PWD).ToList(); if (lst.Count >= 1) { FormsAuthentication.SetAuthCookie(LoginName, false); return(Redirect("/admin/Shop/Index")); } else { return(Redirect("/admin/Login/Index?message=error")); } }
public ActionResult EditSave(decimal Price, string ProductName, int Amount, int ProductId) { lab6_2.Areas.admin.Models.shopEntities db = new Models.shopEntities(); lab6_2.Areas.admin.Models.Product item = db.Product.Find(ProductId); item.Name = ProductName; item.Price = Price; item.StockNum = Amount; var file = Request.Files["pic"]; if (file.ContentLength != 0) { String path = Server.MapPath("/upload/"); String filepath = Guid.NewGuid().ToString() + ".jpg"; System.IO.File.Delete(path + item.Pic); file.SaveAs(path + filepath); item.Pic = filepath; } db.SaveChanges(); return(RedirectToAction("/admin/Shop/Index")); }