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)); }