public async Task <JqDataTableResponse <SalesTaxListItemDto> > GetPagedResultAsync(SalexTaxJqDataTableRequestModel model)
{
if (model.Length == 0)
{
model.Length = Constants.DefaultPageSize;
}
var filterKey = model.Search.Value;
var linqstmt = (from st in _dataContext.SalesTaxes
where st.Status != Constants.RecordStatus.Deleted &&
(model.FilterKey == null ||
EF.Functions.Like(st.Code, "%" + model.FilterKey + "%") ||
EF.Functions.Like(st.Description, "%" + model.FilterKey + "%"))
select new SalesTaxListItemDto
{
Id = st.Id,
Code = st.Code,
Description = st.Description ?? "",
TaxPercentage = st.TaxPercentage,
Status = st.Status,
BankAccountId = st.BankAccountId
})
.AsNoTracking();
var sortExpression = model.GetSortExpression();
var pagedResult = new JqDataTableResponse <SalesTaxListItemDto>
{
RecordsTotal = await _dataContext.SalesTaxes.CountAsync(x => x.Status != Constants.RecordStatus.Deleted),
RecordsFiltered = await linqstmt.CountAsync(),
Data = await linqstmt.OrderBy(sortExpression).Skip(model.Start).Take(model.Length).ToListAsync()
};
return(pagedResult);
}
public async Task <IActionResult> GetPagedResult(SalexTaxJqDataTableRequestModel model)
{
var pagedResult = await _manager.GetPagedResultAsync(model);
return(Ok(pagedResult));
}
public async Task <JqDataTableResponse <SalesTaxListItemDto> > GetPagedResultAsync(SalexTaxJqDataTableRequestModel model)
{
return(await _repository.GetPagedResultAsync(model));
}
