public ViewOrderDetail GetViewOrderDetail(ADProjectDb db, int orderId, int itemId)
{
ViewOrderDetail viewOrderDetail = (from IC in db.ItemCatalogue
join OD in db.OrderDetail
on IC.ItemCatalogueId equals OD.ItemId
where OD.OrderId == orderId
where OD.ItemId == itemId
join SC in db.SupplierCatalogue
on IC.ItemCatalogueId equals SC.ItemId
join O in db.Order
on OD.OrderId equals O.OrderId
where SC.SupplierId == O.SupplierId
select new ViewOrderDetail()
{
orderId = OD.OrderId,
itemId = IC.ItemCatalogueId,
description = IC.ItemDes,
orderQty = OD.OrderQuantity,
price = SC.ItemPrice,
unit = IC.UnitOfMeasure,
expDate = OD.ExpDelDate,
actDate = OD.ActDelDate
}).FirstOrDefault();
return(viewOrderDetail);
}
public ActionResult EditOrderDetail(int orderId, int itemId)
{
using (var db = new ADProjectDb())
{
//get ViewOrderdetail from database
ViewOrderDetail viewOrderDetail = orderService.GetViewOrderDetail(db, orderId, itemId);
// Send Vieworderdetail to record the change
return(View(viewOrderDetail));
}
}
