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