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