private void ConfirmBtn_Click(object sender, EventArgs e)
        {
            SqlCommand checker = new SqlCommand("select *from ScheduleTable where  Date = '" + Month.Text + "/" + Day.Text + "/" + Year.Text + "' and Time ='" + Hour.Text + ":" + Minute.Text + "'", connection);

            connection.Open();
            SqlDataReader reader = checker.ExecuteReader();

            if (reader.HasRows)
            {
                MessageBox.Show("Schedule slot is already occupied");
                Month.SelectedItem  = null;
                Day.SelectedItem    = null;
                Year.SelectedItem   = null;
                Hour.SelectedItem   = null;
                Minute.SelectedItem = null;
                ConfirmBtn.Enabled  = false;
            }
            else
            {
                connection.Close();
                cmd = new SqlCommand("insert into ScheduleTable values('" + PatientName.Text + "','" + Month.Text + "/" + Day.Text + "/" + Year.Text + "','" + Hour.Text + ":" + Minute.Text + "','pending')", connection);
                connection.Open();
                cmd.ExecuteNonQuery();

                connection.Close();
                MessageBox.Show("Schedule Added Successfully");
                PatientName.Clear();
                Month.SelectedItem  = null;
                Day.SelectedItem    = null;
                Year.SelectedItem   = null;
                Hour.SelectedItem   = null;
                Minute.SelectedItem = null;
                ConfirmBtn.Enabled  = false;
            }
        }
 private void ClearBtn_Click(object sender, EventArgs e)
 {
     PatientName.Clear();
     Month.SelectedItem  = null;
     Day.SelectedItem    = null;
     Year.SelectedItem   = null;
     Hour.SelectedItem   = null;
     Minute.SelectedItem = null;
     ConfirmBtn.Enabled  = false;
 }