private void readmessages()
{
MessageRead.Clear();
MessageRead.ScrollToCaret();
string Read_Query = "select * from comments where Sender_ID = '" + sendertext + "' and Reciver_ID = '" + recivertext + "' or Sender_ID = '" + recivertext + "' and Reciver_ID = '" + sendertext + "' ";
connection.Open();
MySqlCommand cmd = new MySqlCommand(Read_Query, connection);
MySqlDataReader dr = cmd.ExecuteReader();
DateTime today = DateTime.Now;
string text;
while (dr.Read())
{
DateTime date_sent = (DateTime)dr["Date_sent"];
MessageRead.Text += date_sent.ToString("dddd HH:mm");
MessageRead.Text += ": ";
MessageRead.Text += dr["Sender_ID"].ToString();
MessageRead.Text += ": ";
if (dr["Important"].ToString() == "1")
{
MessageRead.Text += "<<<IMPORTANT>>>";
}
string message = dr["message"].ToString();
using (Aes myAes = Aes.Create())
{
text = SendClass.Decrypt(message);
}
MessageRead.Text += text.ToString();
if (dr["Important"].ToString() == "1")
{
MessageRead.Text += "<<<IMPORTANT>>>";
}
MessageRead.Text += (Environment.NewLine);
}
connection.Close();
}
private void Send_button_Click(object sender, EventArgs e)
{
DateTime today = DateTime.Now;
int checkbox = 0;
string encrypted_message;
string message = textBox1.Text;
using (Aes myAes = Aes.Create())
{
encrypted_message = SendClass.Encrypt(message);
}
string strtoday = today.ToString("yyyy-MM-dd HH:mm:ss tt");
if (FlagBox.Checked)
{
checkbox = 1;
}
if (string.IsNullOrEmpty(this.textBox1.Text))
{
MessageBox.Show("Can't send nothing!");
}
else
{
connection.Open();
MySqlCommand comm = connection.CreateCommand();
comm.CommandText = "INSERT INTO comments(Sender_ID,Reciver_ID, Message,Important ,Date_sent) VALUES(?sendertext, ?recivertext, ?encrypted_message, ?checkbox, ?date)";
comm.Parameters.AddWithValue("?sendertext", sendertext);
comm.Parameters.AddWithValue("?recivertext", recivertext);
comm.Parameters.AddWithValue("?encrypted_message", encrypted_message);
comm.Parameters.AddWithValue("?checkbox", checkbox);
comm.Parameters.AddWithValue("?date", strtoday);
comm.ExecuteNonQuery();
connection.Close();
}
FlagBox.Checked = false;
textBox1.Clear();
readmessages();
}