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