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