/// <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();
}
