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" }); }
//internal void getSelectedUnitTypes(int loanId, LoanSetupStep1 loanSetupStep1) //{ // DataHandler dataHandler = new DataHandler(); // List<object[]> paramertList = new List<object[]>(); // paramertList.Add(new object[] { "@loan_id", loanId }); // try // { // } // catch // { // } // using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["AutoDealersConnection"].ConnectionString)) // { // try // { // using (SqlCommand cmd = new SqlCommand("spGetLoanUnitTypesByLoanId", con)) // { // cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.Add("@loan_id", SqlDbType.Int).Value = loanId; // con.Open(); // SqlDataReader reader = cmd.ExecuteReader(); // while (reader.Read()) // { // UnitType unitType = new UnitType(); // unitType.unitTypeId = int.Parse(reader["unit_type_id"].ToString()); // //loanSetupStep1.selectedUnitTypes.Add(unitType); // } // reader.Close(); // } // } // catch (Exception ex) // { // throw ex; // } // finally // { // con.Close(); // } // } //} internal int UpdateLoanCurtailment(CurtailmentModel curtailmentModel, int loanId) { DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); bool loanStatus = curtailmentModel.LoanStatus == "Yes" ? true : false; char calMode = curtailmentModel.CalculationBase == "Full payment" ? 'f' : 'a'; char timeBase = curtailmentModel.TimeBase == "Months" ? 'm' : 'd'; paramertList.Add(new object[] { "@loan_id", loanId }); paramertList.Add(new object[] { "@loan_status", loanStatus }); paramertList.Add(new object[] { "@curtailment_due_date", curtailmentModel.DueDate }); paramertList.Add(new object[] { "@curtailment_auto_remind_email", curtailmentModel.AutoRemindEmail}); paramertList.Add(new object[] { "@curtailment_remind_period", curtailmentModel.EmailRemindPeriod }); paramertList.Add(new object[] { "@curtailment_calculation_type", calMode }); paramertList.Add(new object[] { "@pay_off_type", timeBase }); try { return dataHandler.ExecuteSQLReturn("spUpdateLoanCurtailmentd", paramertList); } catch (Exception ex) { throw ex; } }
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." }); }