public static CreditCardLiabilityListViewModel GetCreditCardLiabilityByUser(string username)
{
Entities entities = new Entities();
CreditCardLiabilityListViewModel result = new CreditCardLiabilityListViewModel();
var liabilities = entities.Liabilities.Where(x => x.Username.Equals(username) &&
x.LiabilityType == (int)Constants.Constants.LIABILITY_TYPE.CREDIT_CARD &&
!x.DisabledDate.HasValue).OrderBy(x => x.Name);
foreach (var liability in liabilities)
{
CreditCardLiabilityViewModel viewModel = CreateViewModel(liability);
result.Liabilities.Add(viewModel);
}
result.TotalValue = result.Liabilities.Sum(x => x.Value);
result.TotalMonthlyPayment = result.Liabilities.Sum(x => x.MonthlyPayment);
result.TotalAnnualPayment = result.Liabilities.Sum(x => x.AnnualPayment);
result.TotalInterestRate = result.TotalAnnualPayment / result.TotalValue;
result.IsInitialized = UserQueries.IsCompleteInitialized(username);
return(result);
}
public ActionResult _CreditCardLiabilityTable()
{
CreditCardLiabilityListViewModel model = CreditCardLiabilityQueries.GetCreditCardLiabilityByUser(UserQueries.GetCurrentUsername());
return(PartialView(model));
}
