public DataTablePage <T> GetDataTablePage(DataTablePagingInfo pagingInfo)
{
var data = service.GetAll();
var drawStep = pagingInfo.DrawCounter;
var countRecords = pagingInfo.TotalEntries;
//For single count query
if (countRecords == -1)
{
countRecords = data.Count();
}
var sortExpression = service.GetSortExpressions()[pagingInfo.SortColumnName];
data = GetSortedQuery(data, pagingInfo.SortColumnName
, pagingInfo.SortColumnDirection, sortExpression);
var countFiltered = countRecords;
var whereExpression = MakeWhereExpression(pagingInfo.SearchValue
, pagingInfo.FilterColumnNames, pagingInfo.FilterValues);
if (whereExpression != null)
{
data = GetSearchedQuery(data, whereExpression);
countFiltered = data.Count();
}
data = data
.Skip((pagingInfo.PageNumber - 1) * pagingInfo.PageSize)
.Take(pagingInfo.PageSize);
return(GetJsonDataTable(data, drawStep, countRecords, countFiltered));
}
public IActionResult GetPage([FromQuery] DataTablePagingInfo pagingInfo)
{
log.Info(nameof(TicketVerificationsController.GetPage));
try
{
return(Json(ticketVerificationService.GetVerificationsPage(pagingInfo)));
}
catch (Exception e)
{
log.Error(e);
return(BadRequest());
}
}
public IActionResult GetCurrentPage([FromQuery] DataTablePagingInfo pagingInfo)
{
logger.Info(nameof(TransactionHistoryController.GetCurrentPage));
try
{
if (pagingInfo == null)
{
logger.Warn(nameof(TransactionHistoryController.GetCurrentPage) + " pagingInfo is null");
return(NotFound());
}
return(Json(transactionService.GetTransactionsPage(pagingInfo)));
}
catch (Exception ex)
{
logger.Error(ex);
return(BadRequest(ex));
}
}
public IActionResult GetCurrentPage([FromQuery] DataTablePagingInfo pagingInfo)
{
return(Json(ticketService.GetTicketsPage(pagingInfo)));
}
public DataTablePage <TicketDto> GetTicketsPage(DataTablePagingInfo pagingInfo)
{
var ticketsPage = dataTableService.GetDataTablePage(pagingInfo);
return(mapper.Map <DataTablePage <Ticket>, DataTablePage <TicketDto> >(ticketsPage));
}
public DataTablePage <TicketVerificationDto> GetVerificationsPage(DataTablePagingInfo pagingInfo)
{
var verificationsPage = dataTableService.GetDataTablePage(pagingInfo);
return(mapper.Map <DataTablePage <TicketVerification>, DataTablePage <TicketVerificationDto> >(verificationsPage));
}
public DataTablePage <UserDto> GetUsersPage(DataTablePagingInfo pagingInfo)
{
var usersPage = dataTableService.GetDataTablePage(pagingInfo);
return(mapper.Map <DataTablePage <User>, DataTablePage <UserDto> >(usersPage));
}
public DataTablePage <DocumentDto> GetDocumentPage(DataTablePagingInfo pagingInfo)
{
var documentsPage = dataTableService.GetDataTablePage(pagingInfo);
return(mapper.Map <DataTablePage <Document>, DataTablePage <DocumentDto> >(documentsPage));
}
public IActionResult GetCurrentPage([FromQuery] DataTablePagingInfo pagingInfo)
{
return(Json(userService.GetUsersPage(pagingInfo)));
}
public IActionResult GetCurrentPage([FromQuery] DataTablePagingInfo pagingInfo)
{
return(Json(documentService.GetDocumentPage(pagingInfo)));
}
public DataTablePage <TransactionHistoryDto> GetTransactionsPage(DataTablePagingInfo pagingInfo)
{
var transactionsPage = dataTableService.GetDataTablePage(pagingInfo);
return(mapperService.Map <DataTablePage <TransactionHistory>, DataTablePage <TransactionHistoryDto> >(transactionsPage));
}
