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