public IQueryable <Assinatura> GetByFilters(AssinaturaFilter filters) { var querybase = this.GetAll(); var queryFilter = this.SimpleFilters(filters, querybase); return(queryFilter); }
public async Task <IActionResult> Get([FromQuery] AssinaturaFilter filters) { var result = new HttpResult <AssinaturaDto>(this._logger, this._service); try { var searchResult = await this._service.GetByFiltersPaging(filters); return(result.ReturnCustomResponse(searchResult)); } catch (Exception ex) { return(result.ReturnCustomException(ex, "Assinatura", filters)); } }
public async Task <IActionResult> DataItems([FromQuery] AssinaturaFilter 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] AssinaturaFilter filters) { var result = new HttpResult <AssinaturaDto>(this._logger, this._service); try { filters.AssinaturaId = id; var returnModel = await this._service.GetById(filters); return(result.ReturnCustomResponse(returnModel)); } catch (Exception ex) { return(result.ReturnCustomException(ex, "Assinatura", id)); } }
protected IQueryable <Assinatura> SimpleFilters(AssinaturaFilter filters, IQueryable <Assinatura> queryBase) { var queryFilter = queryBase; if (filters.AssinaturaId.IsSent()) { queryFilter = queryFilter.Where(_ => _.AssinaturaId == filters.AssinaturaId); } if (filters.Nome.IsSent()) { queryFilter = queryFilter.Where(_ => _.Nome.Contains(filters.Nome)); } if (filters.Empresa.IsSent()) { queryFilter = queryFilter.Where(_ => _.Empresa.Contains(filters.Empresa)); } if (filters.SetorId.IsSent()) { queryFilter = queryFilter.Where(_ => _.SetorId == filters.SetorId); } if (filters.Telefone.IsSent()) { queryFilter = queryFilter.Where(_ => _.Telefone.Contains(filters.Telefone)); } if (filters.Senha.IsSent()) { queryFilter = queryFilter.Where(_ => _.Senha.Contains(filters.Senha)); } if (filters.CpfCnpj.IsSent()) { queryFilter = queryFilter.Where(_ => _.CpfCnpj.Contains(filters.CpfCnpj)); } if (filters.Logradouro.IsSent()) { queryFilter = queryFilter.Where(_ => _.Logradouro.Contains(filters.Logradouro)); } if (filters.Numero.IsSent()) { queryFilter = queryFilter.Where(_ => _.Numero.Contains(filters.Numero)); } if (filters.Complemento.IsSent()) { queryFilter = queryFilter.Where(_ => _.Complemento.Contains(filters.Complemento)); } if (filters.Bairro.IsSent()) { queryFilter = queryFilter.Where(_ => _.Bairro.Contains(filters.Bairro)); } if (filters.CidadeId.IsSent()) { queryFilter = queryFilter.Where(_ => _.CidadeId == filters.CidadeId); } if (filters.UF.IsSent()) { queryFilter = queryFilter.Where(_ => _.UF.Contains(filters.UF)); } if (filters.PaisId.IsSent()) { queryFilter = queryFilter.Where(_ => _.PaisId == filters.PaisId); } return(queryFilter); }
public virtual IEnumerable <dynamic> GetDataItems(AssinaturaFilter filters) { var querybase = this.GetAll(); return(this.GetAll().Select(_ => new { Id = _.AssinaturaId, Name = _.Nome })); }
public Assinatura GetById(AssinaturaFilter filters) { var querybase = this.GetByFilters(filters); return(querybase.SingleOrDefault()); }