private void frmPrintReport_Load(object sender, EventArgs e) { /* * select mhs.mhs_id, mhs.mhs_tname * from mst_hpc_site mhs * where mhs.mhs_type = 'P' * and mhs.mhs_room_chkup = 'TRUE' * and mhs.mhs_status = 'A' * and CONVERT(date,GETDATE(),103) between * CONVERT(date,isnull(mhs.mhs_effective_date,getdate()),103) and * CONVERT(date,isnull(mhs.mhs_expire_date,getdate()),103) * order by mhs.mhs_code; */ List <mst_hpc_site> objsite = (from t1 in dbc.mst_hpc_sites where t1.mhs_status == 'A' && t1.mhs_type == 'P' && t1.mhs_room_chkup == true select t1).ToList(); mst_hpc_site newselect = new mst_hpc_site(); newselect.mhs_id = 0; newselect.mhs_ename = "Select All"; objsite.Add(newselect); DDsite.DataSource = objsite.OrderBy(x => x.mhs_id).ToList(); DDsite.DisplayMember = "mhs_ename"; DDsite.ValueMember = "mhs_id"; DDsite.SelectedValue = 0; }
private void frmWaiting_Load(object sender, EventArgs e) { this.Text = Program.GetRoomName("Waiting"); frmBGScreen frmbg = new frmBGScreen(); frmbg.Show(); Application.DoEvents(); //Load Data if (Program.CurrentSite != null) { List <mst_hpc_site> objsite = (from t1 in dbc.mst_hpc_sites where t1.mhs_status == 'A' && t1.mhs_type == 'P' select t1).ToList(); mst_hpc_site newselect = new mst_hpc_site(); //newselect.mhs_id = 0; //newselect.mhs_ename = "Select All"; //objsite.Add(newselect); DDSite.DataSource = objsite.OrderBy(x => x.mhs_id).ToList(); DDSite.DisplayMember = "mhs_ename"; DDSite.ValueMember = "mhs_id"; DDSite.SelectedValue = Program.CurrentSite.mhs_id; uiQueue1.LoadData(dbc, Program.CurrentSite.mhs_id); BindData("", Program.CurrentSite.mhs_id); } frmbg.Close(); }
private void bindSite_Format(object sender, ConvertEventArgs e) { if (e.Value != null) { if (e.Value.GetType() == typeof(int)) { int val = (int)e.Value; try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { mst_hpc_site HpcSite = cdc.mst_hpc_sites.Where(x => x.mhs_id == val).FirstOrDefault(); if (HpcSite != null) { e.Value = HpcSite.mhs_ename; } else { e.Value = ""; } } } catch (Exception ex) { Program.MessageError(this.Name, "bindSite_Format", ex, false); } } } }
public mst_hpc_site getSiteClinic() { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { DateTime dateNow = Program.GetServerDateTime(); mst_hpc_site mhs = cdc.mst_hpc_sites.Where(x => x.mhs_other_clinic == true && x.mhs_status == 'A' && dateNow.Date >= x.mhs_effective_date.Value.Date && dateNow.Date <= (x.mhs_expire_date == null ? dateNow : x.mhs_expire_date.Value.Date)) .FirstOrDefault(); return(mhs); } }
public StatusTransaction SendToBasic(ref trn_patient_regi tpr, ref string messegeSend) { try { DateTime dateNow = Program.GetServerDateTime(); EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); int mvt_regis = mst.GetMstEvent("RG").mvt_id; trn_patient_queue objQueueRegis = new trn_patient_queue(); objQueueRegis.mrm_id = Program.CurrentRoom.mrm_id; objQueueRegis.mvt_id = mvt_regis; objQueueRegis.mrd_id = Program.CurrentRoom.mrd_id; objQueueRegis.tps_start_date = dateNow; objQueueRegis.tps_end_date = dateNow; objQueueRegis.tps_send_by = Program.CurrentUser.mut_username; objQueueRegis.tps_status = "ED"; objQueueRegis.tps_ns_status = null; objQueueRegis.tps_create_date = dateNow; objQueueRegis.tps_create_by = Program.CurrentUser.mut_username; objQueueRegis.tps_update_by = objQueueRegis.tps_create_by; objQueueRegis.tps_update_date = dateNow; tpr.trn_patient_queues.Add(objQueueRegis); mst_room_hdr mrm = mst.GetMstRoomHdr("BM", Program.CurrentSite.mhs_code); mst_hpc_site mhs = mst.GetMstHpcSite(Program.CurrentSite.mhs_code); mst_zone mze = mst.GetMstZone((int)mrm.mze_id); mst_event mvt = mst.GetMstEvent("BM"); trn_patient_queue objQueueBasic = new trn_patient_queue(); objQueueBasic.mrm_id = mrm.mrm_id; objQueueBasic.mvt_id = mvt.mvt_id; objQueueBasic.mrd_id = null; objQueueBasic.tps_status = "NS"; objQueueBasic.tps_ns_status = "WL"; objQueueBasic.tps_create_by = Program.CurrentUser.mut_username; objQueueBasic.tps_create_date = dateNow; objQueueBasic.tps_update_by = Program.CurrentUser.mut_username; objQueueBasic.tps_update_date = dateNow; tpr.trn_patient_queues.Add(objQueueBasic); messegeSend = string.Format(Program.MsgSend, mrm.mrm_ename, mze.mze_ename, mhs.mhs_ename, tpr.tpr_queue_no); return(StatusTransaction.True); } catch (Exception ex) { Program.MessageError("TransactionQueueCls", "SendToBasic", ex, false); return(StatusTransaction.Error); } }
public mst_hpc_site GetMstHpcSite(string mhs_code) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { mst_hpc_site mhs = cdc.mst_hpc_sites.Where(x => x.mhs_code == mhs_code).FirstOrDefault(); return(mhs); } } catch { } return(null); }
public StatusTransaction SendToPE(ref trn_patient_regi tpr, ref string messegeSend) { try { DateTime dateNow = Program.GetServerDateTime(); EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); mst_room_hdr mrm = mst.GetMstRoomHdr("DC", Program.CurrentSite.mhs_code); mst_hpc_site mhs = mst.GetMstHpcSite(mrm.mhs_id); mst_zone mze = mst.GetMstZone((int)mrm.mze_id); mst_event mvt = mst.GetMstEvent("PE"); return(SendToRoom(ref tpr, ref messegeSend, mrm.mrm_id, mvt.mvt_id)); } catch (Exception ex) { Program.MessageError("TransactionQueueCls", "SendToPE", ex, false); return(StatusTransaction.Error); } }
public mst_room_hdr GetMstRoomHdr(string mrm_code, string mhs_code) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { mst_hpc_site mhs = GetMstHpcSite(mhs_code); if (mhs != null) { int mhs_id = mhs.mhs_id; mst_room_hdr mrm = cdc.mst_room_hdrs.Where(x => x.mrm_code == mrm_code && x.mhs_id == mhs_id).FirstOrDefault(); return(mrm); } } } catch { } return(null); }
public static mst_hpc_site getMstHpcSiteByMshCode(string mhs_code) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { DateTime dateNow = Program.GetServerDateTime(); mst_hpc_site mhs = cdc.mst_hpc_sites.Where(x => x.mhs_code == mhs_code && x.mhs_status == 'A' && dateNow.Date >= (x.mhs_effective_date != null ? x.mhs_effective_date.Value.Date : dateNow.Date) && dateNow.Date <= (x.mhs_expire_date != null ? x.mhs_expire_date.Value.Date : dateNow.Date)) .FirstOrDefault(); return(mhs); } } catch { } return(null); }
public StatusTransaction SendToCheckCBeforePE(ref trn_patient_regi tpr, ref string messegeSend) { try { DateTime dateNow = Program.GetServerDateTime(); EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); mst_room_hdr mrm = mst.GetMstRoomHdr("DC", Program.CurrentSite.mhs_code); mst_hpc_site mhs = mst.GetMstHpcSite(mrm.mhs_id); mst_zone mze = mst.GetMstZone((int)mrm.mze_id); mst_event mvt = mst.GetMstEvent("PE"); trn_patient_queue tps = tpr.trn_patient_queues.Where(x => x.mrm_id == mrm.mrm_id && x.mvt_id == mvt.mvt_id).FirstOrDefault(); if (tps == null) { tps = new trn_patient_queue(); tps.tps_create_by = Program.CurrentUser.mut_username; tps.tps_create_date = dateNow; tpr.trn_patient_queues.Add(tps); } tps.mrm_id = mrm.mrm_id; tps.mvt_id = mvt.mvt_id; tps.mrd_id = null; tps.tps_end_date = null; tps.tps_start_date = null; tps.tps_status = "NS"; tps.tps_ns_status = "WP"; tps.tps_update_by = Program.CurrentUser.mut_username; tps.tps_update_date = dateNow; messegeSend = string.Format(Program.MsgSend, mrm.mrm_ename, mze.mze_ename, mhs.mhs_ename, tpr.tpr_queue_no); return(StatusTransaction.True); } catch (Exception ex) { Program.MessageError("TransactionQueueCls", "SendToPE", ex, false); return(StatusTransaction.Error); } }
public trn_patient_regi getDefaultPatientRegis(tmp_getptarrived tga, int SiteCode = -999)//add SiteCode suriya 03/04/2015 { mst_hpc_site mhs_clinic = getSiteClinic(); DateTime dateNow = DateTime.Now; //Program.GetServerDateTime(); trn_patient_regi tpr = new trn_patient_regi { mac_id = null, // mdc_id = null, // mhc_id = null, // //mhs_id = mhs_clinic.mhs_id,//del suriya 03/04/2015 mhs_id = SiteCode == -999 ? mhs_clinic.mhs_id : Program.CurrentSite.mhs_id, //add suriya 03/04/2015 mut_id = null, // tcd_id = null, // tnc_id = null, // tpr_appoint_type = 'T', //tpr_appointment_date = dateNow,//del suriya 03/04/2015 //tpr_arrive_date = dateNow,//del suriya 03/04/2015 tpr_appointment_date = SiteCode == -999 ? dateNow : tga.paadm_admdate, //add suriya 03/04/2015 tpr_arrive_date = SiteCode == -999 ? dateNow : tga.paadm_admdate, //add suriya 03/04/2015 tpr_arrive_type = tga.ser_rowid == 2808 ? 'W' : 'A', tpr_aviation_type = null, // tpr_check_pending = 'N', tpr_comp_dep = null, // tpr_comp_dep_edesc = null, // tpr_comp_dep_tdesc = null, // tpr_comp_edesc = null, // tpr_comp_tdesc = null, // tpr_company_code = null, // tpr_company_id = null, // tpr_create_by = "CONSULT", tpr_create_date = dateNow, tpr_email = tga.paper_email, tpr_employee_no = null, // tpr_en_no = tga.paadm_admno, tpr_en_rowid = tga.paadm_rowid, tpr_foreigner = tga.ctnat_code == "TH" ? 'N' : 'Y', // 'TH' ? 'N' : 'Y' tpr_home_phone = tga.paper_telh, tpr_main_address = tga.paper_stname, tpr_main_amphur = tga.ctcit_desc, tpr_main_id = null, // reinsert when submit tpr_main_province = tga.prov_desc, tpr_main_tumbon = tga.citarea_desc, tpr_main_zip_code = tga.ctzip_code, //tpr_mhc_ename = tpos.Select(x => x.tos_od_set_name).FirstOrDefault(), tpr_miss_lower = false, tpr_mobile_phone = tga.paper_mobphone, tpr_new_patient = getNewPatientType(tga), tpr_npo_text = null, // tpr_npo_time = null, // tpr_office_phone = tga.paper_telo, tpr_other_address = tga.paper_stname, tpr_other_amphur = tga.ctcit_desc, tpr_other_province = tga.prov_desc, tpr_other_tumbon = tga.citarea_desc, tpr_other_zip_code = tga.ctzip_code, tpr_patient_type = '1', tpr_pe_doc = 'N', tpr_pe_doc_code = null, // tpr_pe_doc_name = null, // tpr_pe_status = null, // tpr_pe_type = 'W', tpr_pending = false, tpr_pending_cancel_onday = false, tpr_pending_ct = 0, tpr_pending_no_station = null, // tpr_prev_pe_code = null, // tpr_prev_pe_name = null, // tpr_print_book = "N", tpr_PRM = null, tpr_PRM_check = null, tpr_PRM_doccode = null, tpr_PRM_docname = null, tpr_PRM_doctor = null, tpr_queue_no = getQueueOtherClinic(tga.paadm_admno), tpr_queue_type = getTprQueueType(tga), tpr_remark = null, // tpr_req_doc_code = null, // tpr_req_doc_gender = null, // tpr_req_doc_name = null, // tpr_req_doctor = 'N', tpr_req_inorout_doctor = null, // tpr_req_pe_bef_chkup = null, // tpr_rtn_pe_date = null, // tpr_rtn_pe_name = null, // tpr_send_book = null, // tpr_send_to = null, // tpr_site_use = null, // tpr_status = null, // tpr_type = null, // tpr_update_by = "CONSULT", tpr_update_date = dateNow, tpr_vip_code = tga.penstype_code, tpr_vip_desc = tga.penstype_desc, tpr_arrive_site = tga.LocWhenOrdOther, tpr_arrive_site_desc = tga.LocWhenOrdOtherDesc }; tpr.trn_basic_measure_hdrs.Add(getBasicHdr(tga.papmi_no, tga.paadm_admno)); //GetPatientPackage(ref tpr, dateNow); //genPatientPlan(ref tpr, Program.CurrentSite.mhs_id, dateNow); int enRowID = Convert.ToInt32(tpr.tpr_en_rowid); GetPTPackageCls PackageCls = new GetPTPackageCls(); EnumerableRowCollection <DataRow> getPTPackage = PackageCls.GetPTPackage(enRowID); PackageCls.AddPatientOrderItem(ref tpr, "System", dateNow, getPTPackage); PackageCls.AddPatientOrderSet(ref tpr, "System", dateNow, getPTPackage); List <MapOrderEvent> mapOrder = PackageCls.MapEvent(getPTPackage); PackageCls.AddPatientEvent(ref tpr, "System", dateNow, mapOrder); PackageCls.AddPatientPlan(ref tpr, "System", dateNow, mapOrder); PackageCls.skipReqDoctorOutDepartment(ref tpr); PackageCls.CompleteEcho(ref tpr); PackageCls.skipChangeEstToEcho(ref tpr, tpr.mhs_id); PackageCls.checkOrderPMR(ref tpr, tpr.mhs_id); trn_patient_queue tpq = getPatientQueue("CB", tpr); if (tpq != null) { tpr.trn_patient_queues.Add(tpq); } List <trn_out_department> tod = getOutDepartment(tga.papmi_no, tga.ctloc_code, DateTime.Now); if (tod != null) { tpr.trn_out_departments.AddRange(tod); } trn_patient_cat tpc = getForeignerPatient(tga.ctnat_code); if (tpc != null) { tpr.trn_patient_cats.Add(tpc); } return(tpr); }
private void previewBook(int tpb_id) { try { using (InhCheckupDataContext dbc = new InhCheckupDataContext()) { trn_patient_book tpb = dbc.trn_patient_books.Where(x => x.tpb_id == tpb_id).FirstOrDefault(); string path = @"\\" + tpb.tpb_server_path + @"\" + tpb.tpb_path_file + @"\" + tpb.tpb_file_name; if (File.Exists(path)) { try { Process.Start(path); } catch { lbAlert.Text = "Cannot Open File."; } } else { lbAlert.Text = "File not Exists or Connect Server Error."; } if (tpb.tpb_print_by == null) { tpb.tpb_reprint = 0; } else { tpb.tpb_reprint++; } DateTime dateNow = Program.GetServerDateTime(); tpb.tpb_status = "BP"; tpb.tpb_update_by = Program.CurrentUser.mut_username; tpb.tpb_update_date = dateNow; tpb.tpb_print_by = Program.CurrentUser.mut_username; tpb.tpb_print_date = dateNow; trn_patient_regi tpr = tpb.trn_patient_regi; tpr.tpr_print_book = "C"; EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); mst_hpc_site mhs = mst.GetMstHpcSite(tpr.mhs_id); mst_room_hdr mrm_book = mst.GetMstRoomHdr("BK", mhs.mhs_code); mst_room_dtl mrd_book = dbc.mst_room_dtls.Where(x => x.mrm_id == mrm_book.mrm_id).FirstOrDefault(); mst_event mvt_book = mst.GetMstEvent("BK"); trn_patient_queue tps = tpr.trn_patient_queues.Where(x => x.mrm_id == mrm_book.mrm_id).FirstOrDefault(); if (tps == null) { tps = new trn_patient_queue(); tpr.trn_patient_queues.Add(tps); } tps.mrd_id = mrd_book.mrd_id; tps.mrm_id = mrm_book.mrm_id; tps.mvt_id = mvt_book.mvt_id; tps.tps_bm_seq = null; tps.tps_call_by = Program.CurrentUser.mut_username; tps.tps_call_date = dateNow; tps.tps_call_status = null; tps.tps_end_date = dateNow; tps.tps_update_by = Program.CurrentUser.mut_username; tps.tps_update_date = dateNow; tps.tps_ns_status = null; tps.tps_status = "LR"; mst_room_hdr mrm_finish = mst.GetMstRoomHdr("FN", mhs.mhs_code); mst_event mvt_finish = mst.GetMstEvent("FN"); tpr.trn_patient_queues.Add(new trn_patient_queue { mrd_id = null, mrm_id = mrm_finish.mrm_id, mvt_id = mvt_finish.mvt_id, tps_bm_seq = null, tps_start_date = dateNow, tps_call_by = Program.CurrentUser.mut_username, tps_call_date = dateNow, tps_call_status = null, tps_update_by = Program.CurrentUser.mut_username, tps_update_date = dateNow, tps_ns_status = "QL", tps_status = "NS" }); dbc.SubmitChanges(); } } catch (Exception ex) { throw new Exception(ex.Message); } }
private bool popupFinish(int tpb_id) { using (frmPopupBookFinishRemark frm = new frmPopupBookFinishRemark()) { frmPopupBookFinishRemark.bookFinish _bookFinish = frm.popupFinish(); if (_bookFinish.save == true) { try { using (InhCheckupDataContext dbc = new InhCheckupDataContext()) { DateTime dateNow = Program.GetServerDateTime(); int tpr_id = dbc.trn_patient_books.Where(x => x.tpb_id == tpb_id).Select(x => x.tpr_id).FirstOrDefault(); trn_patient_regi tpr = dbc.trn_patient_regis.Where(x => x.tpr_id == tpr_id).FirstOrDefault(); tpr.tpr_status = "CP"; trn_patient_book tpb = tpr.trn_patient_books.Where(x => x.tpb_id == tpb_id).FirstOrDefault(); tpb.tpb_status = "BF"; tpb.tpb_send_email = _bookFinish.detail.send_email; tpb.tpb_send_post = _bookFinish.detail.send_post; tpb.tpb_finish_remark = _bookFinish.detail.remark; tpb.tpb_update_by = Program.CurrentUser.mut_username; tpb.tpb_update_date = dateNow; tpb.tpb_finish_by = Program.CurrentUser.mut_username; tpb.tpb_finish_date = dateNow; EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); mst_hpc_site mhs = mst.GetMstHpcSite(tpr.mhs_id); mst_room_hdr mrm_finish = mst.GetMstRoomHdr("FN", mhs.mhs_code); //mst_room_dtl mrd_finish = dbc.mst_room_dtls.Where(x => x.mrm_id == mrm_finish.mrm_id).FirstOrDefault(); mst_event mvt_finish = mst.GetMstEvent("FN"); trn_patient_queue tps = tpr.trn_patient_queues.Where(x => x.mrm_id == mrm_finish.mrm_id).FirstOrDefault(); if (tps == null) { tps = new trn_patient_queue(); tpr.trn_patient_queues.Add(tps); } //tps.mrd_id = mrd_finish.mrd_id; tps.mrm_id = mrm_finish.mrm_id; tps.mvt_id = mvt_finish.mvt_id; tps.tps_bm_seq = null; tps.tps_end_date = dateNow; tps.tps_call_by = Program.CurrentUser.mut_username; tps.tps_call_date = dateNow; tps.tps_call_status = null; tps.tps_update_by = Program.CurrentUser.mut_username; tps.tps_update_date = dateNow; tps.tps_ns_status = null; tps.tps_status = "LR"; dbc.SubmitChanges(); } return(true); } catch (Exception ex) { throw new Exception(ex.Message); } } } return(false); }
public static void SendBook(int tprid) { try { EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); using (InhCheckupDataContext dbc = new InhCheckupDataContext()) { DateTime datenow = Program.GetServerDateTime(); int mrmID = 0; int mvtID = 0; string roomname = String.Empty; trn_patient_regi tpr = dbc.trn_patient_regis.Where(x => x.tpr_id == tprid).FirstOrDefault(); //Update trn_patient_queue int tps_ID = (from t in dbc.trn_patient_queues join t2 in dbc.mst_room_hdrs on t.mrm_id equals t2.mrm_id where t.tpr_id == tprid && t2.mrm_code == "CC" && t.tps_status == "WK" select t.tps_id).FirstOrDefault(); var objQueue = (from t1 in dbc.trn_patient_queues where t1.tps_id == tps_ID select t1).FirstOrDefault(); if (objQueue != null) { objQueue.tps_status = "ED"; objQueue.mrd_id = Program.CurrentRoom.mrd_id; objQueue.tps_send_by = Program.CurrentUser.mut_username; objQueue.tps_end_date = datenow; objQueue.tps_update_by = Program.CurrentUser.mut_username; objQueue.tps_update_date = datenow; } // End. mst_hpc_site mhs = mst.GetMstHpcSite(tpr.mhs_id); mrmID = mst.GetMstRoomHdr("BK", mhs.mhs_code).mrm_id; mvtID = mst.GetMstEvent("BK").mvt_id; //mrmID = Program.Getmrm_id(dbc, "BK"); //mvtID = Program.Getmvt_id(dbc, "BK"); var getHnEn = (from t in dbc.trn_patient_regis join t2 in dbc.trn_patients on t.tpt_id equals t2.tpt_id where t.tpr_id == tprid select new { t, t2 }).ToList(); var objevent = (from t1 in dbc.mst_events where t1.mvt_id == mvtID select t1).ToList(); if (objevent.Count != 0) { roomname = objevent[0].mvt_ename; } var objqueueBK = (from t1 in dbc.trn_patient_queues where t1.trn_patient_regi.trn_patient.tpt_hn_no == getHnEn.Select(x => x.t2.tpt_hn_no).FirstOrDefault() && t1.trn_patient_regi.tpr_en_no == getHnEn.Select(x => x.t.tpr_en_no).FirstOrDefault() && t1.mrm_id == mrmID && t1.mvt_id == mvtID select t1).FirstOrDefault(); var objRegis = (from t1 in dbc.trn_patient_regis where t1.tpr_id == tprid select t1).FirstOrDefault(); if (objRegis != null) { objRegis.tpr_status = "WB"; objRegis.tpr_pe_status = "RS"; } if (objqueueBK == null && mrmID != 0) { trn_patient_queue newitem = new trn_patient_queue(); newitem.tpr_id = tprid; newitem.mrm_id = mrmID; newitem.mvt_id = mvtID; newitem.mrd_id = null; newitem.tps_end_date = null; newitem.tps_start_date = null; newitem.tps_status = "NS"; newitem.tps_ns_status = "QL"; newitem.tps_create_by = Program.CurrentUser.mut_username; newitem.tps_create_date = datenow; newitem.tps_update_by = Program.CurrentUser.mut_username; newitem.tps_update_date = datenow; dbc.trn_patient_queues.InsertOnSubmit(newitem); MessageBox.Show("Send Completed. Send To" + roomname, "Completed", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (objqueueBK != null && mrmID != 0) { objqueueBK.mrd_id = null; objqueueBK.tps_status = "NS"; objqueueBK.tps_ns_status = "QL"; objqueueBK.tps_create_date = datenow; objqueueBK.tps_create_by = Program.CurrentUser.mut_username; objqueueBK.tps_update_by = objqueueBK.tps_create_by; objqueueBK.tps_update_date = datenow; MessageBox.Show("Send Completed. Sent To" + roomname, "Completed", MessageBoxButtons.OK, MessageBoxIcon.Information); } if (mvtID == mst.GetMstEvent("BK").mvt_id) { MessageBox.Show("Checkup Process Completed", "Completed", MessageBoxButtons.OK, MessageBoxIcon.Information); } dbc.SubmitChanges(); } } catch (Exception ex) { throw new Exception(ex.Message); } }
private tmp_getptarrived getArrivedByHn(string hn) { lbAlert.Text = "Searching..."; btnCancel.Enabled = false; btnContinue.Enabled = false; btnSearch.Enabled = false; Application.DoEvents(); string tmpHN = hn.Replace("-", ""); System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.CreateSpecificCulture("en-US"); //using (InhCheckupDataContext cdc = new InhCheckupDataContext()) //{ // DateTime dateNow = Program.GetServerDateTime(); // List<vw_tmp_arrive> result = cdc.vw_tmp_arrives // .Where(x => (x.papmi_no == tmpHN || x.papmi_no.Replace("-", "") == tmpHN) && // x.paadm_admdate.Value.Date == dateNow.Date).ToList(); // if (result.Count > 0) // { // result = result.Where(x => x.flag_success == 'N' || x.flag_success == null).ToList(); // if (result.Count > 0) // { // int row_id = result.Select(x => x.row_id).FirstOrDefault(); // return get_tgaByRowID(row_id); // } // else // { // lbAlert.Text = "This HN No. is processing on EMR-checkup."; // } // } // else // { // lbAlert.Text = "This HN No. is not found."; // } // return null; //} try { string currentSite = null; string currentSiteName = null; if (Program.CurrentSite != null) { currentSite = Program.CurrentSite.mhs_code; mst_hpc_site mhs = Program.getMstHpcSiteByMshCode(currentSite); currentSiteName = mhs != null ? mhs.mhs_ename : null; } if (currentSite != null) { DateTime dateTime = Program.GetServerDateTime(); string hn_pos1 = tmpHN.Length >= 2 ? tmpHN.Substring(0, 2) : ""; string hn_pos2 = tmpHN.Length >= 4 ? tmpHN.Substring(2, 2) : ""; string hn_pos3 = tmpHN.Length >= 5 ? tmpHN.Substring(4) : ""; string realHN = hn_pos1 + "-" + hn_pos2 + "-" + hn_pos3; using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { List <tmp_getptarrived> tmpArrived = cdc.tmp_getptarriveds.Where(x => x.papmi_no == realHN && x.paadm_admdate.Value.Date == dateTime.Date) .ToList(); if (tmpArrived.Count > 0) { if (tmpArrived.Where(x => x.flag_success == 'Y').Count() != 0) { lbAlert.Text = "This HN No. is processing on EMR-checkup."; return(null); } } EmrClass.GetDataFromWSTrakCare cls = new EmrClass.GetDataFromWSTrakCare(); using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls()) { string dateNow = Program.GetServerDateString(); string timeNow = string.Format(DateTime.Now.ToString("{0}HH{1}mm{2}ss{3}"), "PT", "H", "M", "S"); tmp_getptarrived tga = ws.GetPTOrderByLocDateHn(currentSite, dateNow, realHN).AsEnumerable() .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 = timeNow, paadm_admdate = x.Field <DateTime?>("PAADM_AdmDate"), allergy_eng = new APITrakcare.GetAllergyCls().GetByHN(x.Field <string>("PAPMI_No")), 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 = cls.returnMainSite(currentSite), ctloc_desc = currentSiteName, 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 = new EmrClass.GetPatientImage().getByPath(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"), flag_success = 'Y', LocWhenOrdOther = cls.returnMainSite(x.Field <string>("LocWhenOrdOther")), //LocWhenOrdCheckup = x.Field<string>("LocWhenOrdCheckup"), //LocWhenOrdConsult = cls.returnMainSite(x.Field<string>("LocWhenOrdConsult")), LocWhenOrdOtherDesc = x.Field <string>("LocWhenOrdOtherDesc"), }).FirstOrDefault(); //btnCancel.Enabled = true; //btnContinue.Enabled = true; //btnSearch.Enabled = true; if (tga == null) { lbAlert.Text = "This HN No. is not found."; return(null); } else { //if (tga.paper_photo == null) //{ // MemoryStream ms = new MemoryStream(); // BKvs2010.Properties.Resources.no_image.Save(ms, System.Drawing.Imaging.ImageFormat.Png); // tga.paper_photo = ms.ToArray(); //} //tmpArrived.ForEach(x => x.flag_success = 'Y'); //cdc.SubmitChanges(); lbAlert.Text = ""; return(tga); } } } } } catch { lbAlert.Text = "This process is Error."; } finally { btnCancel.Enabled = true; btnContinue.Enabled = true; btnSearch.Enabled = true; } return(null); }
public StatusTransaction SendToBook(ref trn_patient_regi tpr, ref string messegeSend) { try { DateTime dateNow = Program.GetServerDateTime(); tpr.tpr_status = "WB"; tpr.tpr_pe_status = "RS"; tpr.tpr_update_by = Program.CurrentUser.mut_username; tpr.tpr_update_date = dateNow; EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); mst_hpc_site mhs = mst.GetMstHpcSite(tpr.mhs_id); mst_room_hdr mrm = mst.GetMstRoomHdr("BK", mhs.mhs_code); mst_event mvt = mst.GetMstEvent("BK"); trn_patient_queue tps = tpr.trn_patient_queues.Where(x => x.mrm_id == mrm.mrm_id && x.mvt_id == mvt.mvt_id).FirstOrDefault(); //book //trn_patient_queue updateQueue; //if (tps == null) //{ // updateQueue = new trn_patient_queue(); // updateQueue.tps_create_by = Program.CurrentUser.mut_username; // updateQueue.tps_create_date = dateNow; // tpr.trn_patient_queues.Add(updateQueue); //} //else //{ // updateQueue = tpr.trn_patient_queues.Where(x => x.tps_id == tps.tps_id).FirstOrDefault(); //} //updateQueue.mrm_id = mrm.mrm_id; //updateQueue.mvt_id = mvt.mvt_id; //updateQueue.mrd_id = null; //updateQueue.tps_end_date = null; //updateQueue.tps_start_date = null; //updateQueue.tps_status = "NS"; //updateQueue.tps_ns_status = "QL"; //updateQueue.tps_update_by = Program.CurrentUser.mut_username; //updateQueue.tps_update_date = dateNow; if (tps == null) { tps = new trn_patient_queue(); tps.tps_create_by = Program.CurrentUser.mut_username; tps.tps_create_date = dateNow; tpr.trn_patient_queues.Add(tps); } tps.mrm_id = mrm.mrm_id; tps.mvt_id = mvt.mvt_id; tps.mrd_id = null; tps.tps_end_date = null; tps.tps_start_date = null; tps.tps_status = "NS"; tps.tps_ns_status = "QL"; tps.tps_update_by = Program.CurrentUser.mut_username; tps.tps_update_date = dateNow; messegeSend = "Queue No. " + tpr.tpr_queue_no + " Send to Book Complete."; return(StatusTransaction.True); } catch (Exception ex) { Program.MessageError("TransactionQueueCls", "SendToBook", ex, false); return(StatusTransaction.Error); } }