public static List <Patient> GetPatientList(bool archived) { using (var db = new PatientJournalContext()) { try { if (archived) { var query = from patients in db.Patients select patients; return(query.ToList <Patient>()); } else { var query = from patients in db.Patients where patients.IsArchived == false select patients; return(query.ToList <Patient>()); } } catch (Exception e) { string result = e.Message; return(null); } } }
public static List <Journal> GetJournalList() { using (var db = new PatientJournalContext()) { try { var query = from j in db.Journals select j; return(query.ToList <Journal>()); } catch (Exception e) { string result = e.Message; return(null); } } }
public static Patient GetPatient(int id) { using (var db = new PatientJournalContext()) { try { var query = from patient in db.Patients where patient.Id == id select patient; return(query.FirstOrDefault()); } catch (Exception e) { string result = e.Message; return(null); } } }