public int NumMonthsUnderBudget(string user)
{
List <string> monthList = GetBudgetMonthsList(user);
if (!monthList.Any())
{
return(0);
}
var monthListNumbers = new List <int>();
foreach (var month in monthList)
{
monthListNumbers.Add(DateTime.ParseExact(month, "MMMM", CultureInfo.CurrentCulture).Month);
}
var underBudget = 0;
var budgetRepo = new BudgetRepository(_context);
foreach (var month in monthListNumbers)
{
var difference = budgetRepo.GetTotalBudgetLimitByMonth(month, user) - TotalSpentByMonth(month, user);
if (difference > 0)
{
underBudget++;
}
}
return(underBudget);
}
public float AmtOverOrUnderBudget(string user)
{
var monthListForUser = GetBudgetMonthNumbersList(user);
if (!monthListForUser.Any())
{
return(0.00f);
}
float totalBudget = 0;
float totalSpent = 0;
var budgetRepo = new BudgetRepository(_context);
foreach (var month in monthListForUser)
{
totalBudget += budgetRepo.GetTotalBudgetLimitByMonth(month, user);
totalSpent += TotalSpentByMonth(month, user);
}
return(totalBudget - totalSpent);
}
