public ActionResult LoadCustomer(JQueryDataTablesModel jQueryDataTablesModel)
{
SearchParameter param = new SearchParameter();
param.SearchColumn = new List <string> {
"Id", "FirstName",
"LastName",
"FirstName2",
"LastName2",
"Phone",
"Email",
"Address",
"Zip"
};
param.SearchColumnValue = jQueryDataTablesModel.sSearch_;
param.StartIndex = jQueryDataTablesModel.iDisplayStart;
param.PageSize = jQueryDataTablesModel.iDisplayLength;
List <Customer> sourceData = _rentalServiceFacade.GetCustomers(param);
var customers = GenericFilterHelper <Customer> .GetFilteredRecords(
sourceData : sourceData,
startIndex : jQueryDataTablesModel.iDisplayStart,
pageSize : jQueryDataTablesModel.iDisplayLength,
sortedColumns : jQueryDataTablesModel.GetSortedColumns("desc"),
totalRecordCount : param.TotalRecordCount,
searchString : jQueryDataTablesModel.sSearch,
isSearch : param.IsFilterValue,
searchColumnValues : jQueryDataTablesModel.sSearch_,
properties : new List <string> {
"Id", "FirstName", "LastName", "FirstName2",
"LastName2", "Phone", "Email", "Address", "Zip"
});
return(Json(new JQueryDataTablesResponse <Customer>(
items: customers,
totalRecords: param.TotalRecordCount,
totalDisplayRecords: param.SearchedCount,
sEcho: jQueryDataTablesModel.sEcho)));
}
public ActionResult Index()
{
DashboardViewModel model = new DashboardViewModel();
DateTime sevenDaysPrior = DateTime.Now.AddDays(-7);
List <Customer> customerList = _rentalFacade.GetCustomers(sevenDaysPrior);
List <QuoteDto> policyList = _rentalFacade.GetPolicies(sevenDaysPrior);
model.NoOfNewCustomersInLast1Week = customerList.Count();
model.NoOfNewCustomersInLast1Day = customerList.Where(x => x.CreationDate > DateTime.Now.AddDays(-1)).Count();
model.NoOfNewCustomersInLast3Days = customerList.Where(x => x.CreationDate > DateTime.Now.AddDays(-3)).Count();
model.NoOfNewPoliciesGeneratedInLast1Week = policyList.Count();
model.NoOfNewPoliciesGeneratedInLast1Day = policyList.Where(x => x.CreationDate > DateTime.Now.AddDays(-1)).Count();
model.NoOfNewPoliciesGeneratedInLast3Days = policyList.Where(x => x.CreationDate > DateTime.Now.AddDays(-3)).Count();
model.PremiumChargedInLast1Day = policyList.Where(x => x.CreationDate > DateTime.Now.AddDays(-1)).Select(x => x.TotalChargedToday).Sum();
model.PremiumChargedInLast3Days = policyList.Where(x => x.CreationDate > DateTime.Now.AddDays(-3)).Select(x => x.TotalChargedToday).Sum();
model.PremiumChargedInLast1Week = policyList.Select(x => x.TotalChargedToday).Sum();
model.IsPaymentProcessorLive = true;
model.IsAegisServiceLive = true;
return(View(model));
}
