private async void button2_Click(object sender, EventArgs e)
{
message_page a = new message_page();
a.Text = this.Text;
a.Tag = textBox9.Text;
a.Show();
this.Hide();
}
private async void button5_Click(object sender, EventArgs e)
{
SqlConnection = new OleDbConnection(connectString);
await SqlConnection.OpenAsync();
OleDbDataReader sqlReader = null;
if (textBox3.Text != "")
{
OleDbCommand command = new OleDbCommand("INSERT INTO [Чат] (Пользователь, Текст, Роль)VALUES(@login, @text, @rol)", SqlConnection);
command.Parameters.AddWithValue("login", this.Text);
command.Parameters.AddWithValue("text", textBox3.Text);
command.Parameters.AddWithValue("rol", "Консультант");
await command.ExecuteNonQueryAsync();
command = new OleDbCommand("SELECT * FROM [Чат]", SqlConnection);
sqlReader = command.ExecuteReader();
while (sqlReader.Read())
{
int for_id = 0;
while (true)
{
if (for_id == Convert.ToInt32(sqlReader["Код"]))
{
if (this.Text == Convert.ToString(sqlReader["Пользователь"]))
{
textBox2.Text += "Вы" + ": " + Convert.ToString(sqlReader["Текст"]) + "\r\n" + "\r\n";
}
else
{
textBox2.Text += Convert.ToString(sqlReader["Пользователь"]) + " (" + Convert.ToString(sqlReader["Роль"]) + "): " + Convert.ToString(sqlReader["Текст"]) + "\r\n" + "\r\n";
}
break;
}
for_id++;
}
}
message_page a = new message_page();
a.Text = this.Text;
a.Tag = this.Tag;
a.Show();
this.Hide();
}
else
{
textBox3.BackColor = Color.Peru;
}
}