//update loan
public void updateLoan(int id, double payment)
{
loan l = wvac.loans.Find(id);
DateTime s;
l.Balance = l.Balance - payment;
s = l.SchedDate.Value;
l.SchedDate = s.AddMonths(1);
if (l.Balance == 0)
{
l.Status = "FULLY PAID";
l.SchedDate = null;
}
wvac.SaveChanges();
}
//insert loan to database
public string InsertLoan(loan loan)
{
try
{
wvac.loans.Add(loan);
wvac.SaveChanges();
return("Your Loan ID is: " + loan.id +
"\nLoan Amount: " + loan.LoanAmount +
"\nTotal Deductions: " + (loan.AdvanceIntrest
+ loan.CBU + loan.ServiceFee + loan.NotarialFee) +
"\nNet Proceeds: " + (loan.LoanAmount - (loan.AdvanceIntrest
+ loan.CBU + loan.ServiceFee + loan.NotarialFee)) +
"\nSchedule for Next Payment: " + loan.SchedDate);
}
catch (Exception ex)
{
return(ex.ToString());
}
}
//create loan
public loan CreateLoan(int userId, string typeOfLoan, int months, double loanAmount, double ai, double sf,
double NOTARIAL_FEE, double cbu, double balance, double monthlyDue, DateTime releaseDate,
DateTime dateDue, DateTime schedPayment)
{
loan loan = new loan();
loan.UserID = userId;
loan.TypeOfLoan = typeOfLoan;
loan.NoOfMonths = months;
loan.LoanAmount = loanAmount;
loan.AdvanceIntrest = ai;
loan.ServiceFee = sf;
loan.NotarialFee = NOTARIAL_FEE;
loan.CBU = cbu;
loan.Balance = balance;
loan.MonthlyDue = monthlyDue;
loan.DateRelease = releaseDate;
loan.DateDue = dateDue;
loan.SchedDate = schedPayment;
loan.Status = "Pending";
return(loan);
}