// GET: Sales/Create public ActionResult Create() { //List Item List <ViewSalesItem> viewSalesItems = new List <ViewSalesItem>(); List <Item> items = db.items.Where(a => a.InActive == false).ToList(); if (items.Count > 0) { foreach (Item item in items) { ViewSalesItem viewSalesItem = new ViewSalesItem(); viewSalesItem.ItemId = item.ItemCode; viewSalesItem.Name = item.ItemName; viewSalesItem.ImageFile = item.ImageFile; viewSalesItem.Price = item.Price; viewSalesItems.Add(viewSalesItem); } } ViewBag.ItemList = viewSalesItems.ToList(); Sale sale = new Sale(); return(View(sale)); }
// GET: Sales/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Sale sale = db.sales.Find(id); if (sale == null) { return(HttpNotFound()); } //List Item List <ViewSalesItem> viewSalesItems = new List <ViewSalesItem>(); List <Item> items = db.items.Where(a => a.InActive == false).ToList(); if (items.Count > 0) { foreach (Item item in items) { ViewSalesItem viewSalesItem = new ViewSalesItem(); viewSalesItem.ItemId = item.ItemCode; viewSalesItem.Name = item.ItemName; viewSalesItem.ImageFile = item.ImageFile; viewSalesItem.Price = item.Price; viewSalesItem.SalesId = sale.SalesId; viewSalesItems.Add(viewSalesItem); if (sale.SalesItemLists.Count > 0) { var salesItem = sale.SalesItemLists.FirstOrDefault(a => a.ItemId == item.ItemCode); if (salesItem != null) { viewSalesItem.Quantity = salesItem.Quantity; viewSalesItem.SalesItemId = salesItem.SalesItemId; } } } } ViewBag.ItemList = viewSalesItems.ToList(); ViewBag.EmployeeId = new SelectList(db.employees, "Id", "EmpFullName"); return(View("Create", sale)); }
public ActionResult Create(Sale sale) { if (ModelState.IsValid) { Employee employee = db.employees.Find(sale.EmployeeId); if (employee == null) { sale.EmployeeId = null; } if (sale.SalesId == 0) { db.sales.Add(sale); db.SaveChanges(); } else { //List<SalesItemList> salesItemLists = db.salesItemLists.Where(a => a.SalesId == sale.SalesId).ToList(); //db.salesItemLists.RemoveRange(salesItemLists); db.Entry(sale).State = EntityState.Modified; Array.ForEach(sale.SalesItemLists.ToArray(), a => db.Entry(a).State = EntityState.Modified); db.SaveChanges(); } return(RedirectToAction("Details", new { id = sale.SalesId })); } //List Item List <ViewSalesItem> viewSalesItems = new List <ViewSalesItem>(); List <Item> items = db.items.Where(a => a.InActive == false).ToList(); if (items.Count > 0) { foreach (Item item in items) { ViewSalesItem viewSalesItem = new ViewSalesItem(); viewSalesItem.ItemId = item.ItemCode; viewSalesItem.Name = item.ItemName; viewSalesItem.ImageFile = item.ImageFile; viewSalesItem.Price = item.Price; viewSalesItems.Add(viewSalesItem); if (sale.SalesItemLists.Count > 0) { var salesItem = sale.SalesItemLists.FirstOrDefault(a => a.ItemId == item.ItemCode); if (salesItem != null) { viewSalesItem.Quantity = salesItem.Quantity; } } } } ViewBag.ItemList = viewSalesItems.ToList(); ViewBag.EmployeeId = new SelectList(db.employees, "Id", "EmpFullName"); return(View(sale)); }