public PagedResponse <TeethDto> Execute(TeethSearch search) { var query = _context.Teeth.AsQueryable(); if (!string.IsNullOrEmpty(search.ToothNumber.ToString()) || !string.IsNullOrWhiteSpace(search.ToothNumber.ToString())) { query = query.Where(x => x.ToothNumber.ToString().ToLower().Contains(search.ToothNumber.ToString().ToLower())); } var skipCount = search.PerPage * (search.Page - 1); var response = new PagedResponse <TeethDto> { CurrentPage = search.Page, ItemsPerPage = search.PerPage, TotalCount = query.Count(), Items = query.Skip(skipCount).Take(search.PerPage).Select(x => new TeethDto { Id = x.Id, ToothNumber = x.ToothNumber }).ToList() }; return(response); }
public IActionResult Get([FromQuery] TeethSearch search, [FromServices] IGetTeethQuery query) { return(Ok(_executor.ExecuteQuery(query, search))); }