public tstPatientDemographic GetPatientIByTestID(string testId) { using (MuseModel model = new MuseModel()) { var patientsDemographics = model.tstPatientDemographics.Where(p => p.TestID.ToString() == testId).ToList().FirstOrDefault(); return(patientsDemographics); } }
private IEnumerable <tstTestDemographic> GetPatientsTests(string patientId) { List <tstTestDemographic> patientTests = new List <tstTestDemographic>(); using (MuseModel model = new MuseModel()) { var patientDemographics = model.tstPatientDemographics.Where(p => p.PatientID == patientId).ToList(); foreach (var item in patientDemographics) { var testDemographics = model.tstTestDemographics.Where(t => t.TestID == item.TestID); patientTests.AddRange(testDemographics); } } return(patientTests); }