public IHttpActionResult GetUsersByCredentials(String pass, String nickOrEmail) { using (Models.NJFOODEntities db = new Models.NJFOODEntities()) { Models.USERS _user = new Models.USERS(); try { _user = db.USERS.FirstOrDefault(u => u.U_Pass == pass && (u.U_Email == nickOrEmail || u.U_Nick == nickOrEmail)); if (_user == null) { return(NotFound()); } if (_user.U_Status != "A") { return(BadRequest("Usuario Inactivo, Comuníquese con el administrador")); } return(Ok(_user)); } catch (Exception) { return(BadRequest("Ha ocurrido un error en la autenticación del usuario")); } } }
public IHttpActionResult UpdateUser(Models.ModelRequest.Users user) { using (Models.NJFOODEntities db = new Models.NJFOODEntities()) { try { Models.USERS _user = new Models.USERS(); _user = db.USERS.FirstOrDefault(u => u.U_Nick == user.U_Nick && u.U_Email != user.U_Email); if (_user != null) { return(BadRequest("Ya existe un usuario con este Alias")); } _user = db.USERS.FirstOrDefault(u => u.U_Id == user.U_Id); _user.U_Name = user.U_Name; _user.U_Apellidos = user.U_Apellidos; _user.U_Nick = user.U_Nick; _user.U_Email = user.U_Email; _user.U_Pass = user.U_Pass; _user.U_Gender = user.U_Gender; db.Entry(_user).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } catch (Exception) { return(BadRequest("Ha ocurrido un error al actualizar el usuario")); } } return(Ok("Usuario actualizado Satisfactoriamente")); }
public IHttpActionResult ChangeTheStatusOfTheUser(int id) { using (Models.NJFOODEntities db = new Models.NJFOODEntities()) { try { Models.USERS _user = new Models.USERS(); _user = db.USERS.FirstOrDefault(u => u.U_Id == id); if (_user == null) { return(NotFound()); } _user.U_Status = (_user.U_Status == "A") ? "I" : "A"; db.Entry(_user).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } catch (Exception) { return(BadRequest("Ha ocurrido un error al cambiar de estado")); } } return(Ok("OK")); }
public ActionResult Login(Models.USERS userModel) { Entities db = new Entities(); var userDetails = db.USERS.FirstOrDefault(dbUser => dbUser.EMAIL == userModel.EMAIL && dbUser.PASSWORDS == userModel.PASSWORDS); if (userDetails == null) { ModelState.AddModelError("", "Ha ocurrido un error ingresando al sistema, trate nuevamente."); return(View(userModel)); } else { Session["userEmail"] = userDetails.EMAIL; return(RedirectToAction("Index", "Home")); } /* * if (!ModelState.IsValid) * { * return View(model); * } * * // This doesn't count login failures towards account lockout * // To enable password failures to trigger account lockout, change to shouldLockout: true * var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout: false); * switch (result) * { * case SignInStatus.Success: * return RedirectToLocal(returnUrl); * case SignInStatus.LockedOut: * return View("Lockout"); * case SignInStatus.RequiresVerification: * return RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe }); * case SignInStatus.Failure: * default: * ModelState.AddModelError("", "Invalid login attempt."); * return View(model); * } */ }
public IHttpActionResult GetUsersById(int id) { using (Models.NJFOODEntities db = new Models.NJFOODEntities()) { try { Models.USERS _user = new Models.USERS(); _user = db.USERS.FirstOrDefault(u => u.U_Id == id); if (_user == null) { return(NotFound()); } return(Ok(_user)); } catch (Exception) { return(BadRequest("Ha ocurrido un error al buscar el usuario")); } } }
public IHttpActionResult AddUser(Models.ModelRequest.Users user) { using (Models.NJFOODEntities db = new Models.NJFOODEntities()) { try { if (user.U_Name != null) { Models.USERS _User = new Models.USERS { U_Id = 0, U_Name = user.U_Name, U_Apellidos = user.U_Apellidos, U_Nick = user.U_Nick, U_Email = user.U_Email, U_Pass = user.U_Pass, U_Gender = user.U_Gender }; _User.U_Status = "A"; db.USERS.Add(_User); db.SaveChanges(); } else { return(BadRequest("Debe completar los datos para finalizar el registro")); } } catch (Exception) { return(BadRequest("No se puedo insertar el registro")); } } return(Ok("OK")); }