public ViewResult Index()
{
if (string.IsNullOrEmpty(User.Identity.Name))
{
userName = "******";
}
else
{
userName = User.Identity.Name;
}
IEnumerable <ExpenseLimit> model = _expenseLimitRepository.GetExpenseLimitsAll(userName);
return(View(model));
}
public IActionResult Index()
{
if (string.IsNullOrEmpty(User.Identity.Name))
{
userName = "******";
}
else
{
userName = User.Identity.Name;
}
List <Expense> expenses = _expenseRepository.GetExpensesAll(userName).ToList();
IEnumerable <ExpenseLimit> expenseLimitList = _expenseLimitRepository.GetExpenseLimitsAll(userName);
foreach (var expenseLimit in expenseLimitList)
{
DashboardViewModel viewModel = new DashboardViewModel();
viewModel.expType = expenseLimit.ExpenseType;
viewModel.monthlyLimit = expenseLimit.Limit;
viewModel.currentSpend = expenses.Where(e => e.ExpenseType == expenseLimit.ExpenseType && e.ExpenseDate.Month == DateTime.Now.Month).Select(e => e.ExpenseAmount).Sum();
if (viewModel.currentSpend > viewModel.monthlyLimit)
{
viewModel.ragStatus = "red";
}
else if (viewModel.currentSpend == viewModel.monthlyLimit)
{
viewModel.ragStatus = "orange";
}
else
{
viewModel.ragStatus = "green";
}
model.Add(viewModel);
}
model = model.OrderBy(m => m.expType).ToList();
return(View(model));
}