/// <summary>
        /// Edit appointment load method
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void EditAppoinUserControl_Load(object sender, EventArgs e)
        {
            //fills the combo boxes with data from the database
            FillComboBoxes();

            //get the appointment id
            string appointmentID = AppointmentUserControl.ReturnAppointmentValue();

            AppointID = AppointmentUserControl.ReturnAppointmentValue();



            //debug purposes
            Console.WriteLine("id is" + appointmentID);
            DataSet dsAppointment = DBConnection.getDBConnectionInstance().getDataSet(Constants.SelectAppointment(appointmentID));

            //get the table to be displayed from the data set
            DataTable dtAppointment = dsAppointment.Tables[0];
        }
 public EditAppoinUserControl()
 {
     InitializeComponent();
     string appointmentID = AppointmentUserControl.ReturnAppointmentValue();
 }