private void button12_Click(object sender, EventArgs e)//appointBTN
 {
     if (checkinput())
     {
         if (checkBox1.Checked)
         {
             try
             {
                 PlaceAppointmentmysql appointPatient = new PlaceAppointmentmysql();
                 appointPatient.AppointPacient(comboBox1.Text, textBox22.Text, comboBox3.Text, int.Parse(comboBox4.Text), int.Parse(comboBox7.Text), comboBox8.Text, dateTimePicker1.Text, textBox17.Text + comboBox6.Text + " - " + textBox18.Text + comboBox5.Text, textBox16.Text);
                 MessageBox.Show($"Successfully added patient - {comboBox1.Text} : {textBox22.Text} to appointment list", "Added", MessageBoxButtons.OK, MessageBoxIcon.Information);
                 appointPatient.changeBedfree(comboBox8.Text, int.Parse(comboBox4.Text), int.Parse(comboBox7.Text));
                 appointPatient.changepatientPLaced(comboBox1.Text);
                 Clera();
             }
             catch (Exception)
             {
                 MessageBox.Show("Please enter valid details", "Invalid details", MessageBoxButtons.OK, MessageBoxIcon.Error);
             }
         }
         else
         {
             PlaceAppointmentmysql appointPatient = new PlaceAppointmentmysql();
             appointPatient.AppointPacient(comboBox1.Text, textBox22.Text, comboBox3.Text, 0, 0, null, dateTimePicker1.Text, textBox17.Text + comboBox6.Text + " - " + textBox18.Text + comboBox5.Text, textBox16.Text);
             MessageBox.Show($"Successfully added patient - {comboBox1.Text} : {textBox22.Text} to appointment list", "Added", MessageBoxButtons.OK, MessageBoxIcon.Information);
             appointPatient.changepatientPLaced(comboBox1.Text);
             Clera();
         }
     }
     else
     {
         MessageBox.Show("Please enter valid input", "Invalid input", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }