public static string addFriend(string email, int ID, string listBoxText)
{
string idNum = getID(email);
string connectionString = null;
MySqlConnection cnn;
connectionString = $"server=localhost;database=SNHUBook;uid=root;pwd={MYSQLPassword};";
cnn = new MySqlConnection(connectionString);
int newID = ID + 1;
string userEmail = MySQLFunctions.getEmail(newID.ToString());
string query = $"INSERT INTO friends (AccountID, ID, value, email) values ({idNum}, {ID}, '{listBoxText}', '{userEmail}');";
MySqlCommand cmd = new MySqlCommand(query, cnn);
MySqlDataReader dr;
cnn.Open();
dr = cmd.ExecuteReader();
string home = string.Empty;
while (dr.Read())
{
home = dr.GetString(0);
Console.WriteLine(home);
}
dr.Close();
cnn.Close();
return(home);
}
