public List <User> GetAcceptedFriends(int id)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(UserQueries.GetAcceptedFriends(id), connection);
connection.Open();
try
{
List <User> friends = new List <User>();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
friends.Add(GetUser((int)reader["friend"]));
}
}
return(friends);
}
catch (SqlException e)
{
throw e;
}
}
}