public RegisterPatientTab()
        {
            InitializeComponent();

            gatherID = endorseID = 0;

            patient = new Patient();
            client = new Client();
            fsheet = new FaceSheet();
            cost = new CostTable();

            server = "localhost";
            user = "******";
            database = "hhc-db";
            password = "******";

            string connString = "SERVER=" + server + ";" + "DATABASE=" +
                                database + ";" + "UID=" + user + ";" +
                                "PASSWORD="******";";

            conn = new MySqlConnection(connString);

            if (OpenConnection())
            {
                int hvnum = 0, cmnum = 0;
                //INITIALIZE CHECK BOX LISTS WITH ITEMS FROM DATABASE.
                string query = "SELECT DESCRIPTION FROM CASE_MGMT_REF;";
                cmd = new MySqlCommand(query, conn);

                read = cmd.ExecuteReader();

                while (read.Read())
                {
                    cmnum++;
                    caseMgmtBox.Items.Add(read.GetString(0));
                }

                read.Close();

                query = "SELECT DESCRIPTION FROM HVAC_REF;";
                cmd.CommandText = query;

                read = cmd.ExecuteReader();

                while (read.Read())
                {
                    hvnum++;
                    hvacCoB.Items.Add(read.GetString(0));
                }

                read.Close();
                //INTITIALIZE FACE SHEET
                Console.WriteLine("Number of CM Items: {0}", cmnum);
                Console.WriteLine("Number of HV Items: {0}", hvnum);
                CloseConnection();
                fsheet = new FaceSheet(cmnum, hvnum);

            }
        }
        public RegisterPatientTab()
        {
            InitializeComponent();

            this.tabPage1.Text = "Register Patient";
            this.tabPage2.Text = "Register Client";
            this.tabPage3.Text = "Requirements";
            this.tabPage4.Text = "Details";

            patient = new Patient();
            client = new Client();
            fsheet = new FaceSheet();

            server = "localhost";
            user = "******";
            database = "hhc-db";
            password = "******";

            string connString = "SERVER=" + server + ";" + "DATABASE=" +
                                database + ";" + "UID=" + user + ";" +
                                "PASSWORD="******";";

            conn = new MySqlConnection(connString);
        }