private trn_doctor_xray LoadResult(string en)
{
trn_doctor_xray result = new trn_doctor_xray();
try
{
using (InhCheckupDataContext con = new InhCheckupDataContext())
{
switch (_trxr_type)
{
case "XR":
var objtcx = con.trn_chest_xrays
.Where(x => x.tpr_id == _tpr_id &&
x.tcx_en_no == en)
.OrderByDescending(x => x.tcx_result_date)
.FirstOrDefault();
if (objtcx != null)
{
result.trxr_type = _trxr_type;
result.trxr_order_code = objtcx.tcx_order_code;
result.trxr_order_name = objtcx.tcx_order_name;
result.trxr_result_date = objtcx.tcx_result_date;
result.trxr_overseen_by = objtcx.tcx_overseen_by;
result.trxr_result = objtcx.tcx_result;
}
return(result);
case "DM":
var objtmg = con.trn_mammograms
.Where(x => x.tpr_id == _tpr_id &&
x.tmg_en_no == en)
.OrderByDescending(x => x.tmg_result_date)
.FirstOrDefault();
if (objtmg != null)
{
result.trxr_type = _trxr_type;
result.trxr_order_code = objtmg.tmg_order_code;
result.trxr_order_name = objtmg.tmg_order_name;
result.trxr_order_date = objtmg.tmg_order_date;
result.trxr_result_date = objtmg.tmg_result_date;
result.trxr_overseen_by = objtmg.tmg_overseen_by;
result.trxr_result = objtmg.tmg_result;
}
return(result);
case "UW":
case "UU":
case "UL":
case "UB":
var objus = con.trn_ultrasounds
.Where(x => x.tpr_id == _tpr_id &&
x.tus_en_no == en &&
x.tus_ultra_type == _trxr_type)
.OrderByDescending(x => x.tus_result_date)
.FirstOrDefault();
if (objus != null)
{
result.trxr_type = _trxr_type;
result.trxr_order_code = objus.tus_order_code;
result.trxr_order_name = objus.tus_order_name;
result.trxr_order_date = objus.tus_order_date;
result.trxr_result_date = objus.tus_result_date;
result.trxr_overseen_by = objus.tus_overseen_by;
result.trxr_result = objus.tus_result;
}
return(result);
case "BD":
var objbmd = con.trn_bmds
.Where(x => x.tpr_id == _tpr_id &&
x.bmd_en_no == en)
.OrderByDescending(x => x.bmd_result_date)
.FirstOrDefault();
if (objbmd != null)
{
result.trxr_type = _trxr_type;
result.trxr_order_code = objbmd.bmd_order_code;
result.trxr_order_name = objbmd.bmd_order_name;
result.trxr_order_date = objbmd.bmd_order_date;
result.trxr_result_date = objbmd.bmd_result_date;
result.trxr_overseen_by = objbmd.bmd_overseen_by;
result.trxr_result = objbmd.bmd_result;
}
return(result);
case "UG":
var objug = con.trn_ugi_xrays
.Where(x => x.tpr_id == _tpr_id &&
x.tug_en_no == en)
.OrderByDescending(x => x.tug_result_date)
.FirstOrDefault();
if (objug != null)
{
result.trxr_type = _trxr_type;
result.trxr_order_code = objug.tug_order_code;
result.trxr_order_name = objug.tug_order_name;
result.trxr_order_date = objug.tug_order_date;
result.trxr_result_date = objug.tug_result_date;
result.trxr_overseen_by = objug.tug_overseen_by;
result.trxr_result = objug.tug_result;
}
return(result);
}
}
}
catch
{
}
return(result);
}
private void LoadData()
{
Clear();
if (_tpr_id != null && _trxr_type != null)
{
try
{
favoriteTextBox1.FavoriteOrder = _trxr_type;
if (_trxr_type == "UU")
{
ChkSummaryResult.Text = "Abdomen Result";
ChkSummaryResult.Visible = true;
}
else if (_trxr_type == "DM")
{
ChkSummaryResult.Text = "Mammogram with Ultrasound Breast Result";
ChkSummaryResult.Visible = true;
}
else
{
ChkSummaryResult.Text = "";
ChkSummaryResult.Visible = false;
}
List <mst_conclusion_favorite_dtl> mst = new EmrClass.FavoriteCls().getFavorite(favoriteTextBox1.FavoriteOrder, favoriteTextBox1.FavoriteType);
favoriteTextBox1.AutoCompleteListThList = mst.Select(x => x.mcfd_description).ToList();
cdc = new InhCheckupDataContext();
trn_patient_regi reg = cdc.trn_patient_regis.Where(x => x.tpr_id == _tpr_id).FirstOrDefault();
if (reg != null)
{
bool retrieve = true;
var ret = reg.trn_patient_retrieves.Where(x => x.tpr_image_type == _trxr_type).FirstOrDefault();
if (ret != null)
{
retrieve = ret.tpr_flag_retrieve == null ? true : (bool)ret.tpr_flag_retrieve;
}
trn_doctor_hdr hdr = reg.trn_doctor_hdrs.FirstOrDefault();
if (hdr == null)
{
hdr = new trn_doctor_hdr();
reg.trn_doctor_hdrs.Add(hdr);
}
trn_doctor_xray xray = hdr.trn_doctor_xrays.Where(x => x.trxr_type == _trxr_type).FirstOrDefault();
if (xray == null)
{
xray = new trn_doctor_xray();
xray.trxr_not_show_rpt = 'N';
xray.trxr_type = _trxr_type;
hdr.trn_doctor_xrays.Add(xray);
}
if (retrieve)
{
var result = LoadResult(reg.tpr_en_no);
xray.trxr_order_code = result.trxr_order_code;
xray.trxr_order_name = result.trxr_order_name;
xray.trxr_order_date = result.trxr_order_date;
xray.trxr_result_date = result.trxr_result_date;
xray.trxr_overseen_by = result.trxr_overseen_by;
xray.trxr_result = result.trxr_result;
}
var xray_images = xray.trn_doctor_xray_images.ToList();
int i = 0;
foreach (trn_doctor_xray_image image in xray_images)
{
System.IO.MemoryStream ms = new System.IO.MemoryStream(image.trxm_image.ToArray());
Image img = Image.FromStream(ms);
AddImage(img, image.trxm_sel_image == 'S' ? true : false);
}
txtPacURL.Text = LoadURL(reg.tpt_id, reg.tpr_en_no);
DoctorXrayBS.DataSource = xray;
}
panel1.Enabled = true;
}
catch (Exception ex)
{
Program.MessageError("DialogImaging", "LoadData()", ex, false);
panel1.Enabled = false;
}
}
}
