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