private void CargarCriteria(ClienteCriteria criteria) { criteria.RazonSocial = this.txtRazonSocial.Text.Trim(); criteria.CUIT = this.txtCuit.Text.Trim() != string.Empty ? long.Parse(this.txtCuit.Text.Trim()) : default(long?); criteria.NombreContacto = this.txtNombreContacto.Text.Trim(); criteria.ApellidoContacto = this.txtApellidoContacto.Text.Trim(); }
public List <ClienteDto> ObtenerClientes(ClienteCriteria criteria) { using (var ctx = new FacturaElectronicaEntities()) { IQueryable <Cliente> query = ctx.Clientes; if (!string.IsNullOrEmpty(criteria.RazonSocial)) { query = query.Where(c => c.RazonSocial.ToUpper().Contains(criteria.RazonSocial.ToUpper())); } if (criteria.CUIT.HasValue) { query = query.Where(c => c.CUIT == criteria.CUIT); } if (!string.IsNullOrEmpty(criteria.NombreContacto)) { query = query.Where(c => c.NombreContacto.ToUpper().Contains(criteria.NombreContacto.ToUpper())); } if (!string.IsNullOrEmpty(criteria.ApellidoContacto)) { query = query.Where(c => c.ApellidoContacto.ToUpper().Contains(criteria.ApellidoContacto.ToUpper())); } return(ToClienteDtoList(query.ToList())); } }
private void Buscar() { IClienteService service = ServiceFactory.GetClienteService(); ClienteCriteria criteria = new ClienteCriteria(); criteria.RazonSocial = this.txtBuscarRazSoc.Text; this.Grid.DataSource = service.ObtenerClientes(criteria); this.Grid.DataBind(); }
private void Buscar() { // cargo los filtros ClienteCriteria criteria = new ClienteCriteria(); CargarCriteria(criteria); List <ClienteDto> list = ServiceFactory.GetClienteService().ObtenerClientes(criteria); this.lblCantReg.Text = string.Format(" ({0})", list.Count); this.Grid.DataSource = list; this.Grid.DataBind(); }