/// <summary> /// Retorna uma lista contendo todos os usuários cadastrados /// </summary> public static List <User> GetAllUsers(string connectionString) { List <User> users = new List <User>(); User temp; using (var conn = new MySqlConnection(connectionString)) { using (var cmd = conn.CreateCommand()) { try { conn.Open(); cmd.CommandText = "SELECT * FROM users"; using (MySqlDataReader dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { temp = Maper.MapUser(dataReader); temp.Password = null; users.Add(temp); } } return(users); } catch (Exception e) { throw e; } } } }
/// <summary> /// Busca na base as informações do usuario para login /// </summary> public static User LoginRequest(string connectionString, string username) { User user = null; using (var conn = new MySqlConnection(connectionString)) { using (var cmd = conn.CreateCommand()) { try { conn.Open(); cmd.CommandText = "SELECT * FROM users WHERE username = '******' AND active = True"; using (MySqlDataReader dataReader = cmd.ExecuteReader()) { dataReader.Read(); user = Maper.MapUser(dataReader); } return(user); } catch (MySqlException e) { throw e; } } } }
/// <summary> /// Retorna um usuário que corresponde ao id informado /// </summary> public static User GetUserById(string connectionString, int userId) { User user = null; using (var conn = new MySqlConnection(connectionString)) { using (var cmd = conn.CreateCommand()) { try { conn.Open(); cmd.CommandText = "SELECT * FROM users WHERE user_id = " + userId; using (MySqlDataReader dataReader = cmd.ExecuteReader()) { dataReader.Read(); user = Maper.MapUser(dataReader); } return(user); } catch (MySqlException e) { throw e; } } } }