private void AcceptFriendInvitation(string username, string friendusername) { if (string.IsNullOrWhiteSpace(username)) { throw new ArgumentNullException(nameof(username)); } if (string.IsNullOrWhiteSpace(friendusername)) { throw new ArgumentNullException(nameof(friendusername)); } using (MySqlConnection connection = new MySqlConnection(connectionString)) { connection.OpenAsync(); string topicname = username + "1" + friendusername; string query = $"Update Friends Set Accepted = 'Y' where UserName = '******' and FriendsUsername = '******'"; string query1 = $"INSERT INTO Friends" + $" (UserName,FriendsUsername,Accepted) " + $"VALUES('{username}', '{friendusername}', 'Y')"; string query2 = $"Create table `{topicname}`(messageid int auto_increment not null primary key, SenderName varchar(50) not null, Messege varchar(1000));"; MySqlCommand cmd = new MySqlCommand(query, connection); cmd.ExecuteNonQuery(); cmd.CommandText = query1; cmd.ExecuteNonQuery(); cmd.CommandText = query2; cmd.ExecuteNonQuery(); connection.CloseAsync(); AzureServiceBusHelper.CreateTopic(topicname); AzureServiceBusHelper.CreateSubscription(topicname, new List <string>() { username, friendusername }); Console.WriteLine("Successfully added new friend"); } }
public static void CreateMultiplechat(string user, string tabletopic) { List <string> topics = AzureServiceBusHelper.TakeAllTopicsForUser(user); string topic = null; bool f = true; foreach (var top in topics.OrderBy(x => x.Length)) { f = true; foreach (var name in (tabletopic + '1' + user).ToString().Split('1').ToList()) { if (top.Split('1').ToList().Contains(name) && top.Split('1').Length == (tabletopic + '1' + user).ToString().Split('1').Length&& f) { topic = top; break; } else { f = false; topic = null; continue; } } } if (topic == null && tabletopic.Contains("1")) { AzureServiceBusHelper.CreateTopic(tabletopic); AzureServiceBusHelper.CreateSubscription(tabletopic, tabletopic.Split('1').ToList()); string query = $"Create table `{tabletopic}`(messageid int auto_increment not null pimary key, SenderName varchar(50) not null, Messege varchar(1000));"; using (MySqlConnection connection = new MySqlConnection(connectionString)) { connection.OpenAsync(); MySqlCommand cmd = new MySqlCommand(query, connection); cmd.ExecuteNonQuery(); connection.CloseAsync(); } Console.WriteLine("New group chat has been successfully created!"); } else { string query = $"SELECT * FROM ChatApp.{topic} order by messageid"; 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 int i = 10; while (dataReader.Read()) { Console.WriteLine(dataReader["SenderName"].ToString().ToLowerInvariant() + ": " + dataReader["Messege"].ToString()); i--; if (i < 0) { break; } } //close Data Reader dataReader.Close(); connection.CloseAsync(); } } }