public async Task <IActionResult> Dashboard() { try { ViewBag.Title = "Nemesys Dashboard"; var model = new ReportDashboardViewModel(); model.TotalRegisteredUsers = _userManager.Users.Count(); model.TotalEntries = _reportRepository.GetAllReports().Count(); return(View(model)); } catch (Exception ex) { _logger.LogError(ex.Message); return(View("Error")); } }
public ActionResult ReportDashboard() { var prepItems = _uow.PrepListItemRepository.Get().ToList(); var userDepartment = _uow.GetUserDepartment(); //var usedReagent = prepItems // .Where(item => item.StockReagent != null) // .GroupBy(item => item.StockReagent) // .OrderByDescending(item => item.Count()) // .ToList() // .Select(item => item.Key.ReagentName) // .FirstOrDefault(); var reagent = prepItems .Where(item => item.StockReagent != null && userDepartment == item.StockReagent.InventoryItems.First().Department) .GroupBy(x => x.StockReagent) .OrderByDescending(s => s.Count()) .First().Key; //var mostUsedReagent = _uow.PrepListItemRepository.Get() //.Where(item => item.StockReagent != null)// && item.StockReagent.InventoryItems.First().Department.DepartmentId == userDepartment.DepartmentId) //.GroupBy(item => item.StockReagent) //.OrderByDescending(item => item.Count()) //.Select(item => item.StockReagent.ReagentName) //.FirstOrDefault(); //var mostUsedStandard = prepItems // .Where(item => item.StockStandard != null && item.StockStandard.InventoryItems.First().Department == userDepartment) // .GroupBy(item => item.StockStandard) // .OrderByDescending(item => item.Count()) // .FirstOrDefault(); var standard = prepItems .Where(item => item.StockStandard != null && userDepartment == item.StockStandard.InventoryItems.First().Department) .GroupBy(x => x.StockStandard) .OrderByDescending(s => s.Count()) .First().Key; //var mostUsedIntermediateStandard = prepItems // .Where(item => item.IntermediateStandard != null && item.IntermediateStandard.InventoryItems.First().Department == userDepartment) // .GroupBy(item => item.IntermediateStandard) // .OrderByDescending(item => item.Count()) // .Select(item => item.Key.IntermediateStandardName) // .FirstOrDefault(); var intStandard = prepItems .Where(item => item.IntermediateStandard != null && userDepartment == item.IntermediateStandard.InventoryItems.First().Department) .GroupBy(x => x.IntermediateStandard) .OrderByDescending(s => s.Count()) .First().Key; //var mostUsedWorkingStandard = prepItems // .Where(item => item.WorkingStandard != null) // .GroupBy(item => item.WorkingStandard) // .OrderByDescending(item => item.Count()) // .Select(item => item.Key.WorkingStandardName) // .FirstOrDefault(); var model = new ReportDashboardViewModel() { StockReagentName = reagent.ReagentName, StockStandardName = standard.StockStandardName, IntermediateStandardName = intStandard.IntermediateStandardName, Department = userDepartment }; return(View(model)); }