public ActionResult MoveLoansToGuarantor(LoanVwViewModel Model, string operationType) { Db db = new Db(DbServices.ConnectionString); ViewBag.ProductTypeList = new SelectList(ProductTypeServices.List(db), "Id", "Name"); ViewBag.LoanStatusList = new SelectList(LoanStatusServices.List(db), "Id", "Name"); if (operationType != null) { int loanId = Model.SelectedLoansList.Where(c => c.IsSelected).FirstOrDefault().LoanId; Response response = ProcessMoveLoanToGuarantors(Model.SelectedGuarantorsList, loanId); if (response.IsSuccess) { return(RedirectToAction("Index")); } else { return(View(Model)); } } else { if (Model.EmployeeLoansFilter != null && Model.EmployeeLoansFilter.EmployeeId != 0) { Model.EmployeeLoansFilter.LoanStatusId = 0; Model.EmployeeLoansResult = db.EmployeeLoans(Model.EmployeeLoansFilter); } else { Model.EmployeeLoansResult = new List <EmployeeLoansResult>(); } return(View(Model)); } }
public ActionResult Create([Bind(Include = "Id, Name, Rate, GuarantorsCount, AccountNumber, PrintLabel, ProfitStrategy, PaymentGroup, IsActive")] ProductType productType) { Db db = new Db(DbServices.ConnectionString); if (ModelState.IsValid) { try { ProductTypeServices.Insert(CurrentUser.Id, productType, db); TempData["Success"] = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "UI", "InsertConfirmed"); return(RedirectToAction("Index")); } catch (CfException cfex) { TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage; } catch (Exception ex) { TempData["Failure"] = ex.Message; } } ViewBag.PaymentGroupList = new SelectList(PaymentGroupServices.List(db), "Id", "Name"); ViewBag.ProfitStrategyList = new SelectList(ProfitStrategyServices.List(db), "Id", "Name"); return(View(productType)); }
public ActionResult ChangeLoanToIncoming(LoanVwViewModel Model, string operationType) { Db db = new Db(DbServices.ConnectionString); ViewBag.ProductTypeList = new SelectList(ProductTypeServices.List(db), "Id", "Name"); ViewBag.LoanStatusList = new SelectList(LoanStatusServices.List(db), "Id", "Name"); if (operationType != null) { //Response response = ProcessMoveLoanToEmployee(Model.SelectedLoansList, Model.EmployeeLoansFilter.EmployeeId.Value, Model.EmployeeId); // if(response.IsSuccess) // { // return RedirectToAction("Index"); // } // else // { // return View(Model); // } return(View(Model)); } else { if (Model.EmployeeLoansFilter != null && Model.EmployeeLoansFilter.EmployeeId != 0) { Model.EmployeeLoansFilter.LoanStatusId = 0; Model.EmployeeLoansResult = db.EmployeeLoans(Model.EmployeeLoansFilter); } else { Model.EmployeeLoansResult = new List <EmployeeLoansResult>(); } return(View(Model)); } }
public ActionResult Edit([Bind(Include = "Id, Employee, ProductType, Amount, Notes")] Product product) { Db db = new Db(DbServices.ConnectionString); if (ModelState.IsValid) { try { ProductServices.Update(CurrentUser.Id, product, db); TempData["Success"] = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "UI", "UpdateConfirmed"); return(RedirectToAction("Index")); } catch (CfException cfex) { TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage; } catch (Exception ex) { TempData["Failure"] = ex.Message; } } ViewBag.EmployeeList = new SelectList(EmployeeServices.List(db), "Id", "FirstName", product.Employee); ViewBag.ProductTypeList = new SelectList(ProductTypeServices.List(db), "Id", "Name", product.ProductType); return(View(product)); }
public ActionResult Create() { Db db = new Db(DbServices.ConnectionString); ViewBag.ProductTypeList = new SelectList(ProductTypeServices.List(db), "Id", "Name"); return(View()); }
public ActionResult Create([Bind(Include = "Id, ProductType, Availability")] ProductTypeAvailability productTypeAvailability) { Db db = new Db(DbServices.ConnectionString); if (ModelState.IsValid) { try { ProductTypeAvailabilityServices.Insert(CurrentUser.Id, productTypeAvailability, db); TempData["Success"] = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "UI", "InsertConfirmed"); return(RedirectToAction("Index")); } catch (CfException cfex) { TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage; } catch (Exception ex) { TempData["Failure"] = ex.Message; } } ViewBag.AvailabilityList = new SelectList(AvailabilityServices.List(db), "Id", "Name"); ViewBag.ProductTypeList = new SelectList(ProductTypeServices.List(db), "Id", "Name"); return(View(productTypeAvailability)); }
public ActionResult Edit(int?id) { LoanRequestViewModel vm = new LoanRequestViewModel(); try { Db db = new Db(DbServices.ConnectionString); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Product product = ProductServices.Get(id.Value, db); Request request = RequestServices.Get(id.Value, db); LoanRequest loanRequest = LoanRequestServices.Get(id.Value, db); RefundableProduct refundableProduct = RefundableProductServices.Get(id.Value, db); if (product == null || request == null || loanRequest == null || refundableProduct == null) { return(HttpNotFound()); } // For Product //ViewBag.EmployeeList = new SelectList(EmployeeServices.List(db), "Id", "Id_Name", product.Employee); ViewBag.ProductTypeList = new SelectList(ProductTypeServices.List(db), "Id", "Name", product.ProductType); // For Request //We need to customise the droplist for two options ViewBag.BypassStatusList = new SelectList(BypassStatusServices.List(db).Where((c => (c.Id == 0 || c.Id == 2))), "Id", "Name"); EmployeeProductCalculatorFilter f = new EmployeeProductCalculatorFilter(); f.EmployeeId = product.Employee; f.ProductTypeId = (short)product.ProductType; f.Amount = (decimal)request.Amount; f.Period = (short)refundableProduct.PaymentPeriod; EmployeeProductCalculatorResult result = db.EmployeeProductCalculatorFirstOrDefault(f); if (result != null) { ViewBag.Calculations = result; } vm.RequestProduct = product; vm.Request = request; vm.LoanRequest = loanRequest; vm.RequestProductProductRefundableProduct = refundableProduct; } catch (CfException cfex) { TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage; } catch (Exception ex) { TempData["Failure"] = ex.Message; } return(View(vm)); }
/// <summary> /// Returns a list of IncomingLoanVw objects /// </summary> /// <returns></returns> public ActionResult Index(IncomingLoanVwViewModel Model) { Db db = new Db(DbServices.ConnectionString); ViewBag.LoanProductProductTypeList = new SelectList(ProductTypeServices.List(db), "Id", "Name"); if (Model.Filter.HasCriteria) { Model.List = IncomingLoanVwServices.Get(Model.Filter, db); } else { Model.List = new List <IncomingLoanVw>(); } return(View(Model)); }
/// <summary> /// Returns a list of ServiceEndGrantRequestVw objects /// </summary> /// <returns></returns> public ActionResult Index(ServiceEndGrantRequestVwViewModel Model) { Db db = new Db(DbServices.ConnectionString); ViewBag.ProductTypeList = new SelectList(ProductTypeServices.List(db), "Id", "Name"); if (Model.Filter.HasCriteria) { Model.List = ServiceEndGrantRequestVwServices.Get(Model.Filter, db); } else { Model.List = new List <ServiceEndGrantRequestVw>(); } return(View(Model)); }
// GET: ProductType/Delete/5 public ActionResult Delete(Nullable <short> id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Db db = new Db(DbServices.ConnectionString); ProductType productType = ProductTypeServices.Get(id.Value, db); if (productType == null) { return(HttpNotFound()); } return(View(productType)); }
//public ActionResult Print(int? employeeId, string fullName, int? typeId, int? decisionNumber, DateTime mindecisionDate, DateTime maxdecisionDate, int? statusId) public ActionResult Print(LoanVwViewModel Model) { Db db = new Db(DbServices.ConnectionString); ViewBag.ProductTypeList = new SelectList(ProductTypeServices.List(db), "Id", "Name"); ViewBag.LoanStatusList = new SelectList(LoanStatusServices.List(db), "Id", "Name"); if (Model.Filter.HasCriteria) { Model.List = LoanVwServices.Get(Model.Filter, db); } else { Model.List = new List <LoanVw>(); } return(PartialView(Model)); }
public ActionResult EmployeeCalculator() { Db db = new Db(DbServices.ConnectionString); // For Product ViewBag.EmployeeList = new SelectList(EmployeeServices.List(db), "Id", "Id_Name"); //ToDo: Just Show Loan Type List <LoanType> l = LoanTypeServices.List(db); List <ProductType> f = ProductTypeServices.List(db); ViewBag.ProductTypeList = new SelectList(ProductTypeServices.List(db), "Id", "Name"); return(View()); }
// GET: ProductTypeAvailability/Edit/5 public ActionResult Edit(Nullable <int> id) { Db db = new Db(DbServices.ConnectionString); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ProductTypeAvailability productTypeAvailability = ProductTypeAvailabilityServices.Get(id.Value, db); if (productTypeAvailability == null) { return(HttpNotFound()); } ViewBag.AvailabilityList = new SelectList(AvailabilityServices.List(db), "Id", "Name", productTypeAvailability.Availability); ViewBag.ProductTypeList = new SelectList(ProductTypeServices.List(db), "Id", "Name", productTypeAvailability.ProductType); return(View(productTypeAvailability)); }
// GET: ProductType/Edit/5 public ActionResult Edit(Nullable <short> id) { Db db = new Db(DbServices.ConnectionString); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ProductType productType = ProductTypeServices.Get(id.Value, db); if (productType == null) { return(HttpNotFound()); } ViewBag.PaymentGroupList = new SelectList(PaymentGroupServices.List(db), "Id", "Name", productType.PaymentGroup); ViewBag.ProfitStrategyList = new SelectList(ProfitStrategyServices.List(db), "Id", "Name", productType.ProfitStrategy); return(View(productType)); }
// GET: Product/Edit/5 public ActionResult Edit(Nullable <int> id) { Db db = new Db(DbServices.ConnectionString); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Product product = ProductServices.Get(id.Value, db); if (product == null) { return(HttpNotFound()); } ViewBag.EmployeeList = new SelectList(EmployeeServices.List(db), "Id", "FirstName", product.Employee); ViewBag.ProductTypeList = new SelectList(ProductTypeServices.List(db), "Id", "Name", product.ProductType); return(View(product)); }
public ActionResult EmployeeDebts() { try { Db db = new Db(DbServices.ConnectionString); List <ProductType> f = ProductTypeServices.List(db); ViewBag.ProductTypeList = new SelectList(LoanTypeVwServices.List(db), "ProductTypeId", "ProductTypeName"); ViewBag.IssuerList = new SelectList(IssuerServices.List(db), "Id", "Name"); } catch (CfException cfex) { TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage; } catch (Exception ex) { TempData["Failure"] = ex.Message; } return(View()); }
public ActionResult DeleteConfirmed(short id) { try { Db db = new Db(DbServices.ConnectionString); ProductTypeServices.Delete(CurrentUser.Id, id, db); TempData["Success"] = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "UI", "DeleteConfirmed"); // return RedirectToAction("Index"); } catch (CfException cfex) { TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage; } catch (Exception ex) { TempData["Failure"] = ex.Message; } // return View(productType); return(RedirectToAction("Index")); }
public ActionResult ChangeLoanToEmployee(LoanVwViewModel Model, string operationType) { Db db = new Db(DbServices.ConnectionString); ViewBag.ProductTypeList = new SelectList(ProductTypeServices.List(db), "Id", "Name"); ViewBag.LoanStatusList = new SelectList(LoanStatusServices.List(db), "Id", "Name"); if (operationType != null) { return(View(Model)); } else { if (Model.Filter.HasCriteria) { Model.Filter.LoanStatusId = (int)LoanStatusEnum.Unfinished; Model.List = LoanVwServices.Get(Model.Filter, db); } else { Model.List = new List <LoanVw>(); } return(View(Model)); } }
public ActionResult Edit(LoanRequestViewModel model) { Db db = new Db(DbServices.ConnectionString); if (ModelState.IsValid) { try { EmployeeProductCalculatorFilter f = new EmployeeProductCalculatorFilter(); f.EmployeeId = model.RequestProduct.Employee; f.ProductTypeId = (short)model.RequestProduct.ProductType; f.Amount = (decimal)model.Request.Amount; f.Period = (short)model.RequestProductProductRefundableProduct.PaymentPeriod; List <EmployeeProductCalculatorResult> result = db.EmployeeProductCalculator(f); if (result.Count > 0) { model.RequestProductProductRefundableProduct.NetAmount = result[0].NetAmount.Value; model.RequestProductProductRefundableProduct.ProfitAmount = result[0].ProfitAmount.Value; model.RequestProductProductRefundableProduct.Installment = result[0].Installment.Value; } // 1- Add Prouct // set the Amount of the Produt the same as Request //model.RequestProduct.Amount = model.Request.Amount; ProductServices.Update(CurrentUser.Id, model.RequestProduct, db); ProductServices.Update(CurrentUser.Id, model.RequestProduct, db); //2-Add Request //model.Request.Product = model.RequestProduct.Id; // model.Request.RequestStatus = (int)RequestStatusEnum.New; //model.Request.Cost = 5; RequestServices.Update(CurrentUser.Id, model.Request, db); //3-Add LoanRequest //model.LoanRequest.Request = model.RequestProduct.Id; LoanRequestServices.Update(CurrentUser.Id, model.LoanRequest, db); //4- Add RefundableProduct //model.RequestProductProductRefundableProduct.Product = model.RequestProduct.Id; RefundableProductServices.Update(CurrentUser.Id, model.RequestProductProductRefundableProduct, db); TempData["Success"] = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "UI", "UpdateConfirmed"); return(RedirectToAction("Index", "LoanRequest")); } catch (CfException cfex) { TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage; } catch (Exception ex) { TempData["Failure"] = ex.Message; } } // For Product ViewBag.EmployeeList = new SelectList(EmployeeServices.List(db), "Id", "FirstName", model.RequestProduct.Employee); ViewBag.ProductTypeList = new SelectList(ProductTypeServices.List(db), "Id", "Name", model.RequestProduct.ProductType); // For Request ViewBag.BypassStatusList = new SelectList(BypassStatusServices.List(db), "Id", "Name", model.Request.BypassStatus); ViewBag.ProductList = new SelectList(ProductServices.List(db), "Id", "Notes", model.Request.Product); ViewBag.RequestStatusList = new SelectList(RequestStatusServices.List(db), "Id", "Name", model.Request.RequestStatus); return(View(model)); }