///<summary></summary>
public static DataTable GetOrderTable(long patNum, bool includeDiscontinued)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
return(Meth.GetTable(MethodBase.GetCurrentMethod(), patNum, includeDiscontinued));
}
DataTable table = new DataTable("orders");
DataRow row;
table.Columns.Add("date");
table.Columns.Add("DateTime", typeof(DateTime));
table.Columns.Add("description");
table.Columns.Add("MedicalOrderNum");
table.Columns.Add("MedicationPatNum");
table.Columns.Add("prov");
table.Columns.Add("status");
table.Columns.Add("type");
List <DataRow> rows = new List <DataRow>();
string command = "SELECT DateTimeOrder,Description,IsDiscontinued,MedicalOrderNum,MedOrderType,ProvNum "
+ "FROM medicalorder WHERE PatNum = " + POut.Long(patNum);
if (!includeDiscontinued) //only include current orders
{
command += " AND IsDiscontinued=0"; //false
}
DataTable rawOrder = Db.GetTable(command);
DateTime dateT;
MedicalOrderType medOrderType;
long medicalOrderNum;
bool isDiscontinued;
for (int i = 0; i < rawOrder.Rows.Count; i++)
{
row = table.NewRow();
dateT = PIn.DateT(rawOrder.Rows[i]["DateTimeOrder"].ToString());
medOrderType = (MedicalOrderType)PIn.Int(rawOrder.Rows[i]["MedOrderType"].ToString());
medicalOrderNum = PIn.Long(rawOrder.Rows[i]["MedicalOrderNum"].ToString());
row["DateTime"] = dateT;
row["date"] = dateT.ToShortDateString();
row["description"] = PIn.String(rawOrder.Rows[i]["Description"].ToString());
if (medOrderType == MedicalOrderType.Laboratory)
{
List <LabPanel> listPanelsForOrder = LabPanels.GetPanelsForOrder(medicalOrderNum);
for (int p = 0; p < listPanelsForOrder.Count; p++)
{
row["description"] += "\r\n "; //new row for each panel
List <LabResult> listResults = LabResults.GetForPanel(listPanelsForOrder[p].LabPanelNum);
if (listResults.Count > 0)
{
row["description"] += listResults[0].DateTimeTest.ToShortDateString() + " - ";
}
row["description"] += listPanelsForOrder[p].ServiceName;
}
}
row["MedicalOrderNum"] = medicalOrderNum.ToString();
row["MedicationPatNum"] = "0";
row["prov"] = Providers.GetAbbr(PIn.Long(rawOrder.Rows[i]["ProvNum"].ToString()));
isDiscontinued = PIn.Bool(rawOrder.Rows[i]["IsDiscontinued"].ToString());
if (isDiscontinued)
{
row["status"] = "Discontinued";
}
else
{
row["status"] = "Active";
}
row["type"] = medOrderType.ToString();
rows.Add(row);
}
//Medications are deprecated for 2014 edition
//MedicationPats
//command="SELECT DateStart,DateStop,MedicationPatNum,CASE WHEN medication.MedName IS NULL THEN medicationpat.MedDescript ELSE medication.MedName END MedName,PatNote,ProvNum "
// +"FROM medicationpat "
// +"LEFT OUTER JOIN medication ON medication.MedicationNum=medicationpat.MedicationNum "
// +"WHERE PatNum = "+POut.Long(patNum);
//if(!includeDiscontinued) {//exclude invalid orders
// command+=" AND DateStart > "+POut.Date(new DateTime(1880,1,1))+" AND PatNote !='' "
// +"AND (DateStop < "+POut.Date(new DateTime(1880,1,1))+" "//no date stop
// +"OR DateStop >= "+POut.Date(DateTime.Today)+")";//date stop hasn't happened yet
//}
//DataTable rawMed=Db.GetTable(command);
//DateTime dateStop;
//for(int i=0;i<rawMed.Rows.Count;i++) {
// row=table.NewRow();
// dateT=PIn.DateT(rawMed.Rows[i]["DateStart"].ToString());
// row["DateTime"]=dateT;
// if(dateT.Year<1880) {
// row["date"]="";
// }
// else {
// row["date"]=dateT.ToShortDateString();
// }
// row["description"]=PIn.String(rawMed.Rows[i]["MedName"].ToString())+", "
// +PIn.String(rawMed.Rows[i]["PatNote"].ToString());
// row["MedicalOrderNum"]="0";
// row["MedicationPatNum"]=rawMed.Rows[i]["MedicationPatNum"].ToString();
// row["prov"]=Providers.GetAbbr(PIn.Long(rawMed.Rows[i]["ProvNum"].ToString()));
// dateStop=PIn.Date(rawMed.Rows[i]["DateStop"].ToString());
// if(dateStop.Year<1880 || dateStop>DateTime.Today) {//not stopped or in the future
// row["status"]="Active";
// }
// else {
// row["status"]="Discontinued";
// }
// row["type"]="Medication";
// rows.Add(row);
//}
//Sorting-----------------------------------------------------------------------------------------
rows.Sort(new MedicalOrderLineComparer());
for (int i = 0; i < rows.Count; i++)
{
table.Rows.Add(rows[i]);
}
return(table);
}
public static List <ReminderRule> GetRemindersForPatient(Patient PatCur)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
return(Meth.GetObject <List <ReminderRule> >(MethodBase.GetCurrentMethod(), PatCur));
}
//Problem,Medication,Allergy,Age,Gender,LabResult
List <ReminderRule> fullListReminders = Crud.ReminderRuleCrud.SelectMany("SELECT * FROM reminderrule");
List <ReminderRule> retVal = new List <ReminderRule>();
List <Disease> listProblems = Diseases.Refresh(PatCur.PatNum);
List <Medication> listMedications = Medications.GetMedicationsByPat(PatCur.PatNum);
List <Allergy> listAllergies = Allergies.Refresh(PatCur.PatNum);
List <LabResult> listLabResults = LabResults.GetAllForPatient(PatCur.PatNum);
for (int i = 0; i < fullListReminders.Count; i++)
{
switch (fullListReminders[i].ReminderCriterion)
{
case EhrCriterion.Problem:
for (int j = 0; j < listProblems.Count; j++)
{
if (fullListReminders[i].CriterionFK == listProblems[j].DiseaseDefNum)
{
retVal.Add(fullListReminders[i]);
break;
}
}
break;
case EhrCriterion.Medication:
for (int j = 0; j < listMedications.Count; j++)
{
if (fullListReminders[i].CriterionFK == listMedications[j].MedicationNum)
{
retVal.Add(fullListReminders[i]);
break;
}
}
break;
case EhrCriterion.Allergy:
for (int j = 0; j < listAllergies.Count; j++)
{
if (fullListReminders[i].CriterionFK == listAllergies[j].AllergyDefNum)
{
retVal.Add(fullListReminders[i]);
break;
}
}
break;
case EhrCriterion.Age:
if (fullListReminders[i].CriterionValue[0] == '<')
{
if (PatCur.Age < int.Parse(fullListReminders[i].CriterionValue.Substring(1, fullListReminders[i].CriterionValue.Length - 1)))
{
retVal.Add(fullListReminders[i]);
}
}
else if (fullListReminders[i].CriterionValue[0] == '>')
{
if (PatCur.Age > int.Parse(fullListReminders[i].CriterionValue.Substring(1, fullListReminders[i].CriterionValue.Length - 1)))
{
retVal.Add(fullListReminders[i]);
}
}
else
{
//This section should never be reached
}
break;
case EhrCriterion.Gender:
if (PatCur.Gender.ToString().ToLower() == fullListReminders[i].CriterionValue.ToLower())
{
retVal.Add(fullListReminders[i]);
}
break;
case EhrCriterion.LabResult:
for (int j = 0; j < listLabResults.Count; j++)
{
if (listLabResults[j].TestName.ToLower().Contains(fullListReminders[i].CriterionValue.ToLower()))
{
retVal.Add(fullListReminders[i]);
break;
}
}
break;
//case EhrCriterion.ICD9:
// for(int j=0;j<listProblems.Count;j++) {
// if(fullListReminders[i].CriterionFK==listProblems[j].DiseaseDefNum) {
// retVal.Add(fullListReminders[i]);
// break;
// }
// }
// break;
}
}
return(retVal);
}
///<summary></summary>
public static List <EduResource> GenerateForPatient(long patNum)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
return(Meth.GetObject <List <EduResource> >(MethodBase.GetCurrentMethod(), patNum));
}
List <Disease> diseaseList = Diseases.Refresh(patNum);
List <MedicationPat> medicationPatList = MedicationPats.Refresh(patNum, false);
List <LabResult> labResultList = LabResults.GetAllForPatient(patNum);
List <EduResource> eduResourceListAll = Crud.EduResourceCrud.SelectMany("SELECT * FROM eduresource");
List <EduResource> retVal = new List <EduResource>();
for (int i = 0; i < eduResourceListAll.Count; i++)
{
if (eduResourceListAll[i].DiseaseDefNum != 0)
{
for (int j = 0; j < diseaseList.Count; j++)
{
if (eduResourceListAll[i].DiseaseDefNum == diseaseList[j].DiseaseDefNum)
{
retVal.Add(eduResourceListAll[i]);
}
}
}
else if (eduResourceListAll[i].Icd9Num != 0) //checks against same list as Diseases/Problems
{
for (int j = 0; j < diseaseList.Count; j++)
{
if (eduResourceListAll[i].Icd9Num == diseaseList[j].ICD9Num)
{
retVal.Add(eduResourceListAll[i]);
}
}
}
else if (eduResourceListAll[i].MedicationNum != 0)
{
for (int j = 0; j < medicationPatList.Count; j++)
{
if (eduResourceListAll[i].MedicationNum == medicationPatList[j].MedicationNum)
{
retVal.Add(eduResourceListAll[i]);
}
}
}
else if (eduResourceListAll[i].LabResultID != "")
{
for (int j = 0; j < labResultList.Count; j++)
{
if (eduResourceListAll[i].LabResultID != labResultList[j].TestID)
{
continue;
}
if (eduResourceListAll[i].LabResultCompare.StartsWith("<"))
{
//PIn.Int not used because blank not allowed.
try{
if (int.Parse(labResultList[j].ObsValue) < int.Parse(eduResourceListAll[i].LabResultCompare.Substring(1)))
{
retVal.Add(eduResourceListAll[i]);
}
}
catch {
//This could only happen if the validation in either input didn't work.
}
}
else if (eduResourceListAll[i].LabResultCompare.StartsWith(">"))
{
try {
if (int.Parse(labResultList[j].ObsValue) > int.Parse(eduResourceListAll[i].LabResultCompare.Substring(1)))
{
retVal.Add(eduResourceListAll[i]);
}
}
catch {
//This could only happen if the validation in either input didn't work.
}
}
}
}
}
return(retVal);
}
public LabResults GetLabResult(long LabPanelNum)
{
LabResults lr = new LabResults();// a variable made from the above declared inner class LabResults
lr.mLabResultmList=LabResultms.GetLabResultms(patm.CustomerNum,LabPanelNum);
return lr;
}
///<summary></summary>
public static List <EduResource> GenerateForPatient(long patNum)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
return(Meth.GetObject <List <EduResource> >(MethodBase.GetCurrentMethod(), patNum));
}
List <Disease> diseaseList = Diseases.Refresh(patNum);
List <MedicationPat> medicationPatList = MedicationPats.Refresh(patNum, false);
List <LabResult> labResultList = LabResults.GetAllForPatient(patNum);
List <EhrLabResult> listEhrLabResults = EhrLabResults.GetAllForPatient(patNum);
List <EduResource> eduResourceListAll = Crud.EduResourceCrud.SelectMany("SELECT * FROM eduresource");
List <EhrMeasureEvent> listTobaccoEvents = EhrMeasureEvents.RefreshByType(patNum, EhrMeasureEventType.TobaccoUseAssessed)
.FindAll(x => x.CodeSystemResult == "SNOMEDCT");
List <EduResource> retVal = new List <EduResource>();
eduResourceListAll.FindAll(x => x.DiseaseDefNum != 0 && diseaseList.Any(y => y.DiseaseDefNum == x.DiseaseDefNum)).ForEach(x => retVal.Add(x));
eduResourceListAll.FindAll(x => x.MedicationNum != 0 &&
medicationPatList.Any(y => y.MedicationNum == x.MedicationNum ||
(y.MedicationNum == 0 && Medications.GetMedication(x.MedicationNum).RxCui == y.RxCui)))
.ForEach(x => retVal.Add(x));
eduResourceListAll.FindAll(x => x.SmokingSnoMed != "" && listTobaccoEvents.Any(y => y.CodeValueResult == x.SmokingSnoMed)).ForEach(x => retVal.Add(x));
foreach (EduResource resourceCur in eduResourceListAll.Where(x => x.LabResultID != ""))
{
foreach (LabResult labResult in labResultList.Where(x => x.TestID == resourceCur.LabResultID))
{
if (resourceCur.LabResultCompare.StartsWith("<"))
{
//PIn.Int not used because blank not allowed.
try{
if (int.Parse(labResult.ObsValue) < int.Parse(resourceCur.LabResultCompare.Substring(1)))
{
retVal.Add(resourceCur);
}
}
catch {
//This could only happen if the validation in either input didn't work.
}
}
else if (resourceCur.LabResultCompare.StartsWith(">"))
{
try {
if (int.Parse(labResult.ObsValue) > int.Parse(resourceCur.LabResultCompare.Substring(1)))
{
retVal.Add(resourceCur);
}
}
catch {
//This could only happen if the validation in either input didn't work.
}
}
} //end LabResultList
foreach (EhrLabResult ehrLabResult in listEhrLabResults.Where(x => x.ObservationIdentifierID == resourceCur.LabResultID)) //matches loinc only.
{
if (retVal.Contains(resourceCur))
{
continue; //already added from loop above.
}
retVal.Add(resourceCur);
} //end EhrLabResults
}
return(retVal);
}