public ActionResult Details(int?id) { @ViewBag.ServiceEndGrantRequestVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "ServiceEndGrantRequest", "ModuleName"); // Details Of Products if (id == null) { return(RedirectToAction("Index")); } Db db = new Db(DbServices.ConnectionString); // Product ProductVwViewModel productVwViewModel = new ProductVwViewModel(); productVwViewModel.Instance = ProductVwServices.GetChildren(id.Value, db); if (productVwViewModel.Instance == null) { return(HttpNotFound()); } productVwViewModel.RequestVwViewModel.Instance = RequestVwServices.Get(id.Value); productVwViewModel.RequestVwViewModel.GrantRequestVwViewModel.Instance = GrantRequestVwServices.Get(id.Value); productVwViewModel.RequestVwViewModel.GrantRequestVwViewModel.ServiceEndGrantRequestVwViewModel.Instance = ServiceEndGrantRequestVwServices.Get(id.Value); return(View(productVwViewModel)); }
private void FormProductView_Load(object sender, EventArgs e) { if (dataSource == null) { DateTime dt = DateTime.Now; DataSource = ProductVwServices.List(new Db(DbServices.ConnectionString)); slblEllapsedTimeValue.Text = (DateTime.Now.Subtract(dt).TotalMilliseconds / 1000).ToString(); } }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Details(Nullable <int> id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ProductVwViewModel productVwViewModel = new ProductVwViewModel(); Db db = new Db(DbServices.ConnectionString); // productVwViewModel.Instance = ProductVwServices.Get(id.Value, db); productVwViewModel.Instance = ProductVwServices.GetChildren(id.Value, db); if (productVwViewModel.Instance == null) { return(HttpNotFound()); } @ViewBag.GrantVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "Grant", "ModuleName"); if (productVwViewModel.Instance.GrantVw != null) { productVwViewModel.GrantVwViewModel.List.Add(productVwViewModel.Instance.GrantVw); } // productVwViewModel.GrantVwViewModel.Instance = productVwViewModel.Instance.GrantVw; @ViewBag.LoanVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "Loan", "ModuleName"); if (productVwViewModel.Instance.LoanVw != null) { productVwViewModel.LoanVwViewModel.List.Add(productVwViewModel.Instance.LoanVw); } // productVwViewModel.LoanVwViewModel.Instance = productVwViewModel.Instance.LoanVw; @ViewBag.RefundableProductVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "RefundableProduct", "ModuleName"); if (productVwViewModel.Instance.RefundableProductVw != null) { productVwViewModel.RefundableProductVwViewModel.List.Add(productVwViewModel.Instance.RefundableProductVw); } // productVwViewModel.RefundableProductVwViewModel.Instance = productVwViewModel.Instance.RefundableProductVw; @ViewBag.RequestVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "Request", "ModuleName"); if (productVwViewModel.Instance.RequestVw != null) { productVwViewModel.RequestVwViewModel.List.Add(productVwViewModel.Instance.RequestVw); } // productVwViewModel.RequestVwViewModel.Instance = productVwViewModel.Instance.RequestVw; return(View(productVwViewModel)); }
/// <summary> /// Returns a list of ProductVw objects /// </summary> /// <returns></returns> public ActionResult Index(ProductVwViewModel Model) { Db db = new Db(DbServices.ConnectionString); ViewBag.ProductTypeList = new SelectList(LoanTypeVwServices.List(db), "ProductTypeId", "ProductTypeName"); if (Model.Filter.HasCriteria) { Model.List = ProductVwServices.Get(Model.Filter, db); } else { Model.List = new List <ProductVw>(); } return(View(Model)); }
public ActionResult Details(int?id) { ViewBag.TitleGuarantor = TitleGuarantor; ViewBag.TitleExceptionalAount = TitleExceptionalAount; // Details Of Products if (id == null) { //return new HttpStatusCodeResult(HttpStatusCode.BadRequest); return(RedirectToAction("Index")); } Db db = new Db(DbServices.ConnectionString); ProductVwViewModel productVwViewModel = new ProductVwViewModel(); productVwViewModel.Instance = ProductVwServices.GetChildren(id.Value, db); if (productVwViewModel.Instance == null) { return(HttpNotFound()); } productVwViewModel.RequestVwViewModel.Instance = RequestVwServices.Get(id.Value); productVwViewModel.RequestVwViewModel.LoanRequestVwViewModel.Instance = LoanRequestVwServices.Get(id.Value); productVwViewModel.RefundableProductVwViewModel.Instance = RefundableProductVwServices.Get(id.Value); List <GuarantorVw> Guarantors = GuarantorVwServices.GetByRefundableProductProductId(id.Value); productVwViewModel.RefundableProductVwViewModel.GuarantorVwViewModel.List = Guarantors; //productVwViewModel.RefundableProductVwViewModel.GuarantorVwViewModel.Instance.GuarantorStatementVw=GuarantorStatementVwServices. productVwViewModel.RequestVwViewModel.LoanRequestVwViewModel.ExceptionalAmountVwViewModel.List = ExceptionalAmountVwServices.GetByLoanRequestRequestProductId(id.Value); List <ExceptionalAmountVw> NetDeduction = ExceptionalAmountVwServices.GetByLoanRequestRequestProductId(id.Value).Where(c => c.ExceptionalAmountTypeId == (int)ExceptionalAmountTypeEnum.NetDeduction).ToList(); List <ExceptionalAmountVw> ExceptionalIncome = ExceptionalAmountVwServices.GetByLoanRequestRequestProductId(id.Value).Where(c => c.ExceptionalAmountTypeId == (int)ExceptionalAmountTypeEnum.ExceptionalIncome).ToList(); List <ExceptionalAmountVw> ExceptionalDeduction = ExceptionalAmountVwServices.GetByLoanRequestRequestProductId(id.Value).Where(c => c.ExceptionalAmountTypeId == (int)ExceptionalAmountTypeEnum.ExceptionalDeduction).ToList(); ViewBag.NetDeduction = NetDeduction; ViewBag.ExceptionalIncome = ExceptionalIncome; ViewBag.ExceptionalDeduction = ExceptionalDeduction; return(PartialView(productVwViewModel)); }
public ActionResult Details(int?id) { ViewBag.TitleGuarantor = TitleGuarantor; ViewBag.TitleExceptionalAount = TitleExceptionalAount; ViewBag.ExceptionalIncome = exceptionalIncome; ViewBag.ExceptionalDeduction = exceptionalDeduction; ViewBag.NetDeduction = netDeduction; // Details Of Products if (id == null) { return(RedirectToAction("Index")); } Db db = new Db(DbServices.ConnectionString); // Product ProductVwViewModel productVwViewModel = new ProductVwViewModel(); productVwViewModel.Instance = ProductVwServices.GetChildren(id.Value, db); if (productVwViewModel.Instance == null) { return(HttpNotFound()); } productVwViewModel.RequestVwViewModel.Instance = RequestVwServices.Get(id.Value); productVwViewModel.RequestVwViewModel.LoanRequestVwViewModel.Instance = LoanRequestVwServices.Get(id.Value); productVwViewModel.RefundableProductVwViewModel.Instance = RefundableProductVwServices.Get(id.Value); List <GuarantorVw> Guarantors = GuarantorVwServices.GetByRefundableProductProductId(id.Value); productVwViewModel.RefundableProductVwViewModel.GuarantorVwViewModel.List = Guarantors; productVwViewModel.RequestVwViewModel.LoanRequestVwViewModel.ExceptionalAmountVwViewModel.List = ExceptionalAmountVwServices.GetByLoanRequestRequestProductId(id.Value); List <ExceptionalAmountVw> NetDeduction = ExceptionalAmountVwServices.GetByLoanRequestRequestProductId(id.Value).Where(c => c.ExceptionalAmountTypeId == (int)ExceptionalAmountTypeEnum.NetDeduction).ToList(); List <ExceptionalAmountVw> ExceptionalIncome = ExceptionalAmountVwServices.GetByLoanRequestRequestProductId(id.Value).Where(c => c.ExceptionalAmountTypeId == (int)ExceptionalAmountTypeEnum.ExceptionalIncome).ToList(); List <ExceptionalAmountVw> ExceptionalDeduction = ExceptionalAmountVwServices.GetByLoanRequestRequestProductId(id.Value).Where(c => c.ExceptionalAmountTypeId == (int)ExceptionalAmountTypeEnum.ExceptionalDeduction).ToList(); ViewBag.NetDeductionList = NetDeduction; ViewBag.ExceptionalIncomeList = ExceptionalIncome; ViewBag.ExceptionalDeductionList = ExceptionalDeduction; // Calculate Solvency and Boundries EmployeeProductCalculatorFilter f = new EmployeeProductCalculatorFilter() { EmployeeId = productVwViewModel.Instance.EmployeeId, ProductTypeId = productVwViewModel.Instance.ProductTypeId, Amount = productVwViewModel.RequestVwViewModel.Instance.Amount, Period = productVwViewModel.RefundableProductVwViewModel.Instance.PaymentPeriod }; EmployeeProductCalculatorResult result = db.EmployeeProductCalculatorFirstOrDefault(f); if (result != null) { GetEmployeeSolvencyFilter filter = new GetEmployeeSolvencyFilter() { EmployeeId = productVwViewModel.Instance.EmployeeId, Amount = productVwViewModel.RequestVwViewModel.Instance.Amount, Date = System.DateTime.Now, Installment = result.Installment, GrossSalary = productVwViewModel.RequestVwViewModel.LoanRequestVwViewModel.Instance.NetIncome, NetSalary = productVwViewModel.RequestVwViewModel.LoanRequestVwViewModel.Instance.NetIncome }; GetEmployeeSolvencyResult solvencyResult = db.GetEmployeeSolvencyFirstOrDefault(filter); ViewBag.Calculator = result; ViewBag.Solvency = solvencyResult; } return(View(productVwViewModel)); }