public ActionResult loadGrid() { string loanCode; try { loanCode = Session["loanCode"].ToString(); } catch (Exception) { //filterContext.Controller.TempData.Add("UserLogin", "Login"); return RedirectToAction("UserLogin", "Login", new { lbl = "Due to inactivity your session has timed out, please log in again." }); } LoanSetupStep1 loanDetails = new LoanSetupStep1(); loanDetails = (new LoanSetupAccess()).GetLoanDetailsByLoanCode(loanCode); BranchAccess ba = new BranchAccess(); ViewBag.ComType = userData.CompanyType; ViewBag.loanId = loanDetails.loanId; ViewBag.loanDetails = loanDetails; UnitPayOffViewModel unitPayOffViewModel = new UnitPayOffViewModel(); CurtailmentAccess payoff = new CurtailmentAccess(); unitPayOffViewModel.UnitPayOffList = new List<UnitPayOffModel>(); unitPayOffViewModel.PayDate = DateTime.Now; unitPayOffViewModel.UnitPayOffList = payoff.GetUnitPayOffList(loanDetails.loanId); decimal advanceFee = 0; advanceFee = payoff.AdvanceForPayOffUnits(loanDetails.loanId); //int advanceFeeAtPayoff = payoff.CheckAdvanceFeeAtPayOff(loanDetails.loanId); //if (advanceFeeAtPayoff == 1) { // foreach (var unit in unitPayOffViewModel.UnitPayOffList) { // unit.IsAdvancePaid = false; // } //} ViewBag.AdvanceFee = advanceFee; var unitPayOffList = unitPayOffViewModel.UnitPayOffList; Session["payoffList"] = unitPayOffList; ViewBag.payOffList = unitPayOffList; TitleAccess ta = new TitleAccess(); Title title = ta.getTitleDetails(loanDetails.loanId); Session["PayOffUnitloanId"] = loanDetails.loanId; if (title != null) { bool isTitleTrack = title.IsTitleTrack; if (isTitleTrack) ViewBag.IsTitleTrack = "Yes"; } return PartialView(unitPayOffViewModel); }
/* Frontend page: Fee Page Title: get fees by selected date Designed: Nadeeka User story: Developed: Nadeeka Date created: 4/21/2016 */ public ActionResult PayFeesForSelectedDueDate(DateTime dueDate, string type) { LoanSetupStep1 loanDetails = new LoanSetupStep1(); loanDetails = (new LoanSetupAccess()).GetLoanDetailsByLoanCode(Session["loanCode"].ToString()); // take the loan detail of selected loan // pass the loan details to the view ViewBag.loanDetails = loanDetails; FeeAccess feeAccess = new FeeAccess(); List<Fees> lstFee = feeAccess.GetFeesByDueDate(loanDetails.loanId, dueDate, type); // get fees list by duedate and type of fee FeesModel feeModel = new FeesModel(); feeModel.FeeModelList = new List<Fees>(); feeModel.Type = type; // if list exists, add to model and session for searching if (lstFee != null && lstFee.Count > 0) { feeModel.FeeModelList.AddRange(lstFee); Session["feeList"] = feeModel.FeeModelList; } // return partial view of selected fee page return PartialView(feeModel); }
/// <summary> /// Frontend page: Advance Unit /// Title: Get loan details and not advanced unit details from database and return to view /// Designed: Nadeeka /// User story: /// Developed: Nadeeka /// Date created: 02/24/2016 /// </summary> /// <param name="model"></param> /// <returns>Return partial view</returns> public ActionResult Advance() { int flag = -1; //assign logged user id to variable int userId = userData.UserId; string loanCode; try { //convert session to string variable loanCode = Session["loanCode"].ToString(); } catch (Exception) { //if exception occured return to login page return RedirectToAction("UserLogin", "Login"); } BranchAccess branch = new BranchAccess(); //retrieve company type for given user id int companyType = branch.getCompanyTypeByUserId(userId); //check company type 1-Lender if (companyType == 1) { ViewBag.isLender = true; } //company type 2 - Dealer else { ViewBag.isLender = false; } ViewBag.unitClickId = ""; LoanSetupStep1 loanDetails = new LoanSetupStep1(); //retrieve loan delails for given loan code loanDetails = (new LoanSetupAccess()).GetLoanDetailsByLoanCode(loanCode); //check logged user role is user if (userData.RoleId == 3) { //check Session["CurrentLoanRights"] is null or empty if (Session["CurrentLoanRights"] == null || Session["CurrentLoanRights"].ToString() == "") { return RedirectToAction("UserDetails", "UserManagement"); } else { var checkPermission = false; string rgts = ""; //convert Session["CurrentLoanRights"] to string variable rgts = (string)Session["CurrentLoanRights"]; string[] rgtList = null; //check right string is not empty if (rgts != "") { //split string rgtList = rgts.Split(','); } //check right list is not null if (rgtList != null) { foreach (var x in rgtList) { //check relevant right for Advance Unit page contains in the user right list if (x == "U01") { checkPermission = true; } } //check permission value is false if (checkPermission == false) { //return to dashboard return RedirectToAction("UserDetails", "UserManagement"); } } else { //return to dashboard return RedirectToAction("UserDetails", "UserManagement"); } } } //check logged user is dealer user else if (userData.RoleId == 4) { //return to dashboard return RedirectToAction("UserDetails", "UserManagement"); } ViewBag.loanDetails = loanDetails; Models.Unit unit = new Models.Unit(); //get units which need to advance for given loan id AdvanceUnit advanceUnit = this.GetAdvanceUnitList(loanDetails.loanId); //assign loan id to session object Session["advUnitloanId"] = loanDetails.loanId; //assign not advanced unit list to session object Session["notAdvancedList"] = advanceUnit.NotAdvanced; ViewBag.advanceList = advanceUnit.NotAdvanced; //check update result of Advance Unit page if((TempData["updateReslt"]!=null)&&(TempData["updateReslt"].ToString() != "")) { //convert result to integer flag = int.Parse(TempData["updateReslt"].ToString()); } //check result value is 1 if (flag == 1) { //flag 1 - success ViewBag.Msg = "Success"; } else if (flag == 0) { //flag 0 - error ViewBag.Msg = "Error"; } else if (flag == 2) { //flag 2 - Advance amount error ViewBag.Msg = "Advance amount error"; }else if(flag == 3) { //flag 3 - Advance error ViewBag.Msg = "Advance Error"; } //return advance unit list to view return View(advanceUnit); }
/// <summary> /// CreatedBy : Nadeeka /// CreatedDate: 2016/02/09 /// /// Insert curtailment details /// /// argument : curtailment list /// /// </summary> /// <returns>1</returns> public LoanSetupStep1 GetLoanDetailsByLoanId(int loanId) { try { LoanSetupStep1 loan = new LoanSetupStep1(); DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@loan_id", loanId }); DataSet dataSet = dataHandler.GetDataSet("spGetLoanDetailsByLoanId", paramertList); if (dataSet != null && dataSet.Tables.Count != 0 && dataSet.Tables[0].Rows.Count != 0) { DataRow dataRow = dataSet.Tables[0].Rows[0]; loan.loanNumber = dataRow["loan_number"].ToString(); loan.startDate = Convert.ToDateTime(dataRow["start_date"]); loan.maturityDate = Convert.ToDateTime(dataRow["maturity_date"]); loan.loanAmount = Convert.ToDecimal(dataRow["loan_amount"]); loan.advancePercentage = Convert.ToInt32(dataRow["advance"]); //0 - day, 1 - month loan.payOffPeriodType = 1; if (dataRow["pay_off_type"].ToString() == "d") loan.payOffPeriodType = 0; //loan.payOffPeriod = Convert.ToInt32(dataRow["pay_off_period"]); loan.LoanStatus = Convert.ToBoolean(dataRow["loan_status"]); loan.isInterestCalculate = Convert.ToBoolean(dataRow["is_interest_calculate"]); loan.isEditAllowable = Convert.ToBoolean(dataRow["is_edit_allowable"]); loan.CurtailmentDueDate = dataRow["curtailment_due_date"].ToString(); loan.CurtailmentAutoRemindEmail = dataRow["curtailment_auto_remind_email"].ToString(); if (!string.IsNullOrEmpty(dataRow["curtailment_remind_period"].ToString())) { loan.CurtailmentEmailRemindPeriod = Convert.ToInt32(dataRow["curtailment_remind_period"].ToString()); } loan.CurtailmentCalculationBase = dataRow["curtailment_calculation_type"].ToString(); return loan; } else { return null; } } catch (Exception ex) { throw ex; } }
/// <summary> /// CreatedBy : Nadeeka /// CreatedDate: 2016/03/15 /// /// Get loan curtailment schedule by loan id /// /// </summary> /// <param name="loanId">loan id</param> /// <returns>curtialment breakdown as a DataSet</returns> public LoanSetupStep1 GetLoanCurtailmentBreakdown(int loanId) { DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@loan_id", loanId }); DataSet dataSet = dataHandler.GetDataSet("spGetLoanCurtailmentBreakdown", paramertList); if (dataSet != null && dataSet.Tables.Count != 0) { LoanSetupStep1 loan = new LoanSetupStep1(); loan.curtailmetList = new List<Curtailment>(); loan.payOffPeriodType = dataSet.Tables[0].Rows[0]["pay_off_type"].ToString().Equals("d") ? 0 : 1; //loan.payOffPeriod = Convert.ToInt32(dataSet.Tables[0].Rows[0]["pay_off_period"].ToString()); loan.CurtailmentCalculationBase = dataSet.Tables[0].Rows[0]["curtailment_calculation_type"].ToString(); loan.advancePercentage = Convert.ToInt32(dataSet.Tables[0].Rows[0]["advance"].ToString()); foreach (DataRow dataRow in dataSet.Tables[0].Rows) { Curtailment curtailment = new Curtailment(); curtailment.CurtailmentId = Convert.ToInt32(dataRow["curtailment_id"].ToString()); curtailment.TimePeriod = Convert.ToInt32(dataRow["time_period"].ToString()); curtailment.Percentage = Convert.ToInt32(dataRow["percentage"].ToString()); loan.curtailmetList.Add(curtailment); } return loan; } else { return null; } }
/// <summary> /// CreatedBy : iRFAN /// CreatedDate: 2016/02/25 /// /// GET LOAN DETAILS BY NON REG BRANCH ID /// /// /// /// </summary> /// <returns>1</returns> public List<LoanSetupStep1> GetLoanDetailsByNonRegBranchId(int nonRegBranchId) { List<LoanSetupStep1> loanList = new List<LoanSetupStep1>(); DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@non_reg_branch_id", nonRegBranchId }); try { DataSet dataSet = dataHandler.GetDataSet("spGetLoanDetailsByNonRegBranchId", paramertList); if (dataSet != null && dataSet.Tables.Count != 0 && dataSet.Tables[0].Rows.Count != 0) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { LoanSetupStep1 loan = new LoanSetupStep1(); loan.loanNumber = dataRow["loan_number"].ToString(); loan.startDate = Convert.ToDateTime(dataRow["start_date"]); loan.maturityDate = Convert.ToDateTime(dataRow["maturity_date"]); loan.loanAmount = Convert.ToDecimal(dataRow["loan_amount"]); loan.advancePercentage = Convert.ToInt32(dataRow["advance"]); //0 - day, 1 - month if (dataRow["pay_off_type"].ToString() == "d") loan.payOffPeriodType = 0; loan.payOffPeriodType = 1; //loan.payOffPeriod = Convert.ToInt32(dataRow["pay_off_period"]); loan.LoanStatus = Convert.ToBoolean(dataRow["loan_status"]); loan.loanCode = dataRow["loan_code"].ToString(); loan.isEditAllowable = Convert.ToBoolean(dataRow["is_edit_allowable"]); loanList.Add(loan); } } return loanList; } catch (Exception ex) { throw ex; } }
internal int insertLoanStepOne(LoanSetupStep1 loanSetupStep1, int loanId) { DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); try { paramertList.Add(new object[] { "@loan_id", loanId }); paramertList.Add(new object[] { "@advance", loanSetupStep1.advancePercentage}); paramertList.Add(new object[] { "@auto_remind_email", loanSetupStep1.autoReminderEmail }); paramertList.Add(new object[] { "@auto_remind_period", loanSetupStep1.autoReminderPeriod }); paramertList.Add(new object[] { "@default_unit_type", loanSetupStep1.defaultUnitType }); paramertList.Add(new object[] { "@is_edit_allowable", loanSetupStep1.isEditAllowable }); paramertList.Add(new object[] { "@is_interest_calculate", loanSetupStep1.isInterestCalculate }); paramertList.Add(new object[] { "@loan_amount", loanSetupStep1.loanAmount }); paramertList.Add(new object[] { "@loan_number", loanSetupStep1.loanNumber }); paramertList.Add(new object[] { "@maturity_date", loanSetupStep1.maturityDate }); paramertList.Add(new object[] { "@non_reg_branch_id", loanSetupStep1.nonRegisteredBranchId }); paramertList.Add(new object[] { "@payment_method", loanSetupStep1.paymentMethod }); //paramertList.Add(new object[] { "@pay_off_period", loanSetupStep1.payOffPeriod }); //paramertList.Add(new object[] { "@pay_off_type", ((loanSetupStep1.payOffPeriodType == 0) ? 'd' : 'm') }); paramertList.Add(new object[] { "@loan_code", (new BranchAccess()).getBranchByBranchId(loanSetupStep1.RegisteredBranchId).BranchCode + "-" + loanSetupStep1.loanNumber }); paramertList.Add(new object[] { "@start_date", loanSetupStep1.startDate }); paramertList.Add(new object[] { "@created_date", DateTime.Now }); paramertList.Add(new object[] { "@loan_status", false }); paramertList.Add(new object[] { "@is_delete", false }); //DataSet dataSet = dataHandler.GetDataSet("spInsertLoanStepOne", paramertList); //if (dataSet != null && dataSet.Tables.Count != 0 && dataSet.Tables[0].Rows.Count != 0) //{ // loanId =int.Parse(dataSet.Tables[0].Rows[0]["return"].ToString()); //} loanId=dataHandler.ExecuteSQLWithReturnVal("spInsertLoanStepOne", paramertList); if (loanId == 0) { return loanId; } else { foreach (UnitType UnitType in loanSetupStep1.allUnitTypes) { if (UnitType.isSelected == true) { List<object[]> paramertList1 = new List<object[]>(); paramertList1.Add(new object[] { "@loan_id", loanId }); paramertList1.Add(new object[] { "@unit_type_id", UnitType.unitTypeId }); dataHandler.GetDataSet("spInsertLoanUniType", paramertList1); } } return loanId; } } catch (Exception ex) { throw ex; } }
/// <summary> /// CreatedBy : Kasun /// CreatedDate: 2016/03/30 /// /// get permissioned loans with branch , non reg branch and loan details /// </summary> /// <param name="userId"></param> /// <returns></returns> public LoanSelection GetPermisssionGivenLoanwithBranchDeatils(int userId,int companyId,int? branchId,int roleId) { LoanSelection detailList = new LoanSelection(); DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@userId", userId }); paramertList.Add(new object[] { "@companyId", companyId }); paramertList.Add(new object[] { "@branchId", branchId }); paramertList.Add(new object[] { "@roleId", roleId }); try { DataSet dataSet = dataHandler.GetDataSet("spRetrivePermissionGivenLoans", paramertList); if (dataSet != null && dataSet.Tables.Count != 0) { List<Branch> RegBranches = new List<Branch>(); List<NonRegBranch> NonRegBranchList = new List<NonRegBranch>(); List<LoanSetupStep1> LoanList = new List<LoanSetupStep1>(); foreach (DataRow dataRow in dataSet.Tables[0].Rows) { Branch branch = new Branch(); NonRegBranch nonRegBranch = new NonRegBranch(); LoanSetupStep1 loan = new LoanSetupStep1(); branch.BranchId = int.Parse(dataRow["branch_id"].ToString()); branch.BranchName = dataRow["regBranchName"].ToString(); nonRegBranch.NonRegBranchId = int.Parse(dataRow["non_reg_branch_id"].ToString()); nonRegBranch.BranchId = branch.BranchId; nonRegBranch.CompanyNameBranchName = dataRow["nonRegBranchName"].ToString(); loan.loanId = int.Parse(dataRow["loan_id"].ToString()); loan.loanNumber = dataRow["loan_number"].ToString(); loan.loanCode = dataRow["loan_code"].ToString(); loan.rightId = dataRow["right_id"].ToString(); loan.loanAmount = decimal.Parse(dataRow["loan_amount"].ToString()); loan.startDate = DateTime.Parse(dataRow["start_date"].ToString()); loan.maturityDate = DateTime.Parse(dataRow["maturity_date"].ToString()) ; loan.CreatedDate = DateTime.Parse(dataRow["created_date"].ToString()) ; if (dataRow["is_title_tracked"].ToString() != null && dataRow["is_title_tracked"].ToString() != "") { loan.titleTracked = bool.Parse(dataRow["is_title_tracked"].ToString()); } if (!string.IsNullOrEmpty(dataRow["has_lot_inspection_fee"].ToString())) { if (bool.Parse(dataRow["has_lot_inspection_fee"].ToString())) { loan.LotInspectionFee = 1; } else { loan.LotInspectionFee = 0; } } else { loan.LotInspectionFee = 0; } if (!string.IsNullOrEmpty(dataRow["has_monthly_loan_fee"].ToString())) { if (bool.Parse(dataRow["has_monthly_loan_fee"].ToString())) { loan.MonthlyLoanFee = 1; } else { loan.MonthlyLoanFee = 0; } } else { loan.MonthlyLoanFee = 0; } if (!string.IsNullOrEmpty(dataRow["has_advance_fee"].ToString())) { if (bool.Parse(dataRow["has_advance_fee"].ToString())) { loan.AdvanceFee = 1; } else { loan.AdvanceFee = 0; } if (!string.IsNullOrEmpty(dataRow["payment_due_method"].ToString())) { if (dataRow["payment_due_method"].ToString().Contains("Vehicle Payoff")) { loan.AdvanceFeePayAtPayoff = true; } else { loan.AdvanceFeePayAtPayoff = false; } } } else { loan.AdvanceFee = 0; } loan.nonRegisteredBranchId = nonRegBranch.NonRegBranchId; bool checkBranch = false; bool checkNonRegBranch = false; bool checkLoan = false; foreach (var br in RegBranches) { if (br.BranchId == branch.BranchId) { checkBranch = true; } } if (checkBranch == false) { RegBranches.Add(branch); } foreach (var nrbr in NonRegBranchList) { if (nrbr.NonRegBranchId == nonRegBranch.NonRegBranchId) { checkNonRegBranch = true; } } if (checkNonRegBranch == false) { NonRegBranchList.Add(nonRegBranch); } foreach (var l in LoanList) { if (l.loanId == loan.loanId) { checkLoan = true; } } if (checkLoan == false) { LoanList.Add(loan); } } detailList.RegBranches = RegBranches; detailList.NonRegBranchList = NonRegBranchList; detailList.LoanList = LoanList; return detailList; } else { return null; } } catch (Exception ex) { throw ex; } }
/* Frontend page: Curtailment Page Title: Curtailments by selected due date Designed: Nadeeka User story: Developed: Nadeeka Date created: 3/21/2016 */ public ActionResult PayCurtailmentForSelectedDueDate(DateTime dueDate) { CurtailmentScheduleModel curtailmentScheduleModel = new CurtailmentScheduleModel(); LoanSetupStep1 loanDetails = new LoanSetupStep1(); loanDetails = (new LoanSetupAccess()).GetLoanDetailsByLoanCode(Session["loanCode"].ToString()); // take loan details of selected loan ViewBag.loanDetails = loanDetails; string f = dueDate.ToShortDateString(); DateTime dd = Convert.ToDateTime(f); CurtailmentAccess curtailmentAccess = new CurtailmentAccess(); List<CurtailmentShedule> curtailmentSchedule = curtailmentAccess.GetCurtailmentScheduleByDueDate(loanDetails.loanId, dd); // get curtailment list by due date ViewBag.DealerEmail = (string)Session["DealerEmail"]; // pass dealer email to the view ViewBag.LoanId = loanDetails.loanId; // pass loan id to the view curtailmentScheduleModel.CurtailmentScheduleInfoModel = new List<CurtailmentShedule>(); curtailmentScheduleModel.CurtailmentScheduleInfoModel.AddRange(curtailmentSchedule); // bind the list of curtailment to model curtailmentScheduleModel.DueDate = dueDate; // bind the due date to model // return the partial view page return PartialView(curtailmentScheduleModel); }
/* Frontend page: Curtailment Page Title: Load curtailment page Designed: Nadeeka User story: Developed: Nadeeka Date created: 3/21/2016 */ public ActionResult PayCurtailments() { // if user access via url -- wrong access if (Session["loanCode"] == null || Session["loanCode"].ToString() == "") return RedirectToAction("UserLogin", "Login", new { lbl = "Failed find loan" }); lCode = Session["loanCode"].ToString(); // take the loan code // if user is a normal user, check his user rights if (userData.RoleId == 3) { if (Session["CurrentLoanRights"] == null || Session["CurrentLoanRights"].ToString() == "") { return RedirectToAction("UserDetails", "UserManagement"); } else { var checkPermission = false; string rgts = ""; rgts = (string)Session["CurrentLoanRights"]; string[] rgtList = null; if (rgts != "") { rgtList = rgts.Split(','); } if (rgtList != null) { foreach (var x in rgtList) { if (x == "U05") { checkPermission = true; } } if (checkPermission == false) { return RedirectToAction("UserDetails", "UserManagement"); } } else { return RedirectToAction("UserDetails", "UserManagement"); } } } // if user is a dealer user -- he is not allowed else if (userData.RoleId == 4) { return RedirectToAction("UserDetails", "UserManagement"); } LoanSetupStep1 loanDetails = new LoanSetupStep1(); loanDetails = (new LoanSetupAccess()).GetLoanDetailsByLoanCode(Session["loanCode"].ToString()); // take the loan details Session["curtLaonId"] = loanDetails.loanId; // save the loan id on session ViewBag.curtTotal = (new CurtailmentAccess()).GetCurtailmentsTotal(loanDetails.loanId); // pass the total amount of curtailment to the view // pass the loan details to the view ViewBag.loanDetails = loanDetails; ViewBag.LoanId = loanDetails.loanId; // return pay curtailment page return View(); }
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 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 int PayFees(List<Fees> lstFee, string type) { int userId = userData.UserId; // set the user id FeeAccess feeAccess = new FeeAccess(); LoanSetupStep1 loanDetails = new LoanSetupStep1(); loanDetails = (new LoanSetupAccess()).GetLoanDetailsByLoanCode(Session["loanCode"].ToString()); // take the loan details by loan code int returnValue = feeAccess.updateFees(lstFee, lstFee[0].PaidDate, loanDetails.loanId, userId); // update fee details //if successfully updated, insert to log if (returnValue == 1) { Log log; // if fee type is advance -- save details to log as advance fee if (type == "advanceFee") { List<string> IDNumbers = new List<string>(); foreach (var fee in lstFee) { IDNumbers.Add(fee.IdentificationNumber); } log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, loanDetails.loanId, "Pay Fees", "Advance Fee Paid for the unit(s) : " + string.Join(",", IDNumbers) + " , Pay Date : " + lstFee[0].PaidDate.ToString("dd/MM/yyyy"), DateTime.Now); (new LogAccess()).InsertLog(log); } // if fee type is monthly loan -- save details to log as monthly loan fee else if (type == "monthlyLoanFee") { List<string> DueDates = new List<string>(); foreach (var fee in lstFee) { DueDates.Add(fee.DueDate); } log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, loanDetails.loanId, "Pay Fees", " Monthly Loan Fee Paid for the due date(s) : { " + string.Join(",", DueDates) + "}" + ", Pay Date : " + lstFee[0].PaidDate.ToString("dd/MM/yyyy"), DateTime.Now); (new LogAccess()).InsertLog(log); } // if fee type is lot inspection fee -- save details to log as lot inspection fee else if (type == "lotInspectionFee") { List<string> DueDates = new List<string>(); foreach (var fee in lstFee) { DueDates.Add(fee.DueDate); } log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, loanDetails.loanId, "Pay Fees", "Lot Inspection Fee Paid for the due date(s) : { " + string.Join(",", DueDates) + " } " + ", Pay Date : " + lstFee[0].PaidDate.ToString("dd/MM/yyyy"), DateTime.Now); (new LogAccess()).InsertLog(log); } } // return the value to view return returnValue; }
internal LoanSetupStep1 GetLoanStepOne(int loanId) { LoanSetupStep1 loanSetupStep1 = new LoanSetupStep1(); IList<UnitType> unittypes = new List<UnitType>(); DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@loan_id", loanId }); try { DataSet dataSet = dataHandler.GetDataSet("spGetLoanStepOneByLoanId", paramertList); if (dataSet != null && dataSet.Tables.Count != 0 && dataSet.Tables[0].Rows.Count != 0) { DataRow dataRow = dataSet.Tables[0].Rows[0]; loanSetupStep1.advancePercentage = int.Parse(dataRow["advance"].ToString()); //loanSetupStep1.allUnitTypes loanSetupStep1.autoReminderEmail = dataRow["auto_remind_email"].ToString(); loanSetupStep1.autoReminderPeriod = int.Parse(dataRow["auto_remind_period"].ToString()); loanSetupStep1.defaultUnitType = int.Parse(dataRow["default_unit_type"].ToString()); loanSetupStep1.isEditAllowable = Convert.ToBoolean(dataRow["is_edit_allowable"].ToString()); loanSetupStep1.isInterestCalculate = Convert.ToBoolean(dataRow["is_interest_calculate"].ToString()); loanSetupStep1.loanAmount = Convert.ToDecimal(dataRow["loan_amount"].ToString()); loanSetupStep1.loanNumber = dataRow["loan_number"].ToString(); //loanSetupStep1.loanNumberForDisplay = loanSetupStep1.loanNumber; loanSetupStep1.maturityDate = Convert.ToDateTime(dataRow["maturity_date"].ToString()); loanSetupStep1.nonRegisteredBranchId = int.Parse(dataRow["non_reg_branch_id"].ToString()); loanSetupStep1.paymentMethod = dataRow["payment_method"].ToString(); //loanSetupStep1.payOffPeriod = int.Parse(dataRow["pay_off_period"].ToString()); //loanSetupStep1.payOffPeriodType = (Convert.ToChar(dataRow["pay_off_type"].ToString()) == 'd') ? 0 : 1; //loanSetupStep1.selectedUnitTypes loanSetupStep1.startDate = Convert.ToDateTime(dataRow["start_date"].ToString()); loanSetupStep1.loanCode = dataRow["loan_code"].ToString(); } DataSet dataSet2 = dataHandler.GetDataSet("spGetLoanUnitTypesByLoanId", paramertList); if (dataSet2 != null && dataSet2.Tables.Count != 0 && dataSet2.Tables[0].Rows.Count != 0) { foreach (DataRow dataRow2 in dataSet2.Tables[0].Rows) { UnitType unitType = new UnitType(); unitType.unitTypeId = int.Parse(dataRow2["unit_type_id"].ToString()); unitType.unitTypeName = dataRow2["unit_type_name"].ToString(); unittypes.Add(unitType); } loanSetupStep1.selectedUnitTypes = unittypes; } return loanSetupStep1; } catch (Exception ex) { throw ex; } //using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["AutoDealersConnection"].ConnectionString)) //{ // try // { // using (SqlCommand cmd = new SqlCommand("spGetLoanStepOneByLoanId", con)) // { // cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.Add("@loan_id", SqlDbType.Int).Value = loanId; // con.Open(); // SqlDataReader reader = cmd.ExecuteReader(); // LoanSetupStep1 loanSetupStep1 = new LoanSetupStep1(); // while (reader.Read()) // { // loanSetupStep1.advancePercentage = int.Parse(reader["advance"].ToString()); // //loanSetupStep1.allUnitTypes // loanSetupStep1.autoReminderEmail = reader["auto_remind_email"].ToString(); // loanSetupStep1.autoReminderPeriod = int.Parse(reader["auto_remind_period"].ToString()); // loanSetupStep1.defaultUnitType = int.Parse(reader["default_unit_type"].ToString()); // loanSetupStep1.isEditAllowable = Convert.ToBoolean(reader["is_edit_allowable"].ToString()); // loanSetupStep1.isInterestCalculate = Convert.ToBoolean(reader["is_interest_calculate"].ToString()); // loanSetupStep1.loanAmount = Convert.ToDecimal(reader["loan_amount"].ToString()); // loanSetupStep1.loanNumber = reader["loan_number"].ToString(); // loanSetupStep1.loanNumberForDisplay = loanSetupStep1.loanNumber; // loanSetupStep1.maturityDate = Convert.ToDateTime(reader["maturity_date"].ToString()); // loanSetupStep1.nonRegisteredBranchId = int.Parse(reader["non_reg_branch_id"].ToString()); // loanSetupStep1.paymentMethod = reader["payment_method"].ToString(); // loanSetupStep1.payOffPeriod = int.Parse(reader["pay_off_period"].ToString()); // loanSetupStep1.payOffPeriodType = (Convert.ToChar(reader["pay_off_type"].ToString()) == 'd') ? 0 : 1; // //loanSetupStep1.selectedUnitTypes // loanSetupStep1.startDate = Convert.ToDateTime(reader["start_date"].ToString()); // loanSetupStep1.loanCode = reader["loan_code"].ToString(); // } // reader.Close(); // IList<UnitType> unittypes = new List<UnitType>(); // using (SqlCommand cmd2 = new SqlCommand("spGetLoanUnitTypesByLoanId", con)) // { // cmd2.CommandType = CommandType.StoredProcedure; // cmd2.Parameters.Add("@loan_id", SqlDbType.Int).Value = loanId; // //con.Open(); // SqlDataReader reader2 = cmd2.ExecuteReader(); // while (reader2.Read()) // { // UnitType unitType = new UnitType(); // unitType.unitTypeId = int.Parse(reader2["unit_type_id"].ToString()); // unitType.unitTypeName = reader2["unit_type_name"].ToString(); // unittypes.Add(unitType); // } // loanSetupStep1.selectedUnitTypes = unittypes; // return loanSetupStep1; // } // } // } // catch (Exception ex) // { // throw ex; // } // finally // { // con.Close(); // } //} }
/* Frontend page: Fee Page Title: Load the Fee Page Designed: Nadeeka User story: Developed: Nadeeka Date created: 4/20/2016 */ public ActionResult PayFees() { try { lCode = Session["loanCode"].ToString(); // take the loan code on session } // if there is no loan on Session -- redirect to login catch (Exception) { return RedirectToAction("UserLogin", "Login", new { lbl = "Due to inactivity your session has timed out, please log in again." }); } LoanSetupStep1 loanDetails = new LoanSetupStep1(); loanDetails = (new LoanSetupAccess()).GetLoanDetailsByLoanCode(Session["loanCode"].ToString()); // take the loan details of loan code // pass loan details to the view ViewBag.loanDetails = loanDetails; Loan loanSelected = new Loan(); // take the loan which was selected from the dashboard and pass it to the view if (Session["loanDashboard"] != null) { loanSelected = (Loan)Session["loanDashboard"]; } else if (Session["oneLoanDashboard"] != null) { loanSelected = (Loan)Session["oneLoanDashboard"]; } else { // if there is no loan selected from dashboard -- wrong access return RedirectToAction("Login", "UserLogin"); } ViewBag.loanSelected = loanSelected; // if user is a normal user, checking the user permission if (userData.RoleId == 3) { if (Session["CurrentLoanRights"] == null || Session["CurrentLoanRights"].ToString() == "") { return RedirectToAction("UserDetails", "UserManagement"); } else { var checkPermission = false; string rgts = ""; rgts = (string)Session["CurrentLoanRights"]; string[] rgtList = null; if (rgts != "") { rgtList = rgts.Split(','); } if (rgtList != null) { foreach (var x in rgtList) { if (x == "U07") { checkPermission = true; } } if (checkPermission == false) { return RedirectToAction("UserDetails", "UserManagement"); } } else { return RedirectToAction("UserDetails", "UserManagement"); } } } // if user is a dealer user -- he is not allowed to fee page else if (userData.RoleId == 4) { return RedirectToAction("UserDetails", "UserManagement"); } // take the due dates of advance fee, monthly loan fee and lot inspection fee string advDuedate; string monDueDate; string lotDuedate; bool returnValue = (new FeeAccess()).GetFeesDueDates(loanDetails.loanId, out advDuedate, out monDueDate, out lotDuedate); // pass due dates to view ViewBag.advDuedate = advDuedate; ViewBag.monDueDate = monDueDate; ViewBag.lotDuedate = lotDuedate; // return fee page return View(); }
/// <summary> /// CreatedBy: Kanishka /// CreatedDate:02/29/2016 /// get loan details by loan code /// </summary> /// <param name="loanCode"></param> /// <returns></returns> internal LoanSetupStep1 GetLoanDetailsByLoanCode(string loanCode) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["AutoDealersConnection"].ConnectionString)) { try { using (SqlCommand cmd = new SqlCommand("spGetLoanDetailsByLoanCode", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@loan_code", SqlDbType.VarChar).Value = loanCode; con.Open(); SqlDataReader reader = cmd.ExecuteReader(); LoanSetupStep1 loanSetupStep1 = new LoanSetupStep1(); while (reader.Read()) { loanSetupStep1.loanId = Convert.ToInt32(reader["loan_id"]); loanSetupStep1.advancePercentage = int.Parse(reader["advance"].ToString()); loanSetupStep1.autoReminderEmail = reader["auto_remind_email"].ToString(); loanSetupStep1.autoReminderPeriod = int.Parse(reader["auto_remind_period"].ToString()); loanSetupStep1.defaultUnitType = int.Parse(reader["default_unit_type"].ToString()); loanSetupStep1.isEditAllowable = Convert.ToBoolean(reader["is_edit_allowable"].ToString()); loanSetupStep1.isInterestCalculate = Convert.ToBoolean(reader["is_interest_calculate"].ToString()); loanSetupStep1.loanAmount = Convert.ToDecimal(reader["loan_amount"].ToString()); loanSetupStep1.loanNumber = reader["loan_number"].ToString(); loanSetupStep1.maturityDate = Convert.ToDateTime(reader["maturity_date"].ToString()); loanSetupStep1.nonRegisteredBranchId = int.Parse(reader["non_reg_branch_id"].ToString()); loanSetupStep1.paymentMethod = reader["payment_method"].ToString(); loanSetupStep1.startDate = Convert.ToDateTime(reader["start_date"].ToString()); loanSetupStep1.RegisteredBranchId = Convert.ToInt32(reader["branch_id"].ToString()); loanSetupStep1.LoanStatus = Convert.ToBoolean(reader["loan_status"]); loanSetupStep1.RegisteredBranchCode = reader["r_branch_code"].ToString(); loanSetupStep1.RegisteredCompanyCode = reader["company_code"].ToString(); if(reader["curtailment_due_date"].ToString()== "EoM") { loanSetupStep1.CurtailmentDueDate = "End of Month"; } else { string dueDate = reader["curtailment_due_date"].ToString(); if (dueDate.Length > 0) { if (dueDate.Length == 1) { if (dueDate.Contains("1")) { loanSetupStep1.CurtailmentDueDate = dueDate+ "st of each month"; } else if (dueDate.Contains("2")) { loanSetupStep1.CurtailmentDueDate = dueDate + "nd of each month"; } else if (dueDate.Contains("3")) { loanSetupStep1.CurtailmentDueDate = dueDate + "rd of each month"; } else { loanSetupStep1.CurtailmentDueDate = dueDate + "th of each month"; } } else if(dueDate.Length > 1) { if (!dueDate.ElementAt(dueDate.Length - 2).ToString().Contains("1")) { if (dueDate.ElementAt(dueDate.Length - 1).ToString().Contains("1")) { loanSetupStep1.CurtailmentDueDate = dueDate + "st of each month"; } else if (dueDate.ElementAt(dueDate.Length - 1).ToString().Contains("2")) { loanSetupStep1.CurtailmentDueDate = dueDate + "nd of each month"; } else if (dueDate.ElementAt(dueDate.Length - 1).ToString().Contains("3")) { loanSetupStep1.CurtailmentDueDate = dueDate + "rd of each month"; } else { loanSetupStep1.CurtailmentDueDate = dueDate + "th of each month"; } } else { loanSetupStep1.CurtailmentDueDate = dueDate + "th of each month"; } } } //loanSetupStep1.CurtailmentDueDate = reader["curtailment_due_date"].ToString()+"th of each month"; } //loanSetupStep1.CurtailmentDueDate = reader["curtailment_due_date"].ToString(); } reader.Close(); IList<UnitType> unittypes = new List<UnitType>(); using (SqlCommand cmd2 = new SqlCommand("spGetLoanUnitTypesByLoanId", con)) { cmd2.CommandType = CommandType.StoredProcedure; cmd2.Parameters.Add("@loan_id", SqlDbType.Int).Value = loanSetupStep1.loanId; //con.Open(); SqlDataReader reader2 = cmd2.ExecuteReader(); while (reader2.Read()) { UnitType unitType = new UnitType(); unitType.unitTypeId = int.Parse(reader2["unit_type_id"].ToString()); unitType.unitTypeName = reader2["unit_type_name"].ToString(); unittypes.Add(unitType); } loanSetupStep1.selectedUnitTypes = unittypes; return loanSetupStep1; } } } catch (Exception ex) { throw ex; } finally { con.Close(); con.Dispose(); } } }
/// <summary> /// CreatedBy:Asanka Senarathna /// CreatedDate:6/27/2016 /// Get Active Loans for Inactive /// </summary> /// <param name="company_Id"></param> /// <param name="branchId"></param> /// <param name="roleId"></param> /// <returns></returns> public LoanSelection GetActiveLoanforInactive( int companyId, int branchId, int roleId) { LoanSelection detailList = new LoanSelection(); DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@companyId", companyId }); paramertList.Add(new object[] { "@branchId", branchId }); paramertList.Add(new object[] { "@roleId", roleId }); try { DataSet dataSet = dataHandler.GetDataSet("spGetActiveLoansforInactive", paramertList); if (dataSet != null && dataSet.Tables.Count != 0) { List<Branch> RegBranches = new List<Branch>(); List<NonRegBranch> NonRegBranchList = new List<NonRegBranch>(); List<LoanSetupStep1> LoanList = new List<LoanSetupStep1>(); foreach (DataRow dataRow in dataSet.Tables[0].Rows) { Branch branch = new Branch(); NonRegBranch nonRegBranch = new NonRegBranch(); LoanSetupStep1 loan = new LoanSetupStep1(); branch.BranchId = int.Parse(dataRow["branch_id"].ToString()); branch.BranchName = dataRow["regBranchName"].ToString(); nonRegBranch.NonRegBranchId = int.Parse(dataRow["non_reg_branch_id"].ToString()); nonRegBranch.BranchId = branch.BranchId; nonRegBranch.CompanyNameBranchName = dataRow["nonRegBranchName"].ToString(); loan.loanId = int.Parse(dataRow["loan_id"].ToString()); loan.loanNumber = dataRow["loan_number"].ToString(); loan.loanCode = dataRow["loan_code"].ToString(); loan.loanAmount = decimal.Parse(dataRow["loan_amount"].ToString()); loan.CreatedDate = DateTime.Parse(dataRow["created_date"].ToString()); loan.startDate = DateTime.Parse(dataRow["start_date"].ToString()); loan.maturityDate = DateTime.Parse(dataRow["maturity_date"].ToString()); loan.CurrentLoanStatus = bool.Parse(dataRow["loan_status"].ToString()); loan.nonRegisteredBranchId = nonRegBranch.NonRegBranchId; bool checkBranch = false; bool checkNonRegBranch = false; bool checkLoan = false; foreach (var br in RegBranches) { if (br.BranchId == branch.BranchId) { checkBranch = true; } } if (checkBranch == false) { RegBranches.Add(branch); } foreach (var nrbr in NonRegBranchList) { if (nrbr.NonRegBranchId == nonRegBranch.NonRegBranchId) { checkNonRegBranch = true; } } if (checkNonRegBranch == false) { NonRegBranchList.Add(nonRegBranch); } foreach (var l in LoanList) { if (l.loanId == loan.loanId) { checkLoan = true; } } if (checkLoan == false) { LoanList.Add(loan); } } detailList.RegBranches = RegBranches; detailList.NonRegBranchList = NonRegBranchList; detailList.LoanList = LoanList; return detailList; } else { return null; } } catch (Exception ex) { throw ex; } }
/* Frontend page: Update Titles Title: Update title status Designed: Piyumi User story: Developed: Piyumi Date created: 03/17/2016 */ public int UpdateTitleStatus(Models.Unit unitTitle) { string loanCode = null; //Check Session["loanCode"] is null or empty if (!string.IsNullOrEmpty(Session["loanCode"].ToString())) { //if not null or empty convert session to string variable loanCode = Session["loanCode"].ToString(); } TitleAccess titleObj = new TitleAccess(); //update title status bool reslt = titleObj.UpdateTitle(unitTitle, loanCode,userData.UserId); //Check result of update title if (reslt) { //if result is true get loan details by loan code LoanSetupStep1 loanDetails = new LoanSetupStep1(); loanDetails = (new LoanSetupAccess()).GetLoanDetailsByLoanCode(loanCode); string status = ""; //Check title status //TitleStatus 0 - Not received if (unitTitle.TitleStatus == 0) { status = "Not Received"; } //TitleStatus 1 - Received else if (unitTitle.TitleStatus == 1) { status = "Received"; } //TitleStatus 2 - Returned to Dealer else if (unitTitle.TitleStatus == 2) { status = "Returned to Dealer"; } //TitleStatus 3 - Sent to Bank else if (unitTitle.TitleStatus == 3) { status = "Sent to Bank"; } //insert log entry Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId,loanDetails.loanId, "Title Status Update", "Update title status of unit:" + unitTitle.IdentificationNumber +" ,Updated status:"+status+",Updated date:"+ DateTime.Now, DateTime.Now); int islog = (new LogAccess()).InsertLog(log); TempData["reslt"] = 1; return 1; } else { TempData["reslt"] =0; return 0; } }