public IQueryable <Empresa> GetByFilters(EmpresaFilter filters) { var querybase = this.GetAll(); var queryFilter = this.SimpleFilters(filters, querybase); return(queryFilter); }
public List <EmpresaQueryResult> GetByFiltro(EmpresaFilter filter) { return(_mapper.Map <List <EmpresaQueryResult> >( _context.Empresas.Where(p => (string.IsNullOrEmpty(filter.Nome) || p.Nome.Contains(filter.Nome)) && (string.IsNullOrEmpty(filter.CNPJ) || p.CNPJ == filter.CNPJ) && filter.DataFundacaoFim == null && filter.DataFundacaoFim == null || p.DataFundacao >= filter.DataFundacaoInicio && p.DataFundacao <= filter.DataFundacaoFim).ToList())); }
public async Task <IActionResult> Get([FromQuery] EmpresaFilter filters) { var result = new HttpResult <EmpresaDto>(this._logger, this._service); try { var searchResult = await this._service.GetByFiltersPaging(filters); return(result.ReturnCustomResponse(searchResult)); } catch (Exception ex) { return(result.ReturnCustomException(ex, "Empresa", filters)); } }
public async Task <IActionResult> DataItems([FromQuery] EmpresaFilter 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)); } }
protected IQueryable <Empresa> SimpleFilters(EmpresaFilter filters, IQueryable <Empresa> queryBase) { var queryFilter = queryBase; if (filters.EmpresaId.IsSent()) { queryFilter = queryFilter.Where(_ => _.EmpresaId == filters.EmpresaId); } if (filters.AssinaturaId.IsSent()) { queryFilter = queryFilter.Where(_ => _.AssinaturaId != null && _.AssinaturaId.Value == filters.AssinaturaId); } if (filters.Nome.IsSent()) { queryFilter = queryFilter.Where(_ => _.Nome.Contains(filters.Nome)); } if (filters.ProprietarioId.IsSent()) { queryFilter = queryFilter.Where(_ => _.ProprietarioId != null && _.ProprietarioId.Value == filters.ProprietarioId); } if (filters.DataCriacaoStart.IsSent()) { queryFilter = queryFilter.Where(_ => _.DataCriacao >= filters.DataCriacaoStart); } if (filters.DataCriacaoEnd.IsSent()) { filters.DataCriacaoEnd = filters.DataCriacaoEnd.AddDays(1).AddMilliseconds(-1); queryFilter = queryFilter.Where(_ => _.DataCriacao <= filters.DataCriacaoEnd); } if (filters.DataAtualizacaoStart.IsSent()) { queryFilter = queryFilter.Where(_ => _.DataAtualizacao != null && _.DataAtualizacao.Value >= filters.DataAtualizacaoStart.Value); } if (filters.DataAtualizacaoEnd.IsSent()) { filters.DataAtualizacaoEnd = filters.DataAtualizacaoEnd.Value.AddDays(1).AddMilliseconds(-1); queryFilter = queryFilter.Where(_ => _.DataAtualizacao != null && _.DataAtualizacao.Value <= filters.DataAtualizacaoEnd); } if (filters.VisibilidadeId.IsSent()) { queryFilter = queryFilter.Where(_ => _.VisibilidadeId == filters.VisibilidadeId); } return(queryFilter); }
public async Task <IActionResult> Get(int id, [FromQuery] EmpresaFilter filters) { var result = new HttpResult <EmpresaDto>(this._logger, this._service); try { filters.EmpresaId = id; var returnModel = await this._service.GetById(filters); return(result.ReturnCustomResponse(returnModel)); } catch (Exception ex) { return(result.ReturnCustomException(ex, "Empresa", id)); } }
public IActionResult Get([FromQuery] EmpresaFilter filter) { if (filter == null) { return(Response(_repository.Get())); } if (filter.DateTimeValidate()) { return(Response(_repository.GetByFiltro(filter))); } else { _notification.Adicionar("Data para filtro inválida."); return(BadRequest()); } }
public Empresa GetById(EmpresaFilter filters) { var querybase = this.GetByFilters(filters); return(querybase.SingleOrDefault()); }
public virtual IEnumerable <dynamic> GetDataItems(EmpresaFilter filters) { var querybase = this.GetAll(); return(this.GetAll().Select(_ => new { Id = _.EmpresaId, Name = _.Nome })); }