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());
}