public List <LookupPreviousLabs> GetVlLabs(int patientId)
{
ILookupPreviousLabs previouslabsvl = new LookupPreviousLabsRepository();
var vl = "Viral Load";
var complete = "Complete";
var myList = previouslabsvl.FindBy(x => x.PatientId == patientId);
var list = myList.GroupBy(x => x.Id).Select(x => x.First()).OrderBy(x => x.Id).Where(x => x.LabName == vl).Where(x => (x.Results.ToLower().Trim() == complete || x.Results.ToLower().Trim() == "completed"));
return(list.Distinct().ToList());
}
public List <LookupPreviousLabs> GetPendingVlLabs(int patientId)
{
ILookupPreviousLabs pendingvllabs = new LookupPreviousLabsRepository();
var vl = "Viral Load";
var pending = "Pending";
var myList = pendingvllabs.FindBy(x => x.PatientId == patientId);
var list = myList.GroupBy(x => x.Id).Select(x => x.First()).OrderBy(x => x.Id).Where(x => x.LabName == vl).Where(x => x.Results == pending);
return(list.Distinct().ToList());
//.Where(x => x.Results == pending)
}
public List <LookupPreviousLabs> GetPendingLabs(int patientId)
{
ILookupPreviousLabs pendinglabsrepository = new LookupPreviousLabsRepository();
// var vl = "Viral Load";
var pending = "Pending";
var myList = pendinglabsrepository.FindBy(
x =>
x.PatientId == patientId &&
x.Results == pending);
var list = myList.GroupBy(x => x.Id).Select(x => x.First()).OrderBy(x => x.Id);
return(list.Distinct().ToList());
}
public List <LookupPreviousLabs> GetPreviousLabs(int patientId)
{
ILookupPreviousLabs previouslabsrepository = new LookupPreviousLabsRepository();
// var list = previouslabsrepository.GetAll().GroupBy(x => x.Id).Select(x => x.First()).OrderBy(l => l.TestName);
//return list.ToList();
//var vl = "Viral Load";
var complete = "Complete";
var myList = previouslabsrepository.FindBy(
x =>
x.PatientId == patientId && (x.Results.ToLower().Trim() == complete || x.Results.ToLower().Trim() == "completed"));
var list = myList.GroupBy(x => x.Id).Select(x => x.First()).OrderBy(x => x.Id);
return(list.Distinct().ToList());
}
public List <LookupPreviousLabs> GetExtruderPendingLabs(int patientId)
{
ILookupPreviousLabs previouslabsrepository = new LookupPreviousLabsRepository();
// var list = previouslabsrepository.GetAll().GroupBy(x => x.Id).Select(x => x.First()).OrderBy(l => l.TestName);
//return list.ToList();
var pending = "Pending";
var myList = previouslabsrepository.FindBy(
x =>
x.PatientId == patientId && x.Results == pending);
var list = myList.GroupBy(x => x.Id).Select(x => x.First());
return(list.Distinct().ToList());
}
public List <LookupPreviousLabs> GetExtruderCompleteLabs(int patientId)
{
ILookupPreviousLabs completelabsrepository = new LookupPreviousLabsRepository();
var complete = "Complete";
var myList = completelabsrepository.FindBy(
x => x.PatientId == patientId && (x.Results.ToLower().Trim() == complete || x.Results.ToLower().Trim() == "completed"));
myList = myList.OrderByDescending(x => x.Id).Take(5);
//DateTime? maxLabDate = null;
//if (myList.ToList().Count > 0) {
// maxLabDate = myList.Max(x => x.ResultDate);
//}
////gets max laborder
//var list = myList.Where(x => x.ResultDate == maxLabDate);
//return list.ToList();
return(myList.ToList());
}