public Page <CategoryResponseDto> FindAll(CategorySearchDto request)
        {
            var query = _db.Categories.AsQueryable();

            if (request.Name != null)
            {
                query = query.Where(category => category.Name.ToLower().Contains(request.Name.ToLower()));
            }

            return(query
                   .Select(category => _mapper.Map <CategoryResponseDto>(category))
                   .GetPaged(request.Page, request.Size));
        }
 public Page <CategoryResponseDto> Get([FromQuery] CategorySearchDto request)
 {
     return(_categoryService.FindAll(request));
 }