private void FormLoanRequestView_Load(object sender, EventArgs e)
{
if (dataSource == null)
{
DateTime dt = DateTime.Now;
DataSource = LoanRequestVwServices.List(new Db(DbServices.ConnectionString));
slblEllapsedTimeValue.Text = (DateTime.Now.Subtract(dt).TotalMilliseconds / 1000).ToString();
}
}
public ActionResult CreateLoanRequestDecision()
{
Db db = new Db(DbServices.ConnectionString);
ManageLoanDecision vm = new ManageLoanDecision();
vm.LoanRequestVwViewModel.List = LoanRequestVwServices.List(db).Where(c => c.RequestRequestStatusId.Value == (int)RequestStatusEnum.FinanciallyApproved).ToList();
return(View(vm));
}
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));
}
