public Pagination <GetManufacturerDto> Execute(ManufacturerQuery request)
{
var query = Context.Manufacturers.AsQueryable();
if (request.Name != null)
{
query = query.Where(r => r.Name.ToLower().Contains(request.Name.ToLower()));
}
var totalCount = query.Count();
query = query.Skip((request.PageNumber - 1) * request.PerPage).Take(request.PerPage);
var pagesCount = (int)Math.Ceiling((double)totalCount / request.PerPage);
return(new Pagination <GetManufacturerDto>
{
CurrentPage = request.PageNumber,
Pages = pagesCount,
Total = totalCount,
Data = query.Select(r => new GetManufacturerDto
{
Id = r.Id,
Name = r.Name
})
});
}
public IActionResult Get([FromQuery] ManufacturerQuery query)
{
try
{
return(Ok(_getManufacturersCommand.Execute(query)));
}
catch (EntityNotFoundException)
{
return(NotFound());
}
}
// GET: Manufacturer
public ActionResult Index(ManufacturerQuery request)
{
return(View(_getManufacturers.Execute(request)));
}
