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