private void buttonNewParticipant_Click(object sender, RoutedEventArgs e)
 {
     if (_department == @"ADVP")
     {
         if (!DbConnector.CheckForExistingPid(textBoxNewParticipantID.Text))
         {
             DbConnector.RunQuery(@"INSERT INTO tbl_Consumer_List_Entry (Consumer_Id) VALUES ('" +
                                  textBoxNewParticipantID.Text + @"');");
         }
         IntakeForm intakeForm = new IntakeForm(textBoxNewParticipantID.Text);
         intakeForm.Show();
     }
     else if (_department == @"ECAP")
     {
         if (!DbConnector.CheckForExistingPid(textBoxNewParticipantID.Text))
         {
             DbConnector.RunQuery(@"INSERT INTO ECAP (Ecap_Id) VALUES ('" +
                                  textBoxNewParticipantID.Text + @"');");
         }
         Ecap ecap = new Ecap(textBoxNewParticipantID.Text);
         ecap.Show();
     }
     else if (_department == @"WOCAPPT")
     {
         if (!DbConnector.CheckForExistingPid(textBoxNewParticipantID.Text))
         {
             DbConnector.RunQuery(@"INSERT INTO WOCAPPT (WocID, DateScheduled) VALUES ('" +
                                  textBoxNewParticipantID.Text + @"', #" + DateTime.Now.ToShortDateString() + "#);");
         }
         WocMenu woc = new WocMenu(textBoxNewParticipantID.Text);
         woc.Show();
     }
     Close();
 }
        /// <summary>
        /// Create intake form with selected PID
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void buttonSelectParticipant_Click(object sender, RoutedEventArgs e)
        {
            if (_department == @"ADVP")
            {
                IntakeForm intakeForm = new IntakeForm(textBoxParticipantID.Text);
                intakeForm.Show();
            }
            else if(_department == @"ECAP")
            {
                Ecap ecap = new Ecap(textBoxParticipantID.Text);
                ecap.Show();
            }
            else if(_department == @"ECAP_VHOURS")
            {

            }
            else if(_department == @"WOCAPPT")
            {
                WocMenu woc = new WocMenu(textBoxParticipantID.Text);
                woc.Show();
            }
            else if(_department == @"WOC_CLASS")
            {

            }
            else if(_department == @"WOC_COMPLOG")
            {

            }
            Close();
        }