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);
}
