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