private ResultSendQueue CheckEventCate(ref List <sp_get_patient_roomResult> patientRoom) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { mst_event eventDoctor = cdc.mst_events.Where(x => x.mvt_code == "EM" && x.mvt_status == 'A').FirstOrDefault(); mst_event eventNurse = cdc.mst_events.Where(x => x.mvt_code == "EN" && x.mvt_status == 'A').FirstOrDefault(); if (eventDoctor != null && eventNurse != null) { foreach (sp_get_patient_roomResult re in patientRoom) { if (re.mvt_id == eventDoctor.mvt_id) { if (patientRoom.Any(x => x.mvt_id == eventNurse.mvt_id)) { re.mvt_type_cate = "S"; } else { re.mvt_type_cate = "M"; } } } } return(ResultSendQueue.SendComplete); } } catch (Exception ex) { globalCls.MessageError("get_lab_result.Class.SendAutoCls", "CheckEventCate(ref List<sp_get_patient_roomResult> patientRoom)", ex.Message); return(ResultSendQueue.Error); } }
public void updatePendingPatientPlan(ref trn_patient_regi tpr, string mvt_code, int mrm_id, int mhs_id) { EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); mst_event mvt = mst.GetMstEvent(mvt_code); updatePendingPatientPlan(ref tpr, mrm_id, mvt.mvt_id, mhs_id); }
private void btnEventAddNew_Click(object sender, EventArgs e) { EventbindingSource1.AddNew(); mst_event newitem = (mst_event)EventbindingSource1.Current; string createBy = Program.CurrentUser.mut_username; DateTime dtnow = Program.GetServerDateTime(); newitem.mvt_create_by = createBy; newitem.mvt_create_date = dtnow; newitem.mvt_update_by = createBy; newitem.mvt_update_date = dtnow; }
private void chEventActive_MouseClick(object sender, MouseEventArgs e) { mst_event currentevent = (mst_event)EventbindingSource1.Current; if (currentevent != null) { var data = (chEventActive.Checked == true) ? 'A' : 'I'; if (data != currentevent.mvt_status) { currentevent.mvt_status = data; } } }
private void RDEvent_Type_Main_MouseClick(object sender, MouseEventArgs e) { mst_event currentevent = (mst_event)EventbindingSource1.Current; if (currentevent != null) { var data = Program.GetValueRadioTochar(pnlMainSub); if (data != currentevent.mvt_type_cate) { currentevent.mvt_type_cate = 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 mst_event GetMstEvent(string mvt_code) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { mst_event mvt = cdc.mst_events.Where(x => x.mvt_code == mvt_code).FirstOrDefault(); return(mvt); } } catch { } return(null); }
private void EventbindingSource1_CurrentItemChanged(object sender, EventArgs e) { mst_event newitem = (mst_event)EventbindingSource1.Current; if (newitem != null) { if (newitem.mvt_status == 'A') { chEventActive.Checked = true; } else { chEventActive.Checked = false; } Program.SetValueRadioGroup(pnlMainSub, newitem.mvt_type_cate); } }
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 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 bool checkPE(int?mvt_id) { using (InhCheckupDataContext contxt = new InhCheckupDataContext()) { mst_event mstEvent = contxt.mst_events.Where(x => x.mvt_id == this.queue_mvt_id).FirstOrDefault(); if (mstEvent != null) { if (mstEvent.mvt_code == "PE") { return(true); } else { return(false); } } else { return(false); } } }
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 SendAutoResult SendAuto(int tps_id, List <int> ListCompleteEvent, string username, int?current_site) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { cdc.Connection.Open(); DbTransaction trans = cdc.Connection.BeginTransaction(); cdc.Transaction = trans; try { trn_patient_queue PatientQueue = cdc.trn_patient_queues .Where(x => x.tps_id == tps_id) .FirstOrDefault(); trn_patient_regi PatientRegis = PatientQueue.trn_patient_regi; int tpr_id = PatientRegis.tpr_id; string queue_no = PatientRegis.tpr_queue_no; int mrm_id = (int)PatientQueue.mrm_id; int? mrd_id = PatientQueue.mrd_id; int? mhs_id = PatientRegis.tpr_site_use == null ? PatientRegis.mhs_id : PatientRegis.tpr_site_use; int _current_site = current_site != null ? (int)current_site : PatientQueue.mst_room_hdr.mhs_id; List <int> room_event = new List <int>(); mst_room_hdr roomHdr = cdc.mst_room_hdrs.Where(x => x.mrm_id == mrm_id).FirstOrDefault(); if (PatientQueue.mrd_id != null) { mst_room_dtl roomDtl = roomHdr.mst_room_dtls.Where(x => x.mrd_id == PatientQueue.mrd_id).FirstOrDefault(); if (roomDtl != null) { if (roomDtl.mst_room_hdr.mrm_code == "EM") { if (roomDtl.mrd_type == 'D') { mst_event mstEvent = cdc.mst_events.Where(x => x.mvt_code == "EM" && x.mvt_status == 'A').FirstOrDefault(); room_event.Add(mstEvent.mvt_id); } else { mst_event mstEvent = cdc.mst_events.Where(x => x.mvt_code == "EN" && x.mvt_status == 'A').FirstOrDefault(); room_event.Add(mstEvent.mvt_id); } } else { room_event = cdc.mst_room_events .Where(x => x.mrm_id == mrm_id) .Select(x => x.mvt_id).ToList(); } } } else { room_event = cdc.mst_room_events .Where(x => x.mrm_id == mrm_id) .Select(x => x.mvt_id).ToList(); } DateTime dateNow = globalCls.GetServerDateTime(); int? mze_id = null; if (roomHdr.mrm_code != "CB") { mze_id = roomHdr.mze_id; } int?next_mrm_id = null; int?next_mvt_id = null; List <sp_get_patient_roomResult> patientRoom = cdc.sp_get_patient_room(tpr_id, mhs_id).ToList(); List <sp_get_patient_roomResult> patientEventComplete = patientRoom.Where(x => ListCompleteEvent.Contains(x.mvt_id)).ToList(); foreach (sp_get_patient_roomResult pr in patientEventComplete) { patientRoom.Remove(pr); } List <inx_sp_get_patient_roomResult> inxPatientRoom = new List <inx_sp_get_patient_roomResult>(); ResultSendQueue result = filterPatientRoom(patientRoom, ref inxPatientRoom, room_event, _current_site, mze_id, 0); if (result == ResultSendQueue.Error) { return(new SendAutoResult { SendResult = SendAutoResult.Result.Error, AlertMsg = "Please Try Again." }); } else if (result == ResultSendQueue.OldRoom) { return(new SendAutoResult { SendResult = SendAutoResult.Result.Error, AlertMsg = "Please Try Again." }); } else { SendAutoResult _SendAutoResult = new SendAutoResult(); new TransactionPlanCls().EndPlan(ref PatientRegis, ListCompleteEvent); new TransactionQueueCls().EndQueue(ref PatientRegis, tps_id, dateNow, username); if (result == ResultSendQueue.SendCheckC) { new TransactionQueueCls().SendToCheckC(ref PatientRegis, dateNow, username); //new Class.GetLabResultCls().Insert_trn_patient_assBackground(tpr_id); new Class.InsertLabCls().RetrieveLabToEmrCheckup(tpr_id, username); new Class.GetVitalSignCLs().GetVistalSignBackground(tpr_id); var roomChkC = cdc.mst_room_hdrs .Where(x => x.mrm_code == "CC" && x.mhs_id == PatientRegis.mhs_id) .Select(x => new { x.mrm_ename, x.mst_hpc_site.mhs_ename, x.mst_zone.mze_ename }).FirstOrDefault(); if (roomChkC == null) { _SendAutoResult.AlertMsg = "Send Queue no. " + queue_no + " To Check Point C."; } else { _SendAutoResult.AlertMsg = string.Format(TemplateMsg, roomChkC.mrm_ename, roomChkC.mhs_ename, roomChkC.mze_ename, queue_no); } } else if (result == ResultSendQueue.SendCheckB) { new TransactionQueueCls().SendToCheckB(ref PatientRegis, dateNow, username); var chkB = PatientRegis.trn_patient_queues .Where(x => x.tps_status == "NS" && x.tps_ns_status == "QL") .Select(x => new { x.mrm_id, }).FirstOrDefault(); var room = cdc.mst_room_hdrs.Where(x => x.mrm_id == mrm_id).FirstOrDefault(); _SendAutoResult.AlertMsg = string.Format(TemplateMsg, room.mrm_ename, room.mst_hpc_site.mhs_ename, room.mst_zone.mze_ename, queue_no); } else { bool patient_eye_dropper = PatientRegis.trn_eye_exam_hdrs.Count() != 0 ? (PatientRegis.trn_eye_exam_hdrs.FirstOrDefault().teh_eyedropper == null ? false : (bool)PatientRegis.trn_eye_exam_hdrs.FirstOrDefault().teh_eyedropper) : false; bool checkEyeDoc = CheckEyeDoctor(tpr_id, mrd_id, patient_eye_dropper, inxPatientRoom, ref next_mrm_id, ref next_mvt_id); if (checkEyeDoc && next_mrm_id != null && next_mvt_id != null) { new TransactionQueueCls().SendToRoom(ref PatientRegis, (int)next_mrm_id, (int)next_mvt_id, dateNow, username); var nextRoom = inxPatientRoom.Where(x => x.mrm_id == next_mrm_id && x.mvt_id == next_mvt_id) .Select(x => new { x.mrm_ename, x.mhs_ename, x.mze_ename }).FirstOrDefault(); _SendAutoResult.AlertMsg = string.Format(TemplateMsg, nextRoom.mrm_ename, nextRoom.mhs_ename, nextRoom.mze_ename, queue_no); } else { string doctor_code = (PatientRegis.tpr_req_doc_code == null || PatientRegis.tpr_req_doc_code == "") ? PatientRegis.tpr_pe_doc_code : PatientRegis.tpr_req_doc_code; bool checkPE = CheckPE(tpr_id, doctor_code, inxPatientRoom, dateNow, ref next_mrm_id, ref next_mvt_id); if (checkPE) { new TransactionQueueCls().SendToRoom(ref PatientRegis, (int)next_mrm_id, (int)next_mvt_id, dateNow, username); var nextRoom = inxPatientRoom.Where(x => x.mrm_id == next_mrm_id && x.mvt_id == next_mvt_id) .Select(x => new { x.mrm_ename, x.mhs_ename, x.mze_ename }).FirstOrDefault(); _SendAutoResult.AlertMsg = string.Format(TemplateMsg, nextRoom.mrm_ename, nextRoom.mhs_ename, nextRoom.mze_ename, queue_no); } else { inx_sp_get_patient_roomResult firstPatientRoom = inxPatientRoom.OrderBy(x => x.priority).FirstOrDefault(); next_mrm_id = firstPatientRoom.mrm_id; next_mvt_id = firstPatientRoom.mvt_id; new TransactionQueueCls().SendToRoom(ref PatientRegis, (int)next_mrm_id, (int)next_mvt_id, dateNow, username); _SendAutoResult.AlertMsg = string.Format(TemplateMsg, firstPatientRoom.mrm_ename, firstPatientRoom.mhs_ename, firstPatientRoom.mze_ename, queue_no); } } } cdc.SubmitChanges(); if (inxPatientRoom.Count() > 0) { trn_patient_queue next_queue = PatientRegis.trn_patient_queues .Where(x => (x.tps_status == "NS" && x.tps_ns_status == "QL") || (x.tps_status == "NS" && x.tps_ns_status == "WP")).FirstOrDefault(); if (next_queue != null) { List <log_send_auto> log = GetLogSendAuto(inxPatientRoom, next_queue.tps_id, tps_id, queue_no); cdc.log_send_autos.InsertAllOnSubmit(log); } } cdc.SubmitChanges(); cdc.Transaction.Commit(); return(_SendAutoResult); } } catch (Exception ex) { globalCls.MessageError("get_lab_result.Class.SendAutoCls", "SendAuto(int tpr_id)", ex.Message); return(new SendAutoResult { SendResult = SendAutoResult.Result.Error, AlertMsg = "Please Try Again." }); } } } catch (Exception ex) { globalCls.MessageError("get_lab_result.Class.SendAutoCls", "SendAuto(int tpr_id)", ex.Message); return(new SendAutoResult { SendResult = SendAutoResult.Result.Error, AlertMsg = "Please Try Again." }); } }
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); } }
private void gridStation_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (gridStation.Columns[e.ColumnIndex].Name == "colBtn") { StatusTransaction updateLower = UpdatedLower(); if (updateLower == StatusTransaction.True) { gridStationObj gso = (gridStationObj)gridStationBindingSource.Current; EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); mst_event mvt = mst.GetMstEvent(gso.mvt_id); if (mvt.mvt_code == "EM") { List <gridStationObj> obj = (List <gridStationObj>)gridStationBindingSource.DataSource; mst_event eyeNurseEvent = mst.GetMstEvent("EN"); var incMvtCode = obj.Select(x => mst.GetMstEvent(x.mvt_id).mvt_code).ToList(); if (incMvtCode.Contains(eyeNurseEvent.mvt_code)) { MessageBox.Show("Can not send to " + mvt.mvt_ename + " before " + eyeNurseEvent.mvt_ename + "." + Environment.NewLine + "Please select another room.", "Send Queue Alert", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } bool success = false; gridStationObj result = (gridStationObj)gridStationBindingSource.Current; if (rdSkip.Checked) { Class.ClsSkipOnStation skip = new Class.ClsSkipOnStation(); if (_useform == useform.onStation) { //success = skip.skipOnStationSendManaul((int)result.mrm_id, result.mvt_id); StatusTransaction skipStation = skip.skipOnStationSendManaul((int)_tpr_id, (int)_tps_id, (int)result.mrm_id, result.mvt_id); if (skipStation == StatusTransaction.True) { new Class.logPatientFlowCls(Class.logPatientFlowCls.sendType.SkipManual, (int)_tpr_id, (int)_tps_id, Program.CurrentSite.mhs_id, Program.CurrentRoom.mrd_ename, Program.CurrentUser.mut_username); success = true; //if (new EmrClass.GetDataMasterCls().GetMstRoomHdr((int)result.mrm_id).mrm_code == "DC") //{ //new Class.FunctionDataCls().stampPEDoctor((int)_tpr_id); //} } else if (skipStation == StatusTransaction.NoProcess) { MessageBox.Show("คนไข้ไม่ได้อยู่ในสถานะดำเนินการ skip ต่อได้", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (skipStation == StatusTransaction.Error) { MessageBox.Show("กรุณา skip อีกครั้ง", "Alert.", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else if (_useform == useform.onWaiting) { //success = skip.skipOnStationSendManaul((int)result.mrm_id, result.mvt_id); StatusTransaction skipStation = skip.skipOnWaitingSendManaul((int)_tpr_id, (int)_tps_id, (int)result.mrm_id, result.mvt_id); if (skipStation == StatusTransaction.True) { new Class.logPatientFlowCls(Class.logPatientFlowCls.sendType.SkipOnWaitingManual, (int)_tpr_id, (int)_tps_id, Program.CurrentSite.mhs_id, "WaitingList", Program.CurrentUser.mut_username); success = true; //if (new EmrClass.GetDataMasterCls().GetMstRoomHdr((int)result.mrm_id).mrm_code == "DC") //{ //new Class.FunctionDataCls().stampPEDoctor((int)_tpr_id); //} } else if (skipStation == StatusTransaction.NoProcess) { MessageBox.Show("คนไข้ไม่ได้อยู่ในสถานะดำเนินการ skip ต่อได้", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (skipStation == StatusTransaction.Error) { MessageBox.Show("กรุณา skip อีกครั้ง", "Alert.", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else if (rdPending.Checked) { Class.ClsPendingOnStation pend = new Class.ClsPendingOnStation(); if (_useform == useform.onStation) { //success = pend.pendingOnStationSendManaul((int)result.mrm_id, result.mvt_id); StatusTransaction pendingStation = pend.pendingOnStationSendManaul((int)_tpr_id, (int)_mvt_id, (int)_mrm_id, (int)_mhs_id, (int)result.mrm_id, result.mvt_id, (int)_tps_id); if (pendingStation == StatusTransaction.True) { new Class.logPatientFlowCls(Class.logPatientFlowCls.sendType.PendingManual, (int)_tpr_id, (int)_tps_id, Program.CurrentSite.mhs_id, Program.CurrentRoom.mrd_ename, Program.CurrentUser.mut_username); success = true; //if (new EmrClass.GetDataMasterCls().GetMstRoomHdr((int)result.mrm_id).mrm_code == "DC") //{ //new Class.FunctionDataCls().stampPEDoctor((int)_tpr_id); //} } else if (pendingStation == StatusTransaction.NoProcess) { MessageBox.Show("คนไข้ไม่ได้อยู่ในสถานะดำเนินการ pending ต่อได้", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (pendingStation == StatusTransaction.Error) { MessageBox.Show("กรุณา pending อีกครั้ง", "Alert.", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else if (_useform == useform.onWaiting) { //success = pend.pendingOnStationSendManaul((int)result.mrm_id, result.mvt_id); StatusTransaction pendingStation = pend.pendingOnWaitingSendManaul((int)_tpr_id, (int)_mvt_id, (int)_mrm_id, (int)_mhs_id, (int)result.mrm_id, result.mvt_id, (int)_tps_id); if (pendingStation == StatusTransaction.True) { new Class.logPatientFlowCls(Class.logPatientFlowCls.sendType.PendingOnWaitingManual, (int)_tpr_id, (int)_tps_id, Program.CurrentSite.mhs_id, "WaitingList", Program.CurrentUser.mut_username); success = true; //if (new EmrClass.GetDataMasterCls().GetMstRoomHdr((int)result.mrm_id).mrm_code == "DC") //{ //new Class.FunctionDataCls().stampPEDoctor((int)_tpr_id); //} } else if (pendingStation == StatusTransaction.NoProcess) { MessageBox.Show("คนไข้ไม่ได้อยู่ในสถานะดำเนินการ pending ต่อได้", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (pendingStation == StatusTransaction.Error) { MessageBox.Show("กรุณากด pending อีกครั้ง", "Alert.", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } if (success) { Program.CurrentRegis = null; Program.CurrentPatient_queue = null; this.DialogResult = System.Windows.Forms.DialogResult.OK; } } else if (updateLower == StatusTransaction.Error) { MessageBox.Show("กรุณากด send manual อีกครั้ง", "Alert.", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception ex) { MessageBox.Show("กรุณากด send manual อีกครั้ง", "Alert.", MessageBoxButtons.OK, MessageBoxIcon.Information); Program.MessageError("frmCancelQueue", "gridStation_CellContentClick", ex, false); } finally { this.Close(); } }
private StatusTransaction get_list_tpl_id(int tpr_id, int mrm_id, ref List <int> list_tpl_id) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { List <int> list_mvt_id = new List <int>(); mst_room_hdr mrm = cdc.mst_room_hdrs.Where(x => x.mrm_id == mrm_id).FirstOrDefault(); switch (mrm.mrm_code) { case "EM": if (Program.CurrentRoom.mrd_type == 'D') { mst_event mvt = cdc.mst_events.Where(x => x.mvt_code == "EM").FirstOrDefault(); if (mvt != null) { list_mvt_id.Add(mvt.mvt_id); } else { return(StatusTransaction.Error); } } else if (Program.CurrentRoom.mrd_type == 'N') { mst_event mvt = cdc.mst_events.Where(x => x.mvt_code == "EN").FirstOrDefault(); if (mvt != null) { list_mvt_id.Add(mvt.mvt_id); } else { return(StatusTransaction.Error); } } break; case "TE": if (Program.CurrentRoom.mrd_type == 'D') { mst_event mvt = cdc.mst_events.Where(x => x.mvt_code == "TX").FirstOrDefault(); if (mvt != null) { list_mvt_id.Add(mvt.mvt_id); } else { return(StatusTransaction.Error); } } else if (Program.CurrentRoom.mrd_type == 'N') { mst_event mvt = cdc.mst_events.Where(x => x.mvt_code == "TE").FirstOrDefault(); if (mvt != null) { list_mvt_id.Add(mvt.mvt_id); } else { return(StatusTransaction.Error); } } break; default: List <mst_room_event> list_room_event = cdc.mst_room_events.Where(x => x.mrm_id == mrm_id).ToList(); if (list_room_event != null && list_room_event.Count > 0) { list_mvt_id = list_room_event.Select(x => x.mvt_id).ToList(); } else { return(StatusTransaction.Error); } break; } List <trn_patient_plan> list_patient_plan = cdc.trn_patient_plans.Where(x => x.tpr_id == tpr_id && list_mvt_id.Contains(x.mvt_id)).ToList(); if (list_patient_plan != null && list_patient_plan.Count() > 0) { list_tpl_id = list_patient_plan.Select(x => x.tpl_id).ToList(); return(StatusTransaction.True); } else { return(StatusTransaction.Error); } } } catch (Exception ex) { Program.MessageError("SendManaulCls", "get_list_tpl_id", ex, false); return(StatusTransaction.Error); } }
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 bool SendQueueDoctorPEBeforeCheckB(int tpr_id, int tps_id, string username) { try { DateTime dateNow = Program.GetServerDateTime(); using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { try { cdc.Connection.Open(); DbTransaction trans = cdc.Connection.BeginTransaction(); cdc.Transaction = trans; trn_patient_regi patientRegis = cdc.trn_patient_regis .Where(x => x.tpr_id == tpr_id) .FirstOrDefault(); trn_patient_queue PatientQueue = patientRegis.trn_patient_queues .Where(x => x.tps_id == tps_id) .FirstOrDefault(); PatientQueue.tps_send_by = username; PatientQueue.tps_end_date = dateNow; PatientQueue.tps_status = "ED"; PatientQueue.tps_ns_status = null; PatientQueue.tps_update_by = username; PatientQueue.tps_update_date = dateNow; mst_event eventScreening = cdc.mst_events.Where(x => x.mvt_code == "SC").FirstOrDefault(); if (patientRegis.trn_patient_queues.Any(x => x.mvt_id == eventScreening.mvt_id)) { if (patientRegis.tpr_return_screening == true) { patientRegis.tpr_return_screening = false; SendToScreening(ref patientRegis, dateNow, username); } else { SendToCheckB(ref patientRegis, dateNow, username); } } else { SendToScreening(ref patientRegis, dateNow, username); } cdc.SubmitChanges(); cdc.Transaction.Commit(); return(true); } catch (Exception ex) { cdc.Transaction.Rollback(); Program.MessageError("TransactionQueueCls", "ReadyQueue(int tps_id, int mrd_id, string username)", ex, false); return(false); } finally { cdc.Connection.Close(); } } } catch (Exception ex) { Program.MessageError("TransactionQueueCls", "ReadyQueue(int tps_id, int mrd_id, string username)", ex, false); return(false); } }
private bool ProcessSelectRoom(int select_mvt_id, int select_mrm_id, int waitingTime) { EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls(); Class.FunctionDataCls func = new Class.FunctionDataCls(); int tpr_id = Program.CurrentRegis.tpr_id; int mrm_id = Program.CurrentRoom.mrm_id; mst_room_hdr currentRoom = mst.GetMstRoomHdr(mrm_id); if (currentRoom != null && currentRoom.mrm_code == "EM" && Program.CurrentRoom.mrd_type == 'N') { mst_event selectRoom = mst.GetMstEvent(select_mvt_id); if (func.checkEyeDropper(tpr_id)) { if (selectRoom != null) { if (selectRoom.mvt_code == "EM") { if (MessageBox.Show("มีการเลือก Eye Dropper ซึ่งมีการรอ 15 นาที" + Environment.NewLine + "คุณต้องการดำเนินการต่อหรือไม่?", "Warning!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { return(true); } else { return(false); } } else { var timelimit = Program.GetLimitTime("EDT"); if (waitingTime > timelimit) { if (MessageBox.Show("ห้องที่คุณเลือก มีเวลารอเกิน " + timelimit.ToString() + " นาที" + Environment.NewLine + "คุณต้องการดำเนินการต่อหรือไม่?", "Warning!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { return(true); } else { return(false); } } else { return(true); } } } return(false); } else { if (selectRoom != null) { if (selectRoom.mvt_code != "EM") { if (MessageBox.Show("ส่งห้องที่ไม่ใช่ Eye Doctor คุณต้องการจะดำเนินการต่อหรือไม่?", "Warning!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { return(true); } else { return(false); } } else { return(true); } } return(false); } } else { return(true); } }