public int AddTray(Dictionary <string, object> items, ApplicationUser user)
{
int trayId = -1;
using (_db)
{
// we need a transaction as multiple entities involved
using (var _trans = _db.Database.BeginTransaction())
{
try
{
Tray tray = new Tray();
tray.UserId = user.Id;
tray.DateCreated = System.DateTime.Now;
tray.TotalPrice = 0;
// calculate the totals and then add the tray row to the table
foreach (var key in items.Keys)
{
ProductViewModel item =
JsonConvert.DeserializeObject <ProductViewModel>(Convert.ToString(items[key]));
if (item.Qty > 0)
{
tray.TotalPrice += item.CostPrice * item.Qty;
}
}
_db.Trays.Add(tray);
_db.SaveChanges();
// then add each item to the trayitems table
foreach (var key in items.Keys)
{
ProductViewModel item =
JsonConvert.DeserializeObject <ProductViewModel>(Convert.ToString(items[key]));
if (item.Qty > 0)
{
TrayItem tItem = new TrayItem();
tItem.Qty = item.Qty;
tItem.ProductId = item.Id;
tItem.TrayId = tray.Id;
_db.TrayItems.Add(tItem);
_db.SaveChanges();
}
}
// test trans by uncommenting out these 3 lines
//int x = 1;
//int y = 0;
//x = x / y;
_trans.Commit();
trayId = tray.Id;
}
catch (Exception ex)
{
trayId = -1;
Console.WriteLine(ex.Message);
_trans.Rollback();
}
}
}
return(trayId);
}
public int AddTray(Dictionary <string, object> items, ApplicationUser user, bool itemsBackOrdered)
{
int trayId = -1;
using (_db)
{
// we need a transaction as multiple entities involved
using (var _trans = _db.Database.BeginTransaction())
{
try
{
Tray tray = new Tray();
tray.Id = 0;
tray.UserId = user.Id;
tray.OrderDate = System.DateTime.Now;
tray.OrderAmount = 0;
// calculate the totals and then add the tray row to the table
foreach (var key in items.Keys)
{
ProductViewModel item = JsonConvert.DeserializeObject <ProductViewModel>(Convert.ToString(items[key]));
if (item.Qty > 0)
{
tray.OrderAmount += item.MSRP * item.Qty;
}
}
_db.Trays.Add(tray);
_db.SaveChanges();
// then add each item to the trayitems table
foreach (var key in items.Keys)
{
ProductViewModel item =
JsonConvert.DeserializeObject <ProductViewModel>(Convert.ToString(items[key]));
if (item.Qty > 0)
{
TrayItem tItem = new TrayItem();
tItem.QtyOrdered = item.Qty;
tItem.SellingPrice = item.MSRP;
if (tItem.QtyOrdered > item.QTYONHAND)
{
tItem.QtySold = item.QTYONHAND;
tItem.QtyBackOrdered = tItem.QtyOrdered - item.QTYONHAND;
item.QTYONHAND = 0;
item.QTYONBACKORDER = tItem.QtyBackOrdered;
itemsBackOrdered = true;
}
if (tItem.QtyOrdered <= item.QTYONHAND)
{
tItem.QtySold = tItem.QtyOrdered;
item.QTYONHAND -= tItem.QtyBackOrdered;
}
tItem.ProductId = item.Id;
tItem.OrderId = tray.Id;
_db.TrayItems.Add(tItem);
_db.SaveChanges();
}
}
// test trans by uncommenting out these 3 lines
//int x = 1;
//int y = 0;
//x = x / y;
_trans.Commit();
trayId = tray.Id;
}
catch (Exception ex)
{
trayId = -1;
Console.WriteLine(ex.Message);
_trans.Rollback();
}
}
}
return(trayId);
}