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