public override void Update(object sender, Tuple<Sale, SaleState> item) { using (SalesDBEntities context = new SalesDBEntities()) { Product product = context.Products .Where(p => p.ProductID == item.Item1.ProductID) .SingleOrDefault<Product>(); switch (item.Item2) { case SaleState.SALE_ADD: product.TotalSalesAmount += item.Item1.Quantity; break; case SaleState.SALE_UPDATE: product.TotalSalesAmount = item.Item1.Quantity; break; case SaleState.SALE_DELETE: product.TotalSalesAmount -= item.Item1.Quantity; break; default: break; } context.SaveChanges(); } }
public ViewResult Index() { List<Sale> sales = new List<Sale>(); using (SalesDBEntities context = new SalesDBEntities()) { sales = context.Sales .Include(s => s.Employee) .Include(s => s.Customer) .Include(s => s.Product) .Take(100).ToList<Sale>(); SalesViewModel viewModel = new SalesViewModel(); viewModel.Sales = sales; return View(viewModel); } }