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