public ActionResult Details(string id) { if (Session["UserId"] != null && Session["Role"].ToString() == "0") { using (nominaDBEntities db = new nominaDBEntities()) { var user = db.User.FirstOrDefault(u => u.Id == id); if (user != null) { UserModel uModel = new UserModel { Email = user.Email, Nombre = String.Format("{0} {1} {2}", user.Nombre, user.ApellidoP, user.ApellidoM), Role = ((userRoles)user.Role).ToString(), IngresoBase = (int)user.IngresoBase, DedDesayuno = (int)user.DedDesayuno, DedAhorro = (int)user.DedAhorro, Status = ((userStatus)user.Status).ToString() }; return(View(uModel)); } return(RedirectToAction("UserAdminModule", "User")); } } return(View("Login")); }
public ActionResult Delete(string id, FormCollection collection) { try { if (Session["UserId"] != null && Session["Role"].ToString() == "0") { using (nominaDBEntities db = new nominaDBEntities()) { var dUser = db.User.FirstOrDefault(u => u.Id == id); if (dUser != null) { db.Entry(dUser).State = EntityState.Deleted; db.SaveChanges(); ModelState.Clear(); return(RedirectToAction("UserAdminModule", "User")); } return(HttpNotFound()); } } return(View("Login")); } catch (Exception ex) { return(View()); } }
public ActionResult ConsultarUser(string IdNom, string IdUser) { if (Session["UserId"] != null) { using (nominaDBEntities db = new nominaDBEntities()) { //Search all nom in selected month by id var nom = db.NomUser.Where(n => n.IdNom == IdNom && n.IdUser == IdUser).FirstOrDefault(); if (nom != null) { var user = db.User.Where(u => u.Id == nom.IdUser).FirstOrDefault(); var tPer = user.IngresoBase + nom.DedPrestamo; var tDed = nom.DedGas + user.DedAhorro + user.DedDesayuno; NomUserDetailsModel nModel = new NomUserDetailsModel { IdNom = nom.IdNom, IdUser = nom.IdUser, Nombre = String.Format("{0} {1} {2}", user.Nombre, user.ApellidoP, user.ApellidoM), DedGas = nom.DedGas, DedPrestamo = nom.DedPrestamo, IngresoBase = user.IngresoBase, DedAhorro = user.DedAhorro, DedDesayuno = user.DedDesayuno, TotalDeduc = tDed, TotalPercep = tPer, Depositado = tPer - tDed }; return(View(nModel)); } } } return(View("LogIn")); }
public ActionResult LogIn(UserLogInModel user) { if (ModelState.IsValid) { using (nominaDBEntities db = new nominaDBEntities()) { Encrypt pass = new Encrypt(); var encPass = pass.ComputeSha256Hash(user.Password); var db_user = db.User.FirstOrDefault(u => u.Password == encPass && u.Email == user.Email); if (db_user != null) { Session["UserID"] = db_user.Id.ToString(); Session["Role"] = db_user.Role.ToString(); //check if user is admin or final //0 for admin, 1 for final user if (db_user.Role == 0) { return(RedirectToAction("UserAdminModule")); } else { return(RedirectToAction("UserFinalModule", "Nomina", new { id = db_user.Id })); } } else { ModelState.AddModelError("Password", Resources.Strings.LogInError); } } } return(View()); }
public ActionResult UserFinalModule(string id) { if (Session["UserId"] != null) { using (nominaDBEntities db = new nominaDBEntities()) { var user = db.User.Where(u => u.Id == id).FirstOrDefault(); ViewBag.Nombre = String.Format("{0} {1} {2}", user.Nombre, user.ApellidoP, user.ApellidoM); var nomina = (from n in db.Nomina join nu in db.NomUser on n.Id equals nu.IdNom where nu.IdUser == id select new { n.Mes, n.Id }).ToList(); List <NominaModel> nModel = new List <NominaModel>(); foreach (var nom in nomina) { nModel.Add(new NominaModel { Mes = nom.Mes, Id = nom.Id }); } return(View(nModel)); } } return(View("LogIn")); }
public ActionResult Create(UserModel user) { try { if (Session["UserId"] != null && Session["Role"].ToString() == "0") { if (ModelState.IsValid) { //Encrypt password Encrypt pass = new Encrypt(); var encPass = pass.ComputeSha256Hash(user.Password); //Get role id var rId = (int)Enum.Parse(typeof(userRoles), user.Role); //Get status id var sId = (int)Enum.Parse(typeof(userStatus), user.Status); //Generate user id string uId = Guid.NewGuid().ToString(); // TODO: Add insert logic here using (nominaDBEntities db = new nominaDBEntities()) { db.User.Add(new User { Id = uId, Nombre = user.Nombre, ApellidoM = user.ApellidoM, ApellidoP = user.ApellidoP, Email = user.Email, Role = rId, Status = sId, Password = encPass, IngresoBase = (int)user.IngresoBase, DedDesayuno = (int)user.DedDesayuno, DedAhorro = (int)user.DedAhorro }); db.SaveChanges(); } ModelState.Clear(); return(RedirectToAction("Details", "User", new { id = uId })); } ViewBag.DropDownRole = new SelectList(Enum.GetValues(typeof(userRoles))); ViewBag.DropDownStatus = new SelectList(Enum.GetValues(typeof(userStatus))); return(View()); } return(View("Login")); } catch (Exception ex) { ModelState.AddModelError("Password", String.Format(Resources.Strings.CreateUserError, ex.InnerException.InnerException.Message)); ViewBag.DropDownRole = new SelectList(Enum.GetValues(typeof(userRoles))); ViewBag.DropDownStatus = new SelectList(Enum.GetValues(typeof(userStatus))); return(View()); } }
public ActionResult Edit(UserModel user) { try { if (Session["UserId"] != null && Session["Role"].ToString() == "0") { ModelState.Remove("Password"); if (ModelState.IsValid) { var modifiedUsername = Session["UserId"]; using (nominaDBEntities db = new nominaDBEntities()) { //Add created by user var cUser = db.User.FirstOrDefault(u => u.Id == user.Id); if (user.Password != null) { //Encrypt new password Encrypt ePass = new Encrypt(); cUser.Password = ePass.ComputeSha256Hash(user.Password); } //Get role and status id var rId = (int)Enum.Parse(typeof(userRoles), user.Role); var sId = (int)Enum.Parse(typeof(userStatus), user.Status); cUser.Role = rId; cUser.Email = user.Email; cUser.Nombre = user.Nombre; cUser.ApellidoM = user.ApellidoM; cUser.ApellidoP = user.ApellidoP; cUser.IngresoBase = Decimal.Parse(user.IngresoBase.ToString(), System.Globalization.NumberStyles.Currency); cUser.DedAhorro = Decimal.Parse(user.DedAhorro.ToString(), System.Globalization.NumberStyles.Currency); cUser.DedDesayuno = Decimal.Parse(user.DedDesayuno.ToString(), System.Globalization.NumberStyles.Currency); db.Entry(cUser).State = EntityState.Modified; db.SaveChanges(); } ModelState.Clear(); return(RedirectToAction("Details", "User", new { id = user.Id })); } ViewBag.DropDownRole = new SelectList(Enum.GetValues(typeof(userRoles))); ViewBag.DropDownStatus = new SelectList(Enum.GetValues(typeof(userStatus))); return(View()); } return(View("Login")); } catch (Exception ex) { ModelState.AddModelError("Password", String.Format(Resources.Strings.CreateUserError, ex.InnerException.InnerException.Message)); ViewBag.DropDownRole = new SelectList(Enum.GetValues(typeof(userRoles))); ViewBag.DropDownStatus = new SelectList(Enum.GetValues(typeof(userStatus))); return(View()); } }
public ActionResult UserAdminModule() { if (Session["UserId"] != null && Session["Role"].ToString() == "0") { using (nominaDBEntities db = new nominaDBEntities()) { var users = db.User.ToList(); List <UserModel> uModel = new List <UserModel>(); foreach (var user in users) { uModel.Add(new UserModel { Nombre = String.Format("{0} {1} {2}", user.Nombre, user.ApellidoP, user.ApellidoM), Id = user.Id }); } return(View(uModel)); } } return(View("LogIn")); }
// GET: Nomina public ActionResult List() { if (Session["UserId"] != null) { using (nominaDBEntities db = new nominaDBEntities()) { var nom = db.Nomina.ToList(); List <NominaModel> nModel = new List <NominaModel>(); foreach (var n in nom) { nModel.Add(new NominaModel { Mes = n.Mes, Id = n.Id }); } return(View(nModel)); } } return(View("LogIn")); }
public ActionResult Delete(string id) { if (Session["UserId"] != null && Session["Role"].ToString() == "0") { using (nominaDBEntities db = new nominaDBEntities()) { var user = db.User.Where(u => u.Id == id).FirstOrDefault(); if (user != null) { ViewBag.DeleteMessage = Resources.Strings.DeleteMessage; return(View(new UserModel { Email = user.Email, Nombre = String.Format("{0} {1} {2}", user.Nombre, user.ApellidoP, user.ApellidoM), Role = ((userRoles)user.Role).ToString(), Status = ((userStatus)user.Status).ToString() })); } return(HttpNotFound()); } } return(View("Login")); }
public ActionResult Edit(string id) { if (Session["UserId"] != null && Session["Role"].ToString() == "0") { //Add types ViewBag.DropDownRole = new SelectList(Enum.GetValues(typeof(userRoles))); ViewBag.DropDownStatus = new SelectList(Enum.GetValues(typeof(userStatus))); using (nominaDBEntities db = new nominaDBEntities()) { var user = db.User.Where(u => u.Id == id).FirstOrDefault(); if (user != null) { //Get role id var rId = ((userRoles)user.Role).ToString(); //Get status id var sId = ((userStatus)user.Status).ToString(); return(View(new UserModel { Nombre = user.Nombre, ApellidoP = user.ApellidoP, ApellidoM = user.ApellidoM, Email = user.Email, Role = rId, Status = sId, IngresoBase = (int)user.IngresoBase, DedDesayuno = (int)user.DedDesayuno, DedAhorro = (int)user.DedAhorro, Password = "", Id = user.Id })); } return(HttpNotFound()); } } return(View("Login")); }
public ActionResult NomUserList(string id) { if (Session["UserId"] != null) { using (nominaDBEntities db = new nominaDBEntities()) { var userid = Session["UserId"].ToString(); //Check user role var user = db.User.Where(u => u.Id == userid).FirstOrDefault(); if (user.Role == 1) { //For non admin users return(RedirectToAction("ConsultarUser", "Nomina", new { IdNom = id, IdUser = Session["UserId"].ToString() })); } //Search all nom in selected month by id var nom = db.NomUser.Where(n => n.IdNom == id).ToList(); var nomId = db.Nomina.Where(n => n.Id == id).FirstOrDefault(); ViewBag.Fecha = nomId.Mes; List <NomUserViewModel> nModel = new List <NomUserViewModel>(); foreach (var n in nom) { user = db.User.Where(u => u.Id == n.IdUser).FirstOrDefault(); nModel.Add(new NomUserViewModel { IdNom = n.IdNom, IdUser = n.IdUser, Nombre = String.Format("{0} {1} {2}", user.Nombre, user.ApellidoP, user.ApellidoM), }); } return(View(nModel)); } } return(View("LogIn")); }