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 FaceSheet(int cmnum, int hvnum)
 {
     physicianID = 0;
     clientID = 0;
     patientID = 0;
     cost = new CostTable();
     casMan = new UInt16[cmnum];
     homVac = new UInt16[hvnum];
     carTra = new bool();
     ambWel = new bool();
     senRes = new bool();
     action = "";
 }
 public void registerCostTable(CostTable c)
 {
     cost = c;
 }