public ActionResult Create(FormCollection collection, int? ProductId, int? ProductUnitId, int? Amount, int? OrderId, int ?CustomerId) { int CustomerTypeId = 1; if (CustomerId != null) { CustomerTypeId = db.Customers.Find(CustomerId).CustomerTypeId; } var p1 = (from p in db.BuyPrices where p.ProductUnitId == ProductUnitId && p.ProductId == ProductId && p.CustomerTypeId == CustomerTypeId select p); if (p1.Count() > 0) { OrderDetail detail = new OrderDetail { OrderId = (int)OrderId, ProductId = (int)ProductId, ProductUnitId = (int)ProductUnitId, Product = db.Products.Find(ProductId), ProductUnit = db.ProductUnits.Find(ProductUnitId), Amount = (int)Amount, Price = p1.First().Price }; db.OrderDetails.Add(detail); db.SaveChanges(); Order order = db.Orders.Include(p => p.OrderDetails).Single(p => p.OrderId == OrderId); ViewBag.CustomerTypeId = new SelectList(db.CustomerTypes, "CustomerTypeId", "Name"); ViewBag.ProductId = new SelectList(db.Products, "ProductId", "Name"); ViewBag.ProductUnitId = new SelectList(db.ProductUnits, "ProductUnitId", "Name"); return View("../Order/Create", order); } else { ViewBag.Message = "Chưa khai báo giá cho sản phẩm này"; Order order = db.Orders.Find(OrderId); ViewBag.CustomerTypeId = new SelectList(db.CustomerTypes, "CustomerTypeId", "Name"); ViewBag.ProductId = new SelectList(db.Products, "ProductId", "Name"); ViewBag.ProductUnitId = new SelectList(db.ProductUnits, "ProductUnitId", "Name"); return View("../Order/Create", order); } }
public ActionResult Edit(OrderDetail orderdetail) { if (ModelState.IsValid) { db.Entry(orderdetail).State = EntityState.Modified; db.SaveChanges(); ViewBag.ProductId = new SelectList(db.Products, "ProductId", "Name"); ViewBag.ProductUnitId = new SelectList(db.ProductUnits, "ProductUnitId", "Name"); Order order = db.Orders.Find(orderdetail.OrderId); ViewBag.CustomerId = new SelectList(db.Customers, "CustomerId", "Name"); return View("../Order/Create", order); } ViewBag.OrderId = new SelectList(db.Orders, "OrderId", "Name", orderdetail.OrderId); return View(orderdetail); }