public ActionResult Login(string user, string pass)
{
try
{
using (Models.ArandaDBEntities db = new Models.ArandaDBEntities())
{
var GetUser = (from usr in db.a_user
where usr.usr_name == user.Trim() &&
usr.usr_password == pass.Trim()
select usr).FirstOrDefault();
if (GetUser == null)
{
ViewBag.Error = "Credenciales Incorrectas";
return(View());
}
Session["User"] = GetUser;
}
return(RedirectToAction("Index", "Home"));
}
catch (Exception ex)
{
ViewBag.Error = ex.Message;
return(View());
}
}
public ActionResult GuardarNuevo(a_user usuario)
{
using (Models.ArandaDBEntities db = new Models.ArandaDBEntities())
{
if (usuario != null)
{
db.a_user.Add(usuario);
db.SaveChanges();
return(RedirectToAction("../Users/Users"));
}
return(View());
}
}
// GET: Users
public ActionResult Users()
{
var User = (a_user)Session["User"];
if (User != null)
{
TempData["rol"] = User.role_fk;
}
using (Models.ArandaDBEntities db = new Models.ArandaDBEntities())
{
var GetUsers = (from usr in db.a_user
select usr);
return(View(GetUsers.ToList()));
}
}
// GET: CrearUsuario
public ActionResult Crear()
{
var User = (a_user)Session["User"];
if (User != null)
{
TempData["rol"] = User.role_fk;
}
using (Models.ArandaDBEntities db = new Models.ArandaDBEntities())
{
var GetRoles = (from rol in db.a_role
select rol);
ViewBag.listaRoles = GetRoles.ToList();
return(View());
}
}
public ActionResult Editar(a_user usuario)
{
using (Models.ArandaDBEntities db = new Models.ArandaDBEntities())
{
int id = (int)TempData["UserID"];
var GetUser = db.a_user.Where(x => x.id == id).FirstOrDefault();
if (GetUser != null)
{
GetUser.fname = usuario.fname;
GetUser.lname = usuario.lname;
GetUser.usr_name = usuario.usr_name;
GetUser.usr_password = usuario.usr_password;
GetUser.address = usuario.address;
GetUser.phone = usuario.phone;
GetUser.email = usuario.email;
db.Entry(GetUser).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("../Users/Users"));
}
}
// GET: EditarUsuario
public ActionResult Editar(int?id)
{
var User = (a_user)Session["User"];
if (User != null)
{
TempData["rol"] = User.role_fk;
}
using (Models.ArandaDBEntities db = new Models.ArandaDBEntities())
{
var GetUser = db.a_user.Where(x => x.id == id).FirstOrDefault();
if (GetUser != null)
{
TempData["UserID"] = id;
TempData.Keep();
return(View(GetUser));
}
return(View());
}
}
// GET: EliminarUsuario
public ActionResult Eliminar(int?id)
{
var User = (a_user)Session["User"];
if (User != null)
{
TempData["rol"] = User.role_fk;
}
using (Models.ArandaDBEntities db = new Models.ArandaDBEntities())
{
if (id > 0)
{
var usuarioId = db.a_user.Where(x => x.id == id).FirstOrDefault();
if (usuarioId != null)
{
db.Entry(usuarioId).State = EntityState.Deleted;
db.SaveChanges();
}
}
}
return(RedirectToAction("../Users/Users"));
}
