public ActionResult LoanAcctHist(int id)
{
try
{
if (id == 0)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var getLoanAccount = context.GetClientLoanAccts(Global.AccountName).FirstOrDefault();
ViewBag.AcctNo = getLoanAccount.AccountNumber;
ViewBag.ProdDescription = getLoanAccount.ProductName;
ViewBag.Balance = getLoanAccount.PrincipalBalance;
int cifkey = Convert.ToInt32(getLoanAccount.IDX);
var getLoanAccountLedger = context.GetClientLoanAcctLedger(getLoanAccount.AccountNumber, cifkey);
ViewBag.totalPrincipalPaid = getLoanAccountLedger.Sum(i => i.Principal);
ViewBag.totalInterestPaid = getLoanAccountLedger.Sum(i => i.Interest);
ViewBag.totalPenalty = getLoanAccountLedger.Sum(i => i.Penalty);
ViewBag.countPrincipalPaid = getLoanAccountLedger.Count(i => i.Principal != 0);
ViewBag.countInterestPaid = getLoanAccountLedger.Count(i => i.Interest != 0);
ViewBag.countPenalty = getLoanAccountLedger.Count(i => i.Penalty != 0);
return(View(getLoanAccountLedger));
}
catch (Exception ex)
{
throw ex;
}
}
