/// <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; } }
public ActionResult Selectloan(string type) { LoanSelection detail = new LoanSelection(); //if edit loan if (!string.IsNullOrEmpty(type) && type.Contains("tidenaol")) { detail = (new UnitAccess()).GetInActiveLoans(userData.UserId, userData.Company_Id, userData.BranchId, userData.RoleId); if (detail != null) { Session["detail"] = detail; } else { return RedirectToAction("UserLogin", "Login"); } } else if (!string.IsNullOrEmpty(type) && type.Contains("aticno")) { detail = (new UnitAccess()).GetPermisssionGivenLoanwithBranchDeatils(userData.UserId, userData.Company_Id, userData.BranchId, userData.RoleId); if (detail != null) { Session["detail"] = detail; } else { return RedirectToAction("UserLogin", "Login"); } } else if(!string.IsNullOrEmpty(type) && type.Contains("tcaninaol")) { detail = (new UnitAccess()).GetActiveLoanforInactive(userData.Company_Id, userData.BranchId, userData.RoleId); if (detail != null) { Session["detail"] = detail; } else { return RedirectToAction("UserLogin", "Login"); } } else if (!string.IsNullOrEmpty(type)) { detail = (new UnitAccess()).GetPermisssionGivenLoanwithBranchDeatils(userData.UserId, userData.Company_Id, userData.BranchId, userData.RoleId); if (detail == null) { ViewBag.type = "return"; return PartialView(); } else if (detail != null) { Session["detail"] = detail; } } int userId = userData.UserId; // if Session is expired throw an error loanSelection.RegBranches = new List<Branch>(); loanSelection.NonRegBranchList = new List<NonRegBranch>(); loanSelection.LoanList = new List<LoanSetupStep1>(); //getting user role UserAccess ua = new UserAccess(); // curUser.Company_Id asanka 8/3/2016 //create list for nonRegisterCompaniers List<NonRegBranch> NonRegisteredBranchLists = detail.NonRegBranchList; //(new BranchAccess()).getNonRegBranches(userData.Company_Id); if (userData.RoleId == 1) { loanSelection.RegBranches = detail.RegBranches; //(new BranchAccess()).getBranches(userData.Company_Id); if (loanSelection.RegBranches != null && loanSelection.RegBranches.Count() == 1) { // the get non registered branches details for perticular branch from the non registeres branches list foreach (NonRegBranch branch in NonRegisteredBranchLists) { if (branch.BranchId == loanSelection.RegBranches[0].BranchId) { loanSelection.NonRegBranchList.Add(branch); } } if (loanSelection.NonRegBranchList.Count() == 1) { List<LoanSetupStep1> loanLists = detail.LoanList; //new LoanSetupAccess().GetLoanDetailsByNonRegBranchId(loanSelection.NonRegBranchList[0].NonRegBranchId); loanSelection.LoanList = new List<LoanSetupStep1>(); foreach (LoanSetupStep1 loan in loanLists) { // if(loan.LoanStatus == true) // { loanSelection.LoanList.Add(loan); // } } //if loans count is one redirect to add unit page } } } else if (userData.RoleId == 2) { //loanSelection.RegBranches.Add((new BranchAccess()).getBranchByBranchId(userData.BranchId)); if (detail.RegBranches != null && detail.RegBranches.Count > 0) { loanSelection.RegBranches.Add(detail.RegBranches[0]); } // 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) { loanSelection.NonRegBranchList.Add(branch); } } if (loanSelection.NonRegBranchList.Count() == 1) { loanSelection.LoanList = detail.LoanList; //new LoanSetupAccess().GetLoanDetailsByNonRegBranchId(loanSelection.NonRegBranchList[0].NonRegBranchId); } } else if (userData.RoleId == 3) { //loanSelection.RegBranches.Add((new BranchAccess()).getBranchByBranchId(userData.BranchId)); loanSelection.RegBranches.Add(detail.RegBranches[0]); // 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) { loanSelection.NonRegBranchList.Add(branch); } } if (loanSelection.NonRegBranchList.Count() == 1) { loanSelection.LoanList = detail.LoanList; //new LoanSetupAccess().GetLoanDetailsByNonRegBranchId(loanSelection.NonRegBranchList[0].NonRegBranchId); } } Session["popUpSelectionType"] = type; if (type == "asderruy") // for add unit page { ViewBag.type = "AddUnit"; return PartialView(loanSelection); } else if (type == "tyuirede") // for add unit page { ViewBag.type = "Advance"; return PartialView(loanSelection); } else if (type == "sedretyt") { ViewBag.type = "Curtailment"; return PartialView(loanSelection); } else if (type == "wsedtgio") { ViewBag.type = "PayOff"; return PartialView(loanSelection); } else if (type == "frtgcvfd") { ViewBag.type = "Title"; return PartialView(loanSelection); } else if (type == "dashboard") { ViewBag.type = "DashBoard"; return PartialView(loanSelection); } else if (type == "linkDealer") { ViewBag.type = "linkDealer"; return PartialView(loanSelection); } else if (type == "assignRights") { ViewBag.type = "assignRights"; return PartialView(loanSelection); } else if (type == "tidenaol") // for add unit page { ViewBag.type = "EditLoan"; return PartialView(loanSelection); } else if (type == "tcaninaol") { ViewBag.type = "InactiveLoan"; return PartialView(loanSelection); } else if (type == "aticno") { ViewBag.type = "RenewLoan"; return PartialView(loanSelection); } return PartialView(loanSelection); }
/// <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; } }
public ActionResult getNonRegBranchesByRegBranchId(int RegBranchId, string type) { LoanSelection list = (LoanSelection)Session["detail"]; List<NonRegBranch> NonRegisteredBranchLists = list.NonRegBranchList;//(new BranchAccess()).getNonRegBranches(userData.Company_Id); LoanSelection loanSelection = new LoanSelection(); loanSelection.NonRegBranchList = new List<NonRegBranch>(); loanSelection.LoanList = new List<LoanSetupStep1>(); // the get non registered branches details for perticular branch from the non registeres branches list foreach (NonRegBranch branch in NonRegisteredBranchLists) { if (branch.BranchId == RegBranchId) { loanSelection.NonRegBranchList.Add(branch); } } ViewBag.type = type; if (loanSelection.NonRegBranchList != null && loanSelection.NonRegBranchList.Count() == 1) { //loanSelection.LoanList = list.LoanList; //new LoanSetupAccess().GetLoanDetailsByNonRegBranchId(loanSelection.NonRegBranchList[0].NonRegBranchId); //if loans count is one redirect to add unit page foreach (LoanSetupStep1 l in list.LoanList) { if (loanSelection.NonRegBranchList[0].NonRegBranchId == l.nonRegisteredBranchId) { //loanSelection.NonRegBranchList.Add(branch); loanSelection.LoanList.Add(l); } } } return PartialView(loanSelection); }