public ActionResult CreatePartnerBranchAtDashboard(EditPartnerBranceModel model)
{
if (userData.RoleId != 1 && userData.RoleId != 2)
{
return RedirectToAction("UserDetails", "UserManagement");
}
CompanyBranchModel nonRegBranch = model.CompanyBranch;
nonRegBranch.MainBranch.StateId = model.StateId;
nonRegBranch.MainBranch.BranchCreatedBy = model.RegBranchId;
nonRegBranch.MainBranch.BranchCompany = model.NonRegCompanyId;
CompanyAccess ca = new CompanyAccess();
BranchAccess ba = new BranchAccess();
Company company = ca.GetNonRegCompanyByCompanyId(model.NonRegCompanyId);
//nonRegBranch.MainBranch.BranchCode = ba.createNonRegBranchCode(company.CompanyCode);
int reslt = ba.insertNonRegBranchDetails(nonRegBranch, userData.UserId, company.CompanyCode);
if (reslt > 0)
{
//update Companay Step States in incomplete Branches continued in dashboard
StepAccess sa = new StepAccess();
sa.UpdateLoanSetupStep(userData.UserId, userData.Company_Id, model.RegBranchId, reslt, 0, 1);
if (_compType == 1)
{
ViewBag.SuccessMsg = "Dealer branch is successfully inserted";
}
else if (_compType == 2)
{
ViewBag.SuccessMsg = "Lender branch is successfully inserted";
}
return RedirectToAction("CreatePartnerBranchAtDashboard", new { lbls = ViewBag.SuccessMsg });
}
else
{
ViewBag.ErrorMsg = "Failed to udate";
return RedirectToAction("CreatePartnerBranchAtDashboard", new { lbls = ViewBag.ErrorMsg });
}
}
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 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 Step8(Fees fees)
{
if (userData.RoleId >= 3)
{
return RedirectToAction("UserLogin", "Login", new { lbl = "You are not Allowed." });
}
StepAccess step = new StepAccess();
if (fees.AdvanceDue == "Vehicle Payoff")
{
fees.AdvanceDueDate = "VP";
}
if (fees.AdvanceDue == "Time of Advance")
{
fees.AdvanceDueDate = "ToA";
}
//if (fees.IsAdvanceFeeCompleteEmailReminder == false)
//{
// fees.AdvanceFeeDealerEmail = "";
// fees.AdvanceFeeDealerEmailRemindPeriod = 0;
//}
//if (fees.IsLoanFeeCompleteEmailReminder == false)
//{
// fees.MonthlyLoanFeeDealerEmail = "";
// fees.MonthlyLoanFeeDealerEmailRemindPeriod = 0;
//}
//if (fees.IsLotFeeCompleteEmailReminder == false)
//{
// fees.LotInspectionFeeDealerEmail = "";
// fees.LotInspectionFeeDealerEmailRemindPeriod = 0;
//}
if (fees.IsAdvanceFeeDueEmailReminder == false)
{
fees.AdvanceDueEmail = "";
fees.AdvanceDueEmailRemindPeriod = 0;
}
if (fees.IsLoanFeeDueEmailReminder == false)
{
fees.MonthlyLoanDueEmail = "";
fees.MonthlyLoanDueEmailRemindPeriod = 0;
}
if (fees.IsLotFeeDueEmailReminder == false)
{
fees.LotInspectionDueEmail = "";
fees.LotInspectionDueEmailRemindPeriod = 0;
}
fees.LoanId = loanData.loanId;
// after hide the due methods
fees.MonthlyLoanDue = "Once a Month";
fees.LotInspectionDue = "Monthly";
if (step.InsertFeesDetails(fees))
{
var userId = userData.UserId;
var branchId = loanData.loanId;
if (fees.isEdit == true)
{
return RedirectToAction("Step9");
}
else if (step.UpdateLoanSetupStep(userData.UserId, loanData.CompanyId, loanData.BranchId, loanData.nonRegisteredBranchId, loanData.loanId, 4))
{
if (loanData.stepId < 4)
{
loanData.stepId = 4;
Log log = new Log(userData.UserId, userData.Company_Id, loanData.BranchId, fees.LoanId, "Fees", "Inserted fees details of loan : " + fees.LoanId, DateTime.Now);
int islog = (new LogAccess()).InsertLog(log);
}
else
{
Log log = new Log(userData.UserId, userData.Company_Id, loanData.BranchId, fees.LoanId, "Fees", "Edited fees details of loan : " + fees.LoanId, DateTime.Now);
int islog = (new LogAccess()).InsertLog(log);
}
Session["loanStep"] = loanData;
return RedirectToAction("Step9");
}
else
{
return RedirectToAction("Step8");
}
}
else
{
return RedirectToAction("Step8");
}
}
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");
}
}
public ActionResult Step5(NonRegCompanyBranchModel nonRegCompanyBranch, string branchCode)
{
CompanyBranchModel nonRegBranch = nonRegCompanyBranch.CompanyBranch;
int userId = userData.UserId;
BranchAccess ba = new BranchAccess();
CompanyAccess ca = new CompanyAccess();
int compType = ba.getCompanyTypeByUserId(userId);
nonRegBranch.MainBranch.StateId = nonRegCompanyBranch.StateId;
nonRegBranch.MainBranch.BranchCode = branchCode;
Company company = new Company();
//check partner branch code is null
if (string.IsNullOrEmpty(branchCode))
{
//get partner company details
company = ca.GetNonRegCompanyByCompanyId(nonRegCompanyBranch.NonRegCompanyId);
}
nonRegBranch.MainBranch = nonRegBranch.MainBranch;
//Get created branch id
UserManageAccess uma = new UserManageAccess();
nonRegBranch.MainBranch.BranchCreatedBy = nonRegCompanyBranch.RegBranchId;
nonRegBranch.MainBranch.BranchCompany = nonRegCompanyBranch.NonRegCompanyId;
//Set admin branch to new user
if (userData.RoleId == 2)
{
nonRegBranch.MainBranch.BranchCreatedBy = userData.BranchId;
}
//insert or update partner branch details
int reslt = ba.insertNonRegBranchDetails(nonRegBranch, userId, company.CompanyCode);
//check result is greater than 0
if (reslt > 0)
{
StepAccess sa = new StepAccess();
bool reslt2 = false;
//check user is admin
if(userData.RoleId == 2)
{
//update company setup and insert a record to loan setup step
reslt2 = sa.UpdateLoanSetupStep(userData.UserId,userData.Company_Id, userData.BranchId, reslt, 0, 1);
}
//check user is super admin
else if(userData.RoleId == 1)
{
//update company setup and insert a record to loan setup step
reslt2 = sa.UpdateLoanSetupStep(userData.UserId,userData.Company_Id, nonRegCompanyBranch.RegBranchId, reslt, 0, 1);
}
//check update result
if (reslt2)
{
//if lender company
if (compType == 1)
{
ViewBag.SuccessMsg = "Dealer branch is successfully created";
}
//if dealer company
else if (compType == 2)
{
ViewBag.SuccessMsg = "Lender branch is successfully created";
}
//----------------
//check loan step is less than 1
if(loanData.stepId<1)
{
//update loan step and assign to session
loanData.stepId = 1;
Session["loanStep"] = loanData;
}
//------------------------
//check user's step status is 1 or 2
if((userData.step_status==1)|| (userData.step_status == 2)) {
//return to step5
return RedirectToAction("Step5", new { lbls = ViewBag.SuccessMsg });
}
//check user's step status is 0
else if (userData.step_status == 0) {
//return loan step 1
return RedirectToAction("Step6");
}
}
}
else
{
ViewBag.ErrorMsg = "Failed to create branch";
}
//Get states to list
List<State> stateList = ca.GetAllStates();
ViewBag.StateId = new SelectList(stateList, "StateId", "StateName");
//return PartialView();
//check ajax request
if (HttpContext.Request.IsAjaxRequest())
{
ViewBag.AjaxRequest = 1;
return PartialView(nonRegCompanyBranch);
}
else
{
return View(nonRegCompanyBranch);
}
}
