private void button2_Click(object sender, EventArgs e) { db db1 = new db(); db1.openConnection(); MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand command = new MySqlCommand("INSERT INTO pacient (`name`, `surname`, `phone`) VALUES (@name, @surname, @phone);", db1.getConnection()); command.Parameters.Add("@name", MySqlDbType.VarChar).Value = name_box.Text; command.Parameters.Add("@surname", MySqlDbType.VarChar).Value = Surname_box.Text; command.Parameters.Add("@phone", MySqlDbType.VarChar).Value = phone_box2.Text; if (command.ExecuteNonQuery() == 1) { MessageBox.Show(String.Format("{0} {1} успешно добавлен в базу!", name_box.Text, Surname_box.Text)); } else { MessageBox.Show("Возникла ошибка"); } db1.closeConnection(); }
private void button1_Click(object sender, EventArgs e) { db db2 = new db(); db2.openConnection(); MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand command = new MySqlCommand("SELECT phone, comment FROM priyom where `doctor_surname` = @doc and `date` = @date", db2.getConnection()); command.Parameters.Add("@doc", MySqlDbType.VarChar).Value = comboBox1.SelectedItem.ToString(); command.Parameters.Add("@date", MySqlDbType.Date).Value = date_pick.SelectionRange.Start; MySqlDataReader reader = command.ExecuteReader(); String[] phones = new String[5]; String[] comment = new String[5]; String[] names = new String[5]; int counter = 0; while (reader.Read()) { phones[counter] = reader[0].ToString(); comment[counter] = reader[1].ToString(); counter += 1; } db2.closeConnection(); db db3 = new db(); db3.openConnection(); MySqlCommand command1 = new MySqlCommand("SELECT `surname` from pacient where `phone` = @phone1 OR `phone` = @phone2 OR `phone` = @phone3 OR `phone` = @phone4 OR `phone` = @phone5", db3.getConnection()); command1.Parameters.Add("@phone1", MySqlDbType.VarChar).Value = phones[0]; command1.Parameters.Add("@phone2", MySqlDbType.VarChar).Value = phones[1]; command1.Parameters.Add("@phone3", MySqlDbType.VarChar).Value = phones[2]; command1.Parameters.Add("@phone4", MySqlDbType.VarChar).Value = phones[3]; command1.Parameters.Add("@phone5", MySqlDbType.VarChar).Value = phones[4]; MySqlDataReader reader1 = command1.ExecuteReader(); int counter1 = 0; while (reader1.Read()) { names[counter1] = reader1[0].ToString(); counter1 += 1; } if (counter1 == 1) { name1.Text = names[0]; name1.Visible = true; comment1.Text = comment[0]; comment1.Visible = true; } else if (counter1 == 2) { name1.Text = names[0]; name1.Visible = true; name2.Text = names[1]; name2.Visible = true; comment1.Text = comment[0]; comment1.Visible = true; comment2.Text = comment[1]; comment2.Visible = true; } else if (counter1 == 3) { name1.Text = names[0]; name1.Visible = true; name2.Text = names[1]; name2.Visible = true; name3.Text = names[2]; name3.Visible = true; comment1.Text = comment[0]; comment1.Visible = true; comment2.Text = comment[1]; comment2.Visible = true; comment3.Text = comment[2]; comment3.Visible = true; } else if (counter1 == 4) { name1.Text = names[0]; name1.Visible = true; name2.Text = names[1]; name2.Visible = true; name3.Text = names[2]; name3.Visible = true; name4.Text = names[3]; name4.Visible = true; comment1.Text = comment[0]; comment1.Visible = true; comment2.Text = comment[1]; comment2.Visible = true; comment3.Text = comment[2]; comment3.Visible = true; comment4.Text = comment[3]; comment4.Visible = true; } else if (counter1 == 5) { name1.Text = names[0]; name1.Visible = true; name2.Text = names[1]; name2.Visible = true; name3.Text = names[2]; name3.Visible = true; name4.Text = names[3]; name4.Visible = true; name5.Text = names[4]; name5.Visible = true; comment1.Text = comment[0]; comment1.Visible = true; comment2.Text = comment[1]; comment2.Visible = true; comment3.Text = comment[2]; comment3.Visible = true; comment4.Text = comment[3]; comment4.Visible = true; comment5.Text = comment[4]; comment5.Visible = true; } db3.closeConnection(); }
private void button1_Click(object sender, EventArgs e) { db db2 = new db(); db2.openConnection(); MySqlDataAdapter adapter1 = new MySqlDataAdapter(); MySqlCommand command1 = new MySqlCommand("SELECT NAME, SURNAME FROM PACIENT WHERE PHONE = @PHONE;", db2.getConnection()); command1.Parameters.Add("@PHONE", MySqlDbType.VarChar).Value = phone_box1.Text; MySqlDataReader reader = command1.ExecuteReader(); String pacient_name; String pacient_surname; if (reader.Read()) { pacient_name = reader[0].ToString(); pacient_surname = reader[1].ToString(); db2.closeConnection(); // До этого момента мы проверили ли есть такой человек в базе, сейчас будем проверять ли у этого доктора на эту дату есть места // Максимум мест для доктора на один день - 5 db db3 = new db(); db3.openConnection(); MySqlDataAdapter adapter2 = new MySqlDataAdapter(); MySqlCommand command2 = new MySqlCommand("SELECT * FROM priyom WHERE `doctor_surname` = @doctor_surname AND `date` = @date", db3.getConnection()); command2.Parameters.Add("@doctor_surname", MySqlDbType.VarChar).Value = doctor_box.SelectedItem.ToString(); command2.Parameters.Add("@date", MySqlDbType.Date).Value = date_pick.SelectionRange.Start; MySqlDataReader reader3 = command2.ExecuteReader(); int counter = 0; while (reader3.Read()) { counter += 1; } if (counter >= 5) { MessageBox.Show("К сожалению в этот день доктор занят!"); db3.closeConnection(); } else { db3.closeConnection(); db db1 = new db(); db1.openConnection(); MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand command = new MySqlCommand("INSERT INTO priyom (`phone`, `doctor_surname`, `date`, `comment`) VALUES (@phone, @doctor_surname, @date, @comment);", db1.getConnection()); command.Parameters.Add("@phone", MySqlDbType.VarChar).Value = phone_box1.Text; command.Parameters.Add("@doctor_surname", MySqlDbType.VarChar).Value = doctor_box.SelectedItem.ToString(); command.Parameters.Add("@date", MySqlDbType.Date).Value = date_pick.SelectionRange.Start; command.Parameters.Add("@comment", MySqlDbType.VarChar).Value = comment.Text; if (command.ExecuteNonQuery() == 1) { MessageBox.Show(String.Format("{0} {1} успешно записан на прием", pacient_name, pacient_surname)); } else { MessageBox.Show("Возникла ошибка"); } db1.closeConnection(); comment.Text = ""; } } else { MessageBox.Show("Такого пациента нету в базе!"); db2.closeConnection(); } }