public string VerificaEmail(string email, int userid) { string response = string.Empty; using (var context = new ExamenOneCoreBDContext(_dbConnection)) { try { UsuarioModel usuarioModel = context.Usuario.Where(select => select.Email.Equals(email) && select.UserId != userid).FirstOrDefault(); if (usuarioModel != null) { response = !string.IsNullOrWhiteSpace(usuarioModel.Email) ? "El correo electrónico ya existe" : "Correo electrónico disponible"; } else { response = "Correo electrónico disponible"; } } catch (Exception ex) { response = string.Format("Error: ", ex.Message); } } return(response); }
public string Create(UsuarioModel usuarioModel) { string response = string.Empty; using (var context = new ExamenOneCoreBDContext(_dbConnection)) { try { context.Database.ExecuteSqlCommand("spCreateUsuario @p0, @p1, @p2, @p3, @p4", parameters: new[] { usuarioModel.Username.ToString(), Security.Encrypt(usuarioModel.Password.ToString()), usuarioModel.Email.ToString(), usuarioModel.Sexo.ToString(), usuarioModel.Estatus.ToString() }); response = string.Format("Usuario Creado"); } catch (Exception ex) { response = string.Format("Error: ", ex.Message); } } return(response); }
public string Login(LoginModel loginModel) { string response = string.Empty; using (var context = new ExamenOneCoreBDContext(_dbConnection)) { try { UsuarioModel usuarioModel = context.Usuario.Where(select => select.Username.Equals(loginModel.Username) && select.Password.Equals(Security.Encrypt(loginModel.Password.ToString()))).FirstOrDefault(); if (usuarioModel != null) { if (usuarioModel.UserId > byte.MinValue) { response = string.Format("OK"); } else { response = string.Format("FAIL"); } } else { response = string.Format("FAIL"); } } catch (Exception ex) { response = string.Format("FAIL"); } } return(response); }
public List <UsuarioModel> GetUsuariosActivos() { List <UsuarioModel> usersList = new List <UsuarioModel>(); using (var context = new ExamenOneCoreBDContext(_dbConnection)) { usersList = context.Usuario.ToList(); } return(usersList); }
public UsuarioModel GetUsuario(int userId) { UsuarioModel response = new UsuarioModel(); using (var context = new ExamenOneCoreBDContext(_dbConnection)) { try { response = context.Usuario.Where(select => select.UserId == userId).FirstOrDefault(); } catch (Exception) { response = new UsuarioModel(); } } return(response); }
public string Delete(int userId) { string response = string.Empty; using (var context = new ExamenOneCoreBDContext(_dbConnection)) { try { UsuarioModel usuarioModel = context.Usuario.Where(select => select.UserId == userId).FirstOrDefault(); usuarioModel.Estatus = false; usuarioModel.FechaActualizacion = DateTime.Now; context.Update <UsuarioModel>(usuarioModel); context.SaveChanges(); response = string.Format("Usuario Eliminado"); } catch (Exception ex) { response = string.Format("Error: ", ex.Message); } } return(response); }
public string UpdatePassword(ChangePasswordModel changePasswordModel) { string response = string.Empty; using (var context = new ExamenOneCoreBDContext(_dbConnection)) { try { context.Database.ExecuteSqlCommand("spUpdatePassword @p0, @p1", parameters: new[] { changePasswordModel.UserId.ToString(), Security.Encrypt(changePasswordModel.Password.ToString()) }); response = string.Format("Contraseña Actualizada"); } catch (Exception ex) { response = string.Format("Error: ", ex.Message); } } return(response); }