public int?CheckRoomSkip(int?tpr_id)
{
try
{
if (tpr_id != null)
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
trn_patient_regi PatientRegis = cdc.trn_patient_regis.Where(x => x.tpr_id == tpr_id).FirstOrDefault();
if (PatientRegis != null)
{
trn_patient_skip_queue PatientSkipQueue = PatientRegis.trn_patient_skip_queues.Where(x => x.tpsq_active == true).FirstOrDefault();
if (PatientSkipQueue != null)
{
return((int)PatientSkipQueue.mrm_id);
}
}
}
}
return(null);
}
catch (Exception ex)
{
Program.MessageError("ReserveSkipCls", "ReserveSkipCls", ex, false);
return(null);
}
}
private void GV_Null_Result_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex > -1)
{
dbc.Connection.Close();
dbc = new InhCheckupDataContext();
Clearfrm();
SetTprID = Convert1.ToInt32(GV_Null_Result["Coltprid", e.RowIndex].Value);
SetEN = Convert1.ToString(GV_Null_Result["EN", e.RowIndex].Value);
CurrentRegis = (from t1 in dbc.trn_patient_regis
where t1.tpr_id == SetTprID
select t1).FirstOrDefault();
Program.CurrentRegis = CurrentRegis;
if (CurrentRegis != null)
{
UIProfileHorizontal1.Loaddata(SetTprID, Program.CurrentSite.mhs_id);
//new code//
this.subjectiveUC1.PatientRegis = CurrentRegis;
this.objectiveUC1.PatientRegis = CurrentRegis;
this.tabAssessmentAndPlanUC1.PatientRegis = CurrentRegis;
if (tabControl1.SelectedTab.Tag.ToString() != "1")
{
tabControl1.SelectedIndex = 0;
}
btnSaveDraft.Enabled = true;
btnSendAuto.Enabled = true;
}
}
}
public void Clear()
{
this.Enabled = false;
txtHeight.Text = "";
txtWeight.Text = "";
txtSystolic.Text = "";
txtDiastolic.Text = "";
txtPulse.Text = "";
txtRight500.Text = "";
txtLeft500.Text = "";
txtRight1000.Text = "";
txtLeft1000.Text = "";
txtRight2000.Text = "";
txtLeft2000.Text = "";
txtRight3000.Text = "";
txtLeft3000.Text = "";
txtRight4000.Text = "";
txtLeft4000.Text = "";
txtSugar.Text = "";
txtAlbumin.Text = "";
txtMicro.Text = "";
txtCholesterol.Text = "";
txtTrig.Text = "";
txtHDL.Text = "";
bsPatientRegis.DataSource = new trn_patient_regi();
_PatientRegis = null;
}
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 void RDGeneral_CheckedChanged(object sender, EventArgs e)
{
DDCompany.Enabled = false; txtEmployeeID.Enabled = false;
trn_patient_regi currentRegis = (trn_patient_regi)trnpatientregisBindingSource.Current;
if (currentRegis != null)
{
if (RDGeneral.Checked)
{
currentRegis.tpr_patient_type = Convert.ToChar(RDGeneral.Tag);
currentRegis.tpr_company_id = null;
currentRegis.tpr_employee_no = null;
}
else if (RDAviationPilot.Checked)
{
currentRegis.tpr_patient_type = Convert.ToChar(RDAviationPilot.Tag);
currentRegis.tpr_company_id = null;
currentRegis.tpr_employee_no = null;
}
else if (RDcorporate.Checked)
{
currentRegis.tpr_patient_type = Convert.ToChar(RDcorporate.Tag);
DDCompany.Enabled = true; txtEmployeeID.Enabled = true;
}
//else if (RDaviationAircrew.Checked)
//{
// currentRegis.tpr_patient_type = Convert.ToChar(RDaviationAircrew.Tag);
// currentRegis.tpr_company_id = null;
// currentRegis.tpr_employee_no = null;
//}
}
}
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);
}
}
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);
}
private void btnCleargraph_Click(object sender, EventArgs e)
{
chart1.Series["Rt"].Points.Clear();
chart1.Series["Lt"].Points.Clear();
trn_patient_regi patient_regis = (trn_patient_regi)bsPatientRegis.Current;
trn_audiometric_hdr patient_audio = patient_regis.trn_audiometric_hdrs.FirstOrDefault();
if (patient_audio != null)
{
patient_audio.tdh_right_level_250 = null;
patient_audio.tdh_right_level_500 = null;
patient_audio.tdh_right_level_750 = null;
patient_audio.tdh_right_level_1000 = null;
patient_audio.tdh_right_level_1500 = null;
patient_audio.tdh_right_level_2000 = null;
patient_audio.tdh_right_level_3000 = null;
patient_audio.tdh_right_level_4000 = null;
patient_audio.tdh_right_level_6000 = null;
patient_audio.tdh_right_level_8000 = null;
patient_audio.tdh_left_level_250 = null;
patient_audio.tdh_left_level_500 = null;
patient_audio.tdh_left_level_750 = null;
patient_audio.tdh_left_level_1000 = null;
patient_audio.tdh_left_level_1500 = null;
patient_audio.tdh_left_level_2000 = null;
patient_audio.tdh_left_level_3000 = null;
patient_audio.tdh_left_level_4000 = null;
patient_audio.tdh_left_level_6000 = null;
patient_audio.tdh_left_level_8000 = null;
}
}
public void Clear()
{
this.Enabled = false;
bsPatientRegis.DataSource = new trn_patient_regi();
_PatientRegis = null;
btnCleargraph_Click(null, null);
}
public StatusTransaction endQueue(ref trn_patient_regi tpr, int tps_id)
{
try
{
DateTime dateNow = Program.GetServerDateTime();
List <trn_patient_queue> tps = tpr.trn_patient_queues
.Where(x => x.tps_id == tps_id).ToList();
tps.ForEach(x =>
{
x.mrd_id = Program.CurrentRoom.mrd_id;
x.tps_send_by = Program.CurrentUser.mut_username;
x.tps_end_date = dateNow;
x.tps_status = "ED";
x.tps_ns_status = null;
x.tps_update_by = Program.CurrentUser.mut_username;
x.tps_update_date = dateNow;
});
return(StatusTransaction.True);
}
catch (Exception ex)
{
Program.MessageError("TransactionQueueCls", "endQueue", ex, false);
return(StatusTransaction.Error);
}
}
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 void Clear()
{
this.Enabled = false;
carotidUC1.Clear();
carotidDuplexReport1.Clear();
_PatientRegis = null;
}
private void LoadLabResult(ref trn_patient_regi _patient_regis)
{
trn_patient_regi objPatient = _patient_regis;
trn_carotid_hdr objTCH = bsCarotidHDR.OfType <trn_carotid_hdr>().FirstOrDefault();
using (InhCheckupDataContext dbc = new InhCheckupDataContext())
{
string en = objPatient.tpr_en_no;
string hn = objPatient.trn_patient.tpt_hn_no;
var objotherxray = (from t1 in dbc.trn_other_xrays
where t1.tox_en_no == en &&
t1.trn_patient_regi.trn_patient.tpt_hn_no == hn &&
t1.tox_room_type == "CD"
select t1).FirstOrDefault();
if (objotherxray != null)
{
txtpatientOrderResult.Text = objTCH.tch_patient_result == null ? objotherxray.tox_result : objTCH.tch_patient_result;
txtComment.Text = objTCH.tch_patient_comt == null ? objotherxray.tox_patient_comt : objTCH.tch_patient_comt;
txtResult.Text = objTCH.tch_result == null ? objotherxray.tox_order_name : objTCH.tch_result;
txtRequestDate.Text = objTCH.tch_request_date == null?objotherxray.tox_order_date.Value.ToShortDateString() : objTCH.tch_request_date.Value.ToShortDateString();
//request_date = Convert.ToDateTime(objotherxray.tox_order_date.Value.ToShortDateString());
//report_date = Convert.ToDateTime(objotherxray.tox_result_date.Value.ToShortDateString());
txtReportDateTime.Text = objTCH.tch_report_date == null?objotherxray.tox_result_date.Value.ToShortDateString() : objTCH.tch_report_date.Value.ToShortDateString();
}
}
}
public bool skipChangeEstToEcho(ref trn_patient_regi tpr, int mhs_id)
{
try
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
DateTime dateNow = Program.GetServerDateTime();
List <string> set_row_id_skip = cdc.mst_config_dtls
.Where(x => x.mst_config_hdr.mfh_code == "ECHO" &&
x.mst_config_hdr.mhs_id == mhs_id &&
x.mst_config_hdr.mfh_status == 'A' &&
(x.mst_config_hdr.mfh_effective_date == null ? true : dateNow >= x.mst_config_hdr.mfh_effective_date.Value.Date) &&
(x.mst_config_hdr.mfh_expire_date == null ? true : dateNow <= x.mst_config_hdr.mfh_expire_date.Value))
.Select(x => x.mfd_text).ToList();
trn_patient_order_set order_skip_est_to_echo = tpr.trn_patient_order_sets
.Where(x => set_row_id_skip.Contains(x.tos_od_set_code) &&
x.tos_status == true).FirstOrDefault();
if (order_skip_est_to_echo != null)
{
EmrClass.GetDataMasterCls getMaster = new EmrClass.GetDataMasterCls();
int est_mvt_id = getMaster.GetMstEvent("ES").mvt_id;
int echo_mvt_id = getMaster.GetMstEvent("EC").mvt_id;
List <trn_patient_plan> planEST = tpr.trn_patient_plans.Where(x => x.mvt_id == est_mvt_id).ToList();
foreach (trn_patient_plan PatientPlan in planEST)
{
PatientPlan.mvt_id = echo_mvt_id;
PatientPlan.tpl_status = 'P';
}
int pe_mvt_id = getMaster.GetMstEvent("PE").mvt_id;
List <trn_patient_plan> planPE = tpr.trn_patient_plans
.Where(x => x.mvt_id == pe_mvt_id).ToList();
foreach (var plan in planPE)
{
tpr.trn_patient_plans.Remove(plan);
}
try
{
List <trn_patient_event> eventEST = tpr.trn_patient_events.Where(x => x.mvt_id == est_mvt_id).ToList();
foreach (var ev in eventEST)
{
tpr.trn_patient_events.Remove(ev);
}
}
catch
{
}
return(true);
}
else
{
return(true);
}
}
}
catch (Exception ex)
{
Program.MessageError("GetDataFromWSTrakCare", "skipChangeEstToEcho", ex, false);
return(false);
}
}
public void Clear()
{
this.Enabled = false;
pftMainUC1.Clear();
pftOccMedUC1.Clear();
_PatientRegis = null;
}
public bool skipReqDoctorOutDepartment(ref trn_patient_regi tpr)
{
try
{
if (tpr.tpr_req_doctor == 'Y' && tpr.tpr_req_inorout_doctor == "UT")
{
int?pe_mvt_id = GetEventID("PE");
List <trn_patient_plan> planPE = tpr.trn_patient_plans.Where(x => x.mvt_id == pe_mvt_id).ToList();
foreach (trn_patient_plan patient_plan in planPE)
{
trn_patient_plan remove_plan = patient_plan;
if (patient_plan.tpl_id != 0)
{
remove_plan = tpr.trn_patient_plans.Where(x => x.tpl_id == patient_plan.tpl_id).FirstOrDefault();
}
tpr.trn_patient_plans.Remove(remove_plan);
}
return(true);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Class.globalCls.MessageError("GetDataFromWSTrakCare", "skipReqDoctorOutDepartment", ex.Message);
return(false);
}
}
public void updatePlanForSkipByMvt(ref trn_patient_regi tpr, int mvt_id)
{
trn_patient_plan currentPlan = tpr.trn_patient_plans.Where(x => x.mvt_id == mvt_id).FirstOrDefault();
currentPlan.tpl_skip = true;
currentPlan.tpl_skip_seq = currentPlan.tpl_skip_seq == null ? 1 : currentPlan.tpl_skip_seq + 1;
}
public bool checkOrderPMR(ref trn_patient_regi tpr, int mhs_id)
{
try
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
DateTime dateNow = Class.globalCls.GetServerDateTime();
List <string> set_row_id_pmr = cdc.mst_config_dtls
.Where(x => x.mst_config_hdr.mfh_code == "EPMR" &&
x.mst_config_hdr.mhs_id == mhs_id &&
x.mst_config_hdr.mfh_status == 'A' &&
(x.mst_config_hdr.mfh_effective_date == null ? true : dateNow >= x.mst_config_hdr.mfh_effective_date.Value.Date) &&
(x.mst_config_hdr.mfh_expire_date == null ? true : dateNow <= x.mst_config_hdr.mfh_expire_date.Value))
.Select(x => x.mfd_text).ToList();
trn_patient_order_set set_pmr = tpr.trn_patient_order_sets.Where(x => set_row_id_pmr.Contains(x.tos_od_set_code)).FirstOrDefault();
if (set_pmr != null)
{
tpr.tpr_PRM = true;
tpr.tpr_PRM_doctor = false;
return(true);
}
else
{
tpr.tpr_PRM = false;
tpr.tpr_PRM_doctor = false;
return(true);
}
}
}
catch (Exception ex)
{
Class.globalCls.MessageError("GetDataFromWSTrakCare", "checkOrderPMR", ex.Message);
return(false);
}
}
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 bool AddPatientOrderSet(ref trn_patient_regi PatientRegis, string username, DateTime dateNow, EnumerableRowCollection <DataRow> PTPackage)
{
try
{
var grpPackage = PTPackage.Where(x => x.Field <string>("ARCOS_RowId") != null).GroupBy(x => x.Field <string>("ARCOS_RowId"));
foreach (var grp in grpPackage)
{
trn_patient_order_set PatientOrderSet = PatientRegis.trn_patient_order_sets.Where(x => x.tos_item_row_id == grp.Key).FirstOrDefault();
if (PatientOrderSet == null)
{
PatientOrderSet = new trn_patient_order_set();
PatientOrderSet.tos_item_row_id = grp.Key;
PatientOrderSet.tos_create_date = dateNow;
PatientOrderSet.tos_create_by = username;
PatientRegis.trn_patient_order_sets.Add(PatientOrderSet);
}
PatientOrderSet.tos_od_set_code = grp.FirstOrDefault().Field <string>("ARCOS_Code");
PatientOrderSet.tos_od_set_name = grp.FirstOrDefault().Field <string>("ARCOS_Desc");
PatientOrderSet.tos_status = grp.All(y => y.Field <string>("OSTAT_Code") == "D") ? false : true;
PatientOrderSet.tos_update_date = dateNow;
PatientOrderSet.tos_update_by = username;
}
return(true);
}
catch (Exception ex)
{
Class.globalCls.MessageError("GetPTPackageCls", "AddPatientOrderSet", ex.Message);
return(false);
}
}
public void updatePendingPatientPlan(ref trn_patient_regi tpr, string mvt_code, int mrm_id, int mhs_id)
{
EmrClass.GetDataMasterCls mst = new EmrClass.GetDataMasterCls();
mst_event mvt = mst.GetMstEvent(mvt_code);
updatePendingPatientPlan(ref tpr, mrm_id, mvt.mvt_id, mhs_id);
}
private string GetTypeWaitingList(trn_patient_regi t0)
{
if (t0.tpr_vip_code != null && t0.tpr_vip_code != "" && t0.tpr_appoint_type == 'L')
{
return("VIP นัดไม่ตรงเวลา");
}
else if (t0.tpr_vip_code != null && t0.tpr_vip_code != "" && t0.tpr_appoint_type == 'T')
{
return("VIP นัดตรงเวลา");
}
if (t0.tpr_arrive_type == 'W')
{
return("Walk-in");
}
if (t0.tpr_arrive_type == 'A' && t0.tpr_appoint_type == 'L')
{
return("นัดไม่ตรงเวลา");
}
else if (t0.tpr_arrive_type == 'A' && t0.tpr_appoint_type == 'T')
{
return("นัดตรงเวลา");
}
return("");
}
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 bsPatient_CurrentChanged(object sender, EventArgs e)
{
if (((BindingSource)sender).Count == 0)
{
return;
}
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
int tpr_id = ((Patients)((BindingSource)sender).Current).tpr_id;
trn_patient_regi tpr = cdc.trn_patient_regis.Where(x => x.tpr_id == tpr_id).FirstOrDefault();
switch (tpr.tpr_patient_type)
{
case '1':
radioButton1.Checked = true;
break;
case '2':
radioButton2.Checked = true;
break;
case '3':
radioButton3.Checked = true;
break;
}
}
}
private void GridPatient_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1)
{
return;
}
string strEn = Convert1.ToString(GridPatient["ColEN", e.RowIndex].Value);
var objcurrentRegi = (from t1 in dbc.trn_patient_regis
where t1.tpr_en_no == strEn
select t1).FirstOrDefault();
if (objcurrentRegi != null)
{
txtHN.Text = objcurrentRegi.trn_patient.tpt_hn_no;
txtEN.Text = objcurrentRegi.tpr_en_no;
txtFullName.Text = objcurrentRegi.trn_patient.tpt_othername;
txtDOB.Text = objcurrentRegi.trn_patient.tpt_dob_text; //objcurrentRegi.trn_patient.tpt_dob.Value.ToString("dd/MM/yyyy");
txtGender.Text = (objcurrentRegi.trn_patient.tpt_gender == 'F') ? "Female" : "Male";
txtNationality.Text = objcurrentRegi.trn_patient.tpt_nation_desc;
txtAge.Text = Program.CalculateAge(objcurrentRegi.trn_patient.tpt_dob.Value, Program.GetServerDateTime());
txtVisitDate.Text = (objcurrentRegi.tpr_arrive_date == null) ? "" : objcurrentRegi.tpr_arrive_date.Value.ToString("dd / MM / yyyy");
txtVisitTime.Text = (objcurrentRegi.tpr_arrive_date == null) ? "" : objcurrentRegi.tpr_arrive_date.Value.ToString("HH:mm:ss");
txtAllergy.Text = objcurrentRegi.trn_patient.tpt_allergy;
PicProfile.Image = Program.byteArrayToImage(objcurrentRegi.trn_patient.tpt_image.ToArray());
DDsite.SelectedValue = 0;
DDStation.SelectedValue = 0;
ShowReport(0, 0);
currentRegis = objcurrentRegi;
}
}
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 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 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);
}
}
private void LoadLabResult(ref trn_patient_regi _patient_regis)
{
try
{
trn_patient_regi objrg = _patient_regis;
using (InhCheckupDataContext dbc = new InhCheckupDataContext())
{
int tpr_id = objrg.tpr_id;
var ObjLabFbs = (from t1 in dbc.trn_patient_labs
where t1.tpl_hn_no == (Program.CurrentRegis == null ? objrg.trn_patient.tpt_hn_no : Program.CurrentRegis.trn_patient.tpt_hn_no) &&
t1.tpl_en_no == (Program.CurrentPatient_queue == null ? objrg.tpr_en_no : Program.CurrentPatient_queue.trn_patient_regi.tpr_en_no) &&
t1.tpl_lab_no == "C0180"
select t1.tpl_lab_value).FirstOrDefault();
var ObjLabCholes = (from t1 in dbc.trn_patient_labs
where t1.tpl_hn_no == (Program.CurrentRegis == null ? objrg.trn_patient.tpt_hn_no : Program.CurrentRegis.trn_patient.tpt_hn_no) &&
t1.tpl_en_no == (Program.CurrentPatient_queue == null ? objrg.tpr_en_no : Program.CurrentPatient_queue.trn_patient_regi.tpr_en_no) && //Program.CurrentPatient_queue.trn_patient_regi.tpr_en_no
t1.tpl_lab_no == "C0130"
select t1.tpl_lab_value).FirstOrDefault();
var ObjLabBmi = (from t1 in dbc.trn_basic_measure_dtls
join t2 in dbc.trn_basic_measure_hdrs on t1.tbm_id equals t2.tbm_id
where t2.tpr_id == tpr_id//tprid
select t1.tbd_bmi).FirstOrDefault();
var ObjLabHbA = (from t1 in dbc.trn_patient_labs
where t1.tpl_hn_no == (Program.CurrentRegis == null ? Program.CurrentRegis.trn_patient.tpt_hn_no : Program.CurrentRegis.trn_patient.tpt_hn_no) &&
t1.tpl_en_no == (Program.CurrentPatient_queue == null ? Program.CurrentRegis.tpr_en_no : Program.CurrentPatient_queue.trn_patient_regi.tpr_en_no) && //Program.CurrentPatient_queue.trn_patient_regi.tpr_en_no
t1.tpl_lab_no == "N0510"
select t1.tpl_lab_value).FirstOrDefault();
var ObjLabLdl = (from t1 in dbc.trn_patient_labs
where t1.tpl_hn_no == (Program.CurrentRegis == null ? Program.CurrentRegis.trn_patient.tpt_hn_no : Program.CurrentRegis.trn_patient.tpt_hn_no) && //Program.CurrentRegis.trn_patient.tpt_hn_no
t1.tpl_en_no == (Program.CurrentPatient_queue == null ? Program.CurrentRegis.tpr_en_no : Program.CurrentPatient_queue.trn_patient_regi.tpr_en_no) && //Program.CurrentPatient_queue.trn_patient_regi.tpr_en_no
t1.tpl_lab_no == "C0159"
select t1.tpl_lab_value).FirstOrDefault();
var ObjLabBp = (from t1 in dbc.trn_basic_measure_dtls
join t2 in dbc.trn_basic_measure_hdrs on t1.tbm_id equals t2.tbm_id
where t2.tpr_id == tpr_id
select t1.tbd_systolic + "/" + t1.tbd_diastolic).FirstOrDefault();
//var ObjMobile = (from t1 in dbc.trn_patient_regis where t1.tpr_id == tpr_id select t1.tpr_mobile_phone).FirstOrDefault();
//if (ObjMobile == null || ObjMobile == "")
//{
// ObjMobile = (from t1 in dbc.trn_patient_regis where t1.tpr_id == tpr_id select t1.tpr_office_phone).FirstOrDefault();
//}
//if (ObjMobile == null || ObjMobile == "")
//{
// ObjMobile = (from t1 in dbc.trn_patient_regis where t1.tpr_id == tpr_id select t1.tpr_home_phone).FirstOrDefault();
//}
txtfbs.Text = ObjLabFbs;
txtcho.Text = ObjLabCholes;
txtbmi.Text = ObjLabBmi;
txthb.Text = ObjLabHbA;
txtldl.Text = ObjLabLdl;
txtbp.Text = ObjLabBp;
//txtmobilephone.Text = ObjMobile;
}
}
catch
{ }
}
public bool? CallBackToBook(int tpr_id, string username)
{
try
{
DateTime dateNow = DateTime.Now;
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
trn_patient_regi patientRegis = cdc.trn_patient_regis
.Where(x => x.tpr_id == tpr_id)
.FirstOrDefault();
trn_patient_doctor_approve doctorApprove = patientRegis.trn_patient_doctor_approve;
if (doctorApprove.tpda_status == "API")
{
return null;
}
doctorApprove.tpda_status = "CBB";
doctorApprove.tpda_process_by = username;
doctorApprove.tpda_process_date = dateNow;
cdc.SubmitChanges();
return true;
}
}
catch
{
}
return false;
}
