public static List <Allergy> DataTableToAllergy(DataTable dt)
{
List <Allergy> algs = new List <Allergy>();
foreach (DataRow row in dt.Rows)
{
Allergy alg = new Allergy();
string algName = string.Empty;
if (!string.IsNullOrEmpty(row["ALG_Comments"].ToString()))
{
algName = row["ALG_Comments"].ToString();
alg.Name = algName;
alg.Category = InterSystemsProvideData.GetAllergyCategory(algName);
algs.Add(alg);
}
else if (!string.IsNullOrEmpty(row["PHCGE_Name"].ToString()))
{
algName = row["PHCGE_Name"].ToString();
alg.Name = algName;
alg.Category = InterSystemsProvideData.GetAllergyCategory(algName);
algs.Add(alg);
}
else if (!string.IsNullOrEmpty(row["ALG_Desc"].ToString()))
{
algName = row["ALG_Desc"].ToString();
alg.Name = algName;
alg.Category = InterSystemsProvideData.GetAllergyCategory(algName);
algs.Add(alg);
}
else if (!string.IsNullOrEmpty(row["ALGR_Desc"].ToString()))
{
algName = row["ALGR_Desc"].ToString();
alg.Name = algName;
alg.Category = InterSystemsProvideData.GetAllergyCategory(algName);
algs.Add(alg);
}
else if (!string.IsNullOrEmpty(row["PHCD_Name"].ToString()))
{
algName = row["PHCD_Name"].ToString();
alg.Name = algName;
alg.Category = InterSystemsProvideData.GetAllergyCategory(algName);
algs.Add(alg);
}
else if (!string.IsNullOrEmpty(row["INGR_Desc"].ToString()))
{
algName = row["INGR_Desc"].ToString();
alg.Name = algName;
alg.Category = InterSystemsProvideData.GetAllergyCategory(algName);
algs.Add(alg);
}
}
return(algs);
}
public static PatientOrder DataTableToPatientOrder(string epiRowId, DataTable dtOneDay, DataTable dtContinue)
{
Models.PatientOrder ptOrder = new Models.PatientOrder();
List <Order> OneDayList = new List <Order>();
List <Order> ContinueList = new List <Order>();
bool isCheck = false;
string[] listARCIM_Code = GlobalVariables.ARCIM_Code.Split('|');
string[] listARCIM_Code_Oneday = GlobalVariables.ARCIM_Code_Oneday.Split('|');
listARCIM_Code_Oneday = listARCIM_Code_Oneday.Where(x => !string.IsNullOrEmpty(x)).ToArray();
string[] listARCIM_Code_Continue = GlobalVariables.ARCIM_Code_Continue.Split('|');
listARCIM_Code_Continue = listARCIM_Code_Continue.Where(x => !string.IsNullOrEmpty(x)).ToArray();
foreach (DataRow row in dtOneDay.Rows)
{
bool isOne = listARCIM_Code_Oneday.Any(s => row["ARCIM_Code"].ToString().Contains(s));
bool isCon = listARCIM_Code_Continue.Any(s => row["ARCIM_Code"].ToString().Contains(s));
// ignore (standing || continue) order
if (isCon || !(isOne || row["OECPR_Desc"].ToString() != "Standing"))
{
continue;
}
Order OneDay = new Order();
isCheck = listARCIM_Code.Any(s => row["ARCIM_Code"].ToString().Contains(s));
if (isCheck)
{
var data = GetQuestionAnswerModelFromAPI(row["OEORI_RowId"].ToString());
OneDay.QuestionAnswerModel = data;
}
else
{
OneDay.QuestionAnswerModel = new List <Questionaire>();
}
OneDay.OEORI_RowId = String.IsNullOrEmpty(row["OEORI_RowId"].ToString())?"": row["OEORI_RowId"].ToString();
OneDay.OEORI_Date = String.IsNullOrEmpty(row["OEORI_Date"].ToString()) ? "" : Convert.ToDateTime(row["OEORI_Date"].ToString()).ToString("dd/MM/") + Convert.ToDateTime(row["OEORI_Date"].ToString()).Year.ToString();
OneDay.ARCIM_Code = String.IsNullOrEmpty(row["ARCIM_Code"].ToString())?"": row["ARCIM_Code"].ToString();
OneDay.Service = String.IsNullOrEmpty(row["ARCIM_Desc"].ToString())?"": row["ARCIM_Desc"].ToString();
OneDay.Qty = String.IsNullOrEmpty(row["OEORI_PhQtyOrd"].ToString()) ?"" : row["OEORI_PhQtyOrd"].ToString();
OneDay.Dose = String.IsNullOrEmpty(row["PHCFR_Desc2"].ToString()) ? "" : row["PHCFR_Desc2"].ToString();
DateTime dt = Convert.ToDateTime(row["OEORI_SttDat"].ToString());
OneDay.StartDate = String.IsNullOrEmpty(row["OEORI_SttDat"].ToString()) ? "" : dt.ToString("dd/MM/") + dt.Year.ToString();
OneDay.StartTime = String.IsNullOrEmpty(row["OEORI_SttTim"].ToString()) ? "" : Convert.ToDateTime(row["OEORI_SttTim"].ToString()).ToString("HH:mm");
OneDay.OrderingClinician = String.IsNullOrEmpty(row["OrderingClinician"].ToString()) ? "" : row["OrderingClinician"].ToString();
OneDay.AuthorisingClinician = String.IsNullOrEmpty(row["AuthorisingClinician"].ToString()) ? "" : row["AuthorisingClinician"].ToString();
OneDay.DCUserCode = String.IsNullOrEmpty(row["DCUserCode"].ToString()) ? "" : row["DCUserCode"].ToString();
OneDay.DCUserName = String.IsNullOrEmpty(row["DCUserName"].ToString())? "" : row["DCUserName"].ToString();
OneDay.DCDate = String.IsNullOrEmpty(row["DCDate"].ToString()) ? "" : Convert.ToDateTime(row["DCDate"].ToString()).ToString("dd/MM/") + Convert.ToDateTime(row["DCDate"].ToString()).Year.ToString();
OneDay.DCTime = String.IsNullOrEmpty(row["DCTime"].ToString()) ? "" : Convert.ToDateTime(row["DCTime"].ToString()).ToString("HH:mm");
OneDay.AddUserCode = String.IsNullOrEmpty(row["AddUserCode"].ToString()) ? "" : row["AddUserCode"].ToString();
OneDay.AddUserName = String.IsNullOrEmpty(row["AddUserName"].ToString()) ? "" : row["AddUserName"].ToString();
OneDay.OSTAT_Code = String.IsNullOrEmpty(row["OSTAT_Code"].ToString()) ? "" : row["OSTAT_Code"].ToString();
OneDay.OSTAT_Desc = String.IsNullOrEmpty(row["OSTAT_Desc"].ToString()) ? "" : row["OSTAT_Desc"].ToString();
OneDay.OEORI_UpdateDate = String.IsNullOrEmpty(row["OEORI_UpdateDate"].ToString()) ? "" : Convert.ToDateTime(row["OEORI_UpdateDate"].ToString()).ToString("dd/MM/") + Convert.ToDateTime(row["OEORI_UpdateDate"].ToString()).Year.ToString();
OneDay.OEORI_UpdateTime = String.IsNullOrEmpty(row["OEORI_UpdateTime"].ToString()) ? "" : Convert.ToDateTime(row["OEORI_UpdateTime"].ToString()).ToString("HH:mm");
OneDayList.Add(OneDay);
}
foreach (DataRow row in dtContinue.Rows)
{
bool isOne = listARCIM_Code_Oneday.Any(s => row["ARCIM_Code"].ToString().Contains(s));
bool isCon = listARCIM_Code_Continue.Any(s => row["ARCIM_Code"].ToString().Contains(s));
// ignore (oneday or not Standing) order
if (isOne || !(isCon || row["OECPR_Desc"].ToString() == "Standing"))
{
continue;
}
Order Continue = new Order();
isCheck = listARCIM_Code.Any(s => row["ARCIM_Code"].ToString().Contains(s));
if (isCheck)
{
var data = GetQuestionAnswerModelFromAPI(row["OEORI_RowId"].ToString());
Continue.QuestionAnswerModel = data;
var test = InterSystemsProvideData.GetQuestionAnswer(row["OEORI_RowId"].ToString());
}
else
{
Continue.QuestionAnswerModel = new List <Questionaire>();
}
Continue.OEORI_RowId = String.IsNullOrEmpty(row["OEORI_RowId"].ToString()) ? "" : row["OEORI_RowId"].ToString();
Continue.OEORI_Date = String.IsNullOrEmpty(row["OEORI_Date"].ToString()) ? "" : Convert.ToDateTime(row["OEORI_Date"].ToString()).ToString("dd/MM/") + Convert.ToDateTime(row["OEORI_Date"].ToString()).Year.ToString();
Continue.ARCIM_Code = String.IsNullOrEmpty(row["ARCIM_Code"].ToString()) ? "" : row["ARCIM_Code"].ToString();
Continue.Service = String.IsNullOrEmpty(row["ARCIM_Desc"].ToString()) ? "" : row["ARCIM_Desc"].ToString();
Continue.Qty = String.IsNullOrEmpty(row["OEORI_PhQtyOrd"].ToString()) ? "" : row["OEORI_PhQtyOrd"].ToString();
Continue.Dose = String.IsNullOrEmpty(row["PHCFR_Desc2"].ToString()) ? "" : row["PHCFR_Desc2"].ToString();
DateTime dt = Convert.ToDateTime(row["OEORI_SttDat"].ToString());
Continue.StartDate = String.IsNullOrEmpty(row["OEORI_SttDat"].ToString()) ? "" : dt.ToString("dd/MM/") + dt.Year.ToString();
Continue.StartTime = String.IsNullOrEmpty(row["OEORI_SttTim"].ToString()) ? "" : Convert.ToDateTime(row["OEORI_SttTim"].ToString()).ToString("HH:mm");
Continue.OrderingClinician = String.IsNullOrEmpty(row["OrderingClinician"].ToString()) ? "" : row["OrderingClinician"].ToString();
Continue.AuthorisingClinician = String.IsNullOrEmpty(row["AuthorisingClinician"].ToString()) ? "" : row["AuthorisingClinician"].ToString();
Continue.DCUserCode = String.IsNullOrEmpty(row["DCUserCode"].ToString()) ? "" : row["DCUserCode"].ToString();
Continue.DCUserName = String.IsNullOrEmpty(row["DCUserName"].ToString()) ? "" : row["DCUserName"].ToString();
Continue.DCDate = String.IsNullOrEmpty(row["DCDate"].ToString()) ? "" : Convert.ToDateTime(row["DCDate"].ToString()).ToString("dd/MM/") + Convert.ToDateTime(row["DCDate"].ToString()).Year.ToString();
Continue.DCTime = String.IsNullOrEmpty(row["DCTime"].ToString()) ? "" : Convert.ToDateTime(row["DCTime"].ToString()).ToString("HH:mm");
Continue.AddUserCode = String.IsNullOrEmpty(row["AddUserCode"].ToString()) ? "" : row["AddUserCode"].ToString();
Continue.AddUserName = String.IsNullOrEmpty(row["AddUserName"].ToString()) ? "" : row["AddUserName"].ToString();
Continue.OSTAT_Code = String.IsNullOrEmpty(row["OSTAT_Code"].ToString()) ? "" : row["OSTAT_Code"].ToString();
Continue.OSTAT_Desc = String.IsNullOrEmpty(row["OSTAT_Desc"].ToString()) ? "" : row["OSTAT_Desc"].ToString();
Continue.OEORI_UpdateDate = String.IsNullOrEmpty(row["OEORI_UpdateDate"].ToString()) ? "" : Convert.ToDateTime(row["OEORI_UpdateDate"].ToString()).ToString("dd/MM/") + Convert.ToDateTime(row["OEORI_UpdateDate"].ToString()).Year.ToString();
Continue.OEORI_UpdateTime = String.IsNullOrEmpty(row["OEORI_UpdateTime"].ToString()) ? "" : Convert.ToDateTime(row["OEORI_UpdateTime"].ToString()).ToString("HH:mm");
ContinueList.Add(Continue);
}
ptOrder.Patient = InterSystemsProvideData.GetPatient(epiRowId);
ptOrder.OneDay = OneDayList;
ptOrder.Continue = ContinueList;
return(ptOrder);
}
