public bool Create()
{
try
{
Data.CLIENTE client = new Data.CLIENTE();
client.RUT = Rut;
client.DV = Dv;
client.P_NOMBRE = FirstName;
client.S_NOMBRE = SecondName;
client.P_APELLIDO = FirstLastName;
client.S_APELLIDO = SecondLastName;
client.FECHA_NAC = BirthDate;
client.SEXO = Gender;
client.DIRECCION = Address;
client.TELEFONO = Phone;
client.EMAIL = Email;
client.ID_COMUNA = IdCommune;
client.ID_USUARIO = User.Id;
client.VULNERABLE = 0;
Connection.LindaSonrisaDB.CLIENTE.Add(client);
Connection.LindaSonrisaDB.SaveChanges();
return(true);
}
catch (Exception e)
{
string val = e.Message;
return(false);
}
}
public bool Read()
{
try
{
Data.USUARIO usr = Connection.LindaSonrisaDB.USUARIO.First(re => re.NOMBRE == User.Username);
Data.CLIENTE client = Connection.LindaSonrisaDB.CLIENTE.First(re => re.ID_USUARIO == usr.ID);
User user = new User()
{
Id = (int)client.ID_USUARIO
};
user.Read();
Rut = (int)client.RUT;
Dv = client.DV;
FirstName = client.P_NOMBRE;
SecondName = client.S_NOMBRE;
FirstLastName = client.P_APELLIDO;
SecondLastName = client.S_APELLIDO;
BirthDate = client.FECHA_NAC;
Gender = client.SEXO;
Address = client.DIRECCION;
Phone = (int)client.TELEFONO;
Email = client.EMAIL;
IdCommune = (int)client.ID_COMUNA;
User = user;
Vulnerable = (int)client.VULNERABLE;
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool RutAlreadyExist()
{
try
{
Data.CLIENTE client = Connection.LindaSonrisaDB.CLIENTE.First(re => re.RUT == Rut);
return(true);
}
catch
{
return(false);
}
}
public bool MailAlreadyExist()
{
try
{
Data.CLIENTE client = Connection.LindaSonrisaDB.CLIENTE.First(re => re.EMAIL == Email);
return(true);
}
catch
{
return(false);
}
}
public string mostYoungerClient()
{
try
{
Data.CLIENTE client = Connection.LindaSonrisaDB.CLIENTE.OrderByDescending(cv => cv.FECHA_NAC).First();
string mostYoungerClientName = client.P_NOMBRE + " " + client.P_APELLIDO + " con " + calculatedYears(client.FECHA_NAC) + " años.";
return(mostYoungerClientName);
}
catch (Exception e)
{
return(null);
}
}
