using System.Collections.Generic; namespace PWAPPv2.Source { class Patient { public string PatNum; public string FName; public string MName; public string LName; public string Gender; public string DoB; public string SSN; public string Address; public string Address2; public string City; public string State; public string Zip; public string HomePhone; public string WorkPhone; public string WirelessPhone; public string Email; public void BuildFromDatabase(Database.DatabaseConnection databaseConnection, string patNum) { List result = databaseConnection.QueryDatabase("SELECT PatNum, LName, FName, MiddleI, Gender, Birthdate," + "SSN, Address, Address2, City, State, Zip, HmPhone, WkPhone, WirelessPhone, Email FROM patient WHERE PatNum = " + patNum); PatNum = result[0]; LName = result[1]; FName = result[2]; MName = result[3]; Gender = result[4]; DoB = result[5]; SSN = result[6]; Address = result[7]; Address2 = result[8]; City = result[9]; State = result[10]; Zip = result[11]; HomePhone = result[12]; WorkPhone = result[13]; WirelessPhone = result[14]; Email = result[15]; } } }