public ActionResult Edit(Models.Product data) { if (ModelState.IsValid) { using (Models.cartEntities _db = new Models.cartEntities()) { var result = (from s in _db.Products where s.Id == data.Id select s).First(); result.Name = data.Name; result.Description = data.Description; result.CategoryId = data.CategoryId; result.Price = data.Price; result.PublishDate = data.PublishDate; result.Status = data.Status; result.DefaultImageId = data.DefaultImageId; result.Quantity = data.Quantity; try { _db.SaveChanges(); } catch (Exception ex) { throw; } TempData["ResultMessage"] = String.Format("{0}修改成功", data.Name); return(RedirectToAction("Index")); } } else { return(View(data)); } }
public ActionResult Index() { List <Models.Product> product = new List <Models.Product>(); using (Models.cartEntities _db = new Models.cartEntities()) { product = (from s in _db.Products select s).ToList(); } return(View(product)); }
// GET: Product public ActionResult Index() { List <Models.Product> result = new List <Models.Product>(); ViewBag.ResultMessage = TempData["ResultMessage"]; ViewBag.ResultError = TempData["ResultError"]; using (Models.cartEntities _db = new Models.cartEntities()) { result = (from s in _db.Products select s).ToList(); return(View(result)); } }
public ActionResult Edit(int id) { //連接model 資料庫(Object service) using (Models.cartEntities _db = new Models.cartEntities()) { var result = (from s in _db.Products where s.Id == id select s).FirstOrDefault(); if (result != default(Models.Product)) { return(View(result)); } TempData["ResultMessage"] = "無此筆資料"; return(RedirectToAction("Index")); } }
public ActionResult Create(Models.Product item) { if (ModelState.IsValid) { using (Models.cartEntities _db = new Models.cartEntities()) { _db.Products.Add(item); _db.SaveChanges(); TempData["ResultMessage"] = String.Format("商品{0}成功建立", item.Name); //redirectToAction會回傳Index的view結果回來 return(RedirectToAction("Index")); } } ViewBag.ResultMessage = "資料有誤,請檢察"; return(View()); }
public ActionResult Delete(int id) { using (Models.cartEntities _db = new Models.cartEntities()) { var result = (from s in _db.Products where s.Id == id select s).FirstOrDefault(); if (result != null) { _db.Products.Remove(result); _db.SaveChanges(); TempData["ResultMessage"] = String.Format("{0}商品成功刪除", result.Name); return(RedirectToAction("Index")); } else { TempData["ResultError"] = "無此商品"; return(RedirectToAction("Index")); } } }
public void AddToProduct(int id) { var findItem = this.cart.Where(s => s.Id == id).Select(s => s).FirstOrDefault(); if (findItem == default(Models.carts.CartItem)) { using (Models.cartEntities _db = new Models.cartEntities()) { var product = (from s in _db.Products where s.Id == id select s).FirstOrDefault(); if (product != default(Models.Product)) { this.AddToProduct(product); } } } else { findItem.Quantity++; } }