public ActionResult AssignInspector(int id, int sender)
{
//var lor = db.loan_officer_assign.Add(AI)
// OfficerAssign OA = new OfficerAssign();
//var AI = AI1.Find(p => p.officer_id == id);
loan_officer_assign oa = new loan_officer_assign();
oa.application_id = sender;
oa.officer_id = id;
db.loan_officer_assign.Add(oa);
db.SaveChanges();
loan_application la = new loan_application();
la = db.loan_application.Find(sender);
//if(la == null)
//{
// return HttpNotFound();
//}
la.status = "Assigned";
db.SaveChanges();
officer O1 = db.officers.Find(id);
string EID = O1.email_id;
string OfficerName = O1.name;
string AppID = oa.application_id.ToString();
SendVerificationLinkEmail(EID, OfficerName, AppID);
return(RedirectToAction("ApplicationList", "View_Loan_Applications"));
}
public ActionResult ApprovedOrRejected(int id)
{
if (ModelState.IsValid)
{
loan_officer_assign loa = new loan_officer_assign();
loa = db.loan_officer_assign.SingleOrDefault(p => p.application_id == id);
//var Applicant = db.loan_application.Find(id);
//string strDDLValue = Request.Form["ddldtatus"].ToString();
//Applicant.status = strDDLValue;
//db.SaveChanges();
//loan_app_or_rej lp = new loan_app_or_rej();
//lp.date_of_approval = (DateTime)DateTime.Now;
//lp.application_id = Applicant.application_id;
//lp.amount_sanctioned = Applicant.loan_amount;
//lp.status = strDDLValue;
//lp.interest_rate = 7.50;
//lp.reasons = "Wont tell you";
//db.loan_app_or_rej.Add(lp);
//db.SaveChanges();
var Applicant = db.loan_application.Find(id);
string strDDLValue = Request.Form["ddldtatus"].ToString();
Applicant.status = strDDLValue;
db.SaveChanges();
loan_app_or_rej lp = new loan_app_or_rej();
lp.date_of_approval = (DateTime)DateTime.Now;
lp.application_id = Applicant.application_id;
lp.amount_sanctioned = Applicant.loan_amount;
lp.status = strDDLValue;
lp.interest_rate = 7.50;
lp.reasons = "Wont tell you";
db.loan_app_or_rej.Add(lp);
db.SaveChanges();
officer O1 = db.officers.Find(loa.officer_id);
string EID = O1.email_id;
string OfficerName = O1.name;
string AppID = Applicant.application_id.ToString();
SendVerificationLinkEmailToOfficer(EID, OfficerName, AppID, lp.status);
return(RedirectToAction("ApplicationList", "View_Loan_Applications"));
}
return(RedirectToAction("ApplicationList", "View_Loan_Applications"));
// return View();
}
