/// <summary>
/// Frontend page: Title(loan setup)
/// Title: Get details of title related to given loanId
/// Designed: Piyumi
/// User story:
/// Date created: 2016/2/9
/// </summary>
/// <param name="loanId"></param>
/// <returns>TitleObject</returns>
public Title getTitleDetails(int loanId)
{
DataHandler dataHandler = new DataHandler();
List <object[]> paramertList = new List <object[]>();
paramertList.Add(new object[] { "@loan_id", loanId });
try
{
DataSet dataSet = dataHandler.GetDataSet("spGetTitleDetailsByLoanId", paramertList);
Title obj1 = new Title();
//Check dataset is not null and table count >0
if (dataSet != null && dataSet.Tables.Count != 0)
{
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
obj1.LoanId = int.Parse(dataRow["loan_id"].ToString());
obj1.IsTitleTrack = bool.Parse(dataRow["is_title_tracked"].ToString());
//Check whether title need to be tracked
if (obj1.IsTitleTrack)
{
obj1.ReceivedTimeLimit = dataRow["title_received_time_period"].ToString();
//Check auto remind period is null or empty
if (!string.IsNullOrEmpty(dataRow["auto_remind_period"].ToString()))
{
obj1.RemindPeriod = int.Parse(dataRow["auto_remind_period"].ToString());
}
//Check auto remind email is null or empty
if (!string.IsNullOrEmpty(dataRow["auto_remind_email"].ToString()))
{
obj1.RemindEmail = dataRow["auto_remind_email"].ToString();
}
else
{
//get auto remind email given in loan details page
LoanSetupAccess st = new LoanSetupAccess();
obj1.RemindEmail = st.getAutoRemindEmailByLoanId(obj1.LoanId);
}
}
else
{
//get auto remind email given in loan details page
LoanSetupAccess st = new LoanSetupAccess();
obj1.RemindEmail = st.getAutoRemindEmailByLoanId(obj1.LoanId);
}
obj1.IsReceipRequired = bool.Parse(dataRow["is_receipt_required"].ToString());
//Check whether receipts are required
if (obj1.IsReceipRequired)
{
obj1.ReceiptRequiredMethod = dataRow["receipt_required_method"].ToString();
}
//Check need scan copy value is null or empty
if (!string.IsNullOrEmpty(dataRow["need_scan_copy"].ToString()))
{
obj1.NeedScanCopy = bool.Parse(dataRow["need_scan_copy"].ToString());
//Check need scan copy value is true
if (obj1.NeedScanCopy)
{
obj1.TitleAcceptMethod = "Scanned Title Adequate";
}
}
}
return(obj1);
}
else
{
return(obj1);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Frontend page: Title(loan setup)
/// Title: Get details of title related to given loanId
/// Designed: Piyumi
/// User story:
/// Date created: 2016/2/9
/// </summary>
/// <param name="loanId"></param>
/// <returns>TitleObject</returns>
public Title getTitleDetails(int loanId)
{
DataHandler dataHandler = new DataHandler();
List<object[]> paramertList = new List<object[]>();
paramertList.Add(new object[] { "@loan_id", loanId });
try
{
DataSet dataSet = dataHandler.GetDataSet("spGetTitleDetailsByLoanId", paramertList);
Title obj1 = new Title();
//Check dataset is not null and table count >0
if (dataSet != null && dataSet.Tables.Count != 0)
{
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
obj1.LoanId = int.Parse(dataRow["loan_id"].ToString());
obj1.IsTitleTrack = bool.Parse(dataRow["is_title_tracked"].ToString());
//Check whether title need to be tracked
if (obj1.IsTitleTrack)
{
obj1.ReceivedTimeLimit = dataRow["title_received_time_period"].ToString();
//Check auto remind period is null or empty
if (!string.IsNullOrEmpty(dataRow["auto_remind_period"].ToString()))
{
obj1.RemindPeriod = int.Parse(dataRow["auto_remind_period"].ToString());
}
//Check auto remind email is null or empty
if (!string.IsNullOrEmpty(dataRow["auto_remind_email"].ToString()))
{
obj1.RemindEmail = dataRow["auto_remind_email"].ToString();
}
else
{
//get auto remind email given in loan details page
LoanSetupAccess st = new LoanSetupAccess();
obj1.RemindEmail = st.getAutoRemindEmailByLoanId(obj1.LoanId);
}
}
else
{
//get auto remind email given in loan details page
LoanSetupAccess st = new LoanSetupAccess();
obj1.RemindEmail = st.getAutoRemindEmailByLoanId(obj1.LoanId);
}
obj1.IsReceipRequired = bool.Parse(dataRow["is_receipt_required"].ToString());
//Check whether receipts are required
if (obj1.IsReceipRequired)
{
obj1.ReceiptRequiredMethod = dataRow["receipt_required_method"].ToString();
}
//Check need scan copy value is null or empty
if (!string.IsNullOrEmpty(dataRow["need_scan_copy"].ToString()))
{
obj1.NeedScanCopy = bool.Parse(dataRow["need_scan_copy"].ToString());
//Check need scan copy value is true
if (obj1.NeedScanCopy)
{
obj1.TitleAcceptMethod = "Scanned Title Adequate";
}
}
}
return obj1;
}
else
{
return obj1;
}
}
catch (Exception ex)
{
throw ex;
}
}
///<summary>
/// Frontend page: Post Method for Inactive Loan
/// Title: create view and get active loan details for inactive in Post method
/// Designed : Asanka Senarathna
/// User story: DFP-103
/// Developed: Asanka Senarathna
/// Date created: 6/27/2016
///</summary>
/// <param name="slctdLoanId"></param>
/// <param name="slctdLoanCode"></param>
public void UpdateLoanStatus_ActiveInactive(int slctdLoanId, string slctdLoanCode)
{
//check Loan ID and Loan code has value for update loan
if ((slctdLoanId > 0) && (!string.IsNullOrEmpty(slctdLoanCode)))
{
LoanSetupAccess ls = new LoanSetupAccess();
int reslt = ls.UpdateLoanStatus_ActiveInactive(slctdLoanId, slctdLoanCode);
//Update loan statues as Inactive(set loan_status = 0)
if (reslt == 1)
{
Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, 0, "Inactive Loan", "Loan Id : " + slctdLoanId + " ,Edited Status : Inactive", DateTime.Now);
//Insert new record to log
int islog = (new LogAccess()).InsertLog(log);
TempData["EditReslt"] = "success";
}
else
{
TempData["EditReslt"] = "failed";
}
}
else
{
TempData["EditReslt"] = "failed";
}
}
/// <summary>
/// CreatedBy : Piyumi
/// CreatedDate: 2016/04/20
///
/// edit loan - post
///
/// </summary>
/// <returns></returns>
///
public void UpdateLoanStatus(int slctdLoanId,string slctdLoanCode,string slctdActiveDate)
{
if((slctdLoanId>0)&&(!string.IsNullOrEmpty(slctdLoanCode)) && (!string.IsNullOrEmpty(slctdActiveDate)))
{
LoanSetupAccess ls = new LoanSetupAccess();
int reslt = ls.UpdateLoanStatus(slctdLoanId, slctdLoanCode, slctdActiveDate);
if(reslt==1)
{
Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, 0, "Edit Loan", "Loan Id : " + slctdLoanId+" ,Edited Status : Active", DateTime.Now);
int islog = (new LogAccess()).InsertLog(log);
TempData["EditReslt"] = "success";
Session.Remove("loanDashboardEditLoan");
}
else
{
TempData["EditReslt"] = "failed";
}
}
else
{
TempData["EditReslt"] = "failed";
}
}
public ActionResult AddCurtailment(List<Curtailment> curtailmentList, CurtailmentModel curtaiulmentModel)
{
//calculate payment percentage
if (userData.RoleId >= 3)
{
return RedirectToAction("UserLogin", "Login", new { lbl = "You are not Allowed." });
}
CurtailmentAccess curtailmentAccess = new CurtailmentAccess();
StepAccess sa = new StepAccess();
if (curtailmentAccess.InsertCurtailment(curtailmentList, loanData.loanId) > 0)
{
ViewBag.SuccessMsg = "Curtailment Details added successfully";
sa.UpdateLoanSetupStep(userData.UserId,loanData.CompanyId, loanData.BranchId, loanData.nonRegisteredBranchId, loanData.loanId, 6);
Log log = new Log(userData.UserId, userData.Company_Id, loanData.BranchId, loanData.loanId, "Curtailment", "Inserted curtailment details of loan : " + loanData.loanId, DateTime.Now);
int islog = (new LogAccess()).InsertLog(log);
ViewBag.Redirect = 1;
}
else
{
sa.UpdateLoanSetupStep(userData.UserId,loanData.CompanyId, loanData.BranchId, loanData.nonRegisteredBranchId, loanData.loanId, 6);
Log log = new Log(userData.UserId, userData.Company_Id, loanData.BranchId, loanData.loanId, "Curtailment", "Edited curtailment details of loan : " + loanData.loanId, DateTime.Now);
int islog = (new LogAccess()).InsertLog(log);
ViewBag.SuccessMsg = "Curtailment Details updated successfully";
}
//bool loanActive = curtaiulmentModel.LoanStatus == "Yes";
LoanSetupAccess loanAccess = new LoanSetupAccess();
loanAccess.UpdateLoanCurtailment(curtaiulmentModel, loanData.loanId);
TempData["LoanId"] = loanData.loanId;
return RedirectToAction("Step10", new { lbl = "Details added successfully" });
}
public ActionResult Step6(string dashbrd)
{
//dashbrd = 6;
int userrole = userData.RoleId;
int userId = userData.UserId;
if (userrole >= 3)
{
return RedirectToAction("UserLogin", "Login", new { lbl = "You are not Allowed." });
}
UserManageAccess uma = new UserManageAccess();
// check if step is less than 6, not allowed to this page...
int stepNo = loanData.stepId;
if (stepNo < 0)
{
return RedirectToAction("UserLogin", "Login", new { lbl = "You are not Allowed." });
}
else if ((stepNo == 0)&&(dashbrd== "bshdrdoanl"))
{
stepNo = 6;
loanData.stepId = 1;
Session["dashboard"] = 1;
// set the loan setup session to step 1
Session["companyStep"] = 5;
loanData.stepId = 1;
Session["loanStep"] = loanData;
}
if(TempData["error"] != null && TempData["error"].ToString() == "error")
{
ViewBag.Error = "Failed to create loan";
}
// get the Role Name for front end view
ViewBag.userroleName = uma.getUserRoleName(userId);
BranchAccess ba = new BranchAccess();
// get the Company type for front end view
int comType = ba.getCompanyTypeByUserId(userId);
//int comType = userData.CompanyType;
ViewBag.ThisCompanyType = (comType == 1) ? "Lender" : "Dealer";//
// retrieve registered branches, nonregistered branches using his company Id
List<Branch> RegisteredBranchLists = (new BranchAccess()).getBranches(userData.Company_Id);
List<NonRegBranch> NonRegisteredBranchLists = (new BranchAccess()).getNonRegBranches(userData.Company_Id);
// get the payments method for front End View
List<string> paymentMethods = new List<string>();
paymentMethods.Add("Auto Deduct/Deposit");
paymentMethods.Add("Invoice/Check");
ViewBag.paymentMethods = paymentMethods;
// Defaul loan setup form and default dates
LoanSetupStep1 loanSetupStep1 = new LoanSetupStep1();
loanSetupStep1.startDate = DateTime.Today;
loanSetupStep1.maturityDate = DateTime.Today.AddDays(1);
// get loan Id for each user
LoanSetupAccess la = new LoanSetupAccess();
int loanId = 0;
if ((userrole == 1) || (userrole == 2))
{
loanId = loanData.loanId;
}
// if loan number exists get the loan details
if (loanId > 0)
{
loanSetupStep1 = la.GetLoanStepOne(loanId);
}
if (userrole == 2)
{
// if user is a admin, his branch id is registerd branch id
loanSetupStep1.RegisteredBranchId = userData.BranchId;
// the get registered branch detail from the company branches list
foreach (Branch branch in RegisteredBranchLists)
{
if (branch.BranchId == userData.BranchId)
{
var newList = new List<Branch>();
newList.Add(branch);
ViewBag.RegisteredBranchId = new SelectList(newList, "BranchId", "BranchName", userData.BranchId);
}
}
var newNonRegList = new List<Branch>();
// the get non registered branches details for perticular branch from the non registeres branches list
foreach (NonRegBranch branch in NonRegisteredBranchLists)
{
if (branch.BranchId == userData.BranchId)
{
newNonRegList.Add(branch);
}
}
ViewBag.NonRegisteredBranchId = new SelectList(newNonRegList, "NonRegBranchId", "CompanyNameBranchName");
}
// if he is a super admin, add all company branches and non registered branches in to the list
else
{
// if super admin get the branch id of the loan
if (loanId > 0)
{
NonRegBranch nonRegBranch = (new BranchAccess()).getNonRegBranchByNonRegBranchId(loanSetupStep1.nonRegisteredBranchId);
loanSetupStep1.RegisteredBranchId = nonRegBranch.BranchId;
}
// add banches which contain non reg branches only
List<Branch> newBranches = new List<Branch>();
foreach (Branch branch in RegisteredBranchLists)
{
foreach (NonRegBranch nonbranch in NonRegisteredBranchLists)
{
if (branch.BranchId == nonbranch.BranchId)
{
newBranches.Add(branch);
break;
}
}
}
ViewBag.RegisteredBranchId = new SelectList(newBranches, "BranchId", "BranchName");
if (newBranches.Count >= 1)
{
ViewBag.NonRegisteredBranchId = new SelectList(NonRegisteredBranchLists, "NonRegBranchId", "CompanyNameBranchName");
}
}
if (NonRegisteredBranchLists.Count == 1)
{
if(userData.RoleId == 1)
{
// the get registered branch detail from the company branches list
foreach (Branch branch in RegisteredBranchLists)
{
if (branch.BranchId == NonRegisteredBranchLists[0].BranchId)
{
var newList = new List<Branch>();
newList.Add(branch);
ViewBag.RegisteredBranchId = new SelectList(newList, "BranchId", "BranchName", userData.BranchId);
}
}
}
loanSetupStep1.nonRegisteredBranchId = NonRegisteredBranchLists[0].NonRegBranchId;
}
loanSetupStep1.allUnitTypes = (new LoanSetupAccess()).getAllUnitTypes();
if (loanId > 0)
{
loanSetupStep1.allUnitTypes = (new LoanSetupAccess()).getAllUnitTypes();
//(new LoanSetupAccess()).getSelectedUnitTypes(loanId, loanSetupStep1);
foreach (UnitType unitType in (List<UnitType>)loanSetupStep1.selectedUnitTypes)
{
foreach (UnitType allUnitType in (List<UnitType>)loanSetupStep1.allUnitTypes)
{
if (allUnitType.unitTypeId == unitType.unitTypeId)
{
allUnitType.isSelected = true;
continue;
}
}
}
}
if (HttpContext.Request.IsAjaxRequest())
{
ViewBag.AjaxRequest = 1;
return PartialView(loanSetupStep1);
}
else
{
return View(loanSetupStep1);
}
}
public ActionResult Step10(string lbl)
{
CurtailmentModel curtailment = new CurtailmentModel();
int userId = userData.UserId;
if (userData.RoleId >= 3)
{
return RedirectToAction("UserLogin", "Login", new { lbl = "You are not Allowed." });
}
//check user step is valid for this step
StepAccess sa = new StepAccess();
if (loanData.stepId == 5)
{
ViewBag.LoanId = 0;
if (lbl == "Details added successfully")
{
ViewBag.SuccessMsg = "Loan setup is completed";
Session["loanStep"] = null;
if (TempData["LoanId"] != null && (int)TempData["LoanId"] > 0) {
ViewBag.LoanId = (int)TempData["LoanId"];
}
if (HttpContext.Request.IsAjaxRequest())
{
ViewBag.AjaxRequest = 1;
return PartialView(curtailment);
}
return View(curtailment);
}
int branchId = loanData.BranchId;
LoanSetupAccess la = new LoanSetupAccess();
int loanId = loanData.loanId;
CurtailmentAccess curAccess = new CurtailmentAccess();
_loan = curAccess.GetLoanDetailsByLoanId(loanId);
_loan.loanId = loanId;
curtailment.AdvancePt = _loan.advancePercentage;
curtailment.RemainingPercentage = curtailment.AdvancePt;
curtailment.InfoModel = new List<Curtailment>();
var curtailments = curAccess.retreiveCurtailmentByLoanId(loanId);
int payPercentage = _loan.advancePercentage;
int? totalPercentage = 0;
int curId = 0;
if (curtailments != null && curtailments.Count > 0)
{
for (int i = 0; i < curtailments.Count; i++)
{
curId++;
totalPercentage += curtailments[i].Percentage;
curtailment.InfoModel.Add(new Curtailment { CurtailmentId = curId, TimePeriod = curtailments[i].TimePeriod, Percentage = curtailments[i].Percentage });
}
curtailment.LoanStatus = _loan.LoanStatus ? "Yes" : "No";
curtailment.CalculationBase = _loan.CurtailmentCalculationBase == "a" ? "Advance" : "Full payment";
curtailment.DueDate = _loan.CurtailmentDueDate;
curtailment.AutoRemindEmail = _loan.CurtailmentAutoRemindEmail;
curtailment.EmailRemindPeriod = _loan.CurtailmentEmailRemindPeriod;
}
ViewBag.CalMode = "Full Payment";
curtailment.RemainingPercentage = payPercentage - totalPercentage;
if (curtailment.RemainingPercentage > 0)
curtailment.InfoModel.Add(new Curtailment { CurtailmentId = curId + 1 });
ViewData["objmodel"] = curtailment;
if (HttpContext.Request.IsAjaxRequest())
{
ViewBag.AjaxRequest = 1;
return PartialView(curtailment);
}
else
{
return View(curtailment);
}
}
return RedirectToAction("UserLogin", "Login", new { lbl = "Due to inactivity your session has timed out, please log in again." });
}
public ActionResult Step9(Title title)
{
int userId = userData.UserId;
int branchId = loanData.BranchId;
//check user is user or dealer user
if (userData.RoleId >= 3)
{
//return to login page
return RedirectToAction("UserLogin", "Login", new { lbl = "You are not Allowed." });
}
TitleAccess ta = new TitleAccess();
LoanSetupAccess la = new LoanSetupAccess();
StepAccess sa = new StepAccess();
int loanId = loanData.loanId;
title.LoanId = loanId;
if (title.ReceivedTimeLimit == "1")
{
title.ReceivedTimeLimit = "Title required to advance";
}
else if (title.ReceivedTimeLimit == "2")
{
title.ReceivedTimeLimit = "Title can arrive at any time";
}
else if (title.ReceivedTimeLimit == "3")
{
title.ReceivedTimeLimit = "Title must arrive within a specified time";
}
if (title.ReceiptRequiredMethod == "1")
{
title.ReceiptRequiredMethod = "Must be physically present";
}
else if (title.ReceiptRequiredMethod == "2")
{
title.ReceiptRequiredMethod = "Scanned copy only";
}
else if (title.ReceiptRequiredMethod == "3")
{
title.ReceiptRequiredMethod = "Physically present or scanned copy";
}
//insert or update title details and get result
int reslt = ta.insertTitleDetails(title);
//check result is not 0
if (reslt >= 0)
{
//update loan setup step table
if (sa.UpdateLoanSetupStep(userData.UserId,loanData.CompanyId, loanData.BranchId, loanData.nonRegisteredBranchId, loanData.loanId, 5))
{
//check current step value of loanData object is less than 5
if (loanData.stepId < 5)
{
//update step
loanData.stepId = 5;
}
//if title update or insert result is 0
if (reslt == 0)
{
//insert record in to log table as insert
Log log = new Log(userData.UserId, userData.Company_Id, loanData.BranchId, title.LoanId, "Title", "Edited title details of loan : " + title.LoanId, DateTime.Now);
int islog = (new LogAccess()).InsertLog(log);
}
if (reslt > 0)
{
//insert record in to log table as update
Log log = new Log(userData.UserId, userData.Company_Id, loanData.BranchId, title.LoanId, "Title", "Inserted title details of loan : " + title.LoanId, DateTime.Now);
int islog = (new LogAccess()).InsertLog(log);
}
//convert loan data object to session variable
Session["loanStep"] = loanData;
//return to curtailment page
return RedirectToAction("Step10");
}
//if update loan setup step result is false return to login page
else
{
return RedirectToAction("UserLogin", "Login", new { lbl = "Due to inactivity your session has timed out, please log in again." });
}
}
else
{
return new HttpStatusCodeResult(404);
}
}
public ActionResult Step9(int? edit)
{
int uId = userData.UserId;
int branchId = loanData.BranchId;
//check user is user or dealer user
if (userData.RoleId >= 3)
{
//return to login
return RedirectToAction("UserLogin", "Login", new { lbl = "You are not Allowed." });
}
//yes no list
List<SelectListItem> isTitleTrackList = new List<SelectListItem>();
isTitleTrackList.Add(new SelectListItem
{
Text = "Yes",
Value = "true"
});
isTitleTrackList.Add(new SelectListItem
{
Text = "No",
Value = "false"
});
ViewBag.isTitleTrack = new SelectList(isTitleTrackList, "Value", "Text");
List<SelectListItem> isReceiptList = new List<SelectListItem>();
isReceiptList.Add(new SelectListItem
{
Text = "Yes",
Value = "true"
});
isReceiptList.Add(new SelectListItem
{
Text = "No",
Value = "false"
});
ViewBag.IsReceipRequired = new SelectList(isReceiptList, "Value", "Text");
//Time Limit Options
List<SelectListItem> timeLimitList = new List<SelectListItem>();
timeLimitList.Add(new SelectListItem
{
Text = "Title required to advance",
Value = "1"
});
timeLimitList.Add(new SelectListItem
{
Text = "Title can arrive at any time",
Value = "2"
});
timeLimitList.Add(new SelectListItem
{
Text = "Title must arrive within a specified time",
Value = "3"
});
ViewBag.ReceivedTimeLimit = new SelectList(timeLimitList, "Value", "Text");
//Receipt required methods
List<SelectListItem> receiptRequiredMethodList = new List<SelectListItem>();
receiptRequiredMethodList.Add(new SelectListItem
{
Text = "Must be physically present",
Value = "1"
});
receiptRequiredMethodList.Add(new SelectListItem
{
Text = "Scanned copy only",
Value = "2"
});
receiptRequiredMethodList.Add(new SelectListItem
{
Text = "Physically present or scanned copy",
Value = "3"
});
ViewBag.ReceiptRequiredMethod = new SelectList(receiptRequiredMethodList, "Value", "Text");
if (uId > 0)
{
LoanSetupAccess la = new LoanSetupAccess();
TitleAccess ta = new TitleAccess();
Title title = new Title();
int loanId = loanData.loanId;
//check loan id is greater than 0
if (loanId > 0)
{
//check is update
if (loanData.stepId>4)
{
//get title details
var titleObj = ta.getTitleDetails(loanId);
ViewBag.Edit = 1;
//check object is not null
if (titleObj != null)
{
if (titleObj.ReceivedTimeLimit == "Title required to advance")
{
titleObj.ReceivedTimeLimit = "1";
}
else if (titleObj.ReceivedTimeLimit == "Title can arrive at any time")
{
titleObj.ReceivedTimeLimit = "2";
}
else if (titleObj.ReceivedTimeLimit == "Title must arrive within a specified time")
{
titleObj.ReceivedTimeLimit = "3";
}
if (titleObj.ReceiptRequiredMethod == "Must be physically present")
{
titleObj.ReceiptRequiredMethod = "1";
}
else if (titleObj.ReceiptRequiredMethod == "Scanned copy only")
{
titleObj.ReceiptRequiredMethod = "2";
}
else if (titleObj.ReceiptRequiredMethod == "Physically present or scanned copy")
{
titleObj.ReceiptRequiredMethod = "3";
}
ViewBag.DefaultEmail = titleObj.RemindEmail;
}
//check object is null
else if(titleObj == null)
{
//return to login
return RedirectToAction("UserLogin", "Login");
}
//check ajax request
if (HttpContext.Request.IsAjaxRequest())
{
ViewBag.AjaxRequest = 1;
return PartialView(titleObj);
}
else
{
return View(titleObj);
}
}
else
{
ViewBag.Edit = 0;
//get auto remind email given in loan setup step 1
string defaultEmail = la.getAutoRemindEmailByLoanId(loanId);
ViewBag.Email = defaultEmail;
//check ajax request
if (HttpContext.Request.IsAjaxRequest())
{
ViewBag.AjaxRequest = 1;
return PartialView();
}
else
{
return View();
}
}
}
//if loan id is 0 or less than 0
else
{
//return to login page
return RedirectToAction("UserLogin", "Login", new { lbl = "Due to inactivity your session has timed out, please log in again." });
}
}
//if logged user id is 0 or less than 0
else
{
//return to login page
return RedirectToAction("UserLogin", "Login", new { lbl = "Due to inactivity your session has timed out, please log in again." });
}
}
public ActionResult Step8()
{
var userId = userData.UserId;
BranchAccess branch = new BranchAccess();
//check user is user or dealer user
if (userData.RoleId >= 3)
{
return RedirectToAction("UserLogin", "Login", new { lbl = "You are not Allowed." });
}
//get company type
int companyType = branch.getCompanyTypeByUserId(userId);
//check lender company
if (companyType == 1)
{
ViewBag.isLender = true;
}
//check dealer company
else
{
ViewBag.isLender = false;
}
Fees fee = new Fees();
LoanSetupAccess loan = new LoanSetupAccess();
fee.LoanId = loanData.loanId;
//check insert or update
if (loanData.stepId > 3)
{
ViewBag.isEdit = "editable";
//get fee details
var hasLoan = loan.checkLoanIsInFeesTables(fee.LoanId);
//check advance amount
if (hasLoan.AdvanceAmount == 0)
{
hasLoan.AdvanceId = "2";
}
else {
hasLoan.AdvanceId = "1";
}
if (hasLoan.MonthlyLoanAmount == 0)
{
hasLoan.MonthlyLoanId = "2";
}
else {
hasLoan.MonthlyLoanId = "1";
}
if (hasLoan.LotInspectionAmount == 0)
{
hasLoan.LotInspectionId = "2";
}
else {
hasLoan.LotInspectionId = "1";
}
if (hasLoan.AdvanceAmount > 0 || hasLoan.MonthlyLoanAmount > 0 || hasLoan.LotInspectionAmount > 0)
{
hasLoan.LoanId = fee.LoanId;
hasLoan.isEdit = true;
//hasLoan.IsAdvanceFeeCompleteEmailReminder = false;
//hasLoan.IsLoanFeeCompleteEmailReminder = false;
//hasLoan.IsLotFeeCompleteEmailReminder = false;
hasLoan.IsAdvanceFeeDueEmailReminder = false;
hasLoan.IsLoanFeeDueEmailReminder = false;
hasLoan.IsLotFeeDueEmailReminder = false;
//if (hasLoan.AdvanceFeeDealerEmail != "")
//{
// hasLoan.IsAdvanceFeeCompleteEmailReminder = true;
//}
//if (hasLoan.MonthlyLoanFeeDealerEmail != "")
//{
// hasLoan.IsLoanFeeCompleteEmailReminder = true;
//}
//if (hasLoan.LotInspectionFeeDealerEmail != "")
//{
// hasLoan.IsLotFeeCompleteEmailReminder = true;
//}
if (hasLoan.AdvanceDueEmail != "")
{
hasLoan.IsAdvanceFeeDueEmailReminder = true;
}
if (hasLoan.MonthlyLoanDueEmail != "")
{
hasLoan.IsLoanFeeDueEmailReminder = true;
}
if (hasLoan.LotInspectionDueEmail != "")
{
hasLoan.IsLotFeeDueEmailReminder = true;
}
}
if (HttpContext.Request.IsAjaxRequest())
{
ViewBag.AjaxRequest = 1;
return PartialView(hasLoan);
}
else
{
return View(hasLoan);
}
}
else
{
ViewBag.isEdit = "notEditable";
Fees feeNew = new Fees();
feeNew.LoanId = fee.LoanId;
if (feeNew.LoanId > 0)
{
feeNew.isEdit = false;
var email = loan.getAutoRemindEmailByLoanId(feeNew.LoanId);
if (email != null)
{
feeNew.AdvanceDueEmail = email;
feeNew.MonthlyLoanDueEmail = email;
feeNew.LotInspectionDueEmail = email;
}
//feeNew.IsAdvanceFeeCompleteEmailReminder = false;
//feeNew.IsLotFeeCompleteEmailReminder = false;
//feeNew.IsLoanFeeCompleteEmailReminder = false;
feeNew.IsAdvanceFeeDueEmailReminder = false;
feeNew.IsLotFeeDueEmailReminder = false;
feeNew.IsLoanFeeDueEmailReminder = false;
if (HttpContext.Request.IsAjaxRequest())
{
ViewBag.AjaxRequest = 1;
return PartialView(feeNew);
}
else
{
return View(feeNew);
}
}
else
{
return RedirectToAction("Step7");
}
}
}
public ActionResult Step6_Post(LoanSetupStep1 loanSetupStep1)
{
int userId = userData.UserId;
if (!CheckTheRangeOfPayOffPeriod(loanSetupStep1.autoReminderPeriod, loanSetupStep1.startDate, loanSetupStep1.maturityDate, 0))
{
return new HttpStatusCodeResult(404, "Auto reminder period is out of range");
}
if (!IsAtleastOneSelectUnitType(loanSetupStep1.allUnitTypes))
{
return new HttpStatusCodeResult(404, "Select Atleast One Unit Type");
}
// check he is super admin or admin
if (userData.RoleId > 2)
{
return new HttpStatusCodeResult(404, "Not Allowed");
}
if ((Session["dashboard"] !=null))
{
loanData.stepId = 1;
}
// check if step is 6...
StepAccess sa = new StepAccess();
if (loanData.stepId < 1)
{
return new HttpStatusCodeResult(404, "Not Allowed");
}
LoanSetupAccess loanSetupAccess = new LoanSetupAccess();
LoanSetupAccess la = new LoanSetupAccess();
int loanId = loanData.loanId;
loanData.CompanyId = userData.Company_Id;
Session["loanStep"] = loanData;
if (loanId > 0)
{
loanId = loanSetupAccess.insertLoanStepOne(loanSetupStep1, loanId);
if (loanId > 0)
{
Log log = new Log(userData.UserId, userData.Company_Id, loanSetupStep1.RegisteredBranchId, loanId, "Loan Details", "Edited Loan : " + loanId, DateTime.Now);
int islog = (new LogAccess()).InsertLog(log);
}
else
{
TempData["error"] = "error";
return RedirectToAction("step6");
}
}
else
{
//loanId = la.getLoanIdByUserId(userId);
loanId = loanSetupAccess.insertLoanStepOne(loanSetupStep1, loanId);
if (loanId > 0)
{
Log log = new Log(userData.UserId, userData.Company_Id, loanSetupStep1.RegisteredBranchId, loanId, "Loan Details", "Inserted Loan : " + loanId, DateTime.Now);
int islog = (new LogAccess()).InsertLog(log);
}
//need to update loanSetup object
else
{
TempData["error"] = "error";
return RedirectToAction("step6");
}
}
if (loanId > 0)
{
if (loanSetupStep1.isInterestCalculate)
{
sa.UpdateLoanSetupStep(userData.UserId, loanData.CompanyId, loanSetupStep1.RegisteredBranchId, loanSetupStep1.nonRegisteredBranchId, loanId, 2);
if (loanData.stepId < 2)
{
loanData.stepId = 2;
}
//loanData.stepId = 2;
}
else
{
sa.UpdateLoanSetupStep(userData.UserId,loanData.CompanyId, loanSetupStep1.RegisteredBranchId, loanSetupStep1.nonRegisteredBranchId, loanId, 3);
if (loanData.stepId < 3)
{
loanData.stepId = 3;
}
}
loanData.BranchId = loanSetupStep1.RegisteredBranchId;
loanData.nonRegisteredBranchId = loanSetupStep1.nonRegisteredBranchId;
loanData.loanId = loanId;
Session["loanStep"] = loanData;
}
Session["loanStep"] = loanData;
if (loanSetupStep1.isInterestCalculate)
{
return RedirectToAction("step7");
}
else
{
//sa.UpdateLoanSetupStep(loanData.CompanyId, loanData.BranchId, loanSetupStep1.nonRegisteredBranchId, loanId, 3);
return RedirectToAction("step8");
}
}