internal void GetInvitaions(Friends s, string username)
{
if (string.IsNullOrWhiteSpace(username))
{
throw new ArgumentNullException(nameof(username));
}
string query = $"Select * from Friends where FriendsUsername = '******' and Accepted = 'N'";
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.OpenAsync();
//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader dataReader = cmd.ExecuteReader();
//Read the data and store them in the list
while (dataReader.Read())
{
Console.WriteLine("Username: "******"UserName"].ToString().ToLowerInvariant() + " has invited you.");
Console.Write("Do you want to accept him (Y/N): ");
string answer = Console.ReadLine().ToUpperInvariant();
if (answer == "Y")
{
AcceptFriendInvitation(username, dataReader["UserName"].ToString().ToLowerInvariant());
s.AddacceptedFriend(dataReader["UserName"].ToString().ToLowerInvariant());
}
else if (answer == "N")
{
RemoveInvitation(dataReader["UserName"].ToString().ToLowerInvariant(), username);
}
else
{
Console.WriteLine("Not answered!");
}
}
dataReader.Close();
connection.CloseAsync();
}
}