public static string GetAllergyCategory(string algName, CacheConnection con) { var cmdString = QueryString.GetAllergyCategory(algName); var result = InterSystemsDa.BindDataCommand(cmdString, con); return(result); }
public static string GetAllergyCategory(string algName) { var cmdString = QueryString.GetAllergyCategory(algName); var result = InterSystemsDa.BindDataCommand(cmdString, Constants.Cache89); return(result); }
//public static internal static bool IsImage(string hn, CacheConnection con) { var dt = InterSystemsDa.DtBindDataCommand(QueryString.GetPatientImage(hn), con); var flag = Helper.CheckPatientImage(dt); return(flag); }
public static List <Allergy> GetAllergys(string hn, CacheConnection con) { var cmdString = QueryString.GetAllergy(hn); var dtAlg = InterSystemsDa.DtBindDataCommand(cmdString, con); var results = Helper.DataTableToAllergy(dtAlg, con); return(results); }
public static IEnumerable <Appointment> GetAppointment(string hn, CacheConnection con) { List <Appointment> apps = new List <Appointment>(); var dtApp = InterSystemsDa.DtBindDataCommandWithValuesMultiple(QueryString.GetAppointments(hn), con, hn); var dtAppCur = InterSystemsDa.DtBindDataCommandWithValues(QueryString.GetAppointmentsCurrent(hn), con, hn); var dtAppPast = InterSystemsDa.DtBindDataCommandWithValuesMultiple(QueryString.GetAppointmentsPast(hn), con, hn); List <Appointment> lstApp = dtApp.ToList <Appointment>(); List <Appointment> lstAppCur = dtAppCur.ToList <Appointment>(); List <Appointment> lstAppPast = dtAppPast.ToList <Appointment>(); var results = lstApp.Concat(lstAppCur).Concat(lstAppPast); foreach (var item in results) { var tupleDatetime = string.IsNullOrEmpty(item.AS_Date) ? new Tuple <string, string>("", "") : new Tuple <string, string>(item.AS_Date, item.AS_SessStartTime); var datetimeString = Helper.ConvertToISO_8601(tupleDatetime.Item1, tupleDatetime.Item2); var datetime = DateTime.Parse(datetimeString); Appointment app = new Appointment() { APPT_Status = item.APPT_Status, AS_Date = datetime.ToString("dd/MM/yyyy"), AS_SessStartTime = datetime.ToString("HH:mm"), CTLOC_Code = item.CTLOC_Code, CTLOC_Desc = item.CTLOC_Desc, CTPCP_Desc = item.CTPCP_Desc, PAADM_VisitStatus = item.PAADM_VisitStatus, SER_Desc = item.SER_Desc }; apps.Add(app); } try { apps = apps.OrderByDescending(a => string.IsNullOrEmpty(a.AS_Date) ? (DateTime?)null : DateTime.ParseExact(a.AS_Date, "dd/MM/yyyy", null)) .ThenByDescending(a => string.IsNullOrEmpty(a.AS_SessStartTime) ? (DateTime?)null : DateTime.ParseExact(a.AS_SessStartTime, "HH:mm", null)).ToList(); } catch (Exception) { return(apps); } return(apps); }
public static Episode GetEpisode(string hn, CacheConnection con) { Episode epi = new Episode(); var dtEpiIn = InterSystemsDa.DtBindDataCommand(QueryString.GetEpisodeInquiry(hn), con); if (dtEpiIn.Rows.Count > 0) { epi = Helper.DataTableToEpisode(dtEpiIn, con); } else { epi.EpisodeInquiry = new List <EpisodeInquiry>(); } return(epi); }
public static Tuple <bool, PatientImage> GetPatientImage(string hn, CacheConnection con) { try { var ptImg = new PatientImage(); var dt = InterSystemsDa.DtBindDataCommand(QueryString.GetPatientImage(hn), con); var isImage = Helper.CheckPatientImage(dt); //ptImg.Image = isImage ? Helper.DataTableToBase64(dt, 500, 500) : ""; return(new Tuple <bool, PatientImage>(isImage, ptImg)); } catch (Exception) { return(new Tuple <bool, PatientImage>(false, new PatientImage())); } }
public static Episode DataTableToEpisode(DataTable dtEpiIn, CacheConnection con) { var epi = new Episode(); var epiInqList = new List <EpisodeInquiry>(); foreach (DataRow row in dtEpiIn.Rows) { var PAADM_ADMNo = row["PAADM_ADMNo"].ToString(); var epiInq = new EpisodeInquiry() { PAADM_ADMNo = PAADM_ADMNo, PAADM_AdmDate = ConvertDate(row["PAADM_AdmDate"].ToString()), PAADM_AdmTime = ToDateTime(row["PAADM_AdmTime"].ToString()).ToString("HH:mm"), CTLOC_Code = row["CTLOC_Code"].ToString(), CTLOC_Desc = row["CTLOC_Desc"].ToString(), CTPCP_Code = row["CTPCP_Code"].ToString(), CTPCP_Desc = row["CTPCP_Desc"].ToString(), PAADM_Type = row["PAADM_Type"].ToString(), PAADM_VisitStatus = row["PAADM_VisitStatus"].ToString(), WARD_Code = row["WARD_Code"].ToString(), WARD_Desc = row["WARD_Desc"].ToString(), ROOM_Code = row["ROOM_Code"].ToString() }; var dtIcd10 = InterSystemsDa.DtBindDataCommand(QueryString.GetIcd10(epiInq.PAADM_ADMNo), con); var dtIcd9 = InterSystemsDa.DtBindDataCommand(QueryString.GetIcd9(epiInq.PAADM_ADMNo), con); epiInq.ICD10 = DataTableToIcd10(dtIcd10); epiInq.ICD9 = DataTableToIcd9(dtIcd9); epiInq.AppConsults = InterSystemsDa.GetApptConsult(PAADM_ADMNo, con); epiInqList.Add(epiInq); } epi.EpisodeInquiry = epiInqList; return(epi); }
public static string GetLastEpisode(string hn) { var epiNo = InterSystemsDa.BindDataCommand(QueryString.GetLastEpisode(hn), Constants.Cache89); return(epiNo); }
public static string GetHn(string epiNo) { var hn = InterSystemsDa.BindDataCommand(QueryString.GetPatientHn(epiNo), Constants.Cache89); return(hn); }