public ActionResult Edit([Bind(Include = "Id,Name,Cost")] Product product) { if (ModelState.IsValid) { db.Entry(product).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(product)); }
public ActionResult Edit([Bind(Include = "Id,ProductId,InStock")] Inventory inventory) { if (ModelState.IsValid) { db.Entry(inventory).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ProductId = new SelectList(db.Products, "Id", "Name", inventory.ProductId); return(View(inventory)); }
public void SaveTransactionWorkFlow(Transaction form) { var key = Guid.NewGuid(); try { using (SalesManagementDemoEntities dbContext = new SalesManagementDemoEntities()) { var prodId = dbContext.Products.Where(t => t.Name == form.Product).Select(t => t.Id).SingleOrDefault(); var accTypeId = int.Parse( dbContext.AccountTypes .Where(w => w.Name == form.AccountType) .Select(S => S.Id)? .FirstOrDefault() .ToString()); dbContext.Order_Details.Add(new Order_Details { Id = key, CustomerFirstName = form.CustFName, CustomerLastName = form.CustLName, AccountType = accTypeId, DeliveryAddress = form.DeliveryAddress, AccountNumber = form.AccountNumber } ); dbContext.SaveChanges(); dbContext.Orders.Add(new Order { ProductId = prodId, Quantity = form.Quantity, TransactionId = key, TotalCost = (form.TotalCost * form.Quantity), OrderDate = DateTime.Now } ); dbContext.SaveChanges(); var budget = new Budget { DepartmentId = 1, Amounted = (decimal)50000.00, TimeStamped = DateTime.Now, Gains = form.TotalCost * (decimal)dbContext.Products.Where(t => t.Name == form.Product).Select(s => s.ProfitRate)?.FirstOrDefault(), Loss = (decimal)0.00, }; budget.budget1 = (decimal)dbContext.Budgets.OrderByDescending(o => o.TimeStamped).Select(s => s.budget1)?.FirstOrDefault() + budget.Gains; dbContext.Budgets.Add(budget); dbContext.SaveChanges(); var updateCount = dbContext.Inventories.Where(w => w.ProductId == prodId).Select(s => s.InStock)?.FirstOrDefault() - form.Quantity; var inventory = new Inventory { ProductId = prodId, InStock = updateCount }; dbContext.Inventories.Attach(inventory); dbContext.Entry(inventory).State = EntityState.Added; dbContext.SaveChanges(); } } catch (Exception e) { return; } }