protected override void Dispose(bool disposing) { if (disposing) { db.Dispose(); } base.Dispose(disposing); }
public void UpdateOrderCancel(string status) { int orderId = Convert.ToInt32(status); WarehouseDBEntities wdm = new WarehouseDBEntities(); Order Oldorder = wdm.Orders.FirstOrDefault(a => a.orderId == orderId); Order orderCopy = Oldorder; orderCopy.orderStatus = "Canceled"; wdm.Entry(Oldorder).CurrentValues.SetValues(orderCopy); wdm.SaveChanges(); wdm.Dispose(); }
public JsonResult GetItems(int warehouseId) { List <Item> items = new List <Item>(); WarehouseDBEntities wdb = new WarehouseDBEntities(); List <Item_Warehouse> iw = wdb.Item_Warehouse.Where(i => i.warehouseId == warehouseId).ToList(); ConsignmentBusinessLayer cbl = new ConsignmentBusinessLayer(); foreach (Item_Warehouse i in iw) { //Item it = wdb.Items.First(k=>k.id==i.itemId); items.Add(cbl.getItem(i.itemId, (int)i.quantity)); } wdb.Dispose(); return(new JsonResult { Data = items, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult CompleteOrder() { if (Session["customerRecord"] != null && Session["orderRecord"] != null) { WarehouseDBEntities wdb = new WarehouseDBEntities(); Customer customer = (Customer)Session["customerRecord"]; List <Item> items = (List <Item>)Session["orderRecord"]; int customerId; try { customerId = wdb.Customers.Max(i => i.id) + 1; } catch (Exception ex) { customerId = 1; } customer.id = customerId; int warehouseId = Convert.ToInt32(customer.selectedWarehouse); int orderId; try { orderId = wdb.Orders.Max(i => i.orderId) + 1; } catch (Exception ex) { orderId = 1; } wdb.Customers.Add(customer); wdb.SaveChanges(); wdb.Dispose(); wdb = new WarehouseDBEntities(); Order order = new Order(); order.orderId = orderId; order.customerId = customerId; order.orderDate = System.DateTime.Now.Date; order.orderStatus = "Unseen"; order.warehouseId = warehouseId; order.totalOrderQuanitity = 0; foreach (Item item in items) { order.totalOrderQuanitity = order.totalOrderQuanitity + Convert.ToInt32(item.Manufacturer); } wdb.Orders.Add(order); wdb.SaveChanges(); wdb.Dispose(); wdb = new WarehouseDBEntities(); List <item_Order> item_OrderList = new List <item_Order>(); foreach (Item item in items) { item_Order itemOrder = new item_Order(); itemOrder.itemId = item.id; itemOrder.orderId = orderId; itemOrder.quantity = Convert.ToInt32(item.Manufacturer); item_OrderList.Add(itemOrder); Item_Warehouse original = wdb.Item_Warehouse.FirstOrDefault(a => a.itemId == item.id && a.warehouseId == warehouseId); Item_Warehouse copy = original; copy.orders += 1; copy.quantity = copy.quantity - itemOrder.quantity; if (original != null) { wdb.Entry(original).CurrentValues.SetValues(copy); wdb.SaveChanges(); wdb.Dispose(); wdb = new WarehouseDBEntities(); } } wdb.item_Order.AddRange(item_OrderList); wdb.SaveChanges(); wdb.Dispose(); Session.Clear(); Session.Abandon(); } else { RedirectToAction("Register", "Account"); } return(View()); }