public IQueryable <Regiao> GetByFilters(RegiaoFilter filters)
{
var querybase = this.GetAll();
var queryFilter = this.SimpleFilters(filters, querybase);
return(queryFilter);
}
public async Task <IActionResult> Get([FromQuery] RegiaoFilter filters)
{
var result = new HttpResult <RegiaoDto>(this._logger, this._service);
try
{
var searchResult = await this._service.GetByFiltersPaging(filters);
return(result.ReturnCustomResponse(searchResult));
}
catch (Exception ex)
{
return(result.ReturnCustomException(ex, "Regiao", filters));
}
}
public async Task <IActionResult> DataItems([FromQuery] RegiaoFilter filters)
{
var result = new HttpResult <dynamic>(this._logger, this._service);
try
{
var items = await this._service.GetDataItems(filters);
return(result.ReturnCustomResponse(items));
}
catch (Exception ex)
{
return(result.ReturnCustomException(ex, "Assinatura", filters));
}
}
public async Task <IActionResult> Get(int id, [FromQuery] RegiaoFilter filters)
{
var result = new HttpResult <RegiaoDto>(this._logger, this._service);
try
{
filters.RegiaoId = id;
var returnModel = await this._service.GetById(filters);
return(result.ReturnCustomResponse(returnModel));
}
catch (Exception ex)
{
return(result.ReturnCustomException(ex, "Regiao", id));
}
}
protected IQueryable <Regiao> SimpleFilters(RegiaoFilter filters, IQueryable <Regiao> queryBase)
{
var queryFilter = queryBase;
if (filters.RegiaoId.IsSent())
{
queryFilter = queryFilter.Where(_ => _.RegiaoId == filters.RegiaoId);
}
if (filters.Nome.IsSent())
{
queryFilter = queryFilter.Where(_ => _.Nome.Contains(filters.Nome));
}
return(queryFilter);
}
public Regiao GetById(RegiaoFilter filters)
{
var querybase = this.GetByFilters(filters);
return(querybase.SingleOrDefault());
}
public virtual IEnumerable <dynamic> GetDataItems(RegiaoFilter filters)
{
var querybase = this.GetAll();
return(this.GetAll().Select(_ => new { Id = _.RegiaoId, Name = _.Nome }));
}