/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Details(Nullable <int> request) { if (request == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } LoanRequestVwViewModel loanRequestVwViewModel = new LoanRequestVwViewModel(); Db db = new Db(DbServices.ConnectionString); // loanRequestVwViewModel.Instance = LoanRequestVwServices.Get(request.Value, db); loanRequestVwViewModel.Instance = LoanRequestVwServices.GetChildren(request.Value, db); if (loanRequestVwViewModel.Instance == null) { return(HttpNotFound()); } @ViewBag.ExceptionalAmountVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "ExceptionalAmount", "ModuleNamePlural"); // loanRequestVwViewModel.ExceptionalAmountVwViewModel.List = ExceptionalAmountVwServices.GetByLoanRequestId(request.Value, db); loanRequestVwViewModel.ExceptionalAmountVwViewModel.List = loanRequestVwViewModel.Instance.ExceptionalAmountVwList; return(View(loanRequestVwViewModel)); }
// GET: Loans/LoanReport public ActionResult Index(LoanRequestVwViewModel model) { EmployeeLoansReport report = new EmployeeLoansReport(); Db db = new Db(DbServices.ConnectionString); List <GetRefundableProductsResult> result = db.GetRefundableProducts(model.Filter.RequestProductEmployeeId); List <string> LoansTypesNames = new List <string>(); List <decimal> OriginalAmounts = new List <decimal>(); List <decimal> RemainingAmounts = new List <decimal>(); List <decimal> PaidAmounts = new List <decimal>(); foreach (GetRefundableProductsResult item in result) { LoansTypesNames.Add(item.ProductId.ToString()); OriginalAmounts.Add(item.DueAmount.Value); PaidAmounts.Add(item.PaidAmount.Value); RemainingAmounts.Add(item.DueAmount.Value - item.PaidAmount.Value); } //LoansTypesNames.Add("سلفة استثمارية"); //LoansTypesNames.Add("سلفة دراسية"); //OriginalAmounts.Add(30000); //OriginalAmounts.Add(50000); //RemainingAmounts.Add(20000); //RemainingAmounts.Add(15000); //PaidAmounts.Add(10000); //PaidAmounts.Add(35000); var loansTypesNames = String.Join(",", LoansTypesNames); ViewBag.LoansTypesNames = loansTypesNames; var remainingAmounts = String.Join(",", RemainingAmounts); ViewBag.RemainingAmounts = remainingAmounts; var paidAmounts = String.Join(",", PaidAmounts); ViewBag.PaidAmounts = paidAmounts; return(View()); }
public ActionResult Index(LoanRequestVwViewModel Model) { Db db = new Db(DbServices.ConnectionString); ViewBag.ProductTypeList = new SelectList(LoanTypeVwServices.List(db), "ProductTypeId", "ProductTypeName"); ViewBag.RequestStatusList = new SelectList(RequestStatusServices.List(db), "Id", "Name"); if (Model.Filter.HasCriteria) { Model.List = LoanRequestVwServices.Get(Model.Filter, db); } else { Model.List = new List <LoanRequestVw>(); } return(View(Model)); }
public ActionResult ManageRejectedRequest() { LoanRequestVwViewModel vm = new LoanRequestVwViewModel(); try { Db db = new Db(DbServices.ConnectionString); List <LoanRequestVw> requests = null; requests = LoanRequestVwServices.List(db).Where(c => c.RequestRequestStatusId == RequestStatusEnum.Invalid.GetHashCode()).ToList(); vm.List = requests; } catch (Exception exc) { throw; } return(View(vm)); }
public ActionResult ManageNewRequests() { LoanRequestVwViewModel vm = new LoanRequestVwViewModel(); try { Db db = new Db(DbServices.ConnectionString); List <LoanRequestVw> requests = null; requests = LoanRequestVwServices.List(db).Where(c => (c.RequestRequestStatusId == RequestStatusEnum.New.GetHashCode()) && c.RequestDate >= new DateTime(2017, 11, 1)).ToList(); vm.List = requests; } catch (Exception exc) { throw; } return(View(vm)); }
// GET: ManageLoanRequests public ActionResult Index() { Db db = new Db(DbServices.ConnectionString); List <LoanRequestVw> requests = null; requests = LoanRequestVwServices.List(db); ViewBag.DecisionType = (int)LoanDecisionTypeEnum.Normal; ViewBag.NewLoanRequestsCount = requests.Where(c => (c.RequestRequestStatusId == (int)RequestStatusEnum.New) && c.RequestDate >= new DateTime(2017, 11, 1)).ToList().Count; ViewBag.ValidLoanRequestsCount = requests.Where(c => (c.RequestRequestStatusId == (int)RequestStatusEnum.Valid)).ToList().Count; ViewBag.ApprovedLoanRequestsCount = requests.Where(c => (c.RequestRequestStatusId == (int)RequestStatusEnum.Approved)).ToList().Count; ViewBag.ExceptionalLoanRequestsCount = requests.Where(c => (c.RequestRequestStatusId == (int)RequestStatusEnum.ExcludedFromValidation)).ToList().Count; ViewBag.RejectedLoanRequestsCount = requests.Where(c => (c.RequestRequestStatusId == (int)RequestStatusEnum.Invalid)).ToList().Count; LoanRequestVwViewModel vm = new LoanRequestVwViewModel(); vm.List = requests; return(View(vm)); }
public ManageLoanDecision() { Requests = new List <RequestCustomized>(); LoanRequestVwViewModel = new LoanRequestVwViewModel(); }