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);
}
}
