public ActionResult ReviewReportE()
{
List<Book> InventoryList = new List<Book>();
var query = from b in _db.Books select b;
query = query.Where(b => b.Inventory > 0);
query = query.Include(b => b.Procurements);
InventoryList = query.ToList();
ViewBag.SelectedRecords = InventoryList.Count();
List<InventoryReportVM> inventoryReportVMs = new List<InventoryReportVM>();
decimal TotalValueSold = 0;
decimal TotalValueCost = 0;
foreach(Book book in InventoryList)
{
InventoryReportVM irvm = new InventoryReportVM();
irvm.Title = book.Title;
irvm.BooksInInventory = book.Inventory;
irvm.WeightedAvgCost = (decimal)book.AvgBookCost;
TotalValueSold += (book.Inventory * (Decimal)book.AvgSalesPrice);
TotalValueCost += (book.Inventory * (Decimal)book.AvgBookCost);
inventoryReportVMs.Add(irvm);
}
ViewBag.TotalCost = TotalValueCost;
ViewBag.TotalValue = TotalValueSold;
return View("ReviewReportE",inventoryReportVMs);
}
public InventoryReportView()
{
InitializeComponent();
var vm = new InventoryReportVM();
DataContext = vm;
}
public void OnGet()
{
InventoryReportVM = new InventoryReportVM()
{
MenuItemList = _unitOfWork.MenuItem.GetMenuItemListForDropdown()
};
}
public ActionResult Inventory()
{
InventoryReportVM model = new InventoryReportVM();
model.NewVehicles = VehicleRepositoryFactory.GetRepository().GetInventoryReport("new");
model.UsedVehicles = VehicleRepositoryFactory.GetRepository().GetInventoryReport("used");
return(View(model));
}
public ActionResult InventoryReport()
{
var model = new InventoryReportVM();
model.PopulateNew(repo);
model.PopulateUsed(repo);
return(View(model));
}
public ActionResult Inventory()
{
var repo = AdminFactory.GetRepository();
InventoryReportVM model = new InventoryReportVM()
{
NewInventoryReport = repo.GetInventoryReport(1),
UsedInventoryReport = repo.GetInventoryReport(2)
};
return(View(model));
}
public ActionResult Inventory()
{
IEnumerable <Vehicle> allVehicles = vRepo.GetAll();
foreach (var item in allVehicles)
{
item.Make = makeRepo.GetById(item.MakeId);
item.Model = modelRepo.GetById(item.ModelId);
}
IEnumerable <Vehicle> newVehicles = allVehicles.Where(v => v.Type == "New");
IEnumerable <Vehicle> usedVehicles = allVehicles.Where(v => v.Type == "Used");
InventoryReportVM inventoryReportVM = new InventoryReportVM();
inventoryReportVM.UsedInventory = Inventory(usedVehicles);
inventoryReportVM.NewInventory = Inventory(newVehicles);
return(View(inventoryReportVM));
}
public InventoryReportView()
{
InitializeComponent();
var vm = new InventoryReportVM();
DataContext = vm;
}
