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; } } }