// GET: SuplyProducts/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SuplyProduct suplyProduct = db.SuplyProduct.Find(id); if (suplyProduct == null) { return(HttpNotFound()); } return(View(suplyProduct)); }
public ActionResult Create(int Id, [Bind(Include = "Id,Id_SuplyInvoice,Id_Product,Quantity,UnitCost,TotalAmount")] SuplyProduct suplyProduct) { if (ModelState.IsValid) { suplyProduct.Id_SuplyInvoice = Id; suplyProduct.UnitCost = (decimal)suplyProduct.TotalAmount / (decimal)suplyProduct.Quantity; db.SuplyProduct.Add(suplyProduct); db.SaveChanges(); SuplyInvoice SI = db.SuplyInvoice.Find(Id); SI.TotalAmount = db.SuplyProduct.Where(t => t.Id_SuplyInvoice == Id).Select(i => i.TotalAmount).Sum(); db.SaveChanges(); return(RedirectToAction("Index", routeValues: new { Id = Id })); } return(RedirectToAction("Index", routeValues: new { Id = Id })); }
public ActionResult DeleteConfirmed(int Id = 0, int Id2 = 0) { if (Id == 0 || Id2 == 0) { return(RedirectToAction("Index", "SuplyInvoices")); } SuplyProduct suplyProduct = db.SuplyProduct.Find(Id); db.SuplyProduct.Remove(suplyProduct); db.SaveChanges(); SuplyInvoice SI = db.SuplyInvoice.Find(Id2); SI.TotalAmount = db.SuplyProduct.Where(t => t.Id_SuplyInvoice == Id).Select(i => i.TotalAmount).Sum(); db.SaveChanges(); return(RedirectToAction("Index", routeValues: new { Id = Id2 })); }