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