public void updatePendingPatientQueue(ref InhCheckupDataContext cdc, ref trn_patient_regi tpr, string mrm_code) { EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); mst_room_hdr mrm = mst.GetMstRoomHdr(mrm_code); updatePendingPatientQueue(ref cdc, ref tpr, mrm.mrm_id); }
public void insertPatientPending(ref trn_patient_regi tpr, string mrm_code) { EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); mst_room_hdr mrm = mst.GetMstRoomHdr(mrm_code); insertPatientPending(ref tpr, mrm.mrm_id); }
public StatusTransaction pendingPatientCheckpointB(int tpr_id, int mhs_id, List <int> list_mvt_id) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { trn_patient_regi tpr = cdc.trn_patient_regis.Where(x => x.tpr_id == tpr_id).FirstOrDefault(); tpr.tpr_pending = true; EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); foreach (int mvt_id in list_mvt_id) { mst_room_hdr mrm = mst.GetMstRoomHdrByMvt(mvt_id, mhs_id); updatePendingPatientPlan(ref tpr, mvt_id, mrm.mrm_id, mhs_id); insertPatientPending(ref tpr, mrm.mrm_id); } cdc.SubmitChanges(); return(StatusTransaction.True); } } catch (Exception ex) { Program.MessageError("ClsPendingOnStation", "pendingPatientCheckpointB", ex, false); return(StatusTransaction.Error); } }
public void updatePendingPatientPlan(ref trn_patient_regi tpr, int mvt_id, int mhs_id) { EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); mst_room_hdr mrm = mst.GetMstRoomHdrByMvt(mvt_id, mhs_id); updatePendingPatientPlan(ref tpr, mrm.mrm_id, mvt_id, mhs_id); }
public string MessegeAlertSkip(int?mrm_id) { try { if (mrm_id == null) { return(string.Empty); } else { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { mst_room_hdr roomHdr = cdc.mst_room_hdrs.Where(x => x.mrm_id == mrm_id).FirstOrDefault(); if (roomHdr == null) { return(string.Empty); } else { return("คนไข้มีสถานะ Skip มาจากห้อง " + roomHdr.mrm_ename + " "); } } } } catch (Exception ex) { Program.MessageError("ReserveSkipCls", "MessegeAlertSkip", ex, false); return(string.Empty); } }
public void updatePendingPatientPlan(ref trn_patient_regi tpr, string mvt_code, string mrm_code, int mhs_id) { EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); mst_event mvt = mst.GetMstEvent(mvt_code); mst_room_hdr mrm = mst.GetMstRoomHdr(mrm_code); updatePendingPatientPlan(ref tpr, mrm.mrm_id, mvt.mvt_id, mhs_id); }
private void ch_Active_roomhdr_MouseClick(object sender, MouseEventArgs e) { mst_room_hdr currenthdr = (mst_room_hdr)RoomHDRbindingSource1.Current; if (currenthdr != null) { var data = (ch_Active_roomhdr.Checked == true) ? 'A' : 'I'; if (data != currenthdr.mrm_status) { currenthdr.mrm_status = data; } } }
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 StatusTransaction endPlan(ref trn_patient_regi tpr, string mrm_code) { try { EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); mst_room_hdr mrm = mst.GetMstRoomHdr(mrm_code); return(endPlan(ref tpr, mrm.mrm_id)); } catch (Exception ex) { Program.MessageError("TransactionPlanCls", "endPlan", ex, false); return(StatusTransaction.Error); } }
public StatusTransaction endQueue(ref trn_patient_regi tpr, string mrm_code) { try { EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); mst_room_hdr mrm = mst.GetMstRoomHdr(mrm_code); int tps_id = Program.CurrentPatient_queue.tps_id; return(endQueue(ref tpr, tps_id)); } catch (Exception ex) { Program.MessageError("TransactionQueueCls", "endQueue", ex, false); return(StatusTransaction.Error); } }
public mst_room_hdr GetMstRoomHdrByMrd_id(int mrd_id) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { mst_room_hdr mrm = cdc.mst_room_dtls.Where(x => x.mrd_id == mrd_id).Select(x => x.mst_room_hdr).FirstOrDefault(); return(mrm); } } catch { } return(null); }
public mst_room_hdr GetMstRoomHdrByMvt(int mvt_id, int mhs_id) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { mst_room_hdr mrm = cdc.mst_room_events.Where(x => x.mvt_id == mvt_id && x.mst_room_hdr.mhs_id == mhs_id).Select(x => x.mst_room_hdr).FirstOrDefault(); return(mrm); } } catch { } return(null); }
private void RoomHDRbindingSource1_CurrentItemChanged1(object sender, EventArgs e) { mst_room_hdr currenthdr = (mst_room_hdr)RoomHDRbindingSource1.Current; if (currenthdr != null) { //status if (currenthdr.mrm_status == 'A') { ch_Active_roomhdr.Checked = true; } else { ch_Active_roomhdr.Checked = false; } } }
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 StatusTransaction endPlan(ref trn_patient_regi tpr, int mrm_id) { try { EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); mst_room_hdr mrm = mst.GetMstRoomHdr(mrm_id); List <int> list_mvt_id = new List <int>(); if (mrm.mrm_code == "EM") { if (Program.CurrentRoom.mrd_type == 'D') { list_mvt_id.Add(mst.GetMstEvent("EM").mvt_id); } else if (Program.CurrentRoom.mrd_type == 'N') { list_mvt_id.Add(mst.GetMstEvent("EN").mvt_id); } } else if (mrm.mrm_code == "TE") { if (Program.CurrentRoom.mrd_type == 'T') { list_mvt_id.Add(mst.GetMstEvent("TX").mvt_id); } else if (Program.CurrentRoom.mrd_type == 'D') { list_mvt_id.Add(mst.GetMstEvent("TE").mvt_id); } } else { list_mvt_id = mst.GetMstRoomEventByMrm(mrm_id).Select(x => x.mvt_id).ToList(); } //List<trn_patient_plan> tpl = tpr.trn_patient_plans // .Where(x => list_mvt_id.Contains(x.mvt_id)).ToList(); //tpl.ForEach(x => x.tpl_status = 'P'); return(endPlan(ref tpr, list_mvt_id)); } catch (Exception ex) { Program.MessageError("TransactionPlanCls", "endPlan", ex, false); return(StatusTransaction.Error); } }
public void SendToCheckC(ref trn_patient_regi PatientRegis, DateTime dateNow, string username, bool andSendBook = false) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { int mhs_id = (PatientRegis.tpr_site_use == null || PatientRegis.tpr_site_use == 0) ? (int)PatientRegis.mhs_id : (int)PatientRegis.tpr_site_use; mst_room_hdr mstRoomHdr = cdc.mst_room_hdrs.Where(x => x.mrm_code == "CC" && x.mhs_id == mhs_id).FirstOrDefault(); mst_event mstEvent = cdc.mst_events .Where(x => x.mvt_code == "CC") .FirstOrDefault(); trn_patient_queue PatientQueue = PatientRegis.trn_patient_queues.Where(x => x.mrm_id == mstRoomHdr.mrm_id && x.mvt_id == mstEvent.mvt_id).FirstOrDefault(); if (PatientQueue == null) { PatientQueue = new trn_patient_queue(); PatientQueue.mrm_id = mstRoomHdr.mrm_id; PatientQueue.mvt_id = mstEvent.mvt_id; PatientQueue.tps_create_by = username; PatientQueue.tps_create_date = dateNow; PatientRegis.trn_patient_queues.Add(PatientQueue); } PatientQueue.mrd_id = null; PatientQueue.tps_end_date = null; PatientQueue.tps_start_date = null; if (andSendBook) { PatientQueue.tps_status = "ED"; } else { PatientQueue.tps_status = "WK"; } PatientQueue.tps_ns_status = null; PatientQueue.tps_update_by = username; PatientQueue.tps_update_date = dateNow; } } catch (Exception ex) { throw ex; } }
private void btnNewRoomhdr_Click(object sender, EventArgs e) { RoomHDRbindingSource1.AddNew(); DateTime dtnow = Program.GetServerDateTime(); mst_room_hdr currenthdr = (mst_room_hdr)RoomHDRbindingSource1.Current; if (currenthdr != null) { string username = Program.CurrentUser.mut_username; int mshid = (from t1 in dbc.mst_hpc_sites select t1.mhs_id).FirstOrDefault(); int mzeid = (from t1 in dbc.mst_zones select t1.mze_id).FirstOrDefault(); currenthdr.mhs_id = mshid; currenthdr.mze_id = mzeid; currenthdr.mrm_create_by = username; currenthdr.mrm_create_date = dtnow; currenthdr.mrm_update_by = username; currenthdr.mrm_update_date = dtnow; } }
private void DDsite_SelectedValueChanged(object sender, EventArgs e) { /* * select mrm.mrm_id, * mrm.mrm_ename * from mst_room_hdr mrm * where mrm.mhs_id = 1 * and mrm.mrm_status = 'A' * and CONVERT(date,GETDATE(),103) between * CONVERT(date,isnull(mrm.mrm_effective_date,getdate()),103) and * CONVERT(date,isnull(mrm.mrm_expire_date,getdate()),103); */ int msh_id = Convert1.ToInt32(DDsite.SelectedValue); var datenow = Program.GetServerDateTime().Date; List <mst_room_hdr> objRoom = (from t1 in dbc.mst_room_hdrs where t1.mrm_status == 'A' && (t1.mrm_effective_date == null || (t1.mrm_effective_date.Value.Date <= datenow && (t1.mrm_expire_date == null || t1.mrm_expire_date.Value.Date >= datenow) ) ) select t1).ToList(); if (msh_id > 0) { objRoom = objRoom.Where(x => x.mhs_id == msh_id).ToList(); } mst_room_hdr roomselect = new mst_room_hdr(); roomselect.mrm_id = 0; roomselect.mrm_ename = "Select All"; objRoom.Add(roomselect); DDStation.DataSource = objRoom.OrderBy(x => x.mhs_id).ToList(); DDStation.DisplayMember = "mrm_ename"; DDStation.ValueMember = "mrm_id"; if (msh_id == 0) { DDStation.SelectedValue = 0; } }
public List <mst_room_dtl> GetListRoomDtl(string mrm_code, string mhs_code) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { mst_room_hdr mrm = GetMstRoomHdr(mrm_code, mhs_code); if (mrm != null) { int mrm_id = mrm.mrm_id; List <mst_room_dtl> mrd = GetListRoomDtl(mrm_id); return(mrd); } } } catch { } return(null); }
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 void updatePendingPatientPlan(ref trn_patient_regi tpr, int mvt_id, int mrm_id, int mhs_id) { EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); mst_room_hdr mrm = mst.GetMstRoomHdr(mrm_id); List <int> list_mvt_id; if (mrm.mrm_code == "TE") { list_mvt_id = new List <int> { mvt_id }; } else { list_mvt_id = mst.GetMstRoomEventByMrm(mrm_id).Select(x => x.mvt_id).ToList(); } List <trn_patient_plan> tpl = tpr.trn_patient_plans .Where(x => list_mvt_id.Contains(x.mvt_id)).ToList(); tpl.ForEach(x => x.tpl_status = 'C'); }
public bool CheckUseBeforePE(int mrm_id, int mvt_id) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { mst_event mstEvent = cdc.mst_events.Where(x => x.mvt_id == mvt_id).FirstOrDefault(); if (mstEvent.mvt_code != "PE") { return(false); } else { mst_room_hdr mstRoomHdr = cdc.mst_room_hdrs.Where(x => x.mrm_id == mrm_id).FirstOrDefault(); if (mstRoomHdr.mrm_code != "DC") { return(false); } else { if (mstRoomHdr.mst_hpc_site.mhs_use_before_pe == null || mstRoomHdr.mst_hpc_site.mhs_use_before_pe == false) { return(false); } else { return(true); } } } } } catch (Exception ex) { Program.MessageError("TransactionQueueCls", "CheckUseBeforePE(int mrm_id, int mvt_id)", ex, false); return(false); } }
public void SendToCheckB(ref trn_patient_regi PatientRegis, DateTime dateNow, string username) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { int mhs_id = (PatientRegis.tpr_site_use == null || PatientRegis.tpr_site_use == 0) ? (int)PatientRegis.mhs_id : (int)PatientRegis.tpr_site_use; mst_room_hdr mstRoomHdr = cdc.mst_room_hdrs.Where(x => x.mrm_code == "CB" && x.mhs_id == mhs_id).FirstOrDefault(); mst_event mstEvent = cdc.mst_events .Where(x => x.mvt_code == "CB") .FirstOrDefault(); trn_patient_queue PatientQueue = PatientRegis.trn_patient_queues .Where(x => x.mst_room_hdr.mrm_code == "CB" && x.mvt_id == mstEvent.mvt_id) .FirstOrDefault(); if (PatientQueue != null) { PatientRegis.tpr_pe_status = "RB"; PatientQueue.mrm_id = mstRoomHdr.mrm_id; PatientQueue.tps_status = "NS"; PatientQueue.tps_ns_status = "QL"; PatientQueue.mrd_id = null; PatientQueue.tps_end_date = null; PatientQueue.tps_start_date = null; PatientQueue.tps_update_by = username; PatientQueue.tps_update_date = dateNow; } else { SendToRoom(ref PatientRegis, mstRoomHdr.mrm_id, mstEvent.mvt_id, dateNow, username); } } } catch (Exception ex) { throw ex; } }
public void SendToPE(ref trn_patient_regi PatientRegis, DateTime dateNow, string username) // use for PE Before Check B { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { int mhs_id = (PatientRegis.tpr_site_use == null || PatientRegis.tpr_site_use == 0) ? (int)PatientRegis.mhs_id : (int)PatientRegis.tpr_site_use; mst_room_hdr mstRoomHdr = cdc.mst_room_hdrs.Where(x => x.mrm_code == "DC" && x.mhs_id == mhs_id).FirstOrDefault(); mst_event mstEvent = cdc.mst_events .Where(x => x.mvt_code == "PE") .FirstOrDefault(); trn_patient_queue PatientQueue = PatientRegis.trn_patient_queues .Where(x => x.mrm_id == mstRoomHdr.mrm_id && x.mvt_id == mstEvent.mvt_id) .FirstOrDefault(); SendToRoom(ref PatientRegis, mstRoomHdr.mrm_id, mstEvent.mvt_id, dateNow, username); } } catch (Exception ex) { throw ex; } }
public void SendToScreening(ref trn_patient_regi PatientRegis, DateTime dateNow, string username) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { int mhs_id = PatientRegis.mhs_id; mst_room_hdr mstRoomHdr = cdc.mst_room_hdrs.Where(x => x.mrm_code == "SC" && x.mhs_id == mhs_id).FirstOrDefault(); mst_event mstEvent = cdc.mst_events .Where(x => x.mvt_code == "SC") .FirstOrDefault(); trn_patient_queue PatientQueue = PatientRegis.trn_patient_queues.Where(x => x.mrm_id == mstRoomHdr.mrm_id && x.mvt_id == mstEvent.mvt_id).FirstOrDefault(); if (PatientQueue == null) { PatientQueue = new trn_patient_queue(); PatientQueue.mrm_id = mstRoomHdr.mrm_id; PatientQueue.mvt_id = mstEvent.mvt_id; PatientQueue.tps_create_by = username; PatientQueue.tps_create_date = dateNow; PatientRegis.trn_patient_queues.Add(PatientQueue); } PatientQueue.mrd_id = null; PatientQueue.tps_end_date = null; PatientQueue.tps_start_date = null; PatientQueue.tps_status = "NS"; PatientQueue.tps_ns_status = "QL"; PatientQueue.tps_update_by = username; PatientQueue.tps_update_date = dateNow; } } catch (Exception ex) { throw ex; } }
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 mst_room_hdr GetMstRoomHdr(string mrm_code, int mhs_id, int?tpr_site_use) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { int?site_id; if (mrm_code == "CC" || mrm_code == "PH" || mrm_code == "BK") { site_id = mhs_id; } else { site_id = (tpr_site_use != null) ? tpr_site_use : mhs_id; } mst_room_hdr mrm = cdc.mst_room_hdrs.Where(x => x.mrm_code == mrm_code && x.mhs_id == site_id).FirstOrDefault(); return(mrm); } } catch { } return(null); }
public void LoadData() { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { if (mrm_code == "RG") { DateTime dateNow = Program.GetServerDateTime(); List <sp_get_waiting_room_hdrResult> result = cdc.tmp_getptarriveds .Where(x => (x.flag_success == null || x.flag_success == 'N') && x.ctloc_code == mhs_code && x.paadm_admdate.Value.Date == dateNow.Date) .OrderBy(x => x.appt_arrivaltime) .Select(x => new sp_get_waiting_room_hdrResult { tpt_hn_no = x.papmi_no, tpt_othername = x.ttl_desc + x.papmi_name + " " + x.papmi_name2 }).ToList(); int inx = 1; result.ForEach(x => x.priority = inx++); DGV_Waiting.Columns["colBtnCancelQueue"].Visible = false; DGV_Waiting.Columns["colSendToCheckB"].Visible = false; DGV_Waiting.DataSource = result; } else { mst_room_hdr room_hdr = cdc.mst_room_hdrs .Where(x => x.mhs_id == mhs_id && x.mrm_code == mrm_code) .FirstOrDefault(); if (room_hdr != null) { List <sp_get_waiting_room_hdrResult> result = cdc.sp_get_waiting_room_hdr(room_hdr.mrm_id).ToList(); if (result.Count() == 0) { DGV_Waiting.DataSource = new List <sp_get_waiting_room_hdrResult>(); } else { if (mrm_code == "BM" || mrm_code == "SC" || mrm_code == "PH") { DGV_Waiting.Columns["colBtnCancelQueue"].Visible = false; DGV_Waiting.Columns["colSendToCheckB"].Visible = false; DGV_Waiting.DataSource = result; } else if (mrm_code == "EM") { int?eye_nurse_mvt_id = cdc.mst_events.Where(x => x.mvt_code == "EN").Select(x => x.mvt_id).FirstOrDefault(); result = result.OrderBy(x => eye_nurse_mvt_id == x.mvt_id ? 0 : 1) .Select((x, inx) => new sp_get_waiting_room_hdrResult { priority = inx + 1, tpr_id = x.tpr_id, tps_id = x.tps_id, mvt_id = x.mvt_id, tpr_queue_no = x.tpr_queue_no, tpt_hn_no = x.tpt_hn_no, tpt_othername = x.tpt_othername, holded = x.holded, reserved = x.reserved }).ToList(); DGV_Waiting.DataSource = result; } else { DGV_Waiting.DataSource = result; } } lbtitle1.Text = string.Format(room_hdr.mrm_ename + "(Total {0})", DGV_Waiting.Rows.Count.ToString()); } else { lbtitle1.Text = ""; } } } } catch (Exception ex) { Program.MessageError(this.Name, "LoadData", ex, false); DGV_Waiting.DataSource = new List <sp_get_waiting_room_hdrResult>(); } }
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); }
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); } }