public string AutoCompleteGetAllOrderSet(string docName) { Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls(); var result = (from dn in ws.GetAllOrderSet(docName).AsEnumerable() where dn.Field <string>("ARCOS_Desc").ToLower().Contains(docName.ToLower()) || dn.Field <string>("ARCOS_Code").ToLower().Contains(docName.ToLower()) select new { desc = dn.Field <string>("ARCOS_Code") + "|,|" + dn.Field <string>("ARCOS_Desc") + "|,|" + dn.Field <string>("ARCIC_Desc") } ).ToList(); string tmpStr = string.Empty; string tmpConj = "<,>"; var result2 = (from t1 in result select t1.desc).ToList(); foreach (object st in result2) { tmpStr = tmpStr + HttpContext.Current.Server.HtmlEncode(st.ToString()) + tmpConj; //tmpStr = tmpStr + HttpContext.Current.Server.HtmlDecode(st.ToString()) + tmpConj; } if (!string.IsNullOrEmpty(tmpStr)) { tmpStr.Substring(1, tmpStr.Length - tmpConj.Length); } return(tmpStr); }
public string AutoCompleteReqDoc(string docName) { docName = docName.ToLower(); Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls(); var a = from dn in ws.GetCareprovider("").AsEnumerable() select dn; var result = (from dn in ws.GetCareprovider("").AsEnumerable() where dn.Field <string>("DoctorName").ToLower().Contains(docName) || dn.Field <string>("CTPCP_Desc").ToLower().Contains(docName) || dn.Field <string>("CTPCP_Code").ToLower().Contains(docName) select new docdata { DocNameE = dn.Field <string>("CTPCP_Desc"), DocNameT = dn.Field <string>("DoctorName"), DocCode = dn.Field <string>("CTPCP_Code") }).ToList(); string tmpStr = string.Empty; string tmpConj = "<,>"; foreach (docdata st in result) { string[] temp = st.DocNameE.Split('/'); tmpStr += st.DocCode + "/" + st.DocNameT + "/" + (temp != null ? temp[0] : "") + tmpConj; //+ st.DocCode+"," } if (!string.IsNullOrEmpty(tmpStr)) { tmpStr.Substring(1, tmpStr.Length - tmpConj.Length); } return(tmpStr); }
protected void btnVerify_Click(object sender, EventArgs e) { Service.WS_TrakcareCls wsVerify = new Service.WS_TrakcareCls(); DataTable dtVerify = wsVerify.GetAllAllergyByHN_NameDob(txtHN.Text.Trim(), txtName.Text.Trim(), txtBirthDate.Text.Trim()); DataTable dtHistory = clsEX.get_history_verify(txtHN.Text.Trim()); if (dtVerify != null) { if (!(dtVerify.Rows.Count).Equals(0)) { if (dtHistory.Rows.Count >= 1) { Session["HN"] = txtHN.Text.Trim(); Session["Name"] = dtVerify.Rows[0]["TTL_Desc"].ToString() + " " + dtVerify.Rows[0]["PAPMI_Name"].ToString() + " " + dtVerify.Rows[0]["PAPMI_Name2"].ToString(); ////Session["Allergy"] = ut.resultAllergy(dtVerify); Response.Redirect("~/web/frm_verify_result.aspx"); } else { lblWarningVerify.Text = "No Verfify Patient"; } } else { lblWarningVerify.Text = "No Verfify Patient"; } } }
public List <DoctorProfile> GetDoctorData() { List <DoctorProfile> DocName = new List <DoctorProfile>(); try { using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { DataTable dt = ws.GetCareprovider(""); if (dt != null) { var result = dt.AsEnumerable().Where(x => x.Field <string>("SSUSR_Initials") != null && x.Field <string>("CTPCP_Desc") != null) .Select(x => new DoctorProfile { SSUSR_Initials = x.Field <string>("SSUSR_Initials"), CTPCP_Desc = x.Field <string>("CTPCP_Desc"), CTPCP_Code = x.Field <string>("CTPCP_Code"), CTPCP_SMCNo = x.Field <string>("CTPCP_SMCNo") }).ToList(); result.Insert(0, new DoctorProfile { SSUSR_Initials = "", CTPCP_Desc = "", CTPCP_Code = "", CTCPT_Desc = "", DoctorName = "", CTPCP_SMCNo = "" }); DocName = result.ToList(); } } return(DocName); } catch { return(DocName); } }
public string GetByHN(string hn) { try { using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { DataTable dt = ws.GetAllergyByHN(hn); string StrAllery = ""; foreach (DataRow dr in dt.Rows) { if (StrAllery == "") { StrAllery = dr["AlgEng_Desc"].ToString(); } else { StrAllery += Environment.NewLine + dr["AlgEng_Desc"].ToString(); } } if (StrAllery == "") { StrAllery = "No Know Allergy"; } return(StrAllery); } } catch (Exception ex) { Program.MessageError("FunctionDataCls", "GetAllergyByHN(String HN)", ex, false); return(""); } }
public byte[] getByWebService(string hn) { try { using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { var img = ws.GetPTImageByHN(hn).AsEnumerable().Select(x => x.Field <byte[]>("docData")).FirstOrDefault(); if (img != null) { return(img); } else { MemoryStream ms = new MemoryStream(); Properties.Resources.no_image.Save(ms, System.Drawing.Imaging.ImageFormat.Png); return(ms.ToArray()); } } } catch { MemoryStream ms = new MemoryStream(); Properties.Resources.no_image.Save(ms, System.Drawing.Imaging.ImageFormat.Png); return(ms.ToArray()); } }
public StatusTransaction WS_GetPTPackageAllStation(ref List <StationStatus> list_StationStatus, int tpr_id) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { trn_patient_regi patient_regis = cdc.trn_patient_regis.Where(x => x.tpr_id == tpr_id).FirstOrDefault(); int en_rowid = Convert.ToInt32(patient_regis.tpr_en_rowid); using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { var result_datatable = ws.GetPTPackage(en_rowid).AsEnumerable(); var result = result_datatable .Where(x => (x.Field <string>("OSTAT_Code") == "V" || x.Field <string>("OSTAT_Code") == "E") && x.Field <string>("ARCOS_RowId") != null) .Select(x => new EntityGetPTPackage { ARCOS_RowId = x.Field <string>("ARCOS_RowId"), ARCOS_Code = x.Field <string>("ARCOS_Code"), ARCOS_Desc = x.Field <string>("ARCOS_Desc"), ARCIM_RowId = x.Field <string>("ARCIM_RowId"), ARCIM_Code = x.Field <string>("ARCIM_Code"), ARCIM_Desc = x.Field <string>("ARCIM_Desc"), OEORI_LabTestSetRow = x.Field <string>("OEORI_LabTestSetRow"), OEORI_AccessionNumber = x.Field <string>("OEORI_AccessionNumber"), ARCIM_Text1 = x.Field <string>("ARCIM_Text1"), OSTAT_Code = x.Field <string>("OSTAT_Code") }).ToList(); var grpStatus = result.GroupBy(x => x.OSTAT_Code); List <StationStatus> list_station = new List <StationStatus>(); foreach (var grp in grpStatus) { foreach (var item in grp) { List <int> _mvt_id = cdc.mst_order_plans.Where(x => x.mop_item_row_id == item.ARCIM_RowId).Select(x => x.mvt_id).ToList(); foreach (int val in _mvt_id) { list_station.Add(new StationStatus { mvt_id = val, status = grp.Key }); } } } list_StationStatus = list_station.GroupBy(x => x.mvt_id).Select(x => new StationStatus { mvt_id = x.Key, status = x.Any(y => y.status == "E") ? "E" : "V" }).ToList(); return(StatusTransaction.True); } } } catch (Exception ex) { Program.MessageError("GetDataFromWSTrakCare", "GetPatientAllStation", ex, false); return(StatusTransaction.Error); } }
public List <string> AutoCompleteReqDoc(string txt) { Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls(); List <string> result = (from t in ws.GetCareprovider(txt).AsEnumerable() where t.Field <string>("DoctorName").Contains(txt) select t.Field <string>("DoctorName")).ToList(); return(result); }
public ActionResult Main(MasterPackageModel model) { try { using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { PackageInformationModel pi = new PackageInformationModel(); pi.string_search = model.string_search; pi.listPackageInformation = ws.GetAllOrderSet(pi.string_search).AsEnumerable() .Where(x => x.Field <string>("ARCOS_Code") != null && x.Field <string>("ARCOS_Code").Trim() != "" && x.Field <string>("ARCOS_Desc") != null && x.Field <string>("ARCOS_Desc").Trim() != "") .Select(x => new PackageInformation { package_code = x.Field <string>("ARCOS_Code"), package_name = x.Field <string>("ARCOS_Desc") }).Distinct() .ToList(); if (pi.listPackageInformation.Count == 0) { return(View(model)); } else { return(View("PackageList", pi)); } } //using (InhCheckupDataContext cdc = new InhCheckupDataContext()) //{ // PackageInformationModel pi = new PackageInformationModel(); // pi.string_search = model.string_search; // pi.listPackageInformation = cdc.trn_patient_order_sets // .Where(x => x.tos_od_set_code.ToUpper().StartsWith(model.string_search.ToUpper())) // .Select(x => new PackageInformation // { // package_code = x.tos_od_set_code, // package_name = x.tos_od_set_name // }).Distinct() // .ToList(); // if (pi.listPackageInformation.Count == 0) // { // return View(model); // } // else // { // return View("PackageList", pi); // } //} } catch { return(View(model)); } }
public List <CheckupLab> Get(string hn, DateTime dateFrom, DateTime dateTo) { try { using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { var result = ws.GetCheckupLab(hn, dateFrom.ToString("yyyy-MM-dd"), dateTo.ToString("yyyy-MM-dd")).AsEnumerable(); return(result.Select(x => new CheckupLab { rowid = x.Field <string>("EPVISVisitNumber"), hn = x.Field <string>("DBT_CDE"), en = x.Field <string>("EPI_NO"), age = Convert.ToInt32(x.Field <string>("EPVIS_AGE")), sex = x.Field <string>("EPVIS_SEX") == "Male" ? "M" : x.Field <string>("EPVIS_SEX") == "Female" ? "F" : "", lab_date = new DateTime( Convert.ToInt32(x.Field <string>("EPIVISDateOfCollection").Substring(0, 4)), Convert.ToInt32(x.Field <string>("EPIVISDateOfCollection").Substring(5, 2)), Convert.ToInt32(x.Field <string>("EPIVISDateOfCollection").Substring(8, 2)), (int)(Convert.ToInt32(x.Field <string>("EPIVISTimeOfCollection")) / 60), (int)(Convert.ToInt32(x.Field <string>("EPIVISTimeOfCollection")) % 60), 0 ), head_lab_code = x.Field <string>("CTTS_CDE"), head_lab_desc = x.Field <string>("CTTS_NME"), lab_code = x.Field <string>("CTTC_CDE"), lab_desc = x.Field <string>("CTTC_DES"), lab_value_number = x.Field <string>("CTTC_RSL_FMT").Contains("N") && x.Field <string>("TST_DTA").Trim().Length > 0 ? x.Field <string>("TST_DTA").Trim().Substring(0, 1) == "." ? "0" + x.Field <string>("TST_DTA") : x.Field <string>("TST_DTA") : x.Field <string>("TST_DTA"), lab_value_string = x.Field <string>("RSL") == null || x.Field <string>("RSL").Trim() == "" ? null : x.Field <string>("RSL").Trim(), lab_unit = x.Field <string>("CTTC_UNT"), lab_range = x.Field <string>("NML"), lab_hl = x.Field <string>("HL") == "H" ? 1 : x.Field <string>("HL") == "L" ? -1 : 0, lab_frs = x.Field <string>("CTTC_RSL_FMT").Contains("N") ? 1 : x.Field <string>("CTTC_RSL_FMT") == "S" ? 2 : x.Field <string>("CTTC_RSL_FMT") == "X" ? 0 : -1, status = x.Field <string>("Status") == "Executed" ? 'E' : 'I', site_code = x.Field <string>("CTHOS_CDE"), lab_seq = (x.Field <string>("Sequen") == null || x.Field <string>("Sequen") == "") ? (int?)null : !IsNumeric(x.Field <string>("Sequen")) ? (int?)null : Convert.ToInt32(x.Field <string>("Sequen")) }).ToList()); } } catch (Exception ex) { throw ex; } }
public trn_basic_measure_hdr getBasicHdr(string hn, string en) { string rvisual_out_lens = null; string lvisual_out_lens = null; string rvisual_with_lens = null; string lvisual_with_lens = null; DateTime dateNow = Program.GetServerDateTime(); using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { DataSet ds = ws.GetvitalSign(en); if (ds != null) { if (ds.Tables.Count > 0) { string WithContactLens = ds.Tables[0].Rows[0]["WithContactLens"] == null ? "" : ds.Tables[0].Rows[0]["WithContactLens"].ToString(); if (WithContactLens == "N") { rvisual_out_lens = ds.Tables[0].Rows[0]["VisionRt"].ToString(); lvisual_out_lens = ds.Tables[0].Rows[0]["VisionLt"].ToString(); } else if (WithContactLens == "Y") { rvisual_with_lens = ds.Tables[0].Rows[0]["VisionRt"].ToString(); lvisual_with_lens = ds.Tables[0].Rows[0]["VisionLt"].ToString(); } } } } trn_basic_measure_hdr tbm = new trn_basic_measure_hdr { tbm_appearance = "GD", tbm_arrive = "WK", tbm_create_by = "System", tbm_create_date = dateNow, tbm_precaution = "SDP", tbm_purpose = 'W', tbm_triage = '5', tbm_type = 'N', tbm_update_by = "System", tbm_update_date = dateNow, tbm_vision_lvisual_out_lens = lvisual_out_lens, tbm_vision_lvisual_with_lens = lvisual_with_lens, tbm_vision_rvisual_out_lens = rvisual_out_lens, tbm_vision_rvisual_with_lens = rvisual_with_lens }; tbm.trn_basic_measure_dtls.AddRange(getVitalSign(hn, en)); return(tbm); }
public EnumerableRowCollection <DataRow> GetPTPackage(int enRowID) { try { using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { return(ws.GetPTPackage(enRowID).AsEnumerable()); } } catch (Exception ex) { Class.globalCls.MessageError("GetPTPackageCls", "GetPTPackage(int enRowID)", ex.Message); return(null); } }
public List <trn_basic_measure_dtl> getVitalSign(string hn, string en) { using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { var result = getVitalSignByHN(hn); if (result != null) { trn_basic_measure_dtl dtl = result.OrderByDescending(x => x.tbd_date).FirstOrDefault(); return(new List <trn_basic_measure_dtl> { dtl }); } return(new List <trn_basic_measure_dtl>()); } }
private bool getUser(LogOnModel model) { using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { DataTable dt = ws.LogonTrakcare(model.UserName, model.Password); if (dt.Rows.Count >= 1) { Session["username"] = dt.Rows[0].Field <string>("USERID"); return(true); } else { return(false); } } }
public string ByGetAllergyByHN(string hn) { try { using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { var result = ws.GetAllergyByHN(hn).AsEnumerable(); var strs = result.Select(x => x.Field <string>("AlgEng_Desc")).Where(x => x != null && x.Trim() != "").ToList(); return(string.Join(Environment.NewLine, strs)); } } catch (Exception ex) { Class.globalCls.MessageError("GetAllergyCls", "ByGetAllergyByHN", ex.Message); throw ex; } }
public void processAll(string SourcePath, string LocalPath, string LocalPathSuccess, string LocalPathError, string LocalPathLog, DateTime dateNow, string LocalPathRerun, string IsRerun, string LocalPathOtherLocation, Boolean IsLoadDatafromWebservice) { //Step 1 : DTS from Flat file to SQL Server DateTime DTCurrent = DateTime.Now; char[] delimiter = { '|' }; string formatDate = "yyyy-MM-dd"; Service.WS_TrakcareCls ws_trak = new Service.WS_TrakcareCls(); DataTable dtArr = ws_trak.GetPTArrivedIncaseFlatFileNotGen(dateNow.ToString(formatDate)); foreach (DataRow drArr in dtArr.Rows) { string EN = string.Empty; string Location = string.Empty; int res = 0; try { Location = string.Empty; EN = drArr["PAADM_ADMNo"].ToString(); Location = drArr["CTLOC_Code"].ToString(); if (EN != string.Empty) { res = serviceGetPTArrivedCheckupFilter(Location, EN, dateNow); } if (res == 1) //success { string PathSuccess = LocalPathSuccess + DateTime.Now.ToString(formatDate); string FileSuccess = PathSuccess + "\\" + EN + "_S_" + Location + ".txt"; if (!Directory.Exists(PathSuccess)) { Directory.CreateDirectory(PathSuccess); } if (!File.Exists(FileSuccess)) { File.AppendAllText(FileSuccess, "Success : DateTime = " + DateTime.Now.ToString()); } } } catch (Exception ex) { } } }
protected void btnRetrieve_Click(object sender, EventArgs e) { lbAlert.Text = ""; txtUserLogin.Text = txtUserLogin.Text.Trim(); if (txtUserLogin.Text.Length > 0) { Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls(); DataTable dt = ws.getUser(txtUserLogin.Text); if (dt.Rows.Count > 0) { txtUserLogin.Text = dt.Rows[0]["SSUSR_Initials"].ToString(); string name = dt.Rows[0]["SSUSR_Name"].ToString(); if (name.Length > 0) { var sName = name.Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries); txtFirstName.Text = sName.FirstOrDefault(); txtLastName.Text = sName.LastOrDefault(); //txtFirstName.Text = name.Substring(0, name.IndexOf(" ")).Trim(); //txtLastName.Text = name.Substring(name.IndexOf(" ")).Trim(); } else { lbAlert.Text = "Unknown User's Name."; txtFirstName.Text = ""; txtLastName.Text = ""; } chActive.Checked = true; } else { lbAlert.Text = "User Not Found."; txtFirstName.Text = ""; txtLastName.Text = ""; chActive.Checked = false; } } else { lbAlert.Text = "Please Insert Username."; txtFirstName.Text = ""; txtLastName.Text = ""; chActive.Checked = false; } }
private EnumerableRowCollection <DataRow> retrieveVitalSign(string hn) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { List <string> checkupCode = cdc.mst_hpc_sites.Where(x => x.mhs_status == 'A' && x.mhs_other_clinic == false).Select(x => x.mhs_code).ToList(); using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { var result = ws.GetVitalSignByHN(hn).AsEnumerable(); var a = result.Where(x => checkupCode.Contains(x.Field <string>("CTLOC_Code"))).ToList(); return(result); } } } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable genTableListPaymentAgreement(string payor) { Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls(); DataTable dt = ws.ListPaymentAgreement(payor); // string tmpStr = "<td>No.</td><td>Code</td><td>Desc</td><td>...</td>"; //string tmpStr = ""; ////int i = 0; //string strsplit = ""; //foreach (DataRow dr in dt.Rows) //{ // tmpStr +=strsplit + dr["AUXIT_Code"].ToString() +","+ dr["AUXIT_Desc"].ToString().Replace(",","|x|"); // strsplit = "|*|"; // //tmpStr += "<tr><td>" + (i + 1).ToString() + "</td><td>" + dr["AUXIT_Code"].ToString() + "</td>"; // //tmpStr += "<td>" + dr["AUXIT_Desc"].ToString() + "</td>"; // //tmpStr += "<td><button type='button' id='btnTest' onclick='delRowPayAgree(" + i.ToString() + ")'>X</button></td></tr>"; // //i++; //} return(dt); }
public List <trn_out_department> getOutDepartment(string hn, string siteCode, DateTime date) { DateTime dateNow = Program.GetServerDateTime(); using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { var result = ws.getApptByHN(hn, siteCode, date.ToString("yyyy-MM-dd")).AsEnumerable(); List <trn_out_department> tod = result.Select(x => new trn_out_department { tod_desc = x.Field <string>("SER_Desc"), tod_location = x.Field <string>("CTLOC_Desc"), tod_start_date = convToDateTime(x.Field <TimeSpan>("AS_SessStartTime"), x.Field <DateTime>("AS_Date")), tod_create_by = null, tod_create_date = dateNow, tod_update_by = null, tod_update_date = dateNow }).ToList(); return(tod); } }
private string GetAllergyByHN(String HN) { try { Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls(); DataTable dt = ws.GetAllAllergyByHN(HN); List <string> allery = dt.AsEnumerable().Select(x => x.Field <string>("Allergy")).ToList(); if (allery != null && allery.Count() > 0) { return(string.Join(Environment.NewLine, allery)); } return("No Know Allergy"); } catch (Exception ex) { Program.MessageError("RetrieveArrivedCls", "GetAllergyByHN", ex, false); return(""); } }
private string getPackageName(string package_code) { try { using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { return(ws.GetAllOrderSet(package_code).AsEnumerable() .Where(x => x.Field <string>("ARCOS_Code") != null && x.Field <string>("ARCOS_Code").Trim() != "" && x.Field <string>("ARCOS_Desc") != null && x.Field <string>("ARCOS_Desc").Trim() != "") .Select(x => x.Field <string>("ARCOS_Desc")).FirstOrDefault()); //return cdc.trn_patient_order_sets // .Where(x => x.tos_od_set_code == package_code) // .Select(x => x.tos_od_set_name) // .FirstOrDefault(); } } catch { return(""); } }
public byte[] ByGetPTImageByHN(string hn) { try { using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { var img = ws.GetPTImageByHN(hn).AsEnumerable().Select(x => x.Field <byte[]>("docData")).FirstOrDefault(); if (img == null) { System.IO.MemoryStream ms = new System.IO.MemoryStream(); Properties.Resources.no_image.Save(ms, System.Drawing.Imaging.ImageFormat.Png); return(ms.ToArray()); } return(img); } } catch (Exception ex) { Class.globalCls.MessageError("GetPatientImageCls", "ByGetPTImageByHN", ex.Message); throw ex; } }
private bool Login1(string strUsername, string strPassword) { Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls(); DataTable dt = ws.LogonTrakcare(strUsername, strPassword); if (dt.Rows.Count > 0) { using (InhToDoListDataContext dbc = new InhToDoListDataContext()) { var objcurrentuser = (from t1 in dbc.mst_user_logins where t1.mul_user_login == strUsername select t1).FirstOrDefault(); if (objcurrentuser != null && (objcurrentuser.mul_user_login == "Admin" && strPassword == "nimd@")) { Constant.CurrentUserLogin = strUsername; return(true); } else { Constant.CurrentUserLogin = ""; return(false); } } } else { if (strUsername == "Admin" && strPassword == "nimd@") { Constant.CurrentUserLogin = strUsername; return(true); } else { Constant.CurrentUserLogin = ""; return(false); } } }
public byte[] GetImageByWS(string hn) { try { using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { var img = ws.GetPTImageByHN(hn).AsEnumerable().Select(x => x.Field <byte[]>("docData")).FirstOrDefault(); if (img == null) { return(GetDefaultImage()); } else { return(img); } } } catch (Exception ex) { Program.MessageError("GetPatientImageCls", "GetImageByWS(string hn)", ex, false); return(GetDefaultImage()); } }
public List <trn_basic_measure_dtl> getVitalSignByHN(string hn) { using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { DateTime dateNow = Program.GetServerDateTime(); DataTable dt = ws.GetVitalSignByHN(hn); if (dt != null) { if (dt.Rows.Count > 0) { List <trn_basic_measure_dtl> bmDtl = new List <trn_basic_measure_dtl>(); var result = dt.AsEnumerable() .GroupBy(x => x.Field <DateTime>("OBS_Date").Add(x.Field <TimeSpan>("OBS_Time"))) .OrderByDescending(x => x.Key) .Take(5); foreach (var re in result) { trn_basic_measure_dtl dtl = new trn_basic_measure_dtl(); foreach (var item in re) { int itemNo = item.Field <int>("OBS_Item_DR"); switch (itemNo) { case 230: dtl.tbd_weight = item.Field <string>("OBS_Value"); break; case 231: dtl.tbd_height = item.Field <string>("OBS_Value"); break; case 11: dtl.tbd_temp = item.Field <string>("OBS_Value"); break; case 129: dtl.tbd_systolic = item.Field <string>("OBS_Value"); break; case 128: dtl.tbd_diastolic = item.Field <string>("OBS_Value"); break; case 9: dtl.tbd_pulse = item.Field <string>("OBS_Value"); break; case 10: dtl.tbd_rr = item.Field <string>("OBS_Value"); break; case 134: dtl.tbd_bmi = item.Field <string>("OBS_Value"); break; case 176: dtl.tbd_waist = item.Field <string>("OBS_Value"); break; case 173: dtl.tbd_vision_lt = item.Field <string>("OBS_Value"); break; case 174: dtl.tbd_vision_rt = item.Field <string>("OBS_Value"); break; case 281: dtl.tbd_vision_with_lens = (item.Field <string>("OBS_Value") == "Y" || item.Field <string>("OBS_Value") == "y") ? true : false; break; } } dtl.tbd_date = re.Key; dtl.tbd_create_by = Program.CurrentUser.mut_username; dtl.tbd_create_date = dateNow; dtl.tbd_update_by = Program.CurrentUser.mut_username; dtl.tbd_update_date = dateNow; bmDtl.Add(dtl); } return(bmDtl); } } } return(null); }
public bool GetInfo(int tpr_id) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { trn_patient_regi patient_regis = cdc.trn_patient_regis.Where(x => x.tpr_id == tpr_id).FirstOrDefault(); string hn = patient_regis.trn_patient.tpt_hn_no; using (Service.WS_TrakcareCls ws_trak = new Service.WS_TrakcareCls()) { var info = ws_trak.GetPTInfoByHN(hn).AsEnumerable() .Select(x => new { PAPMI_No = x.Field <string>("PAPMI_No"), PAPMI_DOB = x.Field <DateTime>("PAPMI_DOB"), PAPMI_Name = x.Field <string>("PAPMI_Name"), PAPMI_Name2 = x.Field <string>("PAPMI_Name2"), PAPMI_Name3 = x.Field <string>("PAPMI_Name3"), PAPMI_Name5 = x.Table.Columns.Contains("PAPMI_Name5") ? x.Field <string>("PAPMI_Name5") : "", PAPMI_Name6 = x.Table.Columns.Contains("PAPMI_Name6") ? x.Field <string>("PAPMI_Name6") : "", PAPMI_Name7 = x.Table.Columns.Contains("PAPMI_Name7") ? x.Field <string>("PAPMI_Name7") : "", PAPER_PrefLanguage_DR = x.Field <int>("PAPER_PrefLanguage_DR"), PAPER_AgeYr = x.Field <string>("PAPER_AgeYr"), PAPER_AgeMth = x.Field <string>("PAPER_AgeMth"), PAPER_AgeDay = x.Field <string>("PAPER_AgeDay"), TTL_Desc = x.Field <string>("TTL_Desc"), CTSEX_Code = x.Field <string>("CTSEX_Code"), CTSEX_Desc = x.Field <string>("CTSEX_Desc"), PAPMI_DOB1 = x.Field <DateTime>("PAPMI_DOB1"), PAPMI_DOB_TEXT = x.Field <string>("papmi_dob_text"), PAPER_StName = x.Field <string>("PAPER_StName"), CTZIP_Code = x.Field <string>("CTZIP_Code"), CTZIP_Desc = x.Field <string>("CTZIP_Desc"), CTNAT_Desc = x.Field <string>("CTNAT_Desc"), //addby Artist 18/01/2016 Area = x.Field <string>("Area"), City = x.Field <string>("City"), Province = x.Field <string>("Province") }).FirstOrDefault(); string[] dobText = info.PAPMI_DOB_TEXT.Split('-'); string dobString = ""; if (dobText.Count() == 3) { dobString = dobText[2] + "/" + dobText[1] + "/" + dobText[0]; } patient_regis.trn_patient.tpt_dob_text = dobString; patient_regis.trn_patient.tpt_hn_no = info.PAPMI_No; patient_regis.trn_patient.tpt_dob = info.PAPMI_DOB; patient_regis.trn_patient.tpt_pre_name = info.TTL_Desc; patient_regis.trn_patient.tpt_first_name = info.PAPMI_Name; patient_regis.trn_patient.tpt_last_name = info.PAPMI_Name2; patient_regis.trn_patient.tpt_gender = info.CTSEX_Code == "M" ? 'M' : 'F'; patient_regis.trn_patient.tpt_nation_desc = info.CTNAT_Desc; //addby Artist 18/01/2016 patient_regis.tpr_main_address = info.PAPER_StName; patient_regis.tpr_main_tumbon = info.Area; patient_regis.tpr_main_amphur = info.City; patient_regis.tpr_main_province = info.Province; patient_regis.tpr_other_address = info.PAPER_StName; patient_regis.tpr_other_tumbon = info.Area; patient_regis.tpr_other_amphur = info.City; patient_regis.tpr_other_province = info.Province; // patient_regis.tpr_main_zip_code = info.CTZIP_Code; patient_regis.tpr_other_zip_code = info.CTZIP_Code; patient_regis.trn_patient.tpt_en_name1 = info.PAPMI_Name5; patient_regis.trn_patient.tpt_en_name2 = info.PAPMI_Name6; patient_regis.trn_patient.tpt_en_name3 = info.PAPMI_Name7; //update image add by m 08/05/2017 dd/mm/yyyy patient_regis.trn_patient.tpt_image = new APITrakcare.GetPatientImageCls().GetImageByWS(info.PAPMI_No); try { string tname = string.IsNullOrEmpty(info.TTL_Desc) ? "" : info.TTL_Desc.Trim(); string fname = string.IsNullOrEmpty(info.PAPMI_Name) ? "" : " " + info.PAPMI_Name.Trim(); string mname = string.IsNullOrEmpty(info.PAPMI_Name3) ? "" : " " + info.PAPMI_Name3.Trim(); string lname = string.IsNullOrEmpty(info.PAPMI_Name2) ? "" : " " + info.PAPMI_Name2.Trim(); string fullname = (tname + fname + mname + lname).Trim(); patient_regis.trn_patient.tpt_fullname = fullname; patient_regis.trn_patient.tpt_othername = fullname; } catch (Exception ex) { try { string tname = string.IsNullOrEmpty(info.TTL_Desc) ? "" : info.TTL_Desc.Trim(); string fname = string.IsNullOrEmpty(info.PAPMI_Name) ? "" : " " + info.PAPMI_Name.Trim(); string lname = string.IsNullOrEmpty(info.PAPMI_Name2) ? "" : " " + info.PAPMI_Name2.Trim(); string fullname = (tname + fname + lname).Trim(); patient_regis.trn_patient.tpt_othername = fullname; } catch { } Program.MessageError("GetDataFromTrakCare", "tpt_fullname", ex, false); } cdc.SubmitChanges(); } } return(true); } catch { } return(false); }
private void CallWebservice() //grid view diagnosis { if (Program.CurrentRegis != null) { using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { using (InhCheckupDataContext dbc = new InhCheckupDataContext()) { int tprid = Program.CurrentRegis.tpr_id; trn_patient_regi currentRegis = (from t1 in dbc.trn_patient_regis where t1.tpr_id == tprid select t1).FirstOrDefault(); if (currentRegis != null) { string HNno = currentRegis.trn_patient.tpt_hn_no; string ENno = currentRegis.tpr_en_no; string Doctorcode = Program.CurrentUser.mut_username; var currentobsChief = (trn_obstetric_chief)bsObstestricChief.Current; DataTable dt = ws.GetDiagnosisByDoctor("01-92-006363", "O01-12-876565", "001915668");//(HNno, ENno, Doctorcode); // gvDiagnosis.AutoGenerateColumns = false; foreach (DataRow dr in dt.Rows) { bsObstetricDiag.AddNew(); var pa = (trn_obstetric_diag)bsObstetricDiag.Current; pa.toc_id = currentobsChief.toc_id; pa.obg_diag_code = dr["MRCID_Code"].ToString(); pa.obg_diag_desc = dr["MRCID_Desc"].ToString(); pa.obg_diag_type = dr["DTYP_Desc"].ToString(); pa.obg_diag_date = Convert.ToDateTime(dr["MRDIA_Date"]); pa.obg_create_by = Program.CurrentUser.mut_username; pa.obg_update_by = pa.obg_create_by; pa.obg_create_date = Program.GetServerDateTime(); pa.obg_update_date = pa.obg_create_date; } //gvDiagnosis.DataSource = dt; //TakeCare 2016 //DataTable dt2 = ws.GetMedicineByDoctor("01-92-006363", "O01-12-876565", "001915668");//(HNno, ENno, Doctorcode);// //gvMedicationTreatment.AutoGenerateColumns = false; //foreach (DataRow dr in dt2.Rows) //{ // bsObstetricMed.AddNew(); // var pa = (trn_obstetric_med)bsObstetricMed.Current; // pa.toc_id = currentobsChief.toc_id; // pa.obm_med_code = dr["ARCIM_Code"].ToString(); // pa.obm_med_desc = dr["ARCIM_Desc"].ToString(); // pa.obm_desc = dr["PHCFR_Desc1"].ToString(); // pa.obm_qty = dr["OEORI_DoseQty"].ToString(); // pa.obm_unit = dr["CTUOM_Desc2"].ToString(); // pa.obm_eat_unit = dr["PHCIN_Desc1"].ToString(); // pa.obm_create_by = Program.CurrentUser.mut_username; // pa.obm_update_by = pa.obm_create_by; // pa.obm_create_date = Program.GetServerDateTime(); // pa.obm_update_date = pa.obm_create_date; //} // gvMedicationTreatment.DataSource = dt2; } } } } }
//end suriya 18/03/2015 public int serviceGetPTArrivedCheckupFilter(string SiteCode, string en, DateTime dateNow) { try { SiteCode = returnMainSite(SiteCode);//add suriya 15/08/2016 using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { if (cdc.tmp_getptarriveds.Any(t => t.paadm_admno == en && t.ctloc_code == SiteCode))//add suriya 24/03/2015 { return(-1); } Service.WS_TrakcareCls ws_trak = new Service.WS_TrakcareCls(); var result = ws_trak.GetPTArrivedCheckUpFilter(SiteCode, en, dateNow.ToString("yyyy-MM-dd")).AsEnumerable(); tmp_getptarrived patient_arrive = result.Select(x => new tmp_getptarrived { paadm_type_of_patient_calc = x.Field <string>("PAADM_Type_of_Patient_Calc"), paadm_rowid = x.Field <int>("PAADM_RowID").ToString(), appt_rowid = x.Field <string>("APPT_RowId"), appt_arrivaltime = x.Field <TimeSpan>("APPT_ArrivalTime").ToString(), paadm_admdate = x.Field <DateTime?>("PAADM_AdmDate"), allergy_eng = GetAllergyByHN(x.Field <string>("PAPMI_No")),//call webserice paadm_admno = x.Field <string>("PAADM_ADMNo"), papmi_no = x.Field <string>("PAPMI_No"), ttl_desc = x.Field <string>("TTL_Desc"), papmi_name = x.Field <string>("PAPMI_Name"), papmi_name2 = x.Field <string>("PAPMI_Name2"), appt_transdate = x.Field <DateTime?>("APPT_TransDate"), appt_datesearch = x.Field <DateTime?>("APPT_DateSearch"), paadm_admtime = x.Field <TimeSpan>("PAADM_admTime").ToString(), ctloc_code = returnMainSite(x.Field <string>("CTLOC_Code")), ctloc_desc = x.Field <string>("CTLOC_Desc"), penstype_code = x.Field <string>("PENSTYPE_Code"), penstype_desc = x.Field <string>("PENSTYPE_Desc"), ser_rowid = x.Field <int>("SER_RowId"), ser_desc = x.Field <string>("SER_Desc"), ctnat_code = x.Field <string>("CTNAT_Code"), ctnat_desc = x.Field <string>("CTNAT_Desc"), ctsex_code = x.Field <string>("CTSEX_Code"), ctsex_desc = x.Field <string>("CTSEX_Desc"), papmi_dob = x.Field <DateTime?>("PAPMI_DOB"), //paper_photo = getImagePatient(x.Field<string>("PAPER_Photo")), paper_photo = new GetPatientImage().getByWebService(x.Field <string>("PAPMI_No")), //paper_photo_path = x.Field<string>("PAPER_Photo"), paper_ageyr = x.Field <string>("PAPER_AgeYr"), paper_agemth = x.Field <string>("PAPER_AgeMth"), paper_ageday = x.Field <string>("PAPER_AgeDay"), paper_stname = x.Field <string>("PAPER_StName"), citarea_desc = x.Field <string>("CITAREA_Desc"), prov_desc = x.Field <string>("PROV_Desc"), ctcit_desc = x.Field <string>("CTCIT_Desc"), ctzip_code = x.Field <string>("CTZIP_Code"), paper_id = x.Field <string>("PAPER_ID"), paper_telo = x.Field <string>("PAPER_TelO"), paper_telh = x.Field <string>("PAPER_TelH"), paper_mobphone = x.Field <string>("PAPER_MobPhone"), paper_email = x.Field <string>("PAPER_Email"), ctmar_desc = x.Field <string>("CTMAR_Desc"), paper_name5 = x.Field <string>("PAPER_Name5"), paper_name6 = x.Field <string>("PAPER_Name6"), paper_name7 = x.Field <string>("PAPER_Name7"), papmi_dob_text = x.Field <string>("papmi_dob_text") }).FirstOrDefault(); if (patient_arrive != null) { if (!cdc.tmp_getptarriveds.Any(t => t.paadm_admno == en && t.ctloc_code == SiteCode)) { cdc.tmp_getptarriveds.InsertOnSubmit(patient_arrive); cdc.SubmitChanges(); } } return(0); } } catch (Exception ex) { throw ex; //add suriya 24/03/2015 } }
public CheckupLabResult ByGetCheckupLab(string hn, DateTime startDate, DateTime endDate, string enCurrent = "")//add enCurrent suriya 30/06/2017 { try { string enHomer = string.Empty;//add suriya 30/06/2017 using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { //add suriya 30/06/2017 if (enCurrent.ToUpper().Contains("I")) { DataTable ENDetails = ws.GetEPIRowIDByEN(enCurrent); enHomer = ENDetails.Rows[0]["PAADM_HomerID"].ToString(); } System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.CreateSpecificCulture("en-US"); //end suriya 30/06/2017 var RawMateWS = ws.GetCheckupLab(hn, startDate.ToString("yyyy-MM-dd"), endDate.ToString("yyyy-MM-dd")).AsEnumerable(); // var RawMateWS = ws.GetCheckupLab(hn, "2018-02-01", endDate.ToString("yyyy-MM-dd")).AsEnumerable(); var RawMateGroups = RawMateWS.Where(x => x.Field <string>("EPI_NO").Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).Count() > 0) .GroupBy(x => x.Field <string>("EPI_NO").Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries)[0]).ToList(); var result = ws.GetPTInfoByHN(hn).AsEnumerable() .Select(x => new CheckupLabResult { hn = hn, sex = x.Field <string>("CTSEX_Code"), dob = x.Field <DateTime>("PAPMI_DOB") }).FirstOrDefault(); if (result != null) { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { //var DateRaw = RawMateGroups.Select(z => z.Field<string>("EPIVISDateOfCollection") ); result.episodes = RawMateGroups.Select(x => new Episode { //en = x.Key, del suriya 30/06/2017 en = enHomer == x.Key ? enCurrent : x.Key, //add suriya 30/06/2017 //labdates = x.GroupBy(y => new DateTime( // Convert.ToInt32( y.Field<string>("EPIVISDateOfCollection").Substring(0, 4) ), // Convert.ToInt32( y.Field<string>("EPIVISDateOfCollection").Substring(5, 2) ), // Convert.ToInt32( y.Field<string>("EPIVISDateOfCollection").Substring(8, 2) ) ) //2017-07-19 // change EPIVISDateOfCollection -> DTE_OF_RCV artist.su 24/08/2017 //labdates = x.GroupBy(y => new DateTime( // Convert.ToInt32(y.Field<string>("DTE_OF_RCV").Substring(0, 4) == "1840" ? y.Field<string>("EPIVISDateOfCollection").Substring(0, 4) : y.Field<string>("DTE_OF_RCV").Substring(0, 4)), // Convert.ToInt32(y.Field<string>("DTE_OF_RCV").Substring(0, 4) == "1840" ? y.Field<string>("EPIVISDateOfCollection").Substring(5, 2) : y.Field<string>("DTE_OF_RCV").Substring(5, 2)), // Convert.ToInt32(y.Field<string>("DTE_OF_RCV").Substring(0, 4) == "1840" ? y.Field<string>("EPIVISDateOfCollection").Substring(8, 2) : y.Field<string>("DTE_OF_RCV").Substring(8, 2)) // ) // labdates = x.GroupBy(y => new DateTime(Convert.ToInt32("2017"), Convert.ToInt32("07"), Convert.ToInt32("19")) //2017-10-30 labdate แก้ 1840 / lab ผิดพลาด labdates = x.GroupBy(y => new DateTime( Convert.ToInt32(y.Field <string>("VISTSDateOfReceive").Substring(0, 4)), Convert.ToInt32(y.Field <string>("VISTSDateOfReceive").Substring(5, 2)), Convert.ToInt32(y.Field <string>("VISTSDateOfReceive").Substring(8, 2))) ).Select(y => new LabDate { labdate = y.Key, labs = (from lab in y join mhs in new LabClass.MappingLocationCls().Mapping() on lab.Field <string>("CTHOS_CDE") equals mhs.subcode into l from m in l.DefaultIfEmpty() select new Lab { rowid = lab.Field <string>("EPVISVisitNumber"), age = lab.Field <string>("EPVIS_AGE") == null ? (int?)null : !IsNumeric(lab.Field <string>("EPVIS_AGE")) ? (int?)null : Convert.ToInt32(lab.Field <string>("EPVIS_AGE")), headcode = lab.Field <string>("CTTS_CDE"), headdesc = lab.Field <string>("CTTS_NME"), code = lab.Field <string>("CTTC_CDE"), labname = lab.Field <string>("CTTC_DES"), //valuenumber = (string.IsNullOrWhiteSpace(lab.Field<string>("TST_DTA")) || string.IsNullOrEmpty(lab.Field<string>("TST_DTA"))) && string.IsNullOrEmpty(lab.Field<string>("VISTD_CMM")) // ? null // : string.IsNullOrEmpty(lab.Field<string>("VISTD_CMM")) == false ? lab.Field<string>("VISTD_CMM").Trim() // : string.IsNullOrWhiteSpace(lab.Field<string>("TST_DTA")) || string.IsNullOrEmpty(lab.Field<string>("TST_DTA")) ? null // : lab.Field<string>("TST_DTA").Trim().Substring(0, 1) == "." // ? "0" + lab.Field<string>("TST_DTA").Trim() // : lab.Field<string>("TST_DTA").Trim(), // var tmbLength = tmbPlus < 1 && tmbDiv < 1 ? value.Length - 3 : // tmbPlus > 1 ? value.Length - tmbPlus : // tmbDiv > 1 ? value.Length - tmbDiv : value.Length - 3; // var tmbReturn = value.Substring(3, tmbLength); valuenumber = string.IsNullOrWhiteSpace(lab.Field <string>("TST_DTA")) || string.IsNullOrEmpty(lab.Field <string>("TST_DTA")) ? null : lab.Field <string>("TST_DTA").Trim().Substring(0, 1) == "." ? "0" + lab.Field <string>("TST_DTA").Trim() : lab.Field <string>("TST_DTA").Trim().Contains("<.") ? lab.Field <string>("TST_DTA").Trim().Replace("<.", "<0.") : lab.Field <string>("TST_DTA").Trim().Contains(">.") ? lab.Field <string>("TST_DTA").Trim().Replace(">.", ">0.") : lab.Field <string>("TST_DTA").Trim().Substring(0, 1).IsNormalized() == false ? lab.Field <string>("TST_DTA").Trim().Substring(1, lab.Field <string>("TST_DTA").Trim().Length - 1) : lab.Field <string>("TST_DTA").Trim(), valuestring = lab.Field <string>("RSL") == null && lab.Field <string>("TST_DTA") == null ? null : string.IsNullOrEmpty(lab.Field <string>("RSL")) == false ? lab.Field <string>("RSL").Trim() : string.IsNullOrEmpty(lab.Field <string>("TST_DTA")) == false ? lab.Field <string>("TST_DTA").Trim() : string.IsNullOrEmpty(lab.Field <string>("RSL")) ? null : lab.Field <string>("RSL").Trim(), unit = lab.Field <string>("CTTC_UNT"), range = lab.Field <string>("NML"), hl = lab.Field <string>("HL") == "H" ? 1 : lab.Field <string>("HL") == "L" ? -1 : 0, frs = lab.Field <string>("CTTC_RSL_FMT") == null ? -1 : lab.Field <string>("CTTC_RSL_FMT").Contains("N") ? 1 : lab.Field <string>("CTTC_RSL_FMT") == "S" ? 2 : lab.Field <string>("CTTC_RSL_FMT") == "X" ? 0 : -1, seq = lab.Field <string>("Sequen") == null || lab.Field <string>("Sequen") == "" ? (int?)null : !IsNumeric(lab.Field <string>("Sequen")) ? (int?)null : Convert.ToInt32(lab.Field <string>("Sequen")), location = lab.Field <string>("CTHOS_CDE"), status = lab.Field <string>("Status") == "Executed" ? 'E' : lab.Field <string>("Status") == "D/C (Discontinued)" ? 'D' : 'I', mhs_id = m == null ? (int?)null : m.mainid, mhs_ename = m == null ? null : m.maindesc, mhs_tname = m == null ? null : m.maindesc }).ToList() }).ToList() }).ToList(); } } return(result); } } catch (Exception ex) { Class.globalCls.MessageError("GetCheckupLabCls", "ByGetCheckupLab", ex.Message); throw ex; } }