public ActionResult Sell()
{
int EmployeeId = (int)Session.Contents["EmployeeId"];
var m = new _5Bites.Models.Store_.Sell.ViewModel();
using (var db = new dbEntities())
{
var ss = db.EmployeeStores.Where(es => es.EmployeeId == EmployeeId).Select(es => es.Store);
foreach (var s in ss)
{
var sm = new Models.Store_.Sell.StoreModel();
sm.Id = s.Id;
sm.Bank = s.Bank;
sm.Name = s.Location.Name;
foreach (var i in s.Location.Inventories)
{
var pm = new Models.Store_.Sell.ProductModel();
pm.Id = i.Product.Id;
pm.Description = i.Product.Name;
pm.Price = i.Product.RetailPrice;
pm.Quantity = i.Quantity;
sm.Inventory.Add(pm);
}
m.Stores.Add(sm);
}
}
return View(m);
}
public ActionResult Inventory()
{
var m = new _5Bites.Models.Store_.Inventory.ViewModel();
using (var db = new dbEntities())
{
var ss = db.Stores.Include("Location");
foreach (var s in ss)
{
var sm = new Models.Store_.Inventory.StoreModel();
sm.Id = s.Id;
sm.Name = s.Location.Name;
foreach (var i in s.Location.Inventories)
{
var pm = new Models.Store_.Inventory.ProductModel();
pm.Description = i.Product.Name;
pm.Price = i.Product.RetailPrice;
pm.Quantity = i.Quantity;
sm.Inventory.Add(pm);
}
m.Stores.Add(sm);
}
}
return View(m);
}
public ActionResult Transfer()
{
int EmployeeId = (int)Session.Contents["EmployeeId"];
var m = new Models.Inventory_.Transfer.ViewModel();
using (var db = new dbEntities())
{
var ps = db.Products;
var ls = db.EmployeeLocations.Where(el => el.EmployeeId == EmployeeId).Select(el => el.Location);
foreach (var l in ls)
{
var lm = new Models.Inventory_.Transfer.LocationModel();
lm.Id = l.Id;
lm.Name = l.Name;
foreach (var p in ps)
{
var pm = new Models.Inventory_.Transfer.ProductModel();
pm.Id = p.Id;
pm.Name = p.Name;
pm.OldQuantity = p.Inventories.SingleOrDefault(i => i.Location == l).Quantity;
pm.Quantity = pm.OldQuantity;
lm.Inventory.Add(pm);
}
m.Locations.Add(lm);
}
}
return View(m);
}
public ActionResult Transactions()
{
var m = new Models.Home.Transactions.ViewModel();
using (var db = new dbEntities())
{
var ts = db.Transactions;
foreach (var t in ts)
{
var tm = new Models.Home.Transactions.TransactionModel();
tm.EmployeeName = t.Employee.Username;
tm.StoreName = t.Store.Location.Name;
tm.ProductName = t.Product.Name;
tm.Quantity = t.Quantity;
tm.Timestamp = t.Timestamp;
m.Transactions.Add(tm);
}
}
return View(m);
}
public ActionResult Purchase(Models.Inventory_.Purchase.ViewModel m)
{
if (ModelState.IsValid)
{
using (var db = new dbEntities())
{
foreach (var lm in m.Locations)
{
foreach (var pm in lm.Inventory)
{
db.Inventories.Single(i => i.LocationId == lm.Id && i.ProductId == pm.Id).Quantity += pm.Quantity;
}
}
db.SaveChanges();
}
return RedirectToAction("Purchase", "Inventory");
}
return View();
}
public ActionResult Sell(_5Bites.Models.Store_.Sell.ViewModel m)
{
if (ModelState.IsValid)
{
int EmployeeId = (int)Session.Contents["EmployeeId"];
using (var db = new dbEntities())
{
foreach (var sm in m.Stores)
{
var s = db.Stores.Single(s_ => s_.Id == sm.Id);
foreach (var pm in sm.Inventory.Where(pm => pm.QuantitySold != 0))
{
var t = new Transaction();
t.ProductId = pm.Id;
t.StoreId = sm.Id;
t.EmployeeId = EmployeeId;
t.Quantity = pm.QuantitySold;
t.Timestamp = DateTime.Now;
db.Transactions.Add(t);
s.Location.Inventories.Single(i => i.ProductId == pm.Id).Quantity -= pm.QuantitySold;
}
s.Bank += sm.Inventory.Sum(pm => pm.QuantitySold * pm.Price);
}
db.SaveChanges();
}
return RedirectToAction("Sell", "Store");
}
return View(m);
}
