public ActionResult LoadPayment(JQueryDataTablesModel jQueryDataTablesModel)
{
SearchParameter param = new SearchParameter();
param.SearchColumn = new List <string> {
"Id", "TransactionId",
"ResponseCode",
"ApprovalCode",
"CreationDate",
"Amount"
};
param.SearchColumnValue = jQueryDataTablesModel.sSearch_;
param.StartIndex = jQueryDataTablesModel.iDisplayStart;
param.PageSize = jQueryDataTablesModel.iDisplayLength;
List <Payment> sourceData = _rentalServiceFacade.GetPayments(param);
var payments = GenericFilterHelper <MobileHome.Insure.Model.Payment> .GetFilteredRecords(
sourceData : sourceData,
startIndex : jQueryDataTablesModel.iDisplayStart,
pageSize : jQueryDataTablesModel.iDisplayLength,
sortedColumns : jQueryDataTablesModel.GetSortedColumns(string.Empty),
totalRecordCount : param.TotalRecordCount,
isSearch : param.IsFilterValue,
searchString : jQueryDataTablesModel.sSearch,
searchColumnValues : jQueryDataTablesModel.sSearch_,
properties : new List <string> {
"Id", "TransactionId", "ResponseCode", "ApprovalCode", "CreationDate", "Amount"
});
return(Json(new JQueryDataTablesResponse <MobileHome.Insure.Model.Payment>(
items: payments,
totalRecords: param.TotalRecordCount,
totalDisplayRecords: param.SearchedCount,
sEcho: jQueryDataTablesModel.sEcho)));
}
public ActionResult LoadingPolicy(JQueryDataTablesModel jQueryDataTablesModel)
{
int totalRecordCount = 0;
int searchRecordCount = 0;
var quotes = GenericFilterHelper <QuoteDto> .GetFilteredRecords(
runTimeMethod : _rentalServiceFacade.GetPolicies,
startIndex : jQueryDataTablesModel.iDisplayStart,
pageSize : jQueryDataTablesModel.iDisplayLength,
sortedColumns : jQueryDataTablesModel.GetSortedColumns(string.Empty),
totalRecordCount : out totalRecordCount,
searchRecordCount : out searchRecordCount,
searchString : jQueryDataTablesModel.sSearch,
searchColumnValues : jQueryDataTablesModel.sSearch_,
properties : new List <string> {
"Id", "ProposalNumber", "PersonalProperty", "Liability",
"Premium", "EffectiveDate", "NoOffInstallments", "SendLandLord"
});
return(Json(new JQueryDataTablesResponse <QuoteDto>(
items: quotes,
totalRecords: totalRecordCount,
totalDisplayRecords: searchRecordCount,
sEcho: jQueryDataTablesModel.sEcho)));
}
public JsonResult LoadParkSites(JQueryDataTablesModel jQueryDataTablesModel)
{
SearchParameter param = new SearchParameter();
param.SearchColumn = new List <string> {
"Id", "ParkId",
"SiteNumber",
"ParkName",
"TenantFirstName",
"TenantLastName",
"CompanyName",
"EffectiveDate",
"ExpiryDate",
"SiteRental",
"Liability",
"PersonalProperty",
"Premium"
};
param.SearchColumnValue = jQueryDataTablesModel.sSearch_;
param.StartIndex = jQueryDataTablesModel.iDisplayStart;
param.PageSize = jQueryDataTablesModel.iDisplayLength;
List <ParkSiteDto> result = _masterServiceFacade.GetParkSites(param);
var parks = GenericFilterHelper <ParkSiteDto> .GetFilteredRecords(
sourceData : result, //Updating bcos, on/off feature has to implement
startIndex : jQueryDataTablesModel.iDisplayStart,
pageSize : jQueryDataTablesModel.iDisplayLength,
sortedColumns : jQueryDataTablesModel.GetSortedColumns(string.Empty),
totalRecordCount : param.TotalRecordCount,
isSearch : param.IsFilterValue,
searchString : jQueryDataTablesModel.sSearch,
searchColumnValues : jQueryDataTablesModel.sSearch_,
properties : new List <string> {
"Id", "ParkId",
"SiteNumber",
"ParkName",
"TenantFirstName",
"TenantLastName",
"CompanyName",
"EffectiveDate",
"ExpiryDate",
"SiteRental",
"Liability",
"PersonalProperty",
"Premium"
});
return(Json(new JQueryDataTablesResponse <ParkSiteDto>(
items: parks,
totalRecords: param.TotalRecordCount,
totalDisplayRecords: param.SearchedCount,
sEcho: jQueryDataTablesModel.sEcho)));
}
public ActionResult LoadPolicy(JQueryDataTablesModel jQueryDataTablesModel)
{
SearchParameter param = new SearchParameter();
param.SearchColumn = new List <string> {
"Id",
"InsuredName",
"InsuredAddress",
"InsuredPhone",
"InsuredEmail",
"ProposalNumber",
"PersonalProperty",
"Liability",
"Premium",
"EffectiveDate",
"NoOffInstallments",
"SendLandLord"
};
param.SearchColumnValue = jQueryDataTablesModel.sSearch_;
param.StartIndex = jQueryDataTablesModel.iDisplayStart;
param.PageSize = jQueryDataTablesModel.iDisplayLength;
List <QuoteDto> sourceData = _rentalServiceFacade.GetPolicies(param);
var quotes = GenericFilterHelper <QuoteDto> .GetFilteredRecords(
sourceData : sourceData,
startIndex : jQueryDataTablesModel.iDisplayStart,
pageSize : jQueryDataTablesModel.iDisplayLength,
sortedColumns : jQueryDataTablesModel.GetSortedColumns(string.Empty),
totalRecordCount : param.TotalRecordCount,
isSearch : param.IsFilterValue,
searchString : jQueryDataTablesModel.sSearch,
searchColumnValues : jQueryDataTablesModel.sSearch_,
properties : new List <string> {
"Id",
"InsuredName",
"InsuredAddress",
"InsuredPhone",
"InsuredEmail",
"ProposalNumber",
"PersonalProperty",
"Liability",
"Premium",
"EffectiveDate",
"NoOffInstallments",
"SendLandLord"
});
return(Json(new JQueryDataTablesResponse <QuoteDto>(
items: quotes,
totalRecords: param.TotalRecordCount,
totalDisplayRecords: param.SearchedCount,
sEcho: jQueryDataTablesModel.sEcho)));
}
public JsonResult LoadPark(JQueryDataTablesModel jQueryDataTablesModel)
{
SearchParameter param = new SearchParameter();
param.SearchColumn = new List <string> {
"Id", "ParkName", //"OfficePhone",
"SpacesToRent",
"SpacesToOwn",
"PhysicalAddress",
"State",
"PhysicalZip",
"IsOn"
};
param.SearchColumnValue = jQueryDataTablesModel.sSearch_;
param.StartIndex = jQueryDataTablesModel.iDisplayStart;
param.PageSize = jQueryDataTablesModel.iDisplayLength;
List <ParkDto> result = _masterServiceFacade.GetListPark(param);
var parks = GenericFilterHelper <ParkDto> .GetFilteredRecords(
sourceData : result, //Updating bcos, on/off feature has to implement
startIndex : jQueryDataTablesModel.iDisplayStart,
pageSize : jQueryDataTablesModel.iDisplayLength,
sortedColumns : jQueryDataTablesModel.GetSortedColumns(string.Empty),
totalRecordCount : param.TotalRecordCount,
searchString : jQueryDataTablesModel.sSearch,
isSearch : param.IsFilterValue,
searchColumnValues : jQueryDataTablesModel.sSearch_,
properties : new List <string> {
"Id", "ParkName", //"OfficePhone",
"SpacesToRent",
"SpacesToOwn",
"PhysicalAddress",
"State",
"PhysicalZip",
"IsOn"
});
return(Json(new JQueryDataTablesResponse <ParkDto>(
items: parks,
totalRecords: param.TotalRecordCount,
totalDisplayRecords: param.SearchedCount,
sEcho: jQueryDataTablesModel.sEcho)));
}
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 virtual async Task <HttpResponseMessage> GetDataGrid(JQueryDataTablesModel dataTablesModel)
{
var entities = await businessService.LoadOrgStructureShareDTOByPagingAsync(
pageNumber : dataTablesModel.iDisplayStart
, pageSize : dataTablesModel.iDisplayLength
, orderBy : UIHelper.GetOrderBy <OrgStructureShareDTO>(dataTablesModel.GetSortedColumns())
, brandName : dataTablesModel.sSearch
);
if (entities.ReturnStatus == false)
{
return(CreateErrorResponse(entities));
}
var mapper = GetMapper();
List <OrgStructureShareDTOViewModel> dataSource = mapper.Map <List <OrgStructureShareDTO>, List <OrgStructureShareDTOViewModel> >(entities.ResultValue);
return(Request.CreateResponse(HttpStatusCode.OK
, DataTablesJson(items: dataSource
, totalRecords: entities.TotalRows
, totalDisplayRecords: entities.TotalRows
, sEcho: dataTablesModel.sEcho)));
}
public ActionResult LoadingCustomer(JQueryDataTablesModel jQueryDataTablesModel)
{
int totalRecordCount = 0;
int searchRecordCount = 0;
var customers = GenericFilterHelper <Customer> .GetFilteredRecords(
runTimeMethod : _rentalServiceFacade.GetCustomers,
startIndex : jQueryDataTablesModel.iDisplayStart,
pageSize : jQueryDataTablesModel.iDisplayLength,
sortedColumns : jQueryDataTablesModel.GetSortedColumns("desc"),
totalRecordCount : out totalRecordCount,
searchRecordCount : out searchRecordCount,
searchString : jQueryDataTablesModel.sSearch,
searchColumnValues : jQueryDataTablesModel.sSearch_,
properties : new List <string> {
"Id", "FirstName", "LastName", "FirstName2", "LastName2", "Phone", "Email", "Address", "Zip"
});
return(Json(new JQueryDataTablesResponse <Customer>(
items: customers,
totalRecords: totalRecordCount,
totalDisplayRecords: searchRecordCount,
sEcho: jQueryDataTablesModel.sEcho)));
}
public ActionResult LoadingPayment(JQueryDataTablesModel jQueryDataTablesModel)
{
int totalRecordCount = 0;
int searchRecordCount = 0;
var payments = GenericFilterHelper <MobileHome.Insure.Model.Payment> .GetFilteredRecords(
runTimeMethod : _rentalServiceFacade.GetPayments,
startIndex : jQueryDataTablesModel.iDisplayStart,
pageSize : jQueryDataTablesModel.iDisplayLength,
sortedColumns : jQueryDataTablesModel.GetSortedColumns(string.Empty),
totalRecordCount : out totalRecordCount,
searchRecordCount : out searchRecordCount,
searchString : jQueryDataTablesModel.sSearch,
searchColumnValues : jQueryDataTablesModel.sSearch_,
properties : new List <string> {
"Id", "TransactionId", "ResponseCode", "ApprovalCode", "CreationDate", "Amount"
});
return(Json(new JQueryDataTablesResponse <MobileHome.Insure.Model.Payment>(
items: payments,
totalRecords: totalRecordCount,
totalDisplayRecords: searchRecordCount,
sEcho: jQueryDataTablesModel.sEcho)));
}
public async Task <HttpResponseMessage> GetDataGrid(JQueryDataTablesModel dataTablesModel)
{
GoalTypeEnum?goalTypeId = GoalTypeEnum.Distributor;
bool? isUsed = null;
var lstGoalGoodsCategoryType = new List <GoalGoodsCategoryTypeEnum>();
string goalTypeParam = "goalType";
string isUsedParam = "isUsed";
string goalGoodsCatTypeParam = "goalGoodsCatType";
if (dataTablesModel.ExternalParam.ContainsKey(goalTypeParam))
{
goalTypeId = Utilities.ToEnum <GoalTypeEnum>(dataTablesModel.ExternalParam[goalTypeParam]);
}
if (dataTablesModel.ExternalParam.ContainsKey(isUsedParam))
{
isUsed = Convert.ToBoolean(dataTablesModel.ExternalParam[isUsedParam]);
}
if (dataTablesModel.ExternalParam.ContainsKey(goalGoodsCatTypeParam))
{
foreach (var item in dataTablesModel.ExternalParam[goalGoodsCatTypeParam].Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries))
{
lstGoalGoodsCategoryType.Add(Utilities.ToEnum <GoalGoodsCategoryTypeEnum>(item).Value);
}
}
if (goalTypeId.HasValue)
{
var entities = await businessService.EntityListByPagingLoader
.LoadAsync(
pageNumber : dataTablesModel.iDisplayStart
, pageSize : dataTablesModel.iDisplayLength
, includes : goal => new { goal.GoalGoodsCategory, goal.Company, goal.GoalGoodsCategoryType, goal.GoalSteps, goal.ComputingType }
, orderBy : UIHelper.GetOrderBy <Goal, GoalViewModel>(dataTablesModel.GetSortedColumns())
, where : or => (or.GoalGoodsCategory.Name.Contains(dataTablesModel.sSearch) ||
or.GoalGoodsCategoryType.Description.Contains(dataTablesModel.sSearch) ||
or.ComputingType.Description.Contains(dataTablesModel.sSearch)
) &&
or.GoalTypeId == goalTypeId.Value &&
(isUsed == null || or.IsUsed == isUsed.Value) &&
(lstGoalGoodsCategoryType.Count == 0 || lstGoalGoodsCategoryType.Contains(or.GoalGoodsCategoryTypeId)));
if (entities.ReturnStatus == false)
{
return(CreateErrorResponse(entities));
}
var mapper = GetMapper();
List <GoalViewModel> dataSource = mapper.Map <List <Goal>, List <GoalViewModel> >(entities.ResultValue);
return(Request.CreateResponse(HttpStatusCode.OK
, DataTablesJson(items: dataSource
, totalRecords: entities.TotalRows
, totalDisplayRecords: entities.TotalRows
, sEcho: dataTablesModel.sEcho)));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, new List <GoalViewModel>()));
}
}
public virtual async Task <HttpResponseMessage> GetDataGrid(JQueryDataTablesModel dataTablesModel)
{
var entities = await businessService.EntityListByPagingLoader.LoadAsync(
pageNumber : dataTablesModel.iDisplayStart
, pageSize : dataTablesModel.iDisplayLength
, includes : x => new { x.Branch, x.PositionType }
, orderBy : UIHelper.GetOrderBy <OrgStructure, OrgStructureIndexViewModel>(dataTablesModel.GetSortedColumns())
,
where : x =>
x.PositionType.Description.Contains(dataTablesModel.sSearch) ||
x.Branch.Name.Contains(dataTablesModel.sSearch) ||
dataTablesModel.sSearch == null);
if (entities.ReturnStatus == false)
{
return(CreateErrorResponse(entities));
}
var mapper = GetMapper();
List <OrgStructureIndexViewModel> dataSource = mapper.Map <List <OrgStructure>, List <OrgStructureIndexViewModel> >(entities.ResultValue);
return(Request.CreateResponse(HttpStatusCode.OK
, DataTablesJson(items: dataSource
, totalRecords: entities.TotalRows
, totalDisplayRecords: entities.TotalRows
, sEcho: dataTablesModel.sEcho)));
}
public async Task <HttpResponseMessage> GetGridData(JQueryDataTablesModel dataTablesModel)
{
var entities = await userBusinessService.LoadAsync(dataTablesModel.sSearch
, orderBy : UIHelper.GetOrderBy <User, RegisterViewModel>(dataTablesModel.GetSortedColumns())
, pageNumber : dataTablesModel.iDisplayStart
, pageSize : dataTablesModel.iDisplayLength);
if (entities.ReturnStatus == false)
{
return(CreateErrorResponse(entities));
}
var mapper = GetMapper();
var dataSource = mapper.Map <List <User>, List <UserIndexViewModel> >(entities.ResultValue);
return(Request.CreateResponse(HttpStatusCode.OK
, DataTablesJson(items: dataSource
, totalRecords: entities.TotalRows
, totalDisplayRecords: entities.TotalRows
, sEcho: dataTablesModel.sEcho)));
}
public JsonResult Search(JQueryDataTablesModel jQueryDataTablesModel)
{
int totalRecordCount;
int searchRecordCount;
var customers = InMemoryCategoryRepository.GetCategories(startIndex: jQueryDataTablesModel.iDisplayStart,
pageSize: jQueryDataTablesModel.iDisplayLength, sortedColumns: jQueryDataTablesModel.GetSortedColumns(),
totalRecordCount: out totalRecordCount, searchRecordCount: out searchRecordCount, searchString: jQueryDataTablesModel.sSearch);
return(Json(new JQueryDataTablesResponse <Category>(items: customers,
totalRecords: totalRecordCount,
totalDisplayRecords: searchRecordCount,
sEcho: jQueryDataTablesModel.sEcho)));
}
