public ActionResult CheckIn_Return(OrderHistoryConfirm confirmReturn, Product Products, Return Returns) { var returns = db.Returns.ToList(); var lotList = db.Lots.ToList(); var returnItem = lotList.Where(x => x.Id == confirmReturn.LotId).FirstOrDefault(); returnItem.Quantity += confirmReturn.QtyConfirmed; var returning = returns.Where(x => x.Id == confirmReturn.CheckId).FirstOrDefault(); returning.InInventory = confirmReturn.CheckedIn; db.SaveChanges(); return(View()); }
public ActionResult Update_OrderConfirm(OrderHistoryConfirm OrderHistConfirm, [Bind(Include = "Id, StockLevel")] Product Products, [Bind(Include = "Id,OrderCost,ProductId,QtyOrdered,LastEditUser,LastEditDateTime")] OrderProduct orderProduct, Order ordere, Lot lot) { var x = OrderHistConfirm.ProductId; var orderedProduct = db.OrderProducts.Where(r => r.Id == OrderHistConfirm.CheckId).FirstOrDefault(); var prod = db.Products.ToList(); var lotList = db.Lots.ToList(); var order = db.Orders.Where(r => r.Id == OrderHistConfirm.CheckId).ToList(); orderedProduct.CheckedIn = true; var Product = prod.Where(r => r.Id == OrderHistConfirm.ProductId).FirstOrDefault(); lotList.Where(r => r.Price == (orderedProduct.OrderCost / orderedProduct.Quantity)).FirstOrDefault().Quantity += OrderHistConfirm.QtyConfirmed; db.SaveChanges(); return(View()); }