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