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();
}
}
