private void button2_Click(object sender, EventArgs e) { string tt; tt = "first"; int coop = 0; if (time_box.SelectedItem.ToString() == "10:30") { tt = "first"; coop = 2; } else if (time_box.SelectedItem.ToString() == "11:45") { tt = "second"; coop = 3; } else if (time_box.SelectedItem.ToString() == "13:00") { tt = "third"; coop = 4; } else if (time_box.SelectedItem.ToString() == "14:15") { tt = "fourth"; coop = 5; } else if (time_box.SelectedItem.ToString() == "15:30") { tt = "fifth"; coop = 6; } DB db0 = new DB(); db0.openConnection(); MySqlDataAdapter adapter0 = new MySqlDataAdapter(); MySqlCommand command0 = new MySqlCommand("select * from lessons where `instructor_surname` = @inst AND `date` = @date AND `time` = @time", db0.getConnection()); command0.Parameters.Add("@inst", MySqlDbType.VarChar).Value = instructor_box.SelectedItem.ToString(); command0.Parameters.Add("@date", MySqlDbType.Date).Value = date_pick.SelectionRange.Start; command0.Parameters.Add("@time", MySqlDbType.VarChar).Value = time_box.Text; MySqlDataReader reader0 = command0.ExecuteReader(); if (reader0.Read()) { MessageBox.Show("This time is busy!"); db0.closeConnection(); } else { db0.closeConnection(); DB db1 = new DB(); db1.openConnection(); MySqlDataAdapter adapter1 = new MySqlDataAdapter(); MySqlCommand command1 = new MySqlCommand("select * from student where `phone` = @phone", db1.getConnection()); command1.Parameters.Add("@phone", MySqlDbType.VarChar).Value = textBox3.Text; MySqlDataReader reader1 = command1.ExecuteReader(); if (reader1.Read()) { db1.closeConnection(); DB db = new DB(); db.openConnection(); MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand command = new MySqlCommand("INSERT INTO LESSONS (`instructor_surname`, `date`, `phone`, `time`) values (@inst, @date, @phone, @time) ", db.getConnection()); command.Parameters.Add("@inst", MySqlDbType.VarChar).Value = instructor_box.SelectedItem.ToString(); command.Parameters.Add("@date", MySqlDbType.Date).Value = date_pick.SelectionRange.Start; command.Parameters.Add("@phone", MySqlDbType.VarChar).Value = textBox3.Text; command.Parameters.Add("@time", MySqlDbType.VarChar).Value = time_box.Text; if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Запись принята!"); } db.closeConnection(); } else { db1.closeConnection(); MessageBox.Show("ERROR, NO SUCH STUDENT IN THE BASE!"); } } }
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(); }