public OrderProductVM GetOrderProductDetail(int orderNumber,int productId) { mergedEntities db = new mergedEntities(); OrderProductVM orderProductVM = new OrderProductVM(); var query = from o in db.OrderDetails where (o.orderNumber == orderNumber) from op in o.OrderProducts where (op.productID == productId) select new OrderProductVM() //select new { OrderNumber = o.orderNumber, ProductId = op.productID, ProductName = op.Product.productName, Quantity = (decimal)op.quantity }; foreach (var item in query) { orderProductVM.OrderNumber = item.OrderNumber; orderProductVM.ProductId = item.ProductId; orderProductVM.ProductName = item.ProductName; orderProductVM.Quantity = item.Quantity; } return orderProductVM; }
public OrderProductVM UpdateOrderProduct(OrderProductVM orderProductVM) { mergedEntities db = new mergedEntities(); OrderProduct orderProduct = db.OrderProducts.Where(o => o.orderNumber == orderProductVM.OrderNumber && o.productID == orderProductVM.ProductId).FirstOrDefault(); orderProduct.productID = orderProductVM.ProductId; orderProduct.quantity = orderProductVM.Quantity; db.SaveChanges(); return orderProductVM; }
public ActionResult EditOrderProduct(OrderProductVM orderProductVM) { ProductRepo productRepo = new ProductRepo(); OrderProductVM editedOrderProductVM = new OrderProductVM(); if (ModelState.IsValid) { editedOrderProductVM = productRepo.UpdateOrderProduct(orderProductVM); return RedirectToAction("DetailsOrderProduct", new { id = orderProductVM.OrderNumber }); } else { ViewBag.ErrorMessage = "This entry is invalid."; return View(orderProductVM); } }
public ActionResult EditOrderProduct(int id,int productId) // "id" is "id order number". { ProductRepo productRepo = new ProductRepo(); OrderProductVM orderProductVM = new OrderProductVM(); orderProductVM = productRepo.GetOrderProductDetail(id, productId); return View(orderProductVM); }