private void btnSave_Click(object sender, EventArgs e)
{
try
{
papResultUC1.EndEdit();
try
{
cdc.SubmitChanges();
}
catch (System.Data.Linq.ChangeConflictException)
{
foreach (System.Data.Linq.ObjectChangeConflict occ in cdc.ChangeConflicts)
{
cdc.Refresh(System.Data.Linq.RefreshMode.KeepChanges, occ.Object);
}
cdc.SubmitChanges();
}
lblAlert.Text = "Save Data Complete.";
}
catch (Exception ex)
{
Program.MessageError(this.Name, "btnSave_Click(object sender, EventArgs e)", ex, false);
lblAlert.Text = "Please Try Again.";
}
}
public static void kickLoginOldRoom(int mut_id, int mrd_id)
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
var log = cdc.log_user_logins.Where(x => x.mut_id == mut_id && /*x.mrd_id == mrd_id &&*/ x.lug_end_date == null).ToList();
foreach (log_user_login item in log)
{
item.lug_end_date = Program.GetServerDateTime();
}
cdc.SubmitChanges();
List <log_user_login> log_room = cdc.log_user_logins.Where(x => /*x.mrd_id == mrd_id &&*/ x.lug_end_date == null).ToList();
if (log_room == null || log_room.Count() == 0)
{
List <int?> list_mrd_id = log_room.Select(x => x.mrd_id).ToList();
List <mst_room_dtl> list_room_dtl = cdc.mst_room_dtls.Where(x => list_mrd_id.Contains(x.mrd_id)).ToList();
list_room_dtl.ForEach(x => x.mrd_rm_status = 'E');
//mst_room_dtl mrd = cdc.mst_room_dtls.Where(x => x.mrd_id == mrd_id).FirstOrDefault();
//if (mrd != null)
//{
// mrd.mrd_rm_status = 'E';
//}
}
mst_user_type mut = cdc.mst_user_types.Where(x => x.mut_id == mut_id).FirstOrDefault();
mut.mut_login_status = Program.get_mutLoginStatus;
cdc.SubmitChanges();
}
}
public static void ExitRoom()
{
if (Program.CurrentRoom != null && Program.CurrentUser != null && Class.ClsManageUserLogin.current_log != null)
{
InhCheckupDataContext dbc = new InhCheckupDataContext();
//log_user_login currentloguserlogin = (from t1 in dbc.log_user_logins
// where t1.mrd_id == Program.CurrentRoom.mrd_id
// && t1.mut_id == Program.CurrentUser.mut_id
// && t1.lug_end_date == null
// select t1).FirstOrDefault();
log_user_login currentloguserlogin = dbc.log_user_logins.Where(x => x.lug_id == Class.ClsManageUserLogin.current_log.lug_id).FirstOrDefault();
if (currentloguserlogin != null)
{
currentloguserlogin.lug_end_date = Program.GetServerDateTime();
}
mst_user_type CurrentUser = (from t1 in dbc.mst_user_types where t1.mut_id == Program.CurrentUser.mut_id select t1).FirstOrDefault();
CurrentUser.mut_login_status = get_mutLoginStatus;
dbc.SubmitChanges();
Program.CurrentUser = CurrentUser;
mst_room_dtl currentroom = (from t1 in dbc.mst_room_dtls where t1.mrd_id == Program.CurrentRoom.mrd_id select t1).FirstOrDefault();
if (currentroom != null)
{
currentroom.mrd_rm_status = 'E';
dbc.SubmitChanges();
}
}
get_mutLoginStatus = '0';
Class.ClsManageUserLogin.current_log = null;
Program.CurrentRegis = null;
Program.CurrentRoom = null;
GC.Collect(); //คำสั่ง Clear Memory ที่เคยเรียก data base มาใช้งาน
AlertOutDepartment.StopTime(); //ปิดการทำงานการเตือน Out Department
}
public StatusTransaction skipOnStationSendManaul(int tpr_id, int tps_id, int next_mrm_id, int next_mvt_id)
{
try
{
InhCheckupDataContext cdc = new InhCheckupDataContext();
trn_patient_regi tpr = cdc.trn_patient_regis.Where(x => x.tpr_id == tpr_id).FirstOrDefault();
trn_patient_queue tps = tpr.trn_patient_queues.Where(x => x.tps_id == tps_id).FirstOrDefault();
Class.FunctionDataCls func = new Class.FunctionDataCls();
updatePlanForSkip(ref tpr, tps_id);
skipReserveCurrentQueue(ref tpr, tps_id);
func.deleteCurrentQueue(ref cdc, ref tpr, tps_id);
func.insertNextQueue(ref tpr, next_mrm_id, next_mvt_id);
try
{
cdc.SubmitChanges();
return(StatusTransaction.True);
}
catch (System.Data.Linq.ChangeConflictException)
{
foreach (ObjectChangeConflict occ in cdc.ChangeConflicts)
{
cdc.Refresh(System.Data.Linq.RefreshMode.KeepChanges, occ.Object);
}
cdc.SubmitChanges();
return(StatusTransaction.True);
}
}
catch (Exception ex)
{
Program.MessageError("ClsSkipOnStation", "skipOnStationSendManaul", ex, false);
return(StatusTransaction.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
tabAssessmentAndPlanUC1.EndEdit();
try
{
dbc.SubmitChanges();
}
catch (System.Data.Linq.ChangeConflictException)
{
foreach (System.Data.Linq.ObjectChangeConflict occ in dbc.ChangeConflicts)
{
dbc.Refresh(System.Data.Linq.RefreshMode.KeepChanges, occ.Object);
}
dbc.SubmitChanges();
}
lbAlertMsg.Text = "Save Data Complete.";
}
catch (Exception ex)
{
Program.MessageError(this.Name, "btnSave_Click", ex, false);
lbAlertMsg.Text = "โปรดลองอีกครั้ง";
}
}
private void btnSave_Click(object sender, EventArgs e)
{
lblMsg.Text = "";
try
{
DateTime dateNow = Program.GetServerDateTime();
DataBinding_trn_doctor_exam.EndEdit();
var other = DataBinding_trn_doctor_exam.OfType <trn_doctor_exam>().FirstOrDefault();
if (other.trxm_create_date == null)
{
other.trxm_create_date = dateNow;
}
other.trxm_update_date = dateNow;
try
{
trn_patient_book_result bookResult = dbc.trn_patient_book_results
.Where(x => x.tpr_id == Program.CurrentRegis.tpr_id &&
x.tpbr_radiology == "OE")
.FirstOrDefault();
if (bookResult == null)
{
bookResult = new trn_patient_book_result()
{
tpr_id = Program.CurrentRegis.tpr_id,
tpbr_radiology = "OE",
tpbr_create_by = Program.CurrentUser.mut_username,
tpbr_create_date = dateNow
};
dbc.trn_patient_book_results.InsertOnSubmit(bookResult);
}
bookResult.tpbr_flag_saved = true;
bookResult.tpbr_show_sections = true;
bookResult.tpbr_show_summary = true;
bookResult.tpbr_not_show_report = false;
bookResult.tpbr_active = true;
bookResult.tpbr_update_by = Program.CurrentUser.mut_username;
bookResult.tpbr_update_date = dateNow;
dbc.SubmitChanges();
}
catch (System.Data.Linq.ChangeConflictException)
{
foreach (System.Data.Linq.ObjectChangeConflict occ in dbc.ChangeConflicts)
{
dbc.Refresh(System.Data.Linq.RefreshMode.KeepChanges, occ.Object);
}
dbc.SubmitChanges();
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
lblMsg.Text = "Save Data Completed.";
}
//------------Save && Cancel
private void btnSaveStationRoom_Click(object sender, EventArgs e)
{
lbmsgAlert.Text = "";
mstroomdtlsBindingSource.EndEdit();
RoomHDRbindingSource1.EndEdit();
dbc.SubmitChanges();
lbmsgAlert.Text = "Save data completed.";
LoadRoomEvent(0);
}
private bool Save(char strType)
{
try
{
if (strType == 'N')
{
var objQuestP = (from t1 in dbc.trn_ques_patients where t1.tpr_id == SetTprID select new { t1.tqp_type }).FirstOrDefault();
if (objQuestP == null || objQuestP.tqp_type == 'D')
{
//lblnotcc_questionnaire.Visible = true;
if (MessageBox.Show("กรุณายืนยันข้อมูลแบบสอบถาม", "Message Alert", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
{
Forms.QuestionnaireFrm fqn = new Forms.QuestionnaireFrm();
fqn.tpr_id = Program.CurrentRegis.tpr_id;
fqn.ShowDialog();
return(false);
}
else
{
return(false);
}
//return false;
}
}
try
{
this.subjectiveUC1.EndEdit();
this.objectiveUC1.EndEdit();
this.tabAssessmentAndPlanUC1.EndEdit();
dbc.SubmitChanges();
}
catch (System.Data.Linq.ChangeConflictException)
{
foreach (System.Data.Linq.ObjectChangeConflict occ in dbc.ChangeConflicts)
{
dbc.Refresh(System.Data.Linq.RefreshMode.KeepChanges, occ.Object);
}
dbc.SubmitChanges();
}
//select set current dc hdr
Program.CurrentHDR = (from hdr in dbc.trn_doctor_hdrs where hdr.tpr_id == SetTprID select hdr).FirstOrDefault();
return(true);
}
catch (Exception ex)
{
Program.MessageError(this.Name, "Save", ex, false);
return(false);
}
}
private void SaveData()
{
try
{
PackageItembindingSource1.EndEdit();
dbc.SubmitChanges();
lbmsgalert.Text = "Save data completed.";
}
catch (Exception ex)
{
lbmsgalert.Text = "Error:" + ex.Message;//Program.MessageError(ex.Message);
}
}
private void btnTab1Save_Click(object sender, EventArgs e)
{
try
{
ConfigHeader_bindingSource1.EndEdit();
mstconfigdtlsBindingSource.EndEdit();
dbc.SubmitChanges();
lbMsgAlertTab1.Text = "Save data completed.";
}
catch (Exception ex)
{
Program.MessageError(ex.Message);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
//save Marrie pnlMarried
PatientbindingSource1.EndEdit();
dbc.SubmitChanges();
lbErrormsg.Text = "Save data completed.";
}
catch (Exception ex)
{
lbErrormsg.Text = ex.Message;
}
}
public bool RegisterPatient(tmp_getptarrived arrivedData)
{
try
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
DateTime dateNow = Program.GetServerDateTime();
EmrClass.GetDataFromWSTrakCare cls = new EmrClass.GetDataFromWSTrakCare();
trn_patient tpt = cdc.trn_patients.Where(x => x.tpt_hn_no == arrivedData.papmi_no).FirstOrDefault();
bool flagNewPatient = true;
if (tpt != null)
{
flagNewPatient = false;
}
cls.otherClinicSkipToCheckB(arrivedData, ref tpt, Program.CurrentSite.mhs_id);//add Program.CurrentSite.mhs_id suriya 03/04/2015
List <trn_patient_regi> listRegis = tpt.trn_patient_regis.Where(x => x.tpr_en_no == arrivedData.paadm_admno).ToList();
foreach (trn_patient_regi regis in listRegis)
{
trn_doctor_hdr docHdr = regis.trn_doctor_hdrs.FirstOrDefault();
if (docHdr == null)
{
docHdr = new trn_doctor_hdr();
regis.trn_doctor_hdrs.Add(docHdr);
docHdr.trh_create_date = dateNow;
docHdr.trh_create_by = "SysImp";
docHdr.trh_update_date = dateNow;
docHdr.trh_update_by = "SysImp";
}
}
if (flagNewPatient)
{
cdc.trn_patients.InsertOnSubmit(tpt);
}
cdc.SubmitChanges();
trn_patient_regi PatientRegis = tpt.trn_patient_regis.OrderByDescending(x => x.tpr_id).FirstOrDefault();
if (PatientRegis != null)
{
new EmrClass.GetPTPackageCls().setRelationOrderSet(ref PatientRegis);
cdc.SubmitChanges();
}
return(true);
}
}
catch (Exception ex)
{
Program.MessageError("EmrClass.FunctionDataCls", "RegisterPatient", ex, false);
return(false);
}
}
private void SaveLAB()
{
try
{
try
{
DateTime dateNow = Program.GetServerDateTime();
trn_patient_book_result bookResult = dbc.trn_patient_book_results
.Where(x => x.tpr_id == Program.CurrentRegis.tpr_id &&
x.tpbr_radiology == "LB")
.FirstOrDefault();
if (bookResult == null)
{
bookResult = new trn_patient_book_result()
{
tpr_id = Program.CurrentRegis.tpr_id,
tpbr_radiology = "LB",
tpbr_create_by = Program.CurrentUser.mut_username,
tpbr_create_date = dateNow
};
dbc.trn_patient_book_results.InsertOnSubmit(bookResult);
}
bookResult.tpbr_flag_saved = true;
bookResult.tpbr_show_sections = true;
bookResult.tpbr_show_summary = true;
bookResult.tpbr_not_show_report = false;
bookResult.tpbr_active = true;
bookResult.tpbr_update_by = Program.CurrentUser.mut_username;
bookResult.tpbr_update_date = dateNow;
dbc.SubmitChanges();
lbAlertMsg.Text = "Save Data Complete.";
}
catch (System.Data.Linq.ChangeConflictException)
{
foreach (System.Data.Linq.ObjectChangeConflict occ in dbc.ChangeConflicts)
{
dbc.Refresh(System.Data.Linq.RefreshMode.KeepChanges, occ.Object);
}
dbc.SubmitChanges();
}
}
catch (ChangeConflictException)
{
foreach (ObjectChangeConflict occ in dbc.ChangeConflicts)
{
dbc.Refresh(System.Data.Linq.RefreshMode.KeepChanges, occ.Object);
}
dbc.SubmitChanges();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
tabPhyExamUC1.EndEdit();
try
{
DateTime dateNow = Program.GetServerDateTime();
trn_patient_book_result bookResult = dbc.trn_patient_book_results
.Where(x => x.tpr_id == this._tpr_id &&
x.tpbr_radiology == "PE")
.FirstOrDefault();
if (bookResult == null)
{
bookResult = new trn_patient_book_result()
{
tpr_id = (int)this._tpr_id,
tpbr_radiology = "PE",
tpbr_create_by = Program.CurrentUser.mut_username,
tpbr_create_date = dateNow
};
dbc.trn_patient_book_results.InsertOnSubmit(bookResult);
}
bookResult.tpbr_flag_saved = true;
bookResult.tpbr_show_sections = true;
bookResult.tpbr_show_summary = true;
bookResult.tpbr_not_show_report = false;
bookResult.tpbr_active = true;
bookResult.tpbr_update_by = Program.CurrentUser.mut_username;
bookResult.tpbr_update_date = dateNow;
dbc.SubmitChanges();
}
catch (System.Data.Linq.ChangeConflictException)
{
foreach (System.Data.Linq.ObjectChangeConflict occ in dbc.ChangeConflicts)
{
dbc.Refresh(System.Data.Linq.RefreshMode.KeepChanges, occ.Object);
}
dbc.SubmitChanges();
}
lbAlertMsg.Text = "Save Data Complete.";
btnSendToDocscan.Enabled = true;
}
catch (Exception ex)
{
Program.MessageError(this.Name, "btnSave_Click", ex, false);
lbAlertMsg.Text = "โปรดลองอีกครั้ง";
}
}
private void UI_DeleteFavorite(object sender, string e)
{
if (MessageBox.Show("Do you want to Delete '" + e + "'?", e, MessageBoxButtons.YesNo) == DialogResult.Yes)
{
try
{
ExamResultUI ui = sender as ExamResultUI;
if (ui != null)
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
mst_autocomplete_physical_exam mst = cdc.mst_autocomplete_physical_exams
.Where(x => x.mape_type == ui.AutoCompleteType &&
x.mst_user_type.mut_username == _username &&
x.mape_description == e)
.FirstOrDefault();
if (mst != null)
{
cdc.mst_autocomplete_physical_exams.DeleteOnSubmit(mst);
cdc.SubmitChanges();
}
List <string> tmp = ui.AutoCompleteListThList;
tmp.Remove(e);
ui.AutoCompleteListThList = tmp;
}
}
}
catch (Exception ex)
{
Program.MessageError("ExamCheckupUC", "UI_DeleteText", ex, false);
}
}
}
public string SaveDraft(int tpr_id, string reason)
{
try
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
trn_patient_doctor_approve patientDoctorApprove = cdc.trn_patient_doctor_approves
.Where(x => x.tpr_id == tpr_id)
.FirstOrDefault();
if (patientDoctorApprove != null)
{
patientDoctorApprove.tpda_reject_reason = reason;
cdc.SubmitChanges();
return("Save Draft Completed.");
}
else
{
return("");
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
private StatusTransaction UpdatedLower()
{
try
{
try
{
_timeLower = Convert.ToInt32(_timeLower).ToString();
}
catch
{
_timeLower = "0";
}
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
DateTime datenow = Program.GetServerDateTime();
trn_patient_regi objpatientregis = (from t1 in cdc.trn_patient_regis
where t1.tpr_id == _tpr_id
select t1).FirstOrDefault();
objpatientregis.tpr_miss_lower = (_checkLower == true) ? true : false;
objpatientregis.tpr_miss_lower_date = (_checkLower == true) ? (DateTime?)datenow : null;
objpatientregis.tpr_call_lower_time = Convert.ToInt32(_timeLower);
objpatientregis.tpr_call_lower_date = Program.GetServerDateTime().AddMinutes((double)objpatientregis.tpr_call_lower_time);
cdc.SubmitChanges();
return(StatusTransaction.True);
}
//End Set column [tus_miss_lower]
}
catch (Exception ex)
{
Program.MessageError("frmUltrasound2", "UpdatedLower", ex, false);
return(StatusTransaction.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
lbAlertMessage.Text = "";
if (GridUsertype.CurrentRow != null)
{
string UserID = Convert1.ToString(GridUsertype.CurrentRow.Cells[1].Value);
string UserName = GridUsertype.CurrentRow.Cells[2].Value.ToString();
var listUserroom = (from t1 in dbc.mst_user_rooms
where t1.mut_username == UserName
select t1);
dbc.mst_user_rooms.DeleteAllOnSubmit(listUserroom);
for (int i = 0; i <= dataGridView1.Rows.Count - 1; i++)
{
if (Convert1.ToBoolean(dataGridView1[0, i].Value) == true)
{
int mrmid = Utility.GetInteger(dataGridView1[1, i].Value);
mst_user_type usermut = (from t1 in dbc.mst_user_types where t1.mut_username == UserName select t1).FirstOrDefault();
mst_user_room newitem = new mst_user_room();
newitem.mst_user_type = usermut;
newitem.mut_id = usermut.mut_id;
newitem.mut_username = UserName;
newitem.mrm_id = mrmid;
dbc.mst_user_rooms.InsertOnSubmit(newitem);
}
}
dbc.SubmitChanges();
lbAlertMessage.Text = "Save data completed.";
}
else
{
lbAlertMessage.Text = "Please select user for edit.";
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (currentObste != null)
{
var objcurrentpft = (from t1 in dbc.trn_obstetric_chiefs
where t1.toc_id == currentObste.toc_id
select t1).FirstOrDefault();
if (objcurrentpft != null)
{
//if (ch_ResultAlert.Enabled == true)
//{
//}
objcurrentpft.toc_doc_code = txtDocCode.Text;
objcurrentpft.toc_doc_name = txtDocName.Text;
dbc.SubmitChanges();
}
lbMsgAlert.Text = "Save data completed.";
txtDocCode.Text = "";
txtDocName.Text = "";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Alert Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public static void MessageError(string strEvent, string ErrorCode, Exception ex, bool isShowMsg)
{
try
{
using (InhCheckupDataContext dbc = new InhCheckupDataContext())
{
log_transaction objlog = new log_transaction();
objlog.its_user_by = (Program.CurrentUser == null) ? "" : Program.CurrentUser.mut_username;
objlog.its_program = (Program.CurrentRoom == null) ? "" : Program.CurrentRoom.mrd_ename;
objlog.its_tpr_id = (Program.CurrentRegis == null) ? 0 : Program.CurrentRegis.tpr_id;
objlog.its_event = strEvent;
objlog.its_err_code = ErrorCode;
objlog.its_err_msg = (ex == null) ? "" : ex.Message;
objlog.its_StackTrace = (ex == null) ? "" : ex.StackTrace;
objlog.its_err_date = Program.GetServerDateTime();
dbc.log_transactions.InsertOnSubmit(objlog);
dbc.SubmitChanges();
}
}
catch (Exception)
{
if (isShowMsg)
{
MessageBox.Show("บันทึก Log Tranaction ไม่ได้", "Error Alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
if (isShowMsg)
{
MessageBox.Show("ระบบเกิดข้อผิดพลาดไม่สามารถทำงานต่อได้ กรุณาติดต่อผู้ดูแลระบบ " + Environment.NewLine + ex.Message, "แจ้งเตือนปัญหาการใช้งาน", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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);
}
}
private bool SkipLower()
{
try
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
DateTime dateNow = Program.GetServerDateTime();
trn_patient_regi PatientRegis = cdc.trn_patient_regis
.Where(x => x.tpr_id == tpr_id)
.FirstOrDefault();
PatientRegis.tpr_miss_lower = chkUltrasound.Checked;
if (chkUltrasound.Checked)
{
PatientRegis.tpr_miss_lower_date = dateNow;
PatientRegis.tpr_call_lower_time = Convert.ToInt32(txtMinuteLower.Text);
PatientRegis.tpr_call_lower_date = dateNow.AddMinutes(Convert.ToInt32(txtMinuteLower.Text));
}
else
{
PatientRegis.tpr_miss_lower_date = null;
PatientRegis.tpr_call_lower_time = null;
PatientRegis.tpr_call_lower_date = null;
}
cdc.SubmitChanges();
return(true);
}
}
catch (Exception ex)
{
Program.MessageError(this.Name, "SkipLower()", ex, false);
return(false);
}
}
public bool SendToCheckBOnStation(int tpr_id, int tps_id)
{
try
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
DateTime dateNow = Program.GetServerDateTime();
trn_patient_regi tpr = cdc.trn_patient_regis.Where(x => x.tpr_id == tpr_id).FirstOrDefault();
patient_regisToCheckB(ref tpr);
queueToCheckB(ref tpr, dateNow);
trn_patient_queue tps = tpr.trn_patient_queues.Where(x => x.tps_id == tps_id).FirstOrDefault(); // update status ห้องปัจจุบัน
tps.tps_send_by = Program.CurrentUser.mut_username;
tps.tps_end_date = dateNow;
tps.tps_status = "ED";
tps.tps_ns_status = null;
tps.tps_update_by = Program.CurrentUser.mut_username;
tps.tps_update_date = dateNow;
cdc.SubmitChanges();
}
return(true);
}
catch
{
}
return(false);
}
public ActionResult LogOn()
{
string username = Request.QueryString["username"];
string otp = Request.QueryString["password"];
if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(otp))
{
return(View());
}
else
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
DateTime dateNow = Utility.GetServerDateTime();
mst_user_otp mdo = cdc.mst_user_otps.Where(x => x.mst_user_type.mut_username == username).FirstOrDefault();
if (mdo != null && mdo.mut_otp == otp && mdo.mut_expire >= dateNow)
{
mdo.mut_expire = dateNow;
cdc.SubmitChanges();
Session["username"] = username;
return(RedirectToAction("PatientSearch", "BookViewer"));
}
else
{
return(View(new LogOnModel()
{
strMsg = "Invalid Log in. Please try again."
}));
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (bsPatient.Count == 0)
{
return;
}
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
int tpr_id = ((Patients)bsPatient.Current).tpr_id;
trn_patient_regi tpr = cdc.trn_patient_regis.Where(x => x.tpr_id == tpr_id).FirstOrDefault();
if (radioButton1.Checked)
{
tpr.tpr_patient_type = '1';
}
else if (radioButton2.Checked)
{
tpr.tpr_patient_type = '2';
}
else
{
tpr.tpr_patient_type = '3';
}
cdc.SubmitChanges();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (CurrentPFT != null)
{
var objcurrentpft = (from t1 in dbc.trn_pfts
where t1.tpf_id == CurrentPFT.tpf_id
select t1).FirstOrDefault();
if (objcurrentpft != null)
{
objcurrentpft.tpf_doc_code = txtDocCode.Text;
objcurrentpft.tpf_doc_name = txtDocName.Text;
dbc.SubmitChanges();
}
lbMsgAlert.Text = "Save data completed.";
txtDocCode.Text = "";
txtDocName.Text = "";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Alert Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnSaveAsDraft_Click(object sender, EventArgs e)
{
try
{
trn_patient_ass_hdr currenthdr = (trn_patient_ass_hdr)PatientAssHdrbindingSource1.Current;
currenthdr.tpeh_summary = Program.GetValueRadioTochar(panelSummary);
PatientAssHdrbindingSource1.EndEdit();
dbc.SubmitChanges();
lbAlertMsg.Text = "Save data completed.";
}
catch (Exception ex)
{
Program.MessageError(this.Name, "btnSaveAsDraft_Click", ex, false);
}
}
private void btnLogIn_Click(object sender, EventArgs e)
{
try
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
userAdmin user = admin.Where(x => x.user.ToUpper() == txtusername.Text.ToUpper()).FirstOrDefault();
if (user != null && user.password == txtpassword.Text)
{
trn_patient_doctor_approve docApprove = cdc.trn_patient_doctor_approves
.Where(x => x.tpr_id == _tpr_id)
.FirstOrDefault();
docApprove.tpda_status = "CBB";
docApprove.tpda_process_by = user.user;
docApprove.tpda_process_date = DateTime.Now;
cdc.SubmitChanges();
loginSuccess = true;
this.Close();
}
else
{
label3.Visible = true;
}
}
}
catch
{
MessageBox.Show("เกิดความผิดพลาด กรุณาลองอีกครั้ง", "Fail.");
}
}
public bool RetrieveLabToEmrCheckupWithQuestionnaire(int tpr_id, LabClass.QuestionnaireResult questionnaire, string user)
{
try
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
DateTime dateNow = Class.globalCls.GetServerDateTime();
var pregis = cdc.trn_patient_regis.Where(x => x.tpr_id == tpr_id).FirstOrDefault();
var ques = pregis.trn_ques_patients.FirstOrDefault();
if (ques == null)
{
ques = new trn_ques_patient
{
tqp_create_by = user,
tqp_create_date = dateNow
};
pregis.trn_ques_patients.Add(ques);
}
ques.tqp_his_smok = questionnaire.smoke;
ques.tqp_fwm_pregnancy = questionnaire.pregnancy;
ques.tqp_ill_med_diab = questionnaire.diabetes;
ques.tqp_update_by = user;
ques.tqp_update_date = dateNow;
cdc.SubmitChanges();
}
return(RetrieveLabToEmrCheckup(tpr_id, user));
}
catch (Exception ex)
{
Class.globalCls.MessageError("InsertLabCls", "RetrieveLabToEmrCheckupWithQuestionnaire", ex.Message);
throw ex;
}
return(false);
}
private void frmMain_FormClosing(object sender, FormClosingEventArgs e)
{
if (MessageBox.Show("คุณต้องการออกจากโปรแกรมหรือไม่", "ยืนยันการออกจากโปรแกรม", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
e.Cancel = true;
}
else
{
if (Class.ClsManageUserLogin.current_log != null)
{
try
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
log_user_login log = cdc.log_user_logins.Where(x => x.lug_id == Class.ClsManageUserLogin.current_log.lug_id).FirstOrDefault();
if (log.lug_end_date == null)
{
log.lug_end_date = Program.GetServerDateTime();
cdc.SubmitChanges();
}
}
}
catch
{
}
}
Program.Logout();
}
}