public ActionResult Edit(Models.Product postback) { if (this.ModelState.IsValid) { using (main.Models.mainEntities db = new Models.mainEntities()) { var result = (from s in db.Products where s.Id == postback.Id select s).FirstOrDefault(); //Revise Data result.Name = postback.Name; result.Price = postback.Price; result.PublishDate = postback.PublishDate; result.Quantity = postback.Quantity; result.Status = postback.Status; result.CategoryId = postback.CategoryId; result.DefaultImageId = postback.DefaultImageId; result.Description = postback.Description; //save data which changed db.SaveChanges(); //retuen message TempData["ResultMessage"] = String.Format("成功編輯"); return(RedirectToAction("Index")); } } else { return(View(postback)); } }
public ActionResult Index(Models.OrderModel.Ship postback) { if (this.ModelState.IsValid) { var currentcart = Models.Cart.Operation.GetCurrentCart(); var UserId = HttpContext.User.Identity.GetUserId(); using (Models.mainEntities db = new Models.mainEntities()) { //Order object var order = new Models.Order() { UserId = UserId, RecieverName = postback.ReceiverName, RecieverPhone = postback.ReceiverPhone, RecieverAddress = postback.ReceiverAddress }; //Add data table db.OrderSet.Add(order); db.SaveChanges(); //Get OrderDetail Object var orderDetails = currentcart.ToOrderDetailList(order.Id); // insert to order datatable db.OrderDetailSet.AddRange(orderDetails); db.SaveChanges(); } return(Content("訂購成功!")); } return(View()); }
// GET: ManageOrder public ActionResult Index() { //取得Models using (Models.mainEntities db = new Models.mainEntities()) { var result = (from s in db.OrderSet select s).ToList(); return(View(result)); } }
public ActionResult MyOrder() { var userId = HttpContext.User.Identity.GetUserId(); using (Models.mainEntities db = new Models.mainEntities()) { var result = (from s in db.OrderSet where s.UserId == userId select s).ToList(); return(View(result)); } }
public ActionResult Index() { //修正為抓取商品 //return View(); using (Models.mainEntities db = new Models.mainEntities()) { var result = (from s in db.Products select s).ToList(); return(View(result)); } }
// GET: Product public ActionResult Index() { List <Models.Product> result = new List <Models.Product>(); // Get Success Message ViewBag.ResultMessage = TempData["ResultMessage"]; using (Models.mainEntities db = new Models.mainEntities()) { //LinQ result = (from s in db.Products select s).ToList(); return(View(result)); } }
public ActionResult MyOrderDetail(int Id) { using (Models.mainEntities db = new Models.mainEntities()) { var result = (from s in db.OrderDetailSet where s.OrderId == Id select s).ToList(); if (result.Count == 0) { return(RedirectToAction("Index")); } else { return(View(result)); } } }
//細項 public ActionResult Details(int Id) { using (Models.mainEntities db = new Models.mainEntities()) { var result = (from s in db.Products where s.Id == Id select s).FirstOrDefault(); if (result == default(Models.Product)) { return(RedirectToAction("Index")); } else { return(View(result)); } } }
public ActionResult Edit(int id) { using (Models.mainEntities db = new Models.mainEntities()) { var result = (from s in db.Products where s.Id == id select s).FirstOrDefault(); if (result != default(Models.Product)) { return(View(result)); } else { TempData["resultMessage"] = "資料有誤,請重新操作"; return(RedirectToAction("Index")); } } }
public ActionResult Create(Models.Product postback) { if (this.ModelState.IsValid) { using (Models.mainEntities db = new Models.mainEntities()) { db.Products.Add(postback); db.SaveChanges(); //Success Message TempData["ResultMessage"] = String.Format("商品[{0}]建立成功", postback.Name); return(RedirectToAction("Index")); } } else { ViewBag.ResultMessage = "資料有誤"; return(View()); } }
public ActionResult Delete(int id) { using (Models.mainEntities db = new Models.mainEntities()) { var result = (from s in db.Products where s.Id == id select s).FirstOrDefault(); if (result != default(Models.Product)) { db.Products.Remove(result); db.SaveChanges(); TempData["resultMessage"] = String.Format("商品[{0}]已刪除", result.Name); return(RedirectToAction("Index")); } else { TempData["resultMessage"] = String.Format("沒有找到指定商品,無法刪除"); return(RedirectToAction("Index")); } } }
public ActionResult SearchByUserName(string UserName) { string searchId = null; using (Models.UserEntities db = new Models.UserEntities()) { searchId = (from s in db.AspNetUsers where s.UserName == UserName select s.Id).FirstOrDefault(); } if (!String.IsNullOrEmpty(searchId)) { using (Models.mainEntities db = new Models.mainEntities()) { var result = (from s in db.OrderSet where s.UserId == searchId select s).ToList(); return(View("Index", result)); } } else { return(View("Index", new List <Models.Order>())); } }