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);
}
