private static int BK101(int?tprID, CheckupDataContext dbcBookLog, int StatusPage)
{
int count101 = dbcBookLog.pw_CR_PatienBook_PatientProfile(tprID).Count();
StatusPage = (count101 > 0) ? 1 : 0;
return(StatusPage);
}
private void DialogInterpretation_Load(object sender, EventArgs e)
{
using (CheckupDataContext cdc = new CheckupDataContext())
{
// Select lab group name for display on header
var labGroup = cdc.trn_patient_ass_dtls.Where(x => x.tped_lab_code.Equals(dtl.tped_lab_code)).FirstOrDefault();
txtLabGroup.Text = labGroup.tped_lab_name;
// Select default interpretation
var ptlGroup = cdc.mst_lab_recoms.Where(x => x.mlr_id.Equals(dtl.mlr_id)).FirstOrDefault();
txtDefIntEN.Text = string.Empty;
txtDefIntTH.Text = string.Empty;
txtDefIntJP.Text = string.Empty;
if (ptlGroup != null)
{
txtDefIntEN.Text = string.IsNullOrEmpty(ptlGroup.mlr_en_name) ? "" : ptlGroup.mlr_en_name;
txtDefIntTH.Text = string.IsNullOrEmpty(ptlGroup.mlr_th_name) ? "" : ptlGroup.mlr_th_name;
txtDefIntJP.Text = string.IsNullOrEmpty(ptlGroup.mlr_jp_name) ? "" : ptlGroup.mlr_jp_name;
}
}
txtNewIntEN.Text = dtl.tped_lab_result_eng;
txtNewIntTH.Text = dtl.tped_lab_result_thai;
txtNewIntJP.Text = dtl.tped_lab_result_jp;
txtItemCode.Text = dtl.tped_lab_code;
txtItemName.Text = dtl.tped_lab_name;
txtNormalRange.Text = dtl.tped_lab_nrange;
txtUnit.Text = dtl.tped_lab_unit;
txtResult.Text = dtl.tped_lab_value;
txtSummary.Text = dtl.tped_summary.ToString();
}
private static int BK111(int?tprID, CheckupDataContext dbcBookLog, int StatusPage)
{
int count111 = dbcBookLog.pw_CR_PatienBook_HearingTest_hdr(tprID).Count();
StatusPage = (count111 > 0) ? 1 : 0;
return(StatusPage);
}
private static int BK102(int?tprID, CheckupDataContext dbcBookLog, int StatusPage)
{
int count102 = dbcBookLog.pw_CR_PatienBook_MedicalHistory(tprID).Count();
StatusPage = (count102 > 0) ? 1 : 0;
return(StatusPage);
}
private static int BK104(int?tprID, CheckupDataContext dbcBookLog, int StatusPage)
{
int count104 = dbcBookLog.pw_CR_PatienBook_LaboratoryResult(tprID).Count();
StatusPage = (count104 > 0) ? 1 : 0;
return(StatusPage);
}
private static int BK113(int?tprID, CheckupDataContext dbcBookLog, int StatusPage)
{
int count113 = dbcBookLog.pw_CR_PatienBook_DentalScreeningRecord_hdr(tprID).Count();
StatusPage = (count113 > 0) ? 1 : 0;
return(StatusPage);
}
public void LoadData(CheckupDataContext dbc)
{
if (Program.CurrentRoom != null)
{
try
{
var objwaitlist = new Class.WaitingListCls().getWaitingRoomDtl(Program.CurrentRoom.mrd_id, Program.CurrentUser.mut_id);
GridWaitingList.DataSource = new SortableBindingList <waitinglist>(objwaitlist.OrderBy(x => x.index).Select((item, index) => new waitinglist
{
NO = index + 1,
Callstatus = item.holded == true ? "HD" : "",
QueueNo = item.tpr_queue_no,
HN = item.tpt_hn_no,
FullName = item.tpt_othername,
tpr_id = item.tpr_id,
hilight = item.reserve
}).ToList());
lbTitle.Text = string.Format("Waiting List (Total {0} คน)", objwaitlist.Count());
timer1.Start();// Stat Timer
}
catch (Exception ex)
{
Program.MessageError("UIWaitList", "LoadData", ex, false);
timer1.Start();
}
}
}
private static int BK106(int?tprID, CheckupDataContext dbcBookLog, int StatusPage)
{
int count106 = dbcBookLog.pw_CR_PatienBook_ChestXRay(tprID)
.Where(s => s.trxr_result != null)
.Count();
StatusPage = (count106 > 0) ? 1 : 0;
return(StatusPage);
}
private static int BK107(int?tprID, CheckupDataContext dbcBookLog, int StatusPage)
{
int count107 = dbcBookLog.pw_CR_PatienBook_UltrasoundAbdomen(tprID)
.Where(s => s.trxr_result != null)
.Count();
StatusPage = (count107 > 0) ? 1 : 0;
return(StatusPage);
}
private static int BK109(int?tprID, CheckupDataContext dbcBookLog, int StatusPage)
{
int count109 = dbcBookLog.pw_CR_PatienBook_OtherTest(tprID)
.Where(s => s.trxm_exam != null)
.Count();
StatusPage = (count109 > 0) ? 1 : 0;
return(StatusPage);
}
private static int BK110(int?tprID, CheckupDataContext dbcBookLog, int StatusPage)
{
int count1101 = dbcBookLog.pw_CR_PatienBook_Summary_N(tprID).Count();
int count1102 = dbcBookLog.pw_CR_PatienBook_Summary_A(tprID).Count();
int count110 = count1101 + count1102;
StatusPage = (count110 > 0) ? 1 : 0;
return(StatusPage);
}
private static int BK1051(int?tprID, CheckupDataContext dbcBookLog, int StatusPage)
{
int count1051 = dbcBookLog.pw_CR_PatienBook_LaboratoryComparison_hdr(tprID)
.Where(s => s.vLab1 != null ||
s.vLab2 != null ||
s.vLab3 != null ||
s.vLab4 != null ||
s.vLab5 != null
)
.Count();
StatusPage = (count1051 > 0) ? 1 : 0;
return(StatusPage);
}
private static int BK103(int?tprID, CheckupDataContext dbcBookLog, int StatusPage)
{
int count1031 = dbcBookLog.pw_CR_PatienBook_PhysicalExamination_hdr(tprID).Count();
int count1032 = dbcBookLog.pw_CR_PatienBook_PhysicalExamination_dtl(tprID)
.Where(s => s.vLab1 != null ||
s.vLab2 != null ||
s.vLab3 != null
)
.Count();
int count1033 = dbcBookLog.pw_CR_PatienBook_PhysicalExamination_dcd(tprID).Count();
int count103 = count1031 + count1032 + count1033;
StatusPage = (count103 > 0) ? 1 : 0;
return(StatusPage);
}
public bool CheckPath(CheckupDataContext dbc, string roomcode)
{
Boolean isCheck = false;
var chkpath = (from t in dbc.mst_reports
where t.mrt_code == roomcode
select t.mrt_path_file).FirstOrDefault();
if (chkpath != null) //Exist report
{
isCheck = true;
}
else //Not exist report
{
isCheck = false;
}
return(isCheck);
}
public void LoadData(CheckupDataContext dbc, int mshID)
{
// int mhs_id = string.IsNullOrEmpty(Program.CurrentSite.mhs_id.ToString()) ? int.MinValue : Convert.ToInt32(Program.CurrentSite.mhs_id.ToString());
var waitingList = (from view1 in dbc.vw_waiting_rooms
where view1.mhs_id == mshID
orderby view1.mrm_seq_show
select new
{
Ename = view1.mrm_ename,
Waiting = (view1.waiting_ps == null)?0:view1.waiting_ps,
time = (view1.waiting_time == null) ? 0 : view1.waiting_time
}).ToList();
DGVStation.DataSource = new SortableBindingList <waintingroomqueue>(waitingList.Select((item, index) => new waintingroomqueue
{
No = index + 1,
Ename = item.Ename,
Waiting = Convert.ToInt32(item.Waiting),
time = Convert.ToInt32(item.time)
}).ToList());
lbsummaryQTY.Text = waitingList.Sum(x => x.Waiting).ToString();
lbSummaryTime.Text = waitingList.Sum(x => x.time).ToString();
}
public bool SaveToDocScan(CheckupDataContext dbc, string roomcode, int tprid, string enCurrent, string careProvider)
{
Boolean isCompleted = false;
try
{
DateTime datenow = Program.GetServerDateTime();
var getDocCode = dbc.mst_report_docscans.Where(x => x.mst_report.mrt_code == roomcode &&
x.mst_report.mrt_status == 'A' &&
datenow >= x.mst_report.mrt_effective_date.Value &&
(x.mst_report.mrt_expire_date != null ? (datenow <= x.mst_report.mrt_expire_date.Value) : true))
.OrderBy(x => x.mds_page_no).ToList();
int count = Directory.GetFiles(@"Imgs\Sub").Length;
for (int i = 0; i < count; i++)
{
#region old code
//byte[] img;
//if (roomcode == "PT101" || roomcode == "PT102" || roomcode == "PT103" || roomcode == "PT104")
// ////Specific 1 page
// img = ImageToBinary(@"Imgs/Sub/" + tprid + roomcode + "_" + DateTime.Now.ToString("yyyy-MM-dd", new CultureInfo("en-US")) + "1.jpg");
//else
// img = ImageToBinary(@"Imgs/Sub/" + tprid + roomcode + "_" + DateTime.Now.ToString("yyyy-MM-dd", new CultureInfo("en-US")) + i + ".jpg");
////SetData to Save
//var getDocCode = (from t1 in dbc.mst_reports
// join t2 in dbc.mst_report_docscans
// on t1.mrt_id equals t2.mrt_id
// where t1.mrt_code == roomcode
// && t1.mrt_status == 'A'
// && datenow >= t1.mrt_effective_date.Value
// && (t1.mrt_expire_date != null ? (datenow <= t1.mrt_expire_date.Value) : true)
// orderby t2.mds_page_no
// select new
// {
// filereport = t1.mrt_path_file + "/" + t1.mrt_file_name,
// t2.mds_doc_code,
// t2.mds_page_code,
// t2.mds_page_no,
// }).ToList();
// getDocCode = dbc.pw_Get_DocCode(roomcode).ToList();
//string hn = (from t1 in dbc.trn_patient_regis where t1.tpr_id == tprid select t1.trn_patient.tpt_hn_no).FirstOrDefault();
//string strEn = enCurrent;
//string strHn = hn;
//string[] sAryHN = strHn.Split('-');
//string[] sAryEN = strEn.Split('-');
//string HN = sAryHN[0] + sAryHN[1] + sAryHN[2];
//string EN = sAryEN[0] + sAryEN[1] + sAryEN[2];
//DataTable Tmptable = new DataTable(); DataSet tmpds = new DataSet("dss");
//Tmptable.Columns.Add("code"); Tmptable.Columns.Add("page");
//tmpds.Tables.Add(Tmptable);
//foreach (var item in getDocCode)////not confirm
//{
// var row = Tmptable.NewRow();
// row["code"] = item.mds_doc_code;
// row["page"] = item.mds_page_code + item.mds_page_no;
// Tmptable.Rows.Add(row);
//}
//string page = TgetDocCode[i - 1]["page"].ToString();
//string doctorCode = Program.CurrentUser.mut_carevider_code;
//string locationCode = Program.CurrentSite.mhs_code;
//string documentCode = Tmptable.Rows[i - 1]["code"].ToString();
//string userId = "EMRCHECKUP";
//string programId = "EMRCHECKUP";
#endregion
byte[] img;
//if (roomcode == "PT101" || roomcode == "PT102" || roomcode == "PT103" || roomcode == "PT104")
// ////Specific 1 page
// img = ImageToBinary(@"Imgs/Sub/" + tprid + roomcode + "_" + DateTime.Now.ToString("yyyy-MM-dd", new CultureInfo("en-US")) + "1.jpg");
//else
img = ImageToBinary(@"Imgs/Sub/" + tprid + roomcode + "_" + DateTime.Now.ToString("yyyy-MM-dd", new CultureInfo("en-US")) + (i + 1) + ".jpg");
string hn = (from t1 in dbc.trn_patient_regis where t1.tpr_id == tprid select t1.trn_patient.tpt_hn_no).FirstOrDefault();
string HN = hn.Replace("-", "");
string EN = enCurrent.Replace("-", "");
string page = getDocCode[i].mds_page_code + getDocCode[i].mds_page_no;
string doctorCode = careProvider;
string locationCode = Program.CurrentSite.mhs_code;
string documentCode = getDocCode[i].mds_doc_code;
string userId = "EMRCHECKUP";
string programId = "EMRCHECKUP";
string DocscanResult = wsSaveDocscan.SaveToDocscan(img, HN, EN, page, careProvider, locationCode, documentCode, userId, programId);
if (string.IsNullOrEmpty(DocscanResult))
{
}
else
{
MessageBox.Show(DocscanResult);
}
}
isCompleted = true;
if (isCompleted == true)
{
DeleteFile();
}
}
catch
{
DeleteFile();
}
return(isCompleted);
}
