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);
}
