private void UpdateDataGridCliente()
{
int idperson;
int idDireccion;
int idUser;
var cliente = client.GetCliente();
var user = client.GetUsers();
var direccion = client.GetDirecciones();
var persone = client.GetPersonas();
var zona = client.GetZonas();
List <Clian> clis = new List <Clian>();
foreach (var c in cliente)
{
idperson = (from p in persone
where p.idPersona == c.idPersona
select p.idPersona).ElementAt(0);
int personiddicreccion = (from p in persone
where p.idPersona == c.idPersona
select p.idDireccion).ElementAt(0);
idDireccion = (from d in direccion where d.idDireccion == personiddicreccion select d.idDireccion).ElementAt(0);
int idzona = (from d in direccion where d.idDireccion == idDireccion select d.idZona).ElementAt(0);
idUser = (from u in user where u.IdUser == c.IdUser select u.IdUser).ElementAt(0);
Clian cli = new Clian
{
IdCliente = c.idCliente,
PuntoFidelizacion = (int)c.puntoFidelizacion,
PrimerNombre = (from p in persone where p.idPersona == idperson select p.primerNombre).ElementAt(0),
SegundoNombre = (from p in persone where p.idPersona == idperson select p.segundoNombre).ElementAt(0),
PrimerApellido = (from p in persone where p.idPersona == idperson select p.primerApellido).ElementAt(0),
SegundoApellido = (from p in persone where p.idPersona == idperson select p.segundoApellido).ElementAt(0),
Email = (from p in persone where p.idPersona == idperson select p.email).ElementAt(0),
Nacionalidad = (from p in persone where p.idPersona == idperson select p.nacionalidad).ElementAt(0),
FechaNacimiento = (from p in persone where p.idPersona == idperson select p.fechaNacimiento).ElementAt(0),
Document = (from p in persone where p.idPersona == idperson select p.Documento).ElementAt(0),
Telefono = (from p in persone where p.idPersona == idperson select p.telefono).ElementAt(0),
Usuario = (from u in user where u.IdUser == c.IdUser select u.idUserName).ElementAt(0),
Zona = (from z in zona where z.idZona == idzona select z.nombre).ElementAt(0),
Apt = (from d in direccion where d.idDireccion == idDireccion select d.Apt).ElementAt(0),
Casa = (from d in direccion where d.idDireccion == idDireccion select d.casa).ElementAt(0),
Calle = (from d in direccion where d.idDireccion == idDireccion select d.calle).ElementAt(0)
};
clis.Add(cli);
}
dataGridView1.DataSource = clis;
}
