public ActionResult Purchase()
{
int EmployeeId = (int)Session.Contents["EmployeeId"];
var m = new Models.Inventory_.Purchase.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_.Purchase.LocationModel();
lm.Id = l.Id;
lm.Name = l.Name;
foreach (var p in ps)
{
var pm = new Models.Inventory_.Purchase.ProductModel();
pm.Id = p.Id;
pm.Name = p.Name;
pm.Price = p.WholesalePrice;
pm.OldQuantity = p.Inventories.SingleOrDefault(i => i.Location == l).Quantity;
lm.Inventory.Add(pm);
}
m.Locations.Add(lm);
}
}
return View(m);
}
public ActionResult Purchase()
{
int EmployeeId = (int)Session.Contents["EmployeeId"];
var m = new Models.Inventory_.Purchase.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_.Purchase.LocationModel();
lm.Id = l.Id;
lm.Name = l.Name;
foreach (var p in ps)
{
var pm = new Models.Inventory_.Purchase.ProductModel();
pm.Id = p.Id;
pm.Name = p.Name;
pm.Price = p.WholesalePrice;
pm.OldQuantity = p.Inventories.SingleOrDefault(i => i.Location == l).Quantity;
lm.Inventory.Add(pm);
}
m.Locations.Add(lm);
}
}
return(View(m));
}