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);
}
}
public void ReserveCurrentQueue(ref trn_patient_regi PatientRegis, int tps_id)
{
trn_patient_skip_queue PatientSkipQueue = PatientRegis.trn_patient_queues
.Where(x => x.tps_id == tps_id &&
x.mst_room_hdr.mrm_skip_reserve == true)
.Select(x => new trn_patient_skip_queue
{
tps_id = x.tps_id,
mrm_id = x.mrm_id,
mrd_id = x.mrd_id,
mvt_id = x.mvt_id,
tps_bm_seq = x.tps_bm_seq,
tps_call_by = x.tps_call_by,
tps_call_date = x.tps_call_date,
tps_call_status = x.tps_call_status,
tps_cancel_by = x.tps_cancel_by,
tps_cancel_date = x.tps_cancel_date,
tps_cancel_other = x.tps_cancel_other,
tps_cancel_remark = x.tps_cancel_remark,
tps_create_by = x.tps_create_by,
tps_create_date = x.tps_create_date,
tps_end_date = x.tps_end_date,
tps_hold_by = x.tps_hold_by,
tps_hold_date = x.tps_hold_date,
tps_lab_date = x.tps_lab_date,
tps_ns_status = x.tps_ns_status,
tps_reserve = x.tps_reserve,
tps_send_by = x.tps_send_by,
tps_start_date = x.tps_start_date,
tps_status = x.tps_status,
tps_update_by = x.tps_update_by,
tps_update_date = x.tps_update_date,
tpsq_active = null
}).FirstOrDefault();
if (PatientSkipQueue != null)
{
PatientRegis.trn_patient_skip_queues.Add(PatientSkipQueue);
}
}
public void SendAndReserve(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)
{
PatientSkipQueue.tpsq_active = false;
if (PatientSkipQueue.mrm_id != null)
{
trn_patient_queue PatientQueue = PatientRegis.trn_patient_queues.Where(x => x.mrm_id == PatientSkipQueue.mrm_id).FirstOrDefault();
if (PatientQueue != null)
{
PatientQueue.tps_reserve = true;
}
}
}
trn_patient_skip_queue PatientNewSkipQueue = PatientRegis.trn_patient_skip_queues.Where(x => x.tpsq_active == null).FirstOrDefault();
if (PatientNewSkipQueue != null)
{
PatientNewSkipQueue.tpsq_active = true;
}
cdc.SubmitChanges();
}
}
}
}
catch (Exception ex)
{
Program.MessageError("ReserveSkipCls", "ReserveSkipCls", ex, false);
}
}
