public void getAllContacts(ref DGVCustom dgv)
{
dgv.DataSource = (from t
in this.lst_contactos
select new
{
Id = t.id,
Nombre = t.getNombre() + t.getApellido(),
Municipio = t.getMpo(),
Estado = t.getEstado(),
Pais = t.getPais(),
Calle = t.getCalle(),
Numero = t.getNumero(),
CP = t.getCp(),
Telefono = t.getTelefono()
}).ToList();
}
public dgvtoxml_dataset(DGVCustom dgv, string name)
{
this.dgv = dgv;
this.path = genericDefinitions.XMLSCHEMASPATH + "\\XMLSchema_" + name + "_" + this.dgv.Name + ".xml";
}
public void getWhereContacts(ref DGVCustom dgv, string[] filters)
{
bool flag = false;
if (filters == null)
{
return;
}
//Se obtiene bloque origen
var query = (from t
in this.lst_contactos
select new
{
Id = t.id.ToString(),
Nombre = t.getNombre() + t.getApellido(),
Municipio = t.getMpo(),
Estado = t.getEstado(),
Pais = t.getPais(),
Calle = t.getCalle(),
Numero = t.getNumero(),
CP = t.getCp().ToString(),
Telefono = t.getTelefono()
}).ToList();
//Se arma Query dinamico
for (var rIndex = 0; rIndex < filters.Length; ++rIndex)
{
if (!(filters[rIndex] != string.Empty))
{
continue;
}
if (!flag)
{
flag = !flag;
}
switch (rIndex)
{
case (0):
{
query = query.Where(x => x.Nombre.ToUpper().Contains(filters[rIndex].ToUpper())).ToList();
break;
}
case (1):
{
query = query.Where(x => x.Pais.ToUpper().Contains(filters[rIndex].ToUpper())).ToList();
break;
}
case (2):
{
query = query.Where(x => x.Estado.ToUpper().Contains(filters[rIndex].ToUpper())).ToList();
break;
}
case (3):
{
query = query.Where(x => x.Municipio.ToUpper().Contains(filters[rIndex].ToUpper())).ToList();
break;
}
case (4):
{
query = query.Where(x => x.Telefono.ToUpper().Contains(filters[rIndex].ToUpper())).ToList();
break;
}
case (5):
{
query = query.Where(x => x.CP.ToUpper().Contains(filters[rIndex].ToUpper())).ToList();
break;
}
}
}
if (flag)
{
dgv.DataSource = query;
}
else
{
dgv.DataSource = query.Where(x => x.Id == "-33").ToList();
}
}
