public bool Execute()
{
Console.Write("Give name for new discussion: ");
String name = Console.ReadLine();
Console.Write("Give name of receiver: ");
String userTo = Console.ReadLine();
Console.Write("Write first message: ");
String msg = Console.ReadLine();
// serialize new chat
ChatRoom c = new ChatRoom(nickName, userTo, name);
c.addMessage(nickName, msg);
String json = JsonConvert.SerializeObject(c, Formatting.None);
// send query to server
ChatCommand cmd = new ChatCommand("add", nickName, json);
StreamWriter writer = new StreamWriter(tcpClient.GetStream());
writer.WriteLine(cmd.ToJson());
writer.Flush();
return false;
}
public UInt64 create(ChatRoom r)
{
MySqlConnection con = null;
UInt64 id = 0;
try
{
con = new MySqlConnection(cs);
con.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
cmd.CommandText = "INSERT INTO chat_rooms (name, user_A, user_B) VALUES(@name, @userA, @userB)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@name", r.Name);
cmd.Parameters.AddWithValue("@userA", r.UserA);
cmd.Parameters.AddWithValue("@userB", r.UserB);
cmd.ExecuteNonQuery();
id = (UInt64)cmd.LastInsertedId;
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
if (con != null)
{
con.Close();
}
}
return id;
}
public bool Execute()
{
Console.Clear();
if (r != null)
{
foreach (ChatMessage m in r.Messages)
{
Console.WriteLine(m.Time + " " + m.UserFrom + ": " + m.Message);
}
Console.WriteLine();
Console.Write("Enter new message: ");
String msg = Console.ReadLine();
if (msg.Length > 2)
{
// simply clone chat room id
ChatRoom c = new ChatRoom();
c.Id = r.Id;
c.addMessage(nickName, msg);
String json = JsonConvert.SerializeObject(c, Formatting.None);
// send query to server
ChatCommand cmd = new ChatCommand("msg", nickName, json);
StreamWriter writer = new StreamWriter(tcpClient.GetStream());
writer.WriteLine(cmd.ToJson());
writer.Flush();
}
else
{
Console.WriteLine("Too short message!");
}
}
return false;
}
