public static SqlQuery ToPagingQuery(this SqlQuery query, SearchSortRequest sort, int page, int take)
{
IFluentPaging fp = ionixFactory.CreatePaging();
fp.Select("*")
.From("(" + query + ") T")
.OrderBy(sort.field + " " + (sort.dir == 0 ? "ASC" : "DESC"))
.Page(page)
.Take(take);
SqlQuery temp = fp.ToQuery();
query.Parameters.ForEach((p) =>
{
temp.Parameters.Add(p);
});
return(temp);
}
public async Task<ActionResult<ListResponse<VehicleTaxDto>>> ListTax(
[FromBody] SearchSortRequest searchSortRequest)
{
Result<VehicleTaxDto[]> res = await _vehicleTaxHandler.ListVehicleTaxSearchSort(
new BasicSearchSortViewModel(
searchBy: searchSortRequest.SearchBy,
sortBy: searchSortRequest.SortBy,
page: searchSortRequest.Page,
perPage: searchSortRequest.PerPage));
if (res.IsSuccess)
{
return new ListResponse<VehicleTaxDto>
{
Data = res.Value,
TotalRecords = res.Value.Length
};
}
return BadRequest(new { Error = res.Errors.FirstOrDefault() });
}
