public IEnumerable <Categoria> List(CategoriaFilter filter)
{
return(Connection.Query <Categoria>(
"SProc_Categoria_GetAll",
commandType: CommandType.StoredProcedure
));
}
public async Task <IActionResult> Get([FromQuery] CategoriaFilter filter)
{
try
{
return(Ok(_mapper.Map <QueryResult <CategoriaDoItemDTO> >(await this.GatewayServiceProvider.Get <ICategoriaDoItemService>().Get(filter))));
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <ICollection <Categoria> > Busca(CategoriaFilter filtro)
{
//inicializa a consulta
var query = _db.Categoria
.AsQueryable();
// faz o filtro
query = Filter(query, filtro);
//retorna o resultado
return(await query.ToListAsync());
}
public IActionResult Find([FromQuery] CategoriaFilter filter)
{
try
{
var result = _service.List(filter);
return(Ok(result));
}
catch (Exception ex)
{
return(StatusCode(500, ex.Message));
}
}
public IQueryable <Categoria> Filter(IQueryable <Categoria> query, CategoriaFilter filter)
{
// executa os filtros
if (filter.Ids != null)
{
query = query.Where(a => filter.Ids.Contains(a.Id));
}
if (!string.IsNullOrEmpty(filter.Nome))
{
query = query.Where(a => a.Nome.Contains(filter.Nome));
}
// retorna o resultado
return(query);
}
public async Task <ActionResult> Get([FromBody] CategoriaFilter item)
{
try
{
//carrega o repositorio
using var repository = new CategoriaRepository();
//efetua a consulta
var result = await repository.Busca(item);
//retorna o resultado
return(Ok(result));
}
catch (Exception ex)
{
return(BadRequest(new ValidationModel(ex.Message)));
}
}
public CategoriaSpec(CategoriaFilter filter)
{
Query.OrderBy(x => x.Nombre).ThenByDescending(x => x.Id);
if (filter.IsPagingEnabled)
{
Query.Skip(PaginationHelper.CalculateSkip(filter))
.Take(PaginationHelper.CalculateTake(filter));
}
if (filter.LoadChildren)
{
Query.Include(x => x.Negocios);
}
if (!string.IsNullOrEmpty(filter.Nombre))
{
Query.Search(x => x.Nombre.ToLower(), "%" + filter.Nombre.ToLower() + "%");
}
}
public IEnumerable <Categoria> List(CategoriaFilter filter)
{
return(_CategoriaRepository.List(filter));
}
public IEnumerable <CategoriaDto> List(CategoriaFilter filter)
{
var list = _service.List(filter);
return(TypeConverter.ConvertTo <IEnumerable <CategoriaDto> >(list));
}
