Beispiel #1
0
    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;
      }
    }
Beispiel #2
0
    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;
    }