public User GetUser(int userId) { const string query = "SELECT * FROM Users WHERE UserId=@userId"; try { using (var command = new MySqlCommand(query, _mySqlDatabaseConnection.MySqlConnection)) { command.Parameters.AddWithValue("@userId", userId); using (var reader = command.ExecuteReader()) { reader.Read(); var user = new User { FirstName = reader["FirstName"].ToString(), LastName = reader["LastName"].ToString(), UserId = (int) reader["UserId"] }; return user; } } } catch (Exception) { return null; } }
public List<User> GetAllUsers() { const string query = "SELECT * FROM Users"; var users = new List<User>(); try { using (var command = new MySqlCommand(query, _mySqlDatabaseConnection.MySqlConnection)) { using (var reader = command.ExecuteReader()) { while (reader.Read()) { var user = new User(); user.FirstName = reader["FirstName"].ToString(); user.LastName = reader["LastName"].ToString(); user.UserId = (int) reader["UserId"]; users.Add(user); } } } } catch (Exception) { return null; } return users; }