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); }