public List <MapOrderEvent> MapEvent(EnumerableRowCollection <DataRow> PTPackage)
{
try
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
var mapEvent = (from pack in PTPackage
join mop in cdc.mst_order_plans
on pack.Field <string>("ARCIM_RowId") equals mop.mop_item_row_id
where mop.mop_status == 'A'
select new MapOrderEvent
{
mop_id = mop.mop_id,
mvt_id = mop.mvt_id,
status = pack.Field <string>("OSTAT_Code"),
use_pac = pack.Field <string>("ARCIM_Text1") != null ? true : false,
pac_sheet = pack.Field <string>("OEORI_AccessionNumber"),
patho = pack.Field <string>("OEORI_LabTestSetRow"),
tk_orderitem_row_id = pack.Field <string>("OEORI_RowId"),
excute_date = pack.Field <DateTime?>("ExecuteDate")
}).ToList();
return(mapEvent);
}
}
catch (Exception ex)
{
Class.globalCls.MessageError("GetPTPackageCls", "MapEvent", ex.Message);
return(null);
}
}
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 char?getTprQueueType(tmp_getptarrived tga)
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
int site = cdc.mst_hpc_sites.Where(x => x.mhs_code == tga.ctloc_code).Select(x => x.mhs_id).FirstOrDefault();
tmp_getptappointment tap = cdc.tmp_getptappointments.Where(x => x.papmi_no == tga.papmi_no).FirstOrDefault();
TimeSpan tarrivaltime;
TimeSpan.TryParse(tga.appt_arrivaltime.Replace("PT", "").Replace("H", ":").Replace("M", ":").Replace("S", ""), out tarrivaltime);
TimeSpan tAppointment;
TimeSpan.TryParse(tga.paadm_admtime.Replace("PT", "").Replace("H", ":").Replace("M", ""), out tAppointment);
var litTime = (from t1 in cdc.mst_config_hdrs
where t1.mhs_id == site && t1.mfh_code == "WTM"
select t1.mst_config_dtls.FirstOrDefault()).FirstOrDefault();
double litValueTime = 1440;
if (litTime != null)
{
litValueTime = (double)litTime.mfd_value;
}
TimeSpan ta = tarrivaltime.Subtract(tAppointment);
List <string> patientVVIP = cdc.mst_check_vvips.Select(x => x.mvp_hn_no).ToList();
if (patientVVIP.Contains(tga.papmi_no))
{
return('1'); //VVIP
}
else if (!string.IsNullOrEmpty(tga.penstype_code))
{
if (tap == null)
{
return('3'); //VIP WalkIn
}
if (ta.TotalMinutes <= litValueTime && tga.ser_rowid != 2808)
{
return('2'); //VIP Appointment
}
else
{
return('3'); //VIP WalkIn
}
}
else
{
if (tap == null)
{
return('5'); //WalkIn
}
if (ta.TotalMinutes <= litValueTime && tga.ser_rowid != 2808)
{
return('4'); //Appointment
}
else
{
return('5'); //WalkIn
}
}
}
}
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 getAudio(int tpr_id)
{
try
{
using (InhCheckupDataContext dbc = new InhCheckupDataContext())
{
trn_audiometric_hdr audio = dbc.trn_audiometric_hdrs
.Where(x => x.tpr_id == tpr_id)
.FirstOrDefault();
txtRight500.Text = ConvertToString(audio.tdh_right_level_500);
txtLeft500.Text = ConvertToString(audio.tdh_left_level_500);
txtRight1000.Text = ConvertToString(audio.tdh_right_level_1000);
txtLeft1000.Text = ConvertToString(audio.tdh_left_level_1000);
txtRight2000.Text = ConvertToString(audio.tdh_right_level_2000);
txtLeft2000.Text = ConvertToString(audio.tdh_left_level_2000);
txtRight3000.Text = ConvertToString(audio.tdh_right_level_3000);
txtLeft3000.Text = ConvertToString(audio.tdh_left_level_3000);
txtRight4000.Text = ConvertToString(audio.tdh_right_level_4000);
txtLeft4000.Text = ConvertToString(audio.tdh_left_level_4000);
}
}
catch (Exception ex)
{
Program.MessageError(this.Name, "getAudio", ex, false);
}
}
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 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);
}
}
}
}
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 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 MstReport Get(string ReportCode)
{
try
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
string server = GetMasterProjectConfigCls.GetConfigFromDB("ServerReport");
if (GetLocalIP() == server)
{
server = @"D:\www";
}
else
{
server = @"\\" + server;
}
var result = cdc.mst_reports
.Where(x => x.mrt_code == ReportCode && x.mrt_status == 'A')
.Select(x => new MstReport
{
ReportNameTH = x.mrt_tname,
ReportNameEN = x.mrt_ename,
ReportFilePath = server + @"\" + x.mrt_path_file + @"\" + x.mrt_file_name
}).FirstOrDefault();
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
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 occMedQuestionnaireToolStripMenuItem_Click(object sender, EventArgs e)
{
if (Program.CurrentRegis != null)
{
frmQuestionareOccmed fqn = new frmQuestionareOccmed(); //Program.CurrentRegis,Program.CurrentUser,Program.CurrentSite
//Tranfer Data Database To Questionnaire
using (InhCheckupDataContext dbc = new InhCheckupDataContext())
{
if (fqn.ShowDialog() == DialogResult.Yes)
{
//Tranfer Data From Questionnaire To PE
//frmPE fpe = (frmPE)frmMDI;
//if (fpe != null)
//{
// //var objq = (from t1 in dbc.trn_ques_patients where t1.tpr_id == Program.CurrentRegis.tpr_id select t1).FirstOrDefault();
// //if (objq != null)
// //{
// var objQuest = (from t1 in dbc.trn_ques_patients where t1.tpr_id == Program.CurrentRegis.tpr_id select new { t1 }).FirstOrDefault();
// if (objQuest == null) { return; }
//}
}
}
}
}
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."
}));
}
}
}
}
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 string GetRemoteIPAddress()
{
try
{
using (InhCheckupDataContext dbc = new InhCheckupDataContext())
{
string objip = (from mfh in dbc.mst_config_hdrs
join mfd in dbc.mst_config_dtls on mfh.mfh_id equals mfd.mfh_id
where mfh.mfh_code == "IUD" &&
mfh.mhs_id == Program.CurrentSite.mhs_id &&
mfh.mfh_status == 'A' &&
mfh.mfh_effective_date.Value.Date <= DateTime.Now.Date &&
(mfh.mfh_expire_date == null ? DateTime.Now.Date : mfh.mfh_expire_date.Value.Date) >= DateTime.Now.Date &&
mfd.mfd_status == 'A' &&
mfd.mfd_effective_date.Value.Date <= DateTime.Now.Date &&
(mfd.mfd_expire_date == null ? DateTime.Now.Date : mfd.mfd_expire_date.Value.Date) >= DateTime.Now.Date
select mfd.mfd_text).FirstOrDefault();
string ip = objip.Substring(2, objip.Length - 2);
return(ip);
}
}
catch (Exception ex)
{
Program.MessageError("ClsTCPClient", "GetRemoteIPAddress", ex, false);
return(null);
}
}
private void SetBindingSource()
{
try
{
using (InhCheckupDataContext contxt = new InhCheckupDataContext())
{
uu = contxt.mst_events.Where(x => x.mvt_code == "UU").Select(x => new RoomEvent {
checkBox = chkUpper, mvt_code = x.mvt_code, mvt_id = x.mvt_id
}).FirstOrDefault();
ul = contxt.mst_events.Where(x => x.mvt_code == "UL").Select(x => new RoomEvent {
checkBox = chkLower, mvt_code = x.mvt_code, mvt_id = x.mvt_id
}).FirstOrDefault();
ul.OnCheckedChanged += new RoomEvent.CheckedChanged(ul_OnCheckedChanged);
ul.OnEnableChanged += new RoomEvent.EnableChanged(ul_OnEnableChanged);
ub = contxt.mst_events.Where(x => x.mvt_code == "UB").Select(x => new RoomEvent {
checkBox = chkBreast, mvt_code = x.mvt_code, mvt_id = x.mvt_id
}).FirstOrDefault();
uw = contxt.mst_events.Where(x => x.mvt_code == "UW").Select(x => new RoomEvent {
checkBox = chkWhole, mvt_code = x.mvt_code, mvt_id = x.mvt_id
}).FirstOrDefault();
}
}
catch
{
}
}
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 UltrasoundFrm_mrdidChanged(object sender, int?e)
{
if (this.FormStatus == formStatus.isStation)
{
if (e == null)
{
newWaitingListStationUC1.mrd_id = null;
ultrasoundUC1.mrd_id = null;
newWaitingListStationUC1.mut_id = this.user.mut_id;
}
else
{
try
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
uu.visible = false;
ul.visible = false;
ub.visible = false;
uw.visible = false;
var roomEvent = cdc.mst_room_events
.Where(x => x.mst_room_hdr.mst_room_dtls.Any(y => y.mrd_id == e))
.Select(x => new
{
x.mvt_id,
x.mst_event.mvt_code
}).ToList();
foreach (var evt in roomEvent)
{
switch (evt.mvt_code)
{
case "UU":
uu.visible = true;
break;
case "UL":
ul.visible = true;
break;
case "UB":
ub.visible = true;
break;
case "UW":
uw.visible = true;
break;
}
}
}
newWaitingListStationUC1.mrd_id = e;
ultrasoundUC1.mrd_id = e;
newWaitingListStationUC1.mut_id = this.user.mut_id;
}
catch (Exception ex)
{
Program.MessageError(this.Name, "UltrasoundFrm_mrdidChanged", ex, false);
}
}
}
}
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);
}
private void setCmbSite()
{
try
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
List <structCmbSite> result = cdc.mst_hpc_sites
.Where(x => x.mhs_status == 'A' &&
x.mhs_type == 'P')
.Select(x => new structCmbSite
{
mhs_id = x.mhs_id,
name = x.mhs_ename
}).ToList();
result.Insert(0, new structCmbSite {
mhs_id = null, name = "Select All"
});
DDSite.ValueMember = "mhs_id";
DDSite.DisplayMember = "name";
DDSite.DataSource = result.OrderBy(x => x.name == null ? 0 : x.mhs_id).ToList();
DDSite.SelectedValue = mhs_id;
}
}
catch (Exception ex)
{
Program.MessageError(this.Name, "setCmbSite", ex, false);
}
}
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 PapResultFrm()
{
InitializeComponent();
try
{
using (InhCheckupDataContext contxt = new InhCheckupDataContext())
{
var combo = contxt.mst_hpc_sites
.Where(x => x.mhs_status == 'A')
.Select(x => new site
{
mhs_id = x.mhs_id,
mhs_ename = x.mhs_ename
}).ToList();
combo.Insert(0, new site {
mhs_id = null, mhs_ename = "All Location"
});
cobLocation.DataSource = combo;
cobLocation.DisplayMember = "mhs_ename";
cobLocation.ValueMember = "mhs_id";
}
}
catch
{
}
}
private void CheckKickedUser()
{
try
{
using (InhCheckupDataContext context = new InhCheckupDataContext())
{
log_user_login lug = context.log_user_logins
.Where(x => x.lug_id == _lug_id)
.FirstOrDefault();
if (lug.lug_end_date != null)
{
this.Close();
OnKickedUser(false);
}
}
}
catch (Exception ex)
{
Program.MessageError(this.Name, "CheckKickedUser", ex, false);
}
Timer timer = new Timer();
timer.Enabled = true;
timer.Interval = 5000;
timer.Tick += new EventHandler(timer_Tick);
timer.Start();
}
public StatusTransaction getConfigMessage(ref double configResult, int mhs_id, string configCode)
{
try
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
DateTime dateNow = Program.GetServerDateTime();
double result = cdc.mst_config_dtls
.Where(x => x.mst_config_hdr.mfh_code == configCode &&
x.mst_config_hdr.mhs_id == mhs_id &&
x.mst_config_hdr.mfh_status == 'A' &&
x.mst_config_hdr.mfh_effective_date.Value.Date <= dateNow &&
((x.mst_config_hdr.mfh_expire_date == null) ? true : x.mst_config_hdr.mfh_expire_date.Value.Date >= dateNow) &&
x.mfd_status == 'A' &&
x.mfd_effective_date.Value.Date <= dateNow &&
((x.mfd_expire_date == null) ? true : x.mfd_expire_date.Value.Date >= dateNow))
.Select(x => (double)x.mfd_value).FirstOrDefault();
configResult = result;
return(StatusTransaction.True);
}
}
catch (Exception ex)
{
Program.MessageError("ClsTCPClient", "getConfigMessage", ex, false);
return(StatusTransaction.Error);
}
}
private void getLab(int tpr_id)
{
try
{
using (InhCheckupDataContext dbc = new InhCheckupDataContext())
{
var labResult = dbc.sp_med_exm_report(tpr_id).FirstOrDefault();
if (labResult.ecg_normal == null && labResult.ecg_abnormal == null)
{
pnlECG.Tag = null;
}
else if (labResult.ecg_normal.Length > 0)
{
pnlECG.Tag = 'N';
}
else if (labResult.ecg_abnormal.Length > 0)
{
pnlECG.Tag = 'A';
}
txtSugar.Text = "";
txtAlbumin.Text = labResult.C0060;
txtMicro.Text = labResult.E0020;
txtCholesterol.Text = "";
txtTrig.Text = "";
txtHDL.Text = "";
}
}
catch (Exception ex)
{
Program.MessageError(this.Name, "getLab", ex, false);
}
}
private StatusTransaction getMessageUnitDisplay(int mhs_id, int mrd_id, int mvt_id, ref List <string> list_message)
{
try
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
mst_room_dtl mrd = cdc.mst_room_dtls.Where(x => x.mrd_id == mrd_id).FirstOrDefault();
string mvt_code = cdc.mst_events.Where(x => x.mvt_id == mvt_id).Select(x => x.mvt_code).FirstOrDefault();
string mrm_code = cdc.mst_room_hdrs.Where(x => x.mrm_id == mrd.mrm_id).Select(x => x.mrm_code).FirstOrDefault();
List <string> list_zone = cdc.mst_room_screens
.Where(x => x.mrm_code == mrm_code &&
x.mvt_code == mvt_code &&
x.mhs_id == mhs_id &&
x.mrs_status == 'A' &&
x.mrs_effective_date.Value.Date <= DateTime.Now.Date &&
((x.mrs_expire_date == null) ? true : x.mrs_expire_date.Value.Date >= DateTime.Now.Date))
.Select(x => x.mze_code).ToList();
foreach (string zone in list_zone)
{
list_message.Add("_" + mhs_id.ToString() + zone + "_" + mrd.mrd_room_no + "_");
}
return(StatusTransaction.True);
}
}
catch (Exception ex)
{
Program.MessageError("ClsTCPClient", "getMessageUnitDisplay", ex, false);
return(StatusTransaction.Error);
}
}
public void loadDashBoard(int site_id)
{
pnDash.Controls.Clear();
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
DateTime dateNow = Program.GetServerDateTime();
List <int> list_mrm_id = cdc.mst_room_hdrs.Where(x => x.mrm_show_dashboard == true &&
x.mhs_id == site_id)
.Select(x => x.mrm_id).ToList();
List <mst_room_dtl> listRoomDoctor = cdc.mst_room_dtls
.Where(x => list_mrm_id.Contains(x.mrm_id) &&
(x.mrd_effective_date == null ? true : x.mrd_effective_date < dateNow) &&
(x.mrd_expire_date == null ? true : x.mrd_expire_date > dateNow) &&
x.mrd_status == 'A')
.OrderBy(x => x.mrd_room_no).ToList();
for (int i = 0; i < listRoomDoctor.Count(); i++)
{
UIGridChangeDoctor ui = new UIGridChangeDoctor();
ui.showDashBoard(listRoomDoctor[i].mrd_id);
ui.ChangeComplete += new UIGridChangeDoctor.changeDoctorComplete(ui_ChangeDoctorComplete);
ui.ChangingDoctor += new UIGridChangeDoctor.changingDoctor(ui_changingDoctor);
this.pnDash.Controls.Add(ui);
ui.Top = (int)Math.Floor((decimal)(i / 2)) * (new UIGridChangeDoctor().Height + 14);
ui.Left = (i % 2) * (new UIGridChangeDoctor().Width + 14);
Visible = true;
ui.BringToFront();
}
}
}
private StatusTransaction isCheckPoint(int mrd_id)
{
try
{
if (mrd_id != 0)
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
mst_room_dtl mrd = cdc.mst_room_dtls.Where(x => x.mrd_id == mrd_id).FirstOrDefault();
if (mrd.mst_room_hdr.mrm_code == "CB" || mrd.mst_room_hdr.mrm_code == "CC")
{
return(StatusTransaction.True);
}
else
{
return(StatusTransaction.False);
}
}
}
else
{
return(StatusTransaction.True);
}
}
catch (Exception ex)
{
Program.MessageError("ClsTCPClient", "isCheckPoint", ex, false);
return(StatusTransaction.Error);
}
}
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 void setSourceGridDetail()
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
var result = cdc.trn_patient_regis.Where(x => x.tpr_arrive_date.Value.Date == CurrentDate.Value.Date).ToList();
}
}
