public ActionResult RequestStatistics(RequestStatisticsFilter model)
{
try
{
List <RequestStatisticsResult> result = db.RequestStatistics(model);
return(PartialView("RequestStatisticsResult", result));
}
catch (CfException exc)
{
ViewBag.RequestStatistics = requestStatistics;
return(View());
}
}
public ActionResult Index()
{
// Call Monthly Balance Function
MonthlyBalanceSumFilter filter = new MonthlyBalanceSumFilter();
DateTime Now = System.DateTime.Now.AddYears(-3);
filter.MinMonth = System.DateTime.Now.AddYears(-4);
filter.MaxMonth = Now;
List <MonthlyBalanceSumResult> result = DbServices.MonthlyBalanceSum(filter);
result = result.OrderBy(c => c.Month).ToList();
List <string> Months = new List <string>();
List <decimal> paidAmounts = new List <decimal>();
List <decimal> incomingAmounts = new List <decimal>();
foreach (MonthlyBalanceSumResult line in result)
{
Months.Add(line.Month.Date.ToString("MMMM"));
paidAmounts.Add(line.AllLoans.Value);
incomingAmounts.Add(line.AllPayments.Value);
}
var months = String.Join(",", Months);
ViewBag.Months = months;
var paid = String.Join(",", paidAmounts);
ViewBag.PaidAmounts = paid;
var incoming = String.Join(",", incomingAmounts);
ViewBag.IncomingAmounts = incoming;
//
RequestStatisticsFilter filterRequest = new RequestStatisticsFilter();
filterRequest.MinDate = System.DateTime.Now.AddYears(-3);
filterRequest.MaxDate = System.DateTime.Now;
List <RequestStatisticsResult> resultRequest = DbServices.RequestStatistics(filterRequest);
foreach (RequestStatisticsResult item in resultRequest)
{
if (item.RequestStatusId == RequestStatusEnum.New.GetHashCode())
{
ViewBag.NewRequestCount = item.RequestCount;
ViewBag.NewRequestSum = item.RequestSum;
continue;
}
//else
//{
// ViewBag.NewRequestCount = 0;
// ViewBag.NewRequestSum = 0;
// continue;
//}
if (item.RequestStatusId == RequestStatusEnum.Executed.GetHashCode())
{
ViewBag.ExecutedRequestCount = item.RequestCount;
ViewBag.ExecutedRequestSum = item.RequestSum;
continue;
}
//else
//{
// ViewBag.ExecutedRequestCount = 0;
// ViewBag.ExecutedRequestSum =0;
// continue;
//}
if (item.RequestStatusId == RequestStatusEnum.FinanciallyApproved.GetHashCode())
{
ViewBag.FinanciallyApprovedRequestCount = item.RequestCount;
ViewBag.FinanciallyApprovedRequestSum = item.RequestSum;
continue;
}
//else
//{
// ViewBag.FinanciallyApprovedRequestCount = 0;
// ViewBag.FinanciallyApprovedRequestSum = 0;
// continue;
//}
if (item.RequestStatusId == RequestStatusEnum.Canceled.GetHashCode())
{
ViewBag.CanceledRequestCount = item.RequestCount;
ViewBag.CanceledRequestSum = item.RequestSum;
continue;
}
//else
//{
// ViewBag.CanceledRequestCount = 0;
// ViewBag.CanceledRequestSum = 0;
// continue;
//}
}
return(View());
}
