public async Task OnGetAsync(string searchString, int?currentPage, int?pageSize) { PageSize = pageSize.HasValue ? pageSize.Value : PaginationConstants.DefaultPageSize; if (!string.IsNullOrEmpty(searchString)) { SearchString = searchString; TotalItems = await _repository.CountAsync(new ClientesSpec(new ClienteFilter { Apellidos = searchString, IsPagingEnabled = false })); } else { TotalItems = await _repository.CountAsync(new ClientesSpec(new ClienteFilter { IsPagingEnabled = false })); } Pager = new Pager(TotalItems, currentPage.HasValue ? currentPage.Value : PaginationConstants.DefaultPage, PageSize); var filter = new ClienteFilter(); filter.IsPagingEnabled = true; filter.Apellidos = searchString; //filter.Nombres = searchString; filter.SizePage = Pager.PageSize; filter.Page = Pager.CurrentPage; Cliente = await _repository.ListAsync(new ClientesSpec(filter)); }
public async Task <Cliente> GetById(ClienteFilter model) { var _cliente = await this.SingleOrDefaultAsync(this.GetAll(this.DataAgregation(model)) .Where(_ => _.ClienteId == model.ClienteId)); return(_cliente); }
public IQueryable <Cliente> GetBySimplefilters(ClienteFilter filters) { var querybase = this.GetAll(this.DataAgregation(filters)) .WithBasicFilters(filters) .WithCustomFilters(filters); return(querybase); }
public async Task <dynamic> GetDataCustom(ClienteFilter filters) { var querybase = await this.ToListAsync(this.GetBySimplefilters(filters).Select(_ => new { Id = _.ClienteId, })); return(querybase); }
public async Task <IEnumerable <dynamic> > GetDataItem(ClienteFilter filters) { var querybase = await this.ToListAsync(this.GetBySimplefilters(filters).Select(_ => new { Id = _.ClienteId, Name = _.Nome })); return(querybase); }
public IQueryable <Cliente> GetBySimplefilters(ClienteFilter filters) { var querybase = this.GetAll(this.DataAgregation(filters)) .WithBasicFilters(filters) .WithLimitTenant(this._user) .WithCustomFilters(filters) .OrderByDomain(filters) .OrderByProperty(filters); return(querybase); }
public async Task <IActionResult> Get([FromQuery] ClienteFilter filters) { var result = new HttpResult <ClienteDto>(this._logger); try { var searchResult = await this._app.GetByFilters(filters); return(result.ReturnCustomResponse(this._app, searchResult, filters)); } catch (Exception ex) { return(result.ReturnCustomException(ex, "Target.Pendencias - Cliente", filters)); } }
public ClienteSpec(ClienteFilter filter) { Query.OrderBy(x => x.Nombre).ThenByDescending(x => x.Id); if (filter.IsPagingEnabled) { Query.Skip(PaginationHelper.CalculateSkip(filter)) .Take(PaginationHelper.CalculateTake(filter)); } if (!string.IsNullOrEmpty(filter.Nombre)) { Query.Search(x => x.Nombre.ToLower(), "%" + filter.Nombre.ToLower() + "%"); } }
public GenericResult <IEnumerable <Cliente> > List(ClienteFilter filter) { GenericResult <IEnumerable <Cliente> > result = new GenericResult <IEnumerable <Cliente> >(); try { result.Result = service.List(filter); } catch (Exception ex) { result.Errors = new string[] { ex.Message }; } return(result); }
public async Task <IActionResult> Get(int id, [FromQuery] ClienteFilter filters) { var result = new HttpResult <ClienteDto>(this._logger); try { filters.ClienteId = id; var returnModel = await this._app.GetOne(filters); return(result.ReturnCustomResponse(this._app, returnModel)); } catch (Exception ex) { return(result.ReturnCustomException(ex, "Target.Pendencias - Cliente", id)); } }
private void txtBxBusqueda_KeyUp(object sender, KeyEventArgs e) { int posicion = 0; ClienteFilter Filtro = new ClienteFilter(this.txtBxBusqueda.Text.Trim(), TipoFiltro); Predicate <ClsCliente> Filtrado = new Predicate <ClsCliente>(Filtro.BuscaAll); posicion = ListCliente.FindIndex(Filtrado); if (posicion == 0) { this.clsClienteBindingSource.Position = 0; } else { this.clsClienteBindingSource.Position = posicion; } }
public IEnumerable <IModel> Get([FromUri] ClienteFilter filter) { IEnumerable <IModel> clientes = null; if (filter.ID == 0) { try { clientes = dao.GetAll(); } catch (Exception e) { throw new HttpResponseException(HttpStatusCode.InternalServerError); } if (clientes.Count() <= 0) { throw new HttpResponseException(HttpStatusCode.NotFound); } } else { // Validar que esté solicitando un cliente válido if (filter.ID < 0) { var response = new HttpResponseMessage() { StatusCode = (HttpStatusCode)422, //Entidad Inprocesable ReasonPhrase = "Identificador de Cliente invalido" }; throw new HttpResponseException(response); } try { clientes = dao.GetByFilter(filter); } catch (Exception e) { throw new HttpResponseException(HttpStatusCode.InternalServerError); } } return(clientes); }
public ClientesSpec(ClienteFilter filter) { Query.OrderBy(x => x.Apellidos).ThenByDescending(x => x.Id); //Query.OrderBy(y => y.Nombres).ThenByDescending(y => y.Id); if (filter.IsPagingEnabled) { Query.Skip(PaginationHelper.CalculateSkip(filter)) .Take(PaginationHelper.CalculateTake(filter)); } if (!string.IsNullOrEmpty(filter.Apellidos)) { Query.Search(x => x.Apellidos, "%" + filter.Apellidos + "%"); } //if (!string.IsNullOrEmpty(filter.Nombres)) // Query.Search(y => y.Nombres, "%" + filter.Nombres + "%"); }
public async Task <IActionResult> Get([FromQuery] ClienteFilter filters) { var result = new HttpResult <dynamic>(this._logger); try { if (filters.FilterBehavior == FilterBehavior.GetDataItem) { var searchResult = await this._rep.GetDataItem(filters); return(result.ReturnCustomResponse(searchResult, filters)); } if (filters.FilterBehavior == FilterBehavior.GetDataCustom) { var searchResult = await this._rep.GetDataCustom(filters); return(result.ReturnCustomResponse(searchResult, filters)); } if (filters.FilterBehavior == FilterBehavior.GetDataListCustom) { var searchResult = await this._rep.GetDataListCustom(filters); return(result.ReturnCustomResponse(searchResult, filters)); } if (filters.FilterBehavior == FilterBehavior.Export) { var searchResult = await this._rep.GetDataListCustom(filters); var export = new ExportExcelCustom <dynamic>(filters); var file = export.ExportFile(this.Response, searchResult, "Cliente"); return(File(file, export.ContentTypeExcel(), export.GetFileName())); } throw new InvalidOperationException("invalid FilterBehavior"); } catch (Exception ex) { return(result.ReturnCustomException(ex, "Calemas.Erp - Cliente", filters)); } }
protected override SqlParameter[] BuildParameters(IFilter IFilter, string strCommand) { ClienteFilter cliente = (ClienteFilter)IFilter; SqlParameter[] parametros = null; switch (strCommand) { case "seleccionar_clientes": SqlParameter idCliente = new SqlParameter("@id", SqlDbType.Int); idCliente.Value = cliente.ID; idCliente.Direction = ParameterDirection.Input; SqlParameter nombre = new SqlParameter("@nombre", SqlDbType.VarChar); nombre.Value = cliente.Nombre; nombre.Direction = ParameterDirection.Input; SqlParameter apellidoPat = new SqlParameter("@apellidoPat", SqlDbType.VarChar); apellidoPat.Value = cliente.ApellidoPat; apellidoPat.Direction = ParameterDirection.Input; SqlParameter apellidoMat = new SqlParameter("@apellidoMat", SqlDbType.VarChar); apellidoMat.Value = cliente.ApellidoMat; apellidoMat.Direction = ParameterDirection.Input; SqlParameter rfc = new SqlParameter("@rfc", SqlDbType.VarChar); rfc.Value = cliente.RFC; rfc.Direction = ParameterDirection.Input; parametros = new SqlParameter[] { idCliente, nombre, apellidoPat, apellidoMat, rfc }; break; } return(parametros); }
public virtual async Task <IEnumerable <Cliente> > GetByFilters(ClienteFilter filters) { var queryBase = this._rep.GetBySimplefilters(filters); return(await this._rep.ToListAsync(queryBase)); }
public virtual async Task <Cliente> GetOne(ClienteFilter filters) { return(await this._rep.GetById(filters)); }
public static IQueryable <Cliente> WithCustomFilters(this IQueryable <Cliente> queryBase, ClienteFilter filters) { var queryFilter = queryBase; return(queryFilter); }
public IEnumerable <Cliente> List(ClienteFilter filter) { var result = connection.Query <Cliente>("Exec GetListCliente @text", filter); return(result); }
public GenericResult <IEnumerable <Cliente> > List([FromBody] ClienteFilter filter) { return(appService.List(filter)); }
public virtual Task <PaginateResult <Cliente> > GetByFiltersPaging(ClienteFilter filters) { var queryBase = this._rep.GetBySimplefilters(filters); return(this._rep.PagingAndDefineFields(filters, queryBase)); }
public ClientesDataTableSpec(ClienteFilter filter) { if (filter.IsPagingEnabled) { Query.Skip(PaginationHelper.CalculateSkip(filter)) .Take(PaginationHelper.CalculateTake(filter)); } if (!string.IsNullOrEmpty(filter.SortColumn) && !string.IsNullOrEmpty(filter.SortColumnDirection)) { if (filter.SortColumnDirection == "desc") { switch (filter.SortColumn) { case "Id": Query.OrderByDescending(p => p.Id); break; case "Nombre": Query.OrderByDescending(p => p.Nombre); break; case "Documento": Query.OrderByDescending(p => p.Documento); break; case "Telefono": Query.OrderByDescending(p => p.Telefono); break; case "Correo": Query.OrderByDescending(p => p.Correo); break; default: Query.OrderByDescending(p => p.Nombre); break; } } else { switch (filter.SortColumn) { case "Id": Query.OrderBy(p => p.Id); break; case "Nombre": Query.OrderBy(p => p.Nombre); break; case "Documento": Query.OrderBy(p => p.Documento); break; case "Telefono": Query.OrderBy(p => p.Telefono); break; case "Correo": Query.OrderBy(p => p.Correo); break; default: Query.OrderBy(p => p.Nombre); break; } } } if (!string.IsNullOrEmpty(filter.SearchValue)) { Query.Where(p => p.Nombre.Contains(filter.SearchValue) || p.Documento.Contains(filter.SearchValue) || p.Telefono.Contains(filter.SearchValue)); } }
public static IQueryable <Cliente> WithCustomFilters(this IQueryable <Cliente> queryBase, ClienteFilter filters) { var queryFilter = queryBase; if (filters.Nome.IsSent()) { queryFilter = queryFilter.Where(_ => _.Pessoa.Nome.Contains(filters.Nome)); } return(queryFilter); }
public static IQueryable <Cliente> OrderByDomain(this IQueryable <Cliente> queryBase, ClienteFilter filters) { return(queryBase.OrderBy(_ => _.ClienteId)); }
public static IQueryable <Cliente> WithBasicFilters(this IQueryable <Cliente> queryBase, ClienteFilter filters) { var queryFilter = queryBase; if (filters.ClienteId.IsSent()) { queryFilter = queryFilter.Where(_ => _.ClienteId == filters.ClienteId); } if (filters.StatusClienteId.IsSent()) { queryFilter = queryFilter.Where(_ => _.StatusClienteId == filters.StatusClienteId); } if (filters.CondominioId.IsSent()) { queryFilter = queryFilter.Where(_ => _.CondominioId != null && _.CondominioId.Value == filters.CondominioId); } if (filters.UserCreateId.IsSent()) { queryFilter = queryFilter.Where(_ => _.UserCreateId == filters.UserCreateId); } if (filters.UserCreateDateStart.IsSent()) { queryFilter = queryFilter.Where(_ => _.UserCreateDate >= filters.UserCreateDateStart); } if (filters.UserCreateDateEnd.IsSent()) { filters.UserCreateDateEnd = filters.UserCreateDateEnd.AddDays(1).AddMilliseconds(-1); queryFilter = queryFilter.Where(_ => _.UserCreateDate <= filters.UserCreateDateEnd); } if (filters.UserAlterId.IsSent()) { queryFilter = queryFilter.Where(_ => _.UserAlterId != null && _.UserAlterId.Value == filters.UserAlterId); } if (filters.UserAlterDateStart.IsSent()) { queryFilter = queryFilter.Where(_ => _.UserAlterDate != null && _.UserAlterDate.Value >= filters.UserAlterDateStart.Value); } if (filters.UserAlterDateEnd.IsSent()) { filters.UserAlterDateEnd = filters.UserAlterDateEnd.Value.AddDays(1).AddMilliseconds(-1); queryFilter = queryFilter.Where(_ => _.UserAlterDate != null && _.UserAlterDate.Value <= filters.UserAlterDateEnd); } return(queryFilter); }
public static IQueryable <Cliente> WithBasicFilters(this IQueryable <Cliente> queryBase, ClienteFilter filters) { var queryFilter = queryBase; if (filters.ClienteId.IsSent()) { queryFilter = queryFilter.Where(_ => _.ClienteId == filters.ClienteId); } if (filters.Nome.IsSent()) { queryFilter = queryFilter.Where(_ => _.Nome.Contains(filters.Nome)); } if (filters.TelefoneDeContato.IsSent()) { queryFilter = queryFilter.Where(_ => _.TelefoneDeContato.Contains(filters.TelefoneDeContato)); } if (filters.EmailDeContato.IsSent()) { queryFilter = queryFilter.Where(_ => _.EmailDeContato.Contains(filters.EmailDeContato)); } if (filters.CPFCNPJ.IsSent()) { queryFilter = queryFilter.Where(_ => _.CPFCNPJ.Contains(filters.CPFCNPJ)); } if (filters.UsuarioId.IsSent()) { queryFilter = queryFilter.Where(_ => _.UsuarioId == filters.UsuarioId); } if (filters.UserCreateId.IsSent()) { queryFilter = queryFilter.Where(_ => _.UserCreateId == filters.UserCreateId); } if (filters.UserCreateDateStart.IsSent()) { queryFilter = queryFilter.Where(_ => _.UserCreateDate >= filters.UserCreateDateStart); } if (filters.UserCreateDateEnd.IsSent()) { filters.UserCreateDateEnd = filters.UserCreateDateEnd.AddDays(1).AddMilliseconds(-1); queryFilter = queryFilter.Where(_ => _.UserCreateDate <= filters.UserCreateDateEnd); } if (filters.UserAlterId.IsSent()) { queryFilter = queryFilter.Where(_ => _.UserAlterId != null && _.UserAlterId.Value == filters.UserAlterId); } if (filters.UserAlterDateStart.IsSent()) { queryFilter = queryFilter.Where(_ => _.UserAlterDate != null && _.UserAlterDate.Value >= filters.UserAlterDateStart.Value); } if (filters.UserAlterDateEnd.IsSent()) { filters.UserAlterDateEnd = filters.UserAlterDateEnd.Value.AddDays(1).AddMilliseconds(-1); queryFilter = queryFilter.Where(_ => _.UserAlterDate != null && _.UserAlterDate.Value <= filters.UserAlterDateEnd); } return(queryFilter); }