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 async Task <HttpResponseMessage> GetGroupByStartEndDateGoalDataGrid(JQueryDataTablesModel dataTablesModel)
{
bool isUsed = false;
string isUsedParam = "isUsed";
if (dataTablesModel.ExternalParam.ContainsKey(isUsedParam))
{
isUsed = Convert.ToBoolean(dataTablesModel.ExternalParam[isUsedParam]);
}
var entities = await businessService.LoadGroupByStartEndDateGoalsAync(isUsed, pageNumber : dataTablesModel.iDisplayStart, pageSize : dataTablesModel.iDisplayLength);
if (entities.ReturnStatus == false)
{
return(CreateErrorResponse(entities));
}
var mapper = GetMapper();
var dataSource = mapper.Map <List <GroupByStartEndDate>, List <GroupByStartEndDateViewModel> >(entities.ResultValue);
if (dataTablesModel.sSearch != null)
{
dataSource = dataSource.Where(x => x.StartDate.Contains(dataTablesModel.sSearch)).ToList();
}
return(Request.CreateResponse(HttpStatusCode.OK
, DataTablesJson(items: dataSource
, totalRecords: entities.TotalRows
, totalDisplayRecords: entities.TotalRows
, sEcho: dataTablesModel.sEcho)));
}
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 ActionResult DataTableHandler(JQueryDataTablesModel parameters)
{
FalconOrchestratorDB db = new FalconOrchestratorDB();
List <Detection> model = HttpContext.Application["Detections"] as List <Detection>;
if (!String.IsNullOrEmpty(parameters.sSearch))
{
model = model.Where(x => x.DetectionDevice.Device.Hostname.Contains(parameters.sSearch.ToLower()) ||
x.Account.AccountName.ToLower().Contains(parameters.sSearch.ToLower()) ||
x.Name.ToLower().Contains(parameters.sSearch.ToLower()) ||
x.FileName.ToLower().Contains(parameters.sSearch.ToLower())).ToList();
}
int sortingColumnIndex = parameters.iSortCol_0;
string sortDirection = parameters.sSortDir_0;
Func <Detection, string> orderingFunction = (x => sortingColumnIndex == 0 ? x.ProcessStartTime.Value.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture) :
sortingColumnIndex == 1 ? x.Severity.SeverityType :
sortingColumnIndex == 2 ? x.Name :
sortingColumnIndex == 3 ? x.DetectionDevice.Device.Hostname :
sortingColumnIndex == 4 ? x.Account.AccountName :
sortingColumnIndex == 5 ? x.FileName :
sortingColumnIndex == 6 ? x.Status.StatusType :
x.Responder != null ? x.Responder.FirstName + " " + x.Responder.LastName : null);
if (sortDirection == "asc")
{
model = model.OrderBy(orderingFunction).ToList();
}
if (sortDirection == "desc")
{
model = model.OrderByDescending(orderingFunction).ToList();
}
var filteredModel = model.Skip(parameters.iDisplayStart)
.Take(parameters.iDisplayLength).ToList();
var data = filteredModel.Select(x => new DetectionListViewModel
{
DT_RowId = x.DetectionId,
DetectionName = x.Name,
FileName = x.FileName,
Responder = x.Responder != null ? x.Responder.FirstName + " " + x.Responder.LastName : null,
Hostname = x.DetectionDevice.Device.Domain != x.DetectionDevice.Device.Hostname ? x.DetectionDevice.Device.Domain + "\\" + x.DetectionDevice.Device.Hostname : x.DetectionDevice.Device.Hostname,
Severity = x.Severity.SeverityType,
Status = x.Status.StatusType,
Timestamp = x.ProcessStartTime.Value.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture),
Username = x.Account.AccountName
});
return(Json(new
{
sEcho = parameters.sEcho,
iTotalRecords = model.Count,
iTotalDisplayRecords = model.Count,
aaData = data
},
JsonRequestBehavior.AllowGet));
}
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 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)));
}
public ActionResult QueryBfRole(JQueryDataTablesModel jQueryDataTablesModel, QueryBfRoleDto query)
{
var queryParam = new QueryBfRoleDto
{
PageIndex = jQueryDataTablesModel.PageIndex,
PageSize = jQueryDataTablesModel.PageSize,
CODE = query.CODE,
NAME = query.NAME,
SortField = jQueryDataTablesModel.SortField,
SortDirection = jQueryDataTablesModel.Direction
};
var pageList = (new BfRoleManager()).GetPagedList(queryParam);
return(DataTablesJson(pageList, jQueryDataTablesModel.GridKey));
}
public ActionResult QueryDB(JQueryDataTablesModel jQueryDataTablesModel, SewerinfoDto query)
{
var queryParam = new SewerinfoDto
{
LeaderCode = query.LeaderCode,
StartIndex = query.StartIndex,
PageIndex = jQueryDataTablesModel.PageIndex,
PageSize = jQueryDataTablesModel.PageSize,
SortField = jQueryDataTablesModel.SortField,
SortDirection = jQueryDataTablesModel.Direction,
RoadName = query.RoadName
};
var pageList = (new YhSewerinfoInfoManager()).GetPagedList(queryParam);
return(DataTablesJson(pageList, jQueryDataTablesModel.GridKey));
}
public ActionResult QueryDB(JQueryDataTablesModel jQueryDataTablesModel, SubContractorDto query)
{
var queryParam = new SubContractorDto
{
PageIndex = jQueryDataTablesModel.PageIndex,
PageSize = jQueryDataTablesModel.PageSize,
SubContractorBoss = query.SubContractorBoss,
SubContractorCode = query.SubContractorCode,
SubContractorCrop = query.SubContractorCrop,
SortField = jQueryDataTablesModel.SortField,
SortDirection = jQueryDataTablesModel.Direction
};
var pageList = (new YhSubcontractorinfoManager()).GetPagedList(queryParam);
return(DataTablesJson(pageList, jQueryDataTablesModel.GridKey));
}
public JsonResult SearchBfOrg(JQueryDataTablesModel jQueryDataTablesModel, BfOrgInfo bfOrgInfo)
{
var queryParam = new QueryBfOrgDto
{
PageIndex = jQueryDataTablesModel.PageIndex,
PageSize = jQueryDataTablesModel.PageSize,
CODE = bfOrgInfo.CODE,
NAME = bfOrgInfo.NAME,
OWNER_ID = bfOrgInfo.OWNER_ID,
SortField = jQueryDataTablesModel.SortField,
SortDirection = jQueryDataTablesModel.Direction
};
var pageList = (new BfOrgManager()).GetPagedList(queryParam);
return(this.DataTablesJson(pageList, jQueryDataTablesModel.GridKey));
}
public ActionResult QueryDB(JQueryDataTablesModel jQueryDataTablesModel, SanitationInfoDto query)
{
var queryParam = new SanitationInfoDto
{
PageIndex = jQueryDataTablesModel.PageIndex,
PageSize = jQueryDataTablesModel.PageSize,
ID = query.ID,
LeaderCode = query.LeaderCode,
SortField = "RoadID",
SortDirection = jQueryDataTablesModel.Direction,
RoadName = query.RoadName
};
var pageList = (new YhSanitationInfoManager()).GetPagedList(queryParam);
return(DataTablesJson(pageList, jQueryDataTablesModel.GridKey));
}
public ActionResult QueryDB(JQueryDataTablesModel jQueryDataTablesModel, ImgInfoDto query)
{
var queryParam = new ImgInfoDto
{
imgModuleId = query.imgModuleId,
imgType = query.imgType,
StartIndex = query.StartIndex,
PageIndex = jQueryDataTablesModel.PageIndex,
PageSize = jQueryDataTablesModel.PageSize,
SortField = jQueryDataTablesModel.SortField,
SortDirection = jQueryDataTablesModel.Direction
};
var pageList = (new YhImgInfoManager()).GetPagedList(queryParam);
return(DataTablesJson(pageList, jQueryDataTablesModel.GridKey));
}
public ActionResult QueryDB(JQueryDataTablesModel jQueryDataTablesModel, SubContLeaderInfoDto query)
{
var queryParam = new SubContLeaderInfoDto
{
PageIndex = jQueryDataTablesModel.PageIndex,
PageSize = jQueryDataTablesModel.PageSize,
LeaderCode = query.LeaderCode,
LeaderName = query.LeaderName,
SubContractorID = query.SubContractorID,
PhoneNumber = query.PhoneNumber,
SortField = jQueryDataTablesModel.SortField,
SortDirection = jQueryDataTablesModel.Direction
};
var pageList = (new YhSubContLeaderInfoManager()).GetPagedList(queryParam);
return(DataTablesJson(pageList, jQueryDataTablesModel.GridKey));
}
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)));
}
//
// GET: /API/Group/
public ActionResult Index(JQueryDataTablesModel param)
{
using (var db = new RIPPWebEntities())
{
var lst = db.S_Group;
var page = lst.OrderByDescending(d => d.ID).Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList().Select(d => new GroupTable()
{
ID = d.ID,
MasterUserID = d.MasterUserID,
MasterName = d.MasterUser != null ? d.MasterUser.RealName : "",
Name = d.Names,
Remark = d.Remark
});
return(new RenderJsonResult()
{
Result = new JQueryDataTablesResponse <GroupTable>(page, lst.Count(), lst.Count(), param.sEcho)
});
}
}
public ActionResult QueryDB(JQueryDataTablesModel jQueryDataTablesModel, AreaInfoDto query)
{
var queryParam = new AreaInfoDto
{
ID = query.ID,
AreaCode = query.AreaCode,
Owner = query.Owner,
Dept = query.Dept,
Area = query.Area,
Section = query.Section,
StartIndex = query.StartIndex,
PageIndex = jQueryDataTablesModel.PageIndex,
PageSize = jQueryDataTablesModel.PageSize,
SortField = jQueryDataTablesModel.SortField,
SortDirection = jQueryDataTablesModel.Direction
};
var pageList = (new YhAreainfoManager()).GetPagedList(queryParam);
return(DataTablesJson(pageList, jQueryDataTablesModel.GridKey));
}
public async Task <HttpResponseMessage> GetDataGrid(JQueryDataTablesModel dataTablesModel)
{
IBusinessLoadByPagingResult <Goods> entities = await lstByPagingLoaderBs.LoadAsync(
includes : ent => new { ent.Company },
orderBy : Utilities.GetOrderBy <Goods>("id", "asc"));
if (entities.ReturnStatus == false)
{
return(CreateErrorResponse(entities));
}
var mapper = GetMapper();
List <GoodsViewModel> dataSource = mapper.Map <List <Goods>, List <GoodsViewModel> >(entities.ResultValue);
return(Request.CreateResponse(HttpStatusCode.OK
, DataTablesJson(items: dataSource,
totalRecords: entities.TotalRows,
totalDisplayRecords: entities.TotalRows,
sEcho: dataTablesModel.sEcho)));
}
public async Task <HttpResponseMessage> GetGeneralGoalDataGrid(JQueryDataTablesModel dataTablesModel)
{
var businessResult = await businessService.EntityListLoader.LoadListAsync(x => x.GoalGoodsCategoryTypeId == GoalGoodsCategoryTypeEnum.TotalSalesGoal && x.GoalTypeId == GoalTypeEnum.Distributor
, orderBy : ord => ord.OrderBy(g => g.StartDate));
if (businessResult.ReturnStatus == false)
{
return(CreateErrorResponse(businessResult));
}
var mapper = GetMapper();
var result = mapper.Map <List <Goal>, List <GoalViewModel> >(businessResult.ResultValue);
return(Request.CreateResponse(HttpStatusCode.OK
, DataTablesJson(items: result
, totalRecords: result.Count
, totalDisplayRecords: result.Count
, sEcho: 0)));
}
public ActionResult QueryDB(JQueryDataTablesModel jQueryDataTablesModel, RoadMunicipalInfoDto query)
{
var queryParam = new RoadMunicipalInfoDto
{
CurbFlatLength = query.CurbFlatLength,
CurbSideLength = query.CurbSideLength,
FastLaneSquare = query.FastLaneSquare,
FastLaneWidth = query.FastLaneWidth,
GuideBoardCount = query.GuideBoardCount,
InspectionShaftCount = query.InspectionShaftCount,
StartIndex = query.StartIndex,
PageIndex = jQueryDataTablesModel.PageIndex,
PageSize = jQueryDataTablesModel.PageSize,
SortField = jQueryDataTablesModel.SortField,
SortDirection = jQueryDataTablesModel.Direction,
RoadName = query.RoadName
};
var pageList = (new YhRoadMunicipalInfoManager()).GetPagedList(queryParam);
return(DataTablesJson(pageList, jQueryDataTablesModel.GridKey));
}
public ActionResult QueryDB(JQueryDataTablesModel jQueryDataTablesModel, RoadbasicinfoDto query)
{
var queryParam = new RoadbasicinfoDto
{
ID = query.ID,
AreaInfoID = query.AreaInfoID,
BridgeNumber = query.BridgeNumber,
RoadCode = query.RoadCode,
RoadLevel = query.RoadLevel,
RoadMaterial = query.RoadMaterial,
RoadName = query.RoadName,
StartIndex = query.StartIndex,
PageIndex = jQueryDataTablesModel.PageIndex,
PageSize = jQueryDataTablesModel.PageSize,
SortField = jQueryDataTablesModel.SortField,
SortDirection = jQueryDataTablesModel.Direction
};
var pageList = (new YhRoadbasicinfoManager()).GetPagedList(queryParam);
return(DataTablesJson(pageList, jQueryDataTablesModel.GridKey));
}
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 virtual async Task <HttpResponseMessage> GetDataGrid(JQueryDataTablesModel dataTablesModel)
{
var entities = await businessService.EntityListByPagingLoader
.LoadAsync(includes : c => c.Status
, pageNumber : dataTablesModel.iDisplayStart
, pageSize : dataTablesModel.iDisplayLength
, orderBy : ord => ord.OrderByDescending(x => x.StartDate));
if (entities.ReturnStatus == false)
{
return(CreateErrorResponse(entities));
}
var mapper = GetMapper();
var dataSource = mapper.Map <List <Promotion>, List <PromotionViewModel> >(entities.ResultValue);
return(Request.CreateResponse(HttpStatusCode.OK
, DataTablesJson(items: dataSource
, totalRecords: entities.TotalRows
, totalDisplayRecords: entities.TotalRows
, sEcho: dataTablesModel.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)));
}
//
// GET: /API/Spec/
/// <summary>
/// 暂时不支持查询和排序
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public ActionResult Index(JQueryDataTablesModel param)
{
if (!RIPP.Web.Chem.Tools.Common.IsLogin)
{
return(new HttpUnauthorizedResult());
}
using (var db = new RIPPWebEntities())
{
//string sql="select * from ( select top {0} * from ( select top {1} * from spec from
var lst = db.spec.OrderByDescending(d => d.id);
var page = db.spec.OrderByDescending(d => d.id).Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList().Select(d => new SpecModel()
{
addtime = d.addtime,
ext = d.ext,
id = d.id,
name = d.name
});
return(new RenderJsonResult()
{
Result = new JQueryDataTablesResponse <SpecModel>(page, lst.Count(), page.Count(), param.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 JsonResult Index(JQueryDataTablesModel jQueryDataTablesModel)
{
int totalRecordCount;
int searchRecordCount;
var tasks = GetTaskManagers(
startIndex: jQueryDataTablesModel.iDisplayStart,
pageSize: jQueryDataTablesModel.iDisplayLength,
sortedColumns: Convert.ToInt32(Request["iSortCol_0"]),
//tipoOrdem: Request["sSortDir_0"].ToString(),
totalRegistrosCount: out totalRecordCount,
searchRegistrosCount: out searchRecordCount
//searchModel: searchModel
);
//TrataDadosGrid(produtos);
return(this.DataTablesJson(
items: tasks,
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 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 JsonResult GetCustomers(JQueryDataTablesModel datatablesRequestInfo, CustomerModel customer)
{
var random = new Random();
IList<Customer> customers = _customerService.GetCustomers().Where(x => x.Name.StartsWith(datatablesRequestInfo.sSearch_[0])).ToList();
IEnumerable<CustomersGridResponseModel> customerDtos =
customers.Select(x => new CustomersGridResponseModel
{
CustomerId = x.Id,
CreationDate = x.Created.LocalDateTime,
CustomerName = x.Name,
Calls = random.Next(),
Fields = random.Next(),
Details = random.Next().ToString()
});
var customersGridResponseModels = customerDtos as IList<CustomersGridResponseModel> ?? customerDtos.ToList();
IEnumerable<CustomersGridResponseModel> dtos =
customersGridResponseModels.Skip(datatablesRequestInfo.iDisplayStart)
.Take(datatablesRequestInfo.iDisplayLength);
var numberOfcustomersToShow = customersGridResponseModels.Count();
var response = new JQueryDataTablesResponse<CustomersGridResponseModel>(dtos, numberOfcustomersToShow, numberOfcustomersToShow,
datatablesRequestInfo.sEcho);
return Json(response);
}
