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