//Search for patient info (for now only based on SSN) AND only works with (retrieves) ONE patient private void Button1_Click(object sender, EventArgs e) { textSetFirstName.Text = ""; textSetLastName.Text = ""; textSetSSN.Text = ""; textSetAddress.Text = ""; textSetPhoneNumber.Text = ""; ConnectDB EMRDatabase = new ConnectDB(); dataGridView1.Rows.Clear(); if (!textPatientNameSearch.Text.Equals("")) //if searching by name { Patients = EMRDatabase.SelectByName(FirstName); //retrieve list by First Name } else { Patients = EMRDatabase.Select(SSN); //retrieve list by SSN } Fname = Patients[0]; Lname = Patients[1]; Birthday = Patients[2]; InsProvider = Patients[3]; Address = Patients[4]; Email = Patients[5]; Phone = Patients[6]; Sex = Patients[7]; PrimaryPhysician = Patients[8]; BloodType = Patients[9]; InsNumber = Patients[10]; Ssn = Patients[11]; for (int i = 0; i < Ssn.Count; i++) { dataGridView1.Rows.Add(Fname[i], Lname[i], Birthday[i], InsNumber[i]); } }
private void buttonPatientSearch_Click(object sender, EventArgs e) { ConnectDB EMRDatabase = new ConnectDB(); Patients = EMRDatabase.Select(SSN); //retrieve by SSN PatientsMoreInfo[0] = Patients[0][0]; PatientsMoreInfo[1] = Patients[1][0]; PatientsMoreInfo[2] = Patients[11][0]; PatientsMoreInfo[3] = Patients[4][0]; PatientsMoreInfo[4] = Patients[6][0]; PatientsMoreInfo[5] = Patients[5][0]; PatientsMoreInfo[6] = Patients[7][0]; PatientsMoreInfo[7] = Patients[2][0]; PatientsMoreInfo[8] = Patients[9][0]; PatientsMoreInfo[9] = Patients[8][0]; PatientsMoreInfo[10] = Patients[3][0]; PatientsMoreInfo[11] = Patients[10][0]; PatientMoreInfo moreInfo = new PatientMoreInfo(PatientsMoreInfo, true); moreInfo.Show(); }