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