public List <ClassLibrary1.cliente> GetClientes() { using (ClassLibrary1.PeruVirtualEntities db = new ClassLibrary1.PeruVirtualEntities()) { return(db.cliente.ToList()); } }
public List <ClassLibrary1.usuario> GetUsuarios() { using (ClassLibrary1.PeruVirtualEntities db = new ClassLibrary1.PeruVirtualEntities()) { return(db.usuario.ToList()); } }
public ClassLibrary1.cliente getClient(int id) { using (ClassLibrary1.PeruVirtualEntities db = new ClassLibrary1.PeruVirtualEntities()) { var query = db.cliente.Where(c => c.idCliente == id); if (query.Any()) { return(query.Single()); } } return(null); }
public void CreateUser(int idcliente, string nombreUsuario, string contrasenia) { using (ClassLibrary1.PeruVirtualEntities db = new ClassLibrary1.PeruVirtualEntities()) { ClassLibrary1.usuario user = new ClassLibrary1.usuario { idCliente = idcliente, nomUsuario = nombreUsuario, contrasenia = contrasenia }; db.usuario.Add(user); db.SaveChanges(); } }
public bool IsEmailTaken(string email) { using (ClassLibrary1.PeruVirtualEntities db = new ClassLibrary1.PeruVirtualEntities()) { var query = (from c in db.cliente where c.correo == email select new { c.correo }); if (query.Any()) { return(true); } } return(false); }
public bool IsUsernameTaken(string username) { using (ClassLibrary1.PeruVirtualEntities db = new ClassLibrary1.PeruVirtualEntities()) { var query = (from u in db.usuario where u.nomUsuario == username select new { u.nomUsuario }); if (query.Any()) { return(true); } } return(false); }
public int AccesClient(string nombreUsuario, string contrasenia) { using (ClassLibrary1.PeruVirtualEntities db = new ClassLibrary1.PeruVirtualEntities()) { var query = (from u in db.usuario where u.nomUsuario == nombreUsuario && u.contrasenia == contrasenia select new { u.idCliente, u.idUsuario }); if (query.Any()) { return(query.Single().idCliente); } } return(0); }
public void CreateClient(string email, string contrasenia, string nombreUsuario, string nombre) { using (ClassLibrary1.PeruVirtualEntities db = new ClassLibrary1.PeruVirtualEntities()) { ClassLibrary1.cliente client = new ClassLibrary1.cliente { correo = email, nombre = nombre }; db.cliente.Add(client); db.SaveChanges(); var query = (from c in db.cliente where c.correo == email select new { c.idCliente }); if (query.Any()) { this.usuarioService.CreateUser(query.Single().idCliente, nombreUsuario, contrasenia); } } }