public ActionResult LoanAc(Loan_Account_Entites le) { if (Session["user"] != null) { LoanBL lb = new LoanBL(); int res = lb.LoanAc(le); if (res > 0) { ViewData["a"] = "Your Loan Sucessfull"; } else { ViewData["a"] = "INValid CustomerDetails"; } return(View()); } else { return(RedirectToAction("Login")); } }
public int LoanAc(Loan_Account_Entites la) { int d = 0; int age = 0; db = new MphasisBankEntities(); var res = db.Customers.Where(t => t.CustId == la.CustId); if (res.Count() > 0) { var cd = db.LoanAccounts.OrderByDescending(t => t.LnAccountid).First(); if (cd == null) { la.LnAccountid = "LN10001"; } else { la.LnAccountid = "LN" + (Convert.ToInt32(cd.LnAccountid.Substring(2, 5)) + 1).ToString(); } foreach (var item in res) { DateTime dt = Convert.ToDateTime(item.Dob); DateTime today = DateTime.Today; age += today.Year - dt.Year; } if (age > 60) { if (la.lnAmount < 100000) { la.ROI = 0.095; d = 1; } else { d = 0; } } else { if (la.lnAmount > 10000 && la.lnAmount <= 500000) { la.ROI = 0.1; d = 1; } else if (la.lnAmount > 500000 && la.lnAmount <= 1000000) { la.ROI = 0.095; d = 1; } else if (la.lnAmount > 1000000) { la.ROI = 0.09; d = 1; } else { d = 0; } } if (d == 1) { la.EMI = la.lnAmount * la.ROI * (1 + la.ROI) * la.Tenure / ((1 + la.ROI) * la.Tenure - 1); la.StartDate = DateTime.Now; LoanAccount l = new LoanAccount() { LnAccountid = la.LnAccountid, CustId = la.CustId, lnAmount = la.lnAmount, StartDate = la.StartDate, Tenure = la.Tenure, ROI = la.ROI, EMI = la.EMI }; db.LoanAccounts.Add(l); db.SaveChanges(); } } else { d = 0; } return(d); }
public int LoanAc(Loan_Account_Entites la) { return(ld.LoanAc(la)); }