private void comboBox7_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox7.Text != "Select Room")
{
comboBox8.Items.Clear();
comboBox8.Items.Add("Select Bed");
comboBox8.Text = "Select Bed";
comboBox8.Enabled = true;
PlaceAppointmentmysql roomfee = new PlaceAppointmentmysql();
textBox15.Text = roomfee.FindRoomFee(int.Parse(comboBox4.Text), int.Parse(comboBox7.Text));
List <string> beds = roomfee.freeBeds(int.Parse(comboBox4.Text), int.Parse(comboBox7.Text));
if (beds == null)
{
comboBox8.Text = "No free beds";
comboBox8.Enabled = false;
}
else
{
foreach (var item in beds)
{
comboBox8.Items.Add(item);
}
}
}
else
{
comboBox8.Items.Clear();
comboBox8.Items.Add("Select Bed");
comboBox8.Text = "Select Bed";
comboBox8.Enabled = false;
textBox15.Text = null;
}
}
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);
}
}
private void comboBox4_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox4.Text != "Select Floor")
{
comboBox7.Items.Clear();
comboBox7.Items.Add("Select Room");
comboBox7.Text = "Select Room";
comboBox7.Enabled = true;
PlaceAppointmentmysql findroom = new PlaceAppointmentmysql();
List <string> rooms = findroom.FindRooms(int.Parse(comboBox4.Text));
foreach (var item in rooms)
{
comboBox7.Items.Add(item);
}
}
else
{
comboBox7.Items.Clear();
comboBox7.Items.Add("Select Room");
comboBox7.Text = "Select Room";
comboBox8.Items.Clear();
comboBox8.Items.Add("Select Bed");
comboBox8.Text = "Select Bed";
comboBox7.Enabled = false;
comboBox8.Enabled = false;
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
textBox22.Clear();
if (comboBox1.Text != "Patient ID")
{
PlaceAppointmentmysql name = new PlaceAppointmentmysql();
textBox22.Text = name.findpatientsinformation(comboBox1.Text);
}
}
private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)
{
textBox20.Clear();
textBox14.Clear();
textBox2.Clear();
if (comboBox3.Text != "Select Doctor")
{
PlaceAppointmentmysql doctorinfo = new PlaceAppointmentmysql();
List <string> doctor = doctorinfo.findDoctorInformation(comboBox3.Text);
try
{
textBox20.Text = doctor[0];
textBox14.Text = doctor[1];
textBox2.Text = doctor[2];
}
catch (Exception)
{
textBox20.Clear();
textBox14.Clear();
textBox2.Clear();
}
}
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
comboBox3.Items.Clear();
textBox20.Clear();
textBox14.Clear();
textBox2.Clear();
comboBox3.Items.Add("Select Doctor");
comboBox3.Text = "Select Doctor";
if (comboBox2.Text != "Doctor Qualification")
{
PlaceAppointmentmysql DoctorsNames = new PlaceAppointmentmysql();
List <string> names = DoctorsNames.FindDoctorsNAMEbyqualification(comboBox2.Text);
foreach (var item in names)
{
comboBox3.Items.Add(item.ToString());
comboBox3.Enabled = true;
}
}
else
{
comboBox3.Enabled = false;
}
}
private void button2_Click(object sender, EventArgs e)
{
Clera();
panel2.Visible = true;
dateTimePicker1.MinDate = DateTime.Today;
PlaceAppointmentmysql doctorsqualifications = new PlaceAppointmentmysql();
List <string> qualifications = doctorsqualifications.FindDoctorsQualifications();
List <string> patientsID = doctorsqualifications.FindAllPatintsID();
List <string> floors = doctorsqualifications.FindFloors();//???
foreach (var item in qualifications)
{
comboBox2.Items.Add(item);
}
foreach (var item in patientsID)
{
comboBox1.Items.Add(item);
}
foreach (var item in floors)
{
comboBox4.Items.Add(item);
}
}
