private void button1_Click(object sender, EventArgs e)
{
first.Text = "";
phone1.Text = "";
phone2.Text = "";
phone3.Text = "";
phone4.Text = "";
phone5.Text = "";
group1.Text = "";
DB db1 = new DB();
db1.openConnection();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand("SELECT phone FROM lessons where `instructor_surname` = @inst and `date` = @date and `time` = '10:30'", db1.getConnection());
command.Parameters.Add("@inst", MySqlDbType.VarChar).Value = instructor_box.SelectedItem.ToString();
command.Parameters.Add("@date", MySqlDbType.Date).Value = date_pick.SelectionRange.Start;
MySqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
phone1.Text = reader[0].ToString();
phone1.Visible = true;
}
db1.closeConnection();
//
DB db2 = new DB();
db2.openConnection();
MySqlDataAdapter adapter2 = new MySqlDataAdapter();
MySqlCommand command2 = new MySqlCommand("SELECT phone FROM lessons where `instructor_surname` = @inst and `date` = @date and `time` = '11:45'", db2.getConnection());
command2.Parameters.Add("@inst", MySqlDbType.VarChar).Value = instructor_box.SelectedItem.ToString();
command2.Parameters.Add("@date", MySqlDbType.Date).Value = date_pick.SelectionRange.Start;
MySqlDataReader reader2 = command2.ExecuteReader();
if (reader2.Read())
{
phone2.Text = reader2[0].ToString();
phone2.Visible = true;
}
db2.closeConnection();
//
DB db3 = new DB();
db3.openConnection();
MySqlDataAdapter adapter3 = new MySqlDataAdapter();
MySqlCommand command3 = new MySqlCommand("SELECT phone FROM lessons where `instructor_surname` = @inst and `date` = @date and `time` = '13:00'", db3.getConnection());
command3.Parameters.Add("@inst", MySqlDbType.VarChar).Value = instructor_box.SelectedItem.ToString();
command3.Parameters.Add("@date", MySqlDbType.Date).Value = date_pick.SelectionRange.Start;
MySqlDataReader reader3 = command3.ExecuteReader();
if (reader3.Read())
{
phone3.Text = reader3[0].ToString();
phone3.Visible = true;
}
db3.closeConnection();
//
DB db4 = new DB();
db4.openConnection();
MySqlDataAdapter adapter4 = new MySqlDataAdapter();
MySqlCommand command4 = new MySqlCommand("SELECT phone FROM lessons where `instructor_surname` = @inst and `date` = @date and `time` = '14:15'", db4.getConnection());
command4.Parameters.Add("@inst", MySqlDbType.VarChar).Value = instructor_box.SelectedItem.ToString();
command4.Parameters.Add("@date", MySqlDbType.Date).Value = date_pick.SelectionRange.Start;
MySqlDataReader reader4 = command4.ExecuteReader();
if (reader4.Read())
{
phone4.Text = reader4[0].ToString();
phone4.Visible = true;
}
db4.closeConnection();
//
DB db5 = new DB();
db5.openConnection();
MySqlDataAdapter adapter5 = new MySqlDataAdapter();
MySqlCommand command5 = new MySqlCommand("SELECT phone FROM lessons where `instructor_surname` = @inst and `date` = @date and `time` = '15:30'", db5.getConnection());
command5.Parameters.Add("@inst", MySqlDbType.VarChar).Value = instructor_box.SelectedItem.ToString();
command5.Parameters.Add("@date", MySqlDbType.Date).Value = date_pick.SelectionRange.Start;
MySqlDataReader reader5 = command5.ExecuteReader();
if (reader5.Read())
{
phone5.Text = reader5[0].ToString();
phone5.Visible = true;
}
db5.closeConnection();
}
