52 lines
1.5 KiB
C#
52 lines
1.5 KiB
C#
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<string> 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];
|
|
}
|
|
|
|
|
|
}
|
|
}
|