private byte[] GetPatientPhotoBytes(string patientId) { using (var ariaContext = new AriaEntityContext(GetConnectionString())) { var dbPatient = ariaContext.Patients.First(p => p.PatientId == patientId); return(dbPatient.Photos.Last().Picture); } }
private string GetPhysicianFullName() { using (var ariaContext = new AriaEntityContext(GetConnectionString())) { var physicianId = _patient.PrimaryOncologistId; var dbDoctor = ariaContext.Doctors.First(d => d.DoctorId == physicianId); return(dbDoctor.FirstName + " " + dbDoctor.LastName); } }