public async Task <IActionResult> Login(string user, string password)
{
if (!string.IsNullOrEmpty(user) && !string.IsNullOrEmpty(password))
{
RolContext db = new RolContext();
var usr = db.usuarios.FirstOrDefault(e => e.nombreUsuario == user && e.contraseñaUsuario == password);
if (usr != null)
{
var claims = new List <Claim>
{
new Claim(ClaimTypes.Name, usr.nombreUsuario)
};
ClaimsIdentity userIdentity = new ClaimsIdentity(claims, "login");
ClaimsPrincipal principal = new ClaimsPrincipal(userIdentity);
await HttpContext.SignInAsync(principal);
return(RedirectToAction("Index", "Usuario"));
}
else
{
return(RedirectToAction("Index", new{ message = "Verifica tus datos" }));
}
}
else
{
return(RedirectToAction("Index", new{ message = "Llena los campos" }));
}
}
public IActionResult Index()
{
using (var r = new RolContext())
{
var rol = r.rol.ToList();
return(View(rol));
}
}
public IActionResult Edit(int?id)
{
using (var r = new RolContext())
{
var rol = r.rol.Single(n => n.idRol == id);
return(View(rol));
}
}
public IActionResult Edit(int?id)
{
using (var r = new RolContext())
{
var usuario = r.usuarios.Single(n => n.idUsuario == id);
return(View(usuario));
}
}
// [HttpPost]
public IActionResult Delete(int?id)
{
using (var r = new RolContext()){
var rol = r.rol.Single(n => n.idRol == id);
r.Remove(rol);
r.SaveChanges();
return(RedirectToAction("Index"));
}
}
public IActionResult EditSave(int rid, string rname)
{
using (var r = new RolContext()){
var rol = r.rol.Single(n => n.idRol == rid);
rol.nombreRol = rname;
r.SaveChanges();
return(RedirectToAction("Index"));
}
}
// [HttpPost]
public IActionResult Delete(int?id)
{
using (var r = new RolContext()){
var usuario = r.usuarios.Single(n => n.idUsuario == id);
r.Remove(usuario);
r.SaveChanges();
return(RedirectToAction("Index"));
}
}
public IActionResult EditSave(int userid, string username, string userpass)
{
using (var r = new RolContext()){
var usuario = r.usuarios.Single(n => n.idUsuario == userid);
usuario.nombreUsuario = username;
usuario.contraseñaUsuario = userpass;
r.SaveChanges();
return(RedirectToAction("Index"));
}
}
public IActionResult Save(int rid, string rname)
{
using (var r = new RolContext()){
Console.WriteLine(rid);
Console.WriteLine(rname);
var nuevoRol = new rol()
{
idRol = rid,
nombreRol = rname
};
var roles = r.rol.Add(nuevoRol);
r.SaveChanges();
return(RedirectToAction("Index"));
}
}
public IActionResult Index()
{
using (var r = new RolContext())
{
List <user> usuariosJ = r.usuarios.ToList();
List <rol> rolJ = r.rol.ToList();
List <aux> userandrolJ = r.aux.ToList();
var tablasJ = from c in userandrolJ
join st in rolJ on c.idRol equals st.idRol into tablas1
from st in tablas1.DefaultIfEmpty()
join ct in usuariosJ on c.idUsuario equals ct.idUsuario into table2
from ct in table2.DefaultIfEmpty()
select new UserAndRolsModel {
usuarioRolesDetails = c, rolDetails = st, usuarioDetail = ct
};
return(View(tablasJ));
}
}
public IActionResult Save(int userid, string username, string userpass, int select_rol)
{
using (var r = new RolContext()){
var nuevoUsuario = new user()
{
idUsuario = userid,
nombreUsuario = username,
contraseñaUsuario = userpass
};
var userAndRol = new aux()
{
idUsuario = userid,
idRol = select_rol
};
var usuarios = r.usuarios.Add(nuevoUsuario);
var userRol = r.aux.Add(userAndRol);
r.SaveChanges();
return(RedirectToAction("Index"));
}
}
public IActionResult Create(rol roles)
{
using (var r = new RolContext())
{
if (roles.idRol == 0)
{
ModelState.AddModelError("", "Selecciona un rol");
}
int Sel = roles.idRol;
ViewBag.SelectedValue = roles.idRol;
List <rol> rol = new List <Db.rol>();
rol = (from Roles in r.rol
select Roles).ToList();
rol.Insert(0, new rol {
idRol = 0, nombreRol = "Selecciona "
});
ViewBag.ListofRoles = rol;
return(View("Registro"));
}
}
public RolController(RolContext context)
{
_context = context;
}
