/// <summary>
/// Load up page to view patient profile
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void viewPatient(object sender, RoutedEventArgs e)
{
Button b = sender as Button;
PatientHolder account = b.CommandParameter as PatientHolder;
subparent.loadPatientInfo(account.ID, "profile");
}
public void load()
{
listView.Items.Clear();
DataTable qry = parent.query("select patientid,pcode,email,lastname,firstname,sex,(select photoblob from photo where login_user_id=photo.id) as photo from patient");
foreach (DataRow rw in qry.Rows)
{
PatientHolder patient = new PatientHolder();
patient.ID = int.Parse(rw["patientid"].ToString());
patient.email = rw["email"].ToString();
patient.pcode = rw["pcode"].ToString();
patient.fullname = rw["lastname"].ToString() + " " + rw["firstname"].ToString();
patient.sex = rw["sex"].ToString();
patient.photo = parent.getImg((byte[])rw["photo"]);
listView.Items.Add(patient);
}
resultLabel.Content = "Result: " + qry.Rows.Count + " found";
}