protected void btnsearch_Click(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { DataSet ds = new DataSet(); string companyid = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; string strfrom = ""; string strto = ""; string attorney = ""; foreach (Object item in lstattorny.SelectedValues) { if (attorney.Equals("")) { attorney = item.ToString(); } else if (attorney != null) { attorney = attorney + "," + item.ToString(); } } if (dtfromdate.Value != null && dttodate.Value != null) { DateTime from = Convert.ToDateTime(dtfromdate.Value); DateTime to = Convert.ToDateTime(dttodate.Value); strfrom = from.ToString("MM/dd/yyyy"); strto = to.ToString("MM/dd/yyyy"); } Bill_Sys_PatientBO obj = new Bill_Sys_PatientBO(); ds = obj.loadgrid(companyid, attorney, strfrom, strto); grdattorneyreport.DataSource = ds; grdattorneyreport.DataBind(); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
// To load Patient Details private void GetPatientDeskList() { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); try { grdPatientDeskList.DataSource = _bill_Sys_PatientBO.GetPatienDeskList("GETPATIENTLIST", ((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_CASE_ID); grdPatientDeskList.DataBind(); if ((((Bill_Sys_SystemObject)Session["SYSTEM_OBJECT"]).SZ_CHART_NO != "1")) { grdPatientDeskList.Columns[1].Visible = false; } } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
private void GetPatientDeskList() { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } Bill_Sys_PatientBO _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); try { grdPatientDeskList.DataSource = _bill_Sys_PatientBO.GetPatienDeskList("GETPATIENTLIST", txtCaseID.Text); grdPatientDeskList.DataBind(); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
private void GetBillingInformation() { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); try { grdBillingInformation.DataSource = _bill_Sys_PatientBO.GetPatienDeskList("BILLINGINFORMATION", ((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_CASE_ID, ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID); grdBillingInformation.DataBind(); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void lstInsuranceCompanyAddress_SelectedIndexChanged(object sender, EventArgs e) { Bill_Sys_PatientBO _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); try { ArrayList _arraylist = _bill_Sys_PatientBO.GetInsuranceAddressDetail(lstInsuranceCompanyAddress.SelectedValue); txtInsuranceAddress.Text = _arraylist[2].ToString(); txtInsuranceCity.Text = _arraylist[3].ToString(); txtInsuranceState.Text = _arraylist[4].ToString(); txtInsuranceZip.Text = _arraylist[5].ToString(); txtInsuranceStreet.Text = _arraylist[6].ToString(); txtInsFax.Text = _arraylist[9].ToString(); txtInsPhone.Text = _arraylist[10].ToString(); // txtInsContactPerson.Text = _arraylist[11].ToString(); Page.MaintainScrollPositionOnPostBack = true; } catch (Exception ex) { //usrMessage.PutMessage(ex.ToString()); //usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_ErrorMessage); //usrMessage.Show(); } }
protected void btn_ViewAll_Click(object sender, EventArgs e) { case_id = ""; list_case_id = ""; _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); //DataSet ds=new DataSet(); ArrayList arr = new ArrayList(); arr.Add(txtCaseNumber.Text); arr.Add(txtPatientName.Text); arr.Add(txtCompanyID.Text); arr.Add(txtFromDate.Text); arr.Add(txtToDate.Text); arr.Add(extddlCaseType.Text); arr.Add(txtOpenFromDate.Text); arr.Add(txtOpenToDate.Text); arr.Add(txtVisitFromDate.Text); arr.Add(txtVisitTODate.Text); //ds = _bill_Sys_PatientBO.Get_Patient_Visit_Summary_Report(arr); //for (int i = 0; i < ds.Tables[0].Rows.Count; i++) //{ // case_id = case_id + ds.Tables[0].Rows[i][1].ToString() + ","; //} //list_case_id = case_id.Substring(0, case_id.Length - 1); //_bill_Sys_PatientBO = new Bill_Sys_PatientBO(); //arr=new ArrayList(); DataTable dt = _bill_Sys_PatientBO.Get_SpecialityCountReport_New(arr); Session["SpecialityCount"] = dt; Page.RegisterClientScriptBlock("mm", "<script language='javascript'>window.open('../Bill_Sys_GetTreatment.aspx', 'TreatmentData', 'left=30,top=30,scrollbars=1');</script>"); }
protected void extddlInsuranceCompany_extendDropDown_SelectedIndexChanged(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { ClearInsurancecontrol(); Bill_Sys_PatientBO _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); lstInsuranceCompanyAddress.DataSource = _bill_Sys_PatientBO.GetInsuranceCompanyAddress(extddlInsuranceCompany.Text); lstInsuranceCompanyAddress.DataTextField = "DESCRIPTION"; lstInsuranceCompanyAddress.DataValueField = "CODE"; lstInsuranceCompanyAddress.DataBind(); Page.MaintainScrollPositionOnPostBack = true; } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void BindGrid() { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { txtEmployerName.Text = extddlEmployer.Selected_Text; Bill_Sys_PatientBO objBillSysPatientBO = new Bill_Sys_PatientBO(); ArrayList arrPatient = new ArrayList(); arrPatient.Add(txtCompanyID.Text); arrPatient.Add(extddlEmployer.Text); if (txtCaseNo.Text != "") { string cases = ""; string[] spiltcases = txtCaseNo.Text.Trim().Split(','); for (int i = 0; i < spiltcases.Length; i++) { if (cases == "") { cases = "'" + spiltcases[i].ToString() + "'"; } else { cases += ",'" + spiltcases[i].ToString() + "'"; } } arrPatient.Add(cases); } else { arrPatient.Add(""); } arrPatient.Add(txtPatientName.Text); arrPatient.Add(rdoISActivePatient.SelectedValue.ToString()); DataSet ds = objBillSysPatientBO.GetEmployeCase(arrPatient); grdCaseMaster.DataSource = ds; grdCaseMaster.DataBind(); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
public void BindPatientInfo() { Bill_Sys_PatientBO _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); DataSet DsPatientInfo = _bill_Sys_PatientBO.GetPatientInfo(txtPatientId.Text, txtCompanyId.Text); DtlView.DataSource = DsPatientInfo; DtlView.DataBind(); }
private void ConfigPatientDesk() { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); try { DataTable dt = _bill_Sys_PatientBO.GetConfigPatientDesk(((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ROLE); foreach (DataRow dr in dt.Rows) { switch (dr[0].ToString()) { case "Treatment Information": tblTreatmentInformation.Visible = true; break; case "Last Treatment": tblLastTreatment.Visible = true; break; case "All Treatments": tblAllTreatment.Visible = true; break; case "Billing Information": tblBillingInformation.Visible = true; break; case "Visit Information": tblVisitInformation.Visible = true; break; } } } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void BindGrid() {//Logging Start string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { this.txtEmployerName.Text = this.extddlEmployer.Selected_Text; Bill_Sys_PatientBO billSysPatientBO = new Bill_Sys_PatientBO(); ArrayList arrayLists = new ArrayList(); arrayLists.Add(this.txtCompanyID.Text); arrayLists.Add(this.extddlEmployer.Text); if (this.txtCaseNo.Text == "") { arrayLists.Add(""); } else { string str = ""; string[] strArrays = this.txtCaseNo.Text.Trim().Split(new char[] { ',' }); for (int i = 0; i < (int)strArrays.Length; i++) { str = (str != "" ? string.Concat(str, ",'", strArrays[i].ToString(), "'") : string.Concat("'", strArrays[i].ToString(), "'")); } arrayLists.Add(str); } arrayLists.Add(this.txtPatientName.Text); arrayLists.Add(this.rdoISActivePatient.SelectedValue.ToString()); DataSet employeCase = billSysPatientBO.GetEmployeCase(arrayLists); this.grdCaseMaster.DataSource = employeCase; this.grdCaseMaster.DataBind(); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void Page_Load(object sender, EventArgs e) { string companyid = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; DataSet ds; string flag = "GET_USER_LIST"; Bill_Sys_PatientBO obj = new Bill_Sys_PatientBO(); ds = obj.loadattorney(flag, companyid); lstattorny.ValueField = "CODE"; lstattorny.TextField = "DESCRIPTION"; lstattorny.DataSource = ds; lstattorny.DataBind(); }
//not used yet private void viewrepoert() { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { string company_id = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; for (int i = 0; i < grdattorneyreport.VisibleRowCount; i++) { //if (((CheckBox)di.FindControl("chkSelect")).Checked) //{ // case_id = case_id + "'" + grdCaseMaster.DataKeys[di.RowIndex][0].ToString() + "',"; // string assignlawfirm=assignlawfirm+"'"+grdattorneyreport.GetRowValues(i,"SZ_ASSIGNED_LAWFIRM_ID"); } string case_id = "5094,5142,5142,7536"; string list_case_id = case_id.Substring(0, case_id.Length - 1); Bill_Sys_PatientBO _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); DataTable dt = _bill_Sys_PatientBO.Get_SpecAttorneyCountReport(list_case_id, company_id, "", ""); Session["SpecialityCount"] = dt; // Page.RegisterClientScriptBlock("mm", "<script language='javascript'>window.open('../Bill_Sys_GetTreatment.aspx', 'TreatmentData', 'left=30,top=30,scrollbars=1');</script>"); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ajAutoIns.ContextKey = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; extddlInsuranceCompany.Flag_ID = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; extddlCaseType.Flag_ID = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; // txtPatientId.Text = ((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_PATIENT_ID; CaseDetailsBO _caseDetailsBO = new CaseDetailsBO(); txtPatientId.Text = _caseDetailsBO.GetCasePatientID(txtCaseID.Text, ""); Bill_Sys_PatientDeskList objGetVisitInfo = new Bill_Sys_PatientDeskList(); DataSet dsVisitInfo = new DataSet(); if (txtCaseID.Text.Trim() != "" && txtEventID.Text.Trim() != "") { dsVisitInfo = objGetVisitInfo.GetVisitInsInfo(txtCaseID.Text, ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID, txtEventID.Text, "EVENT"); } else if (txtCaseID.Text != "" && txtEventID.Text.Trim() == "") { dsVisitInfo = objGetVisitInfo.GetVisitInsInfo(txtCaseID.Text, ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID, txtEventID.Text, "CASE"); } if (dsVisitInfo.Tables.Count > 0) { if (dsVisitInfo.Tables[0].Rows.Count > 0) { txtPolicyHolder.Text = dsVisitInfo.Tables[0].Rows[0]["SZ_POLICY_HOLDER"].ToString(); txtPolicyNumber.Text = dsVisitInfo.Tables[0].Rows[0]["SZ_POLICY_NO"].ToString(); txtClaimNumber.Text = dsVisitInfo.Tables[0].Rows[0]["SZ_CLAIM_NUMBER"].ToString(); txtdateofaccident.Text = dsVisitInfo.Tables[0].Rows[0]["SZ_DOA"].ToString(); extddlCaseType.Text = dsVisitInfo.Tables[0].Rows[0]["SZ_CASE_TYPE_ID"].ToString(); hdninsurancecode.Value = dsVisitInfo.Tables[0].Rows[0]["SZ_INS_ID"].ToString(); txtInsuranceCompany.Text = dsVisitInfo.Tables[0].Rows[0]["SZ_INSURANCE_NAME"].ToString(); Bill_Sys_PatientBO _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); // lstInsuranceCompanyAddress.Items.Clear(); //notuse lstInsuranceCompanyAddress.DataSource = _bill_Sys_PatientBO.GetInsuranceCompanyAddress(extddlInsuranceCompany.Text).Tables[0]; lstInsuranceCompanyAddress.DataSource = _bill_Sys_PatientBO.GetInsuranceCompanyAddress(hdninsurancecode.Value).Tables[0]; lstInsuranceCompanyAddress.DataTextField = "DESCRIPTION"; lstInsuranceCompanyAddress.DataValueField = "CODE"; lstInsuranceCompanyAddress.DataBind(); lstInsuranceCompanyAddress.Text = dsVisitInfo.Tables[0].Rows[0]["SZ_INS_ADD_ID"].ToString(); lstInsuranceCompanyAddress_SelectedIndexChanged(sender, e); } } } }
protected void btnViewReport_Click(object sender, EventArgs e) {//Logging Start string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { string company_id = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; foreach (GridViewRow di in grdCaseMaster.Rows) { if (((CheckBox)di.FindControl("chkSelect")).Checked) { case_id = case_id + "'" + grdCaseMaster.DataKeys[di.RowIndex][0].ToString() + "',"; } } list_case_id = case_id.Substring(0, case_id.Length - 1); _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); DataTable dt = _bill_Sys_PatientBO.Get_SpecialityCountReport(list_case_id, txtCompanyID.Text, txtVisitFromDate.Text, txtVisitTODate.Text); Session["SpecialityCount"] = dt; Page.RegisterClientScriptBlock("mm", "<script language='javascript'>window.open('../Bill_Sys_GetTreatment.aspx', 'TreatmentData', 'left=30,top=30,scrollbars=1');</script>"); } catch (Exception ex) { this.Session["SendPatientToDoctor"] = false; Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void btnRemove_Click(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { Bill_Sys_PatientBO _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); _bill_Sys_PatientBO.RemoveInsuranceInfoevent(txteventid.Text, txtCompanyID.Text); usrMessage1.PutMessage("Remove Successfully"); usrMessage1.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage); usrMessage1.Show(); lstInsuranceCompanyAddress.Items.Clear(); txtInsuranceAddress.Text = ""; txtInsuranceCompany.Text = ""; txtclaimno.Text = ""; txtpoliccyno.Text = ""; txtInsCity.Text = ""; txtInsState.Text = ""; txtInsZip.Text = ""; txtInsPhone.Text = ""; txtInsFax.Text = ""; hdninsurancecode.Value = ""; Page.MaintainScrollPositionOnPostBack = true; } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
private void GetDoctorTreatmentList() { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); try { grdDoctorTreatmentList.DataSource = _bill_Sys_PatientBO.GetPatienDeskList("GETTREATINGDOCTOR", ((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_CASE_ID, ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID); grdDoctorTreatmentList.DataBind(); string strDoctorName = ""; for (int i = 0; i < grdDoctorTreatmentList.Items.Count; i++) { Label lbl = (Label)grdDoctorTreatmentList.Items[i].Cells[0].FindControl("lblDoctorName"); if (strDoctorName != "" && strDoctorName == lbl.Text) { lbl.Text = ""; } else { strDoctorName = lbl.Text; } } } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void lstInsuranceCompanyAddress_SelectedIndexChanged(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } Bill_Sys_PatientBO _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); try { ArrayList _arraylist = _bill_Sys_PatientBO.GetInsuranceAddressDetail(lstInsuranceCompanyAddress.SelectedValue); txtInsuranceaddid.Text = lstInsuranceCompanyAddress.SelectedValue; txtInsuranceAddress.Text = _arraylist[2].ToString(); txtInsCity.Text = _arraylist[3].ToString(); txtInsState.Text = _arraylist[4].ToString(); txtInsZip.Text = _arraylist[5].ToString(); txtInsFax.Text = _arraylist[9].ToString(); txtInsPhone.Text = _arraylist[10].ToString(); Page.MaintainScrollPositionOnPostBack = true; } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void Page_Load(object sender, EventArgs e) { strConn = ConfigurationManager.AppSettings["Connection_String"].ToString(); { mbs.lawfirm.Bill_Sys_Patient_Details obj = new Bill_Sys_Patient_Details(); mbs.provider.ProviderServices obj_provider = new ProviderServices(); try { if (!IsPostBack) { Bill_Sys_PatientBO _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); if (Session["Office_ID"] != null) { hdnOfficeId.Value = Session["Office_ID"].ToString(); } if (Request.QueryString.Count > 0) { szCaseId = Request.QueryString["caseid"].ToString(); txtcaseid.Text = szCaseId; CaseDetailsBO _caseDetailsBO = new CaseDetailsBO(); Bill_Sys_CaseObject _bill_Sys_CaseObject = new Bill_Sys_CaseObject(); szBillingCmp = Request.QueryString["cmpid"].ToString(); txtCompanyid.Text = szBillingCmp; // string patientName = Request.QueryString["pname"].ToString(); caseno = Request.QueryString["caseno"].ToString(); _bill_Sys_CaseObject.SZ_CASE_ID = szCaseId; _bill_Sys_CaseObject.SZ_COMAPNY_ID = szBillingCmp; //_bill_Sys_CaseObject.SZ_PATIENT_NAME = patientName; _bill_Sys_CaseObject.SZ_CASE_NO = caseno; Session["CASE_OBJECT"] = _bill_Sys_CaseObject; mbs.lawfirm.Bill_Sys_CollectDocAndZip _cNz = new mbs.lawfirm.Bill_Sys_CollectDocAndZip(); DataSet Batchds = new DataSet(); Batchds = _cNz.GetDowloadAs(szCaseId); if (Batchds.Tables[0].Rows.Count > 0 && Batchds.Tables[0].Rows[0][0].ToString() == "SNGL") { //i= DtlView.FindControl("abc"); //Table tb = (Table)DtlView.Items.FindControl("tblF"); //DtlView1.DataSource = Batchds; //DtlView1.DataBind(); //DtlView1.Visible = true; } else { } } _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); DataSet ds = obj_provider.GetPatientInfo_Provider(szCaseId, szBillingCmp); //DataSet ds = _bill_Sys_PatientBO.GetPatientInfo_Provider(((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_CASE_ID, sz_CmpId); //DataSet ds = obj.GetPatientInformation(((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_CASE_ID, sz_CmpId); if (ds.Tables[0].Columns.Count == 1) { Session["Check"] = "Not Correct"; Response.Redirect("Bill_Sys_SearchCase.aspx"); } else { DataTable dt = ds.Tables[0]; DtlView.DataSource = ds; DtlView.DataBind(); } //To Open Document Manager hdnCaseId.Value = szCaseId; hdnCaseNo.Value = caseno; hdnCompanyId.Value = szBillingCmp.ToString(); //End Of Code } } catch (Exception exc) { usrMessage.PutMessage(exc.ToString()); usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_ErrorMessage); usrMessage.Show(); } } }
protected void intialLoad(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } string szinsurnacecompanyname = Request.QueryString["insurancecompanyname"].ToString(); if (szinsurnacecompanyname != null && szinsurnacecompanyname != "") { szinsurnacecompanyname = szinsurnacecompanyname.Replace("@sq@", "'"); } string szinsurnaceid = Request.QueryString["insuranceid"].ToString(); string szinsurnaceaddid = Request.QueryString["insuranceaddid"].ToString(); string eventid = Request.QueryString["eventid"].ToString(); string caseid = Request.QueryString["caseid"].ToString(); string szclaimno = Request.QueryString["claimno"].ToString(); string szpolicyno = Request.QueryString["policyno"].ToString(); string szcasetype = Request.QueryString["casetype"].ToString(); string szpolicyholder = Request.QueryString["policyholder"].ToString(); string dateofaccident = Request.QueryString["dateofaccident"].ToString(); string szpatientphone = Request.QueryString["patientPhone"].ToString(); string szlocation = Request.QueryString["locationname"].ToString(); string szEventProcID = Request.QueryString["EventProcID"].ToString(); txtInsuranceid.Text = szinsurnaceid; txtInsuranceaddid.Text = szinsurnaceaddid; txteventid.Text = eventid; txtCaseID.Text = caseid; txtclaimno.Text = szclaimno; txtpoliccyno.Text = szpolicyno; txtInsuranceCompany.Text = szinsurnacecompanyname; extddlCaseType.Text = szcasetype; txtpolicyholder.Text = szpolicyholder; txtPatientPhoneNo.Text = szpatientphone.Trim(); extddlLocation.Text = szlocation; txtEventPRocID.Text = szEventProcID; if (szcasetype == "CT000000000000000120") { extddlCoSignedby.Enabled = true; } DataSet ds = new DataSet(); Bill_Sys_ProcedureCode_BO _bill_Sys_ProcedureCode_BO = new Bill_Sys_ProcedureCode_BO(); ds = _bill_Sys_ProcedureCode_BO.UpdateCoSignedBy(Convert.ToInt32(szEventProcID), extddlCoSignedby.Text, "GET"); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { extddlCoSignedby.Text = ds.Tables[0].Rows[0][0].ToString(); } } if (dateofaccident.Trim() == "OC") { txtdateofaccident.Text = ""; ChkOC.Checked = true; txtdateofaccident.Enabled = false; imgbtnATAccidentDate.Enabled = false; } else { if (dateofaccident.ToLower().Trim() != "missing") { txtdateofaccident.Text = dateofaccident; } else { txtdateofaccident.Text = ""; } } //hdninsurancecode.Value = szinsurnaceid; if (txtInsuranceCompany.Text != "") { if (szinsurnaceid != "0") { try { ClearInsurancecontrol(); Bill_Sys_PatientBO _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); lstInsuranceCompanyAddress.DataSource = _bill_Sys_PatientBO.GetInsuranceCompanyAddress(szinsurnaceid); lstInsuranceCompanyAddress.DataTextField = "DESCRIPTION"; lstInsuranceCompanyAddress.DataValueField = "CODE"; lstInsuranceCompanyAddress.DataBind(); for (int i = 0; i < lstInsuranceCompanyAddress.Items.Count; i++) { if (lstInsuranceCompanyAddress.Items[i].Value == szinsurnaceaddid) { lstInsuranceCompanyAddress.SelectedIndex = i; lstInsuranceCompanyAddress_SelectedIndexChanged(sender, e); break; } } Page.MaintainScrollPositionOnPostBack = true; } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } } else { lstInsuranceCompanyAddress.Items.Clear(); hdninsurancecode.Value = ""; } btnremove.Enabled = true; } else { lstInsuranceCompanyAddress.Items.Clear(); txtInsuranceAddress.Text = ""; txtInsCity.Text = ""; txtInsState.Text = ""; txtInsZip.Text = ""; txtInsPhone.Text = ""; txtInsFax.Text = ""; hdninsurancecode.Value = ""; Page.MaintainScrollPositionOnPostBack = true; btnremove.Enabled = false; } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void txtInsuranceCompany_TextChanged(object sender, EventArgs args) { Bill_Sys_PatientBO _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); string strInsuranceID = hdninsurancecode.Value; int Index = 0; if (txtInsuranceCompany.Text != "") { if (strInsuranceID != "0" && strInsuranceID != "") { try { ClearInsurancecontrol(); lstInsuranceCompanyAddress.DataSource = _bill_Sys_PatientBO.GetInsuranceCompanyAddress(strInsuranceID); // DataSet dslstInsuranceCompanyAddress = new DataSet(); dslstInsuranceCompanyAddress = (DataSet)lstInsuranceCompanyAddress.DataSource; lstInsuranceCompanyAddress.DataTextField = "DESCRIPTION"; lstInsuranceCompanyAddress.DataValueField = "CODE"; if (dslstInsuranceCompanyAddress.Tables[0].Rows.Count == 0) { lstInsuranceCompanyAddress.Items.Clear(); } else { lstInsuranceCompanyAddress.DataBind(); for (int i = 0; i < dslstInsuranceCompanyAddress.Tables[0].Rows.Count; i++) { if (dslstInsuranceCompanyAddress.Tables[0].Rows[i][2].ToString().Equals("1")) { Index = i; } } lstInsuranceCompanyAddress.SelectedIndex = Index; ArrayList _arraylist = _bill_Sys_PatientBO.GetInsuranceAddressDetail(dslstInsuranceCompanyAddress.Tables[0].Rows[Index][0].ToString()); txtInsuranceAddress.Text = _arraylist[2].ToString(); txtInsuranceCity.Text = _arraylist[3].ToString(); txtInsuranceState.Text = _arraylist[4].ToString(); //extddlInsuranceState.Text = _arraylist[4].ToString(); txtInsuranceZip.Text = _arraylist[5].ToString(); txtInsuranceStreet.Text = _arraylist[6].ToString(); if (_arraylist[8].ToString() != "") { //extddlInsuranceState.Text = _arraylist[8].ToString(); txtInsPhone.Text = _arraylist[10].ToString(); } Page.MaintainScrollPositionOnPostBack = true; } lstInsuranceCompanyAddress.DataTextField = "DESCRIPTION"; lstInsuranceCompanyAddress.DataValueField = "CODE"; lstInsuranceCompanyAddress.DataBind(); Page.MaintainScrollPositionOnPostBack = true; if (lstInsuranceCompanyAddress.Items.Count == 1) { ArrayList _arraylist = _bill_Sys_PatientBO.GetInsuranceAddressDetail(dslstInsuranceCompanyAddress.Tables[0].Rows[0][0].ToString()); txtInsuranceAddress.Text = _arraylist[2].ToString(); txtInsuranceCity.Text = _arraylist[3].ToString(); txtInsuranceState.Text = _arraylist[4].ToString(); //extddlInsuranceState.Text = _arraylist[4].ToString(); txtInsuranceZip.Text = _arraylist[5].ToString(); txtInsuranceStreet.Text = _arraylist[6].ToString(); if (_arraylist[8].ToString() != "") { //extddlInsuranceState.Text = _arraylist[8].ToString(); Page.MaintainScrollPositionOnPostBack = true; } } ArrayList _arraylistnew = new ArrayList(); lstInsuranceCompanyAddress.DataSource = _bill_Sys_PatientBO.GetInsuranceCompanyAddress(hdninsurancecode.Value); if (_arraylistnew.Count == 0) { } else { txtInsuranceAddress.Text = _arraylistnew[1].ToString(); for (int i = 0; i < lstInsuranceCompanyAddress.Items.Count; i++) { if (lstInsuranceCompanyAddress.Items[i].Value == _arraylistnew[0].ToString()) { lstInsuranceCompanyAddress.SelectedIndex = i; break; } } txtInsuranceCity.Text = _arraylistnew[2].ToString(); txtInsuranceZip.Text = _arraylistnew[3].ToString(); txtInsuranceStreet.Text = _arraylistnew[4].ToString(); txtInsuranceState.Text = _arraylistnew[6].ToString(); //extddlInsuranceState.Text = _arraylistnew[5].ToString(); Page.MaintainScrollPositionOnPostBack = true; } } catch (Exception ex) { //usrMessage.PutMessage(ex.ToString()); //usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_ErrorMessage); //usrMessage.Show(); } } else { lstInsuranceCompanyAddress.Items.Clear(); txtInsuranceAddress.Text = ""; txtInsuranceCity.Text = ""; txtInsuranceState.Text = ""; //extddlInsuranceState.Text = ""; txtInsuranceZip.Text = ""; txtInsuranceStreet.Text = ""; txtInsPhone.Text = ""; hdninsurancecode.Value = ""; } } else { lstInsuranceCompanyAddress.Items.Clear(); txtInsuranceAddress.Text = ""; txtInsuranceCity.Text = ""; txtInsuranceState.Text = ""; //extddlInsuranceState.Text = ""; txtInsuranceZip.Text = ""; txtInsuranceStreet.Text = ""; txtInsPhone.Text = ""; hdninsurancecode.Value = ""; } }
protected void Page_Load(object sender, EventArgs e) { string sz_CmpId = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; strConn = ConfigurationManager.AppSettings["Connection_String"].ToString(); // if (((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).BT_REFERRING_FACILITY == true && ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID != e.Item.Cells[28].Text) { // Bill_Sys_PatientBO _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); mbs.lawfirm.Bill_Sys_Patient_Details obj = new Bill_Sys_Patient_Details(); try { if (!IsPostBack) { string szBillingCmp = ""; if (Request.QueryString.Count > 0) { Bill_Sys_PatientBO _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); szCaseId = Request.QueryString["csid"].ToString(); byte[] ar = System.Convert.FromBase64String(szCaseId); szCaseId = System.Text.ASCIIEncoding.ASCII.GetString(ar); CaseDetailsBO _caseDetailsBO = new CaseDetailsBO(); Bill_Sys_CaseObject _bill_Sys_CaseObject = new Bill_Sys_CaseObject(); szBillingCmp = Request.QueryString["cmp"].ToString(); byte[] ar1 = System.Convert.FromBase64String(szBillingCmp); szBillingCmp = System.Text.ASCIIEncoding.ASCII.GetString(ar1); string patientName = Request.QueryString["pname"].ToString(); byte[] ar2 = System.Convert.FromBase64String(patientName); patientName = System.Text.ASCIIEncoding.ASCII.GetString(ar2); string caseno = Request.QueryString["caseno"].ToString(); byte[] ar4 = System.Convert.FromBase64String(caseno); caseno = System.Text.ASCIIEncoding.ASCII.GetString(ar4); _bill_Sys_CaseObject.SZ_CASE_ID = szCaseId; _bill_Sys_CaseObject.SZ_COMAPNY_ID = szBillingCmp; _bill_Sys_CaseObject.SZ_PATIENT_NAME = patientName; _bill_Sys_CaseObject.SZ_CASE_NO = caseno; Session["CASE_OBJECT"] = _bill_Sys_CaseObject; mbs.lawfirm.Bill_Sys_CollectDocAndZip _cNz = new mbs.lawfirm.Bill_Sys_CollectDocAndZip(); DataSet Batchds = new DataSet(); Batchds = _cNz.GetDowloadAs(szCaseId); if (Batchds.Tables[0].Rows.Count > 0 && Batchds.Tables[0].Rows[0][0].ToString() == "SNGL") { //i= DtlView.FindControl("abc"); //Table tb = (Table)DtlView.Items.FindControl("tblF"); //DtlView1.DataSource = Batchds; //DtlView1.DataBind(); //DtlView1.Visible = true; } else { } } DataSet ds = obj.GetPatientInformation(((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_CASE_ID, sz_CmpId); if (ds.Tables[0].Columns.Count == 1) { Session["Check"] = "Not Correct"; Response.Redirect("Bill_Sys_SearchCase.aspx"); } else { DataTable dt = ds.Tables[0]; DtlView.DataSource = ds; DtlView.DataBind(); } //To Open Document Manager hdnCaseId.Value = ((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_CASE_ID; hdnCaseNo.Value = ((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_CASE_NO; hdnCompanyId.Value = szBillingCmp.ToString(); //End Of Code } } catch (Exception exc) { usrMessage.PutMessage(exc.ToString()); usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_ErrorMessage); usrMessage.Show(); } } }
protected void Page_Load(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { string company_id = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; if (!IsPostBack) { string lawfirmid = "7536"; string datefrom = ""; string dateto = ""; if (base.Request.QueryString["visitfromdate"] != null) { datefrom = Request.QueryString["visitfromdate"].ToString(); } if (base.Request.QueryString["visittodate"] != null) { dateto = Request.QueryString["visittodate"].ToString(); } if (base.Request.QueryString["assignedLFid"] != null) { lawfirmid = Request.QueryString["assignedLFid"].ToString(); } //string case_id = "'5094','5142','5142','7536'"; //string list_case_id = case_id.Substring(0, case_id.Length - 1); Bill_Sys_PatientBO _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); DataTable dt = _bill_Sys_PatientBO.Get_SpecAttorneyCountReport(lawfirmid, company_id, datefrom, dateto); //DataTable dt = new DataTable(); //dt = ((DataTable)Session["SpecialityCount"]); if (dt.Rows.Count > 0) { //grdTreatment.DataSource = ((DataTable)Session["SpecialityCount"]); grdTreatment.DataSource = dt; grdTreatment.DataBind(); //Session["EXPORTSpecialityCount"] = Session["SpecialityCount"]; Session["EXPORTSpecialityCount"] = dt; //Session["SpecialityCount"] = null; } } } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } #region "check version readonly or not" string app_status = ((Bill_Sys_BillingCompanyObject)Session["APPSTATUS"]).SZ_READ_ONLY.ToString(); if (app_status.Equals("True")) { Bill_Sys_ChangeVersion cv = new Bill_Sys_ChangeVersion(this.Page); cv.MakeReadOnlyPage("Get_Treatment.aspx"); } #endregion //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
private void GetPatientDetails() { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } DataSet dspatientinfo = new DataSet(); try { _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); dspatientinfo = GetPatienView(txtcaseid.Text, txtCompanyID.Text); if (dspatientinfo.Tables[0].Rows.Count > 0) { if (dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_FIRST_NAME"].ToString() != " ") { txtPatientFName.Text = dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_FIRST_NAME"].ToString(); } if (dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_LAST_NAME"].ToString() != " ") { txtPatientLName.Text = dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_LAST_NAME"].ToString(); } if (dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_FIRST_NAME"].ToString() != " ") { txtMI.Text = dspatientinfo.Tables[0].Rows[0]["MI"].ToString(); } if (dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_ADDRESS"].ToString() != " ") { txtPatientAddress.Text = dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_ADDRESS"].ToString(); } if (dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_CITY"].ToString() != " ") { txtPatientCity.Text = dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_CITY"].ToString(); } if (dspatientinfo.Tables[0].Rows[0]["DOB"].ToString() != " ") { txtDateOfBirth.Text = dspatientinfo.Tables[0].Rows[0]["DOB"].ToString(); } if (dspatientinfo.Tables[0].Rows[0]["SZ_GENDER"].ToString() != " ") { ddlSex.SelectedValue = dspatientinfo.Tables[0].Rows[0]["SZ_GENDER"].ToString(); } if (dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_CITY"].ToString() != " ") { txtPatientCity.Text = dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_CITY"].ToString(); } if (dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_STATE_ID"].ToString() != " ") { extddlPatientState.Text = dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_STATE_ID"].ToString(); } if (dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_PHONE"].ToString() != " ") { txthomephone.Text = dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_PHONE"].ToString(); } if (dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_ZIP"].ToString() != " ") { txtPatientZip.Text = dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_ZIP"].ToString(); } if (dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_EMAIL"].ToString() != " ") { txtPatientEmail.Text = dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_EMAIL"].ToString(); } if (dspatientinfo.Tables[0].Rows[0]["SZ_WORK_PHONE_EXTENSION"].ToString() != " ") { txtExtension.Text = dspatientinfo.Tables[0].Rows[0]["SZ_WORK_PHONE_EXTENSION"].ToString(); } if (dspatientinfo.Tables[0].Rows[0]["SZ_ATTORNEY_ID"].ToString() != " ") { extddlAttorney.Text = dspatientinfo.Tables[0].Rows[0]["SZ_ATTORNEY_ID"].ToString(); } if (dspatientinfo.Tables[0].Rows[0]["SZ_CASE_TYPE_ID"].ToString() != " ") { extddlCaseType.Text = dspatientinfo.Tables[0].Rows[0]["SZ_CASE_TYPE_ID"].ToString(); } if (dspatientinfo.Tables[0].Rows[0]["SZ_CASE_STATUS_ID"].ToString() != " ") { extddlCaseStatus.Text = dspatientinfo.Tables[0].Rows[0]["SZ_CASE_STATUS_ID"].ToString(); } if (dspatientinfo.Tables[0].Rows[0]["SZ_SOCIAL_SECURITY_NO"].ToString() != " ") { txtSocialSecurityNumber.Text = dspatientinfo.Tables[0].Rows[0]["SZ_SOCIAL_SECURITY_NO"].ToString(); } if (dspatientinfo.Tables[0].Rows[0]["SZ_POLICY_HOLDER"].ToString() != " ") { txtPolicyHolder.Text = dspatientinfo.Tables[0].Rows[0]["SZ_POLICY_HOLDER"].ToString(); } if (dspatientinfo.Tables[0].Rows[0]["SZ_INSURANCE_ID"].ToString() != " " && dspatientinfo.Tables[0].Rows[0]["SZ_INSURANCE_ID"].ToString() != "") { extddlInsuranceCompany.Text = dspatientinfo.Tables[0].Rows[0]["SZ_INSURANCE_ID"].ToString(); // Not in use hdninsurancecode.Value = dspatientinfo.Tables[0].Rows[0]["SZ_INSURANCE_ID"].ToString(); txtInsuranceCompany.Text = dspatientinfo.Tables[0].Rows[0]["SZ_INSURANCE_NAME"].ToString(); if (extddlInsuranceCompany.Text != "NA" && extddlInsuranceCompany.Text != "") //Not use { if (txtInsuranceCompany.Text != "" && txtInsuranceCompany.Text != "No suggestions found for your search") { lstInsuranceCompanyAddress.DataSource = _bill_Sys_PatientBO.GetInsuranceCompanyAddress(hdninsurancecode.Value).Tables[0]; } } lstInsuranceCompanyAddress.DataTextField = "DESCRIPTION"; lstInsuranceCompanyAddress.DataValueField = "CODE"; lstInsuranceCompanyAddress.DataBind(); } if (dspatientinfo.Tables[0].Rows[0]["SZ_INS_ADDRESS_ID"].ToString() != " " && dspatientinfo.Tables[0].Rows[0]["SZ_INS_ADDRESS_ID"].ToString() != "" && dspatientinfo.Tables[0].Rows[0]["SZ_INSURANCE_ID"].ToString() != " " && dspatientinfo.Tables[0].Rows[0]["SZ_INSURANCE_ID"].ToString() != "") { try { lstInsuranceCompanyAddress.SelectedValue = dspatientinfo.Tables[0].Rows[0]["SZ_INS_ADDRESS_ID"].ToString(); txtInsuranceAddress.Text = dspatientinfo.Tables[0].Rows[0]["SZ_INSURANCE_ADDRESS"].ToString(); txtInsuranceCity.Text = dspatientinfo.Tables[0].Rows[0]["SZ_INSURANCE_CITY"].ToString(); txtInsuranceState.Text = dspatientinfo.Tables[0].Rows[0]["SZ_INSURANCE_STATE"].ToString(); txtInsuranceZip.Text = dspatientinfo.Tables[0].Rows[0]["SZ_INSURANCE_ZIP"].ToString(); txtInsFax.Text = dspatientinfo.Tables[0].Rows[0]["sz_fax_number"].ToString(); txtInsPhone.Text = dspatientinfo.Tables[0].Rows[0]["SZ_INSURANCE_PHONE"].ToString(); txtInsContactPerson.Text = dspatientinfo.Tables[0].Rows[0]["sz_contact_person"].ToString(); } catch { } } if (dspatientinfo.Tables[0].Rows[0]["SZ_CLAIM_NUMBER"].ToString() != " " && dspatientinfo.Tables[0].Rows[0]["SZ_CLAIM_NUMBER"].ToString() != "") { txtClaimNumber.Text = dspatientinfo.Tables[0].Rows[0]["SZ_CLAIM_NUMBER"].ToString(); if (txtClaimNumber.Text.Equals("NA")) { txtClaimNumber.Text = ""; } } if (dspatientinfo.Tables[0].Rows[0]["SZ_POLICY_NUMBER"].ToString() != " " && dspatientinfo.Tables[0].Rows[0]["SZ_POLICY_NUMBER"].ToString() != "") { txtPolicyNumber.Text = dspatientinfo.Tables[0].Rows[0]["SZ_POLICY_NUMBER"].ToString(); if (txtPolicyNumber.Text.Equals("NA")) { txtPolicyNumber.Text = ""; } } if (dspatientinfo.Tables[0].Rows[0]["DT_ACCIDENT_DATE"].ToString() != "01/01/1900") { txtATAccidentDate.Text = dspatientinfo.Tables[0].Rows[0]["DT_ACCIDENT_DATE"].ToString(); } else { txtATAccidentDate.Text = ""; } txtATPlateNumber.Text = dspatientinfo.Tables[0].Rows[0]["SZ_PLATE_NO"].ToString(); txtATAddress.Text = dspatientinfo.Tables[0].Rows[0]["SZ_ACCIDENT_ADDRESS"].ToString(); txtATCity.Text = dspatientinfo.Tables[0].Rows[0]["SZ_ACCIDENT_CITY"].ToString(); txtATReportNumber.Text = dspatientinfo.Tables[0].Rows[0]["SZ_REPORT_NO"].ToString(); txtATAdditionalPatients.Text = dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_FROM_CAR"].ToString(); extddlATAccidentState.Text = dspatientinfo.Tables[0].Rows[0]["SZ_ACCIDENT_STATE_ID"].ToString(); txtATHospitalName.Text = dspatientinfo.Tables[0].Rows[0]["SZ_HOSPITAL_NAME"].ToString(); txtATHospitalAddress.Text = dspatientinfo.Tables[0].Rows[0]["SZ_HOSPITAL_ADDRESS"].ToString(); txtATDescribeInjury.Text = dspatientinfo.Tables[0].Rows[0]["SZ_DESCRIBE_INJURY"].ToString(); txtATAdmissionDate.Text = dspatientinfo.Tables[0].Rows[0]["DT_ADMISSION_DATE"].ToString(); if (dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_TYPE"].ToString() != " ") { string sz_patienttype = dspatientinfo.Tables[0].Rows[0]["SZ_PATIENT_TYPE"].ToString(); foreach (ListItem li in rdolstPatientType.Items) { if (li.Value.ToString() == sz_patienttype) { li.Selected = true; break; } } } txtEmployerName.Text = dspatientinfo.Tables[0].Rows[0]["SZ_EMPLOYER_NAME"].ToString(); txtEmployerPhone.Text = dspatientinfo.Tables[0].Rows[0]["SZ_EMPLOYER_PHONE"].ToString(); txtEmployerAddress.Text = dspatientinfo.Tables[0].Rows[0]["SZ_EMPLOYER_ADDRESS"].ToString(); txtEmployerCity.Text = dspatientinfo.Tables[0].Rows[0]["SZ_EMPLOYER_CITY"].ToString(); extddlEmployerState.Text = dspatientinfo.Tables[0].Rows[0]["SZ_EMPLOYER_STATE_ID"].ToString(); txtEmployerZip.Text = dspatientinfo.Tables[0].Rows[0]["SZ_EMPLOYER_ZIP"].ToString(); if (dspatientinfo.Tables[0].Rows[0]["DT_FIRST_TREATMENT"].ToString() != "01/01/1900" && dspatientinfo.Tables[0].Rows[0]["DT_FIRST_TREATMENT"].ToString() != " ") { txtDateofFirstTreatment.Text = dspatientinfo.Tables[0].Rows[0]["DT_FIRST_TREATMENT"].ToString(); } else { txtDateofFirstTreatment.Text = ""; } txtChartNo.Text = dspatientinfo.Tables[0].Rows[0]["SZ_CHART_NO"].ToString(); if (dspatientinfo.Tables[0].Rows[0]["SZ_ADJUSTER_ID"].ToString() != " " && dspatientinfo.Tables[0].Rows[0]["SZ_ADJUSTER_ID"].ToString() != "") { extddlAdjuster.Text = dspatientinfo.Tables[0].Rows[0]["SZ_ADJUSTER_ID"].ToString(); } txtAdjusterPhone.Text = dspatientinfo.Tables[0].Rows[0]["SZ_PHONE"].ToString(); txtAdjusterExtension.Text = dspatientinfo.Tables[0].Rows[0]["SZ_EXTENSION"].ToString(); txtfax.Text = dspatientinfo.Tables[0].Rows[0]["SZ_FAX"].ToString(); txtEmail.Text = dspatientinfo.Tables[0].Rows[0]["SZ_EMAIL"].ToString(); } } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request ID=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
private void GetPatientDetails() { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { SqlCommand command; SqlDataReader reader; this._bill_Sys_PatientBO = new Bill_Sys_PatientBO(); DataSet patientInfo = this._bill_Sys_PatientBO.GetPatientInfo(this.txtPatientID.Text, ((Bill_Sys_BillingCompanyObject)this.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID); if (patientInfo.Tables[0].Rows.Count > 0) { this.DtlView.DataSource = patientInfo; this.DtlView.DataBind(); if (patientInfo.Tables[0].Rows[0].ItemArray.GetValue(1).ToString() != " ") { //this.txtPatientFName.Text = patientInfo.Tables[0].Rows[0]["SZ_PATIENT_FIRST_NAME"].ToString(); } if (patientInfo.Tables[0].Rows[0]["sz_source_company_name"].ToString() != "") { } if ((patientInfo.Tables[0].Rows[0]["BT_WRONG_PHONE"].ToString() == "True") && (patientInfo.Tables[0].Rows[0]["BT_WRONG_PHONE"].ToString() != "")) { System.Web.UI.WebControls.CheckBox chk = (System.Web.UI.WebControls.CheckBox) this.DtlView.FindControl("chkViewWrongPhone"); // this.chkWrongPhone.Checked = true; chk.Checked = true; } else { //this.chkWrongPhone.Checked = false; } Label label = (Label)this.DtlView.Items[0].FindControl("lblViewMiddleName"); label.Text = patientInfo.Tables[0].Rows[0]["MI"].ToString(); //lblViewMiddleName.Text = patientInfo.Tables[0].Rows[0]["MI"].ToString(); if ((patientInfo.Tables[0].Rows[0]["DT_DOB"].ToString() != "01/01/1900") && (patientInfo.Tables[0].Rows[0]["DT_DOB"].ToString() != " ")) { } else { } Label label2 = (Label)this.DtlView.Items[0].FindControl("lblViewGender"); label2.Text = patientInfo.Tables[0].Rows[0]["SZ_GENDER"].ToString(); if ((patientInfo.Tables[0].Rows[0]["DT_INJURY"].ToString() != "01/01/1900") && (patientInfo.Tables[0].Rows[0]["DT_INJURY"].ToString() != " ")) { // this.txtDateOfInjury.Text = patientInfo.Tables[0].Rows[0]["DT_INJURY"].ToString(); } else { // this.txtDateOfInjury.Text = ""; } // this.txtJobTitle.Text = patientInfo.Tables[0].Rows[0]["SZ_JOB_TITLE"].ToString(); // this.txtWorkActivites.Text = patientInfo.Tables[0].Rows[0]["SZ_WORK_ACTIVITIES"].ToString(); if ((patientInfo.Tables[0].Rows[0]["BT_TRANSPORTATION"] == "True") && (patientInfo.Tables[0].Rows[0]["SZ_PATIENT_LAST_NAME"] != "")) { System.Web.UI.WebControls.CheckBox chk = (System.Web.UI.WebControls.CheckBox) this.DtlView.Items[0].FindControl("chkTransportation"); chk.Checked = true; chk.Checked = true; } else { } if (patientInfo.Tables[0].Rows[0]["SZ_PATIENT_TYPE"].ToString() != " ") { string str = patientInfo.Tables[0].Rows[0]["SZ_PATIENT_TYPE"].ToString(); } //Label label7 = (Label)this.DtlView.Items[0].FindControl("lblVLocation1"); //label7.Text = patientInfo.Tables[0].Rows[0]["sz_location_Name"].ToString(); if ((patientInfo.Tables[0].Rows[0]["SZ_CASE_ID"].ToString() != " ") && (patientInfo.Tables[0].Rows[0]["SZ_CASE_ID"].ToString() != "")) { this.txtCaseID.Text = patientInfo.Tables[0].Rows[0]["SZ_CASE_ID"].ToString(); } if ((patientInfo.Tables[0].Rows[0]["SZ_CASE_TYPE_ID"].ToString() != " ") && (patientInfo.Tables[0].Rows[0]["SZ_CASE_TYPE_ID"].ToString() != "")) { this.extddlCaseType.Text = patientInfo.Tables[0].Rows[0]["SZ_CASE_TYPE_ID"].ToString(); this.txtCaseTypeID.Text = patientInfo.Tables[0].Rows[0]["SZ_CASE_TYPE_ID"].ToString(); Label label8 = (Label)this.DtlView.Items[0].FindControl("lblViewCasetype"); if ((this.extddlCaseType.Text != "NA") && (this.extddlCaseType.Text != "")) { label8.Text = this.extddlCaseType.Selected_Text; } } if ((patientInfo.Tables[0].Rows[0]["SZ_PROVIDER_ID"].ToString() != " ") && (patientInfo.Tables[0].Rows[0]["SZ_PROVIDER_ID"].ToString() != "")) { //this.extddlProvider.Text = patientInfo.Tables[0].Rows[0]["SZ_PROVIDER_ID"].ToString(); } if ((patientInfo.Tables[0].Rows[0]["SZ_INSURANCE_ID"].ToString() != " ") && (patientInfo.Tables[0].Rows[0]["SZ_INSURANCE_ID"].ToString() != "")) { } if ((patientInfo.Tables[0].Rows[0]["SZ_CASE_STATUS_ID"].ToString() != " ") && (patientInfo.Tables[0].Rows[0]["SZ_CASE_STATUS_ID"].ToString() != "")) { this.extddlCaseStatus.Text = patientInfo.Tables[0].Rows[0]["SZ_CASE_STATUS_ID"].ToString(); Label label9 = (Label)this.DtlView.Items[0].FindControl("lblViewCaseStatus"); if ((this.extddlCaseStatus.Text != "NA") && (this.extddlCaseStatus.Text != "")) { label9.Text = this.extddlCaseStatus.Selected_Text; } } if ((patientInfo.Tables[0].Rows[0]["SZ_ATTORNEY_ID"].ToString() != " ") && (patientInfo.Tables[0].Rows[0]["SZ_ATTORNEY_ID"].ToString() != "")) { //this.extddlAttorney.Text = patientInfo.Tables[0].Rows[0]["SZ_ATTORNEY_ID"].ToString(); //this.hdnattorneycode.Value = this.extddlAttorney.Text; //Label label10 = (Label)this.DtlView.Items[0].FindControl("lblViewAttorney"); //if ((this.extddlAttorney.Text != "NA") && (this.extddlAttorney.Text != "")) //{ // label10.Text = this.extddlAttorney.Selected_Text; //} } if ((patientInfo.Tables[0].Rows[0]["SZ_POLICY_NUMBER"].ToString() != " ") && (patientInfo.Tables[0].Rows[0]["SZ_POLICY_NUMBER"].ToString() != "")) { //this.txtPolicyNumber.Text = patientInfo.Tables[0].Rows[0]["SZ_POLICY_NUMBER"].ToString(); //if (this.txtPolicyNumber.Text.Equals("NA")) //{ // this.txtPolicyNumber.Text = ""; //} } if ((patientInfo.Tables[0].Rows[0]["SZ_ADJUSTER_ID"].ToString() != " ") && (patientInfo.Tables[0].Rows[0]["SZ_ADJUSTER_ID"].ToString() != "")) { } if ((patientInfo.Tables[0].Rows[0]["SZ_POLICY_REPORT"].ToString() != " ") && (patientInfo.Tables[0].Rows[0]["SZ_POLICY_REPORT"].ToString() != "")) { //this.txtPolicyReport.Text = patientInfo.Tables[0].Rows[0]["SZ_POLICY_REPORT"].ToString(); } if ((patientInfo.Tables[0].Rows[0]["SZ_LOCATION_ID"].ToString() != " ") && (patientInfo.Tables[0].Rows[0]["SZ_LOCATION_ID"].ToString() != "")) { //this.extddlLocation.Text = patientInfo.Tables[0].Rows[0]["SZ_LOCATION_ID"].ToString(); //Label label12 = (Label)this.DtlView.Items[0].FindControl("lblVLocation1"); //if ((this.extddlLocation.Text != "NA") && (this.extddlLocation.Text != "")) //{ // label12.Text = this.extddlLocation.Selected_Text; //} } if (((patientInfo.Tables[0].Rows[0]["SZ_INS_ADDRESS_ID"].ToString() != " ") && (patientInfo.Tables[0].Rows[0]["SZ_INS_ADDRESS_ID"].ToString() != "")) && ((patientInfo.Tables[0].Rows[0]["SZ_INSURANCE_ID"].ToString() != " ") && (patientInfo.Tables[0].Rows[0]["SZ_INSURANCE_ID"].ToString() != ""))) { try { } catch { } } string connectionString = ConfigurationManager.AppSettings["Connection_String"].ToString(); this.sqlCon = new SqlConnection(connectionString); DataSet dataSet = new DataSet(); try { string str3 = "SELECT * FROM mst_case_type_wise_ui_access_control WHERE sz_case_type_id = '" + this.txtCaseTypeID.Text + "' and sz_company_id = '" + this.txtCompanyID.Text + "' and sz_page_name = 'Workarea' "; this.sqlCon.Open(); command = new SqlCommand(str3, this.sqlCon); new SqlDataAdapter(command).Fill(dataSet); } catch (Exception ex) { ex.Message.ToString(); } finally { if (this.sqlCon.State == ConnectionState.Open) { this.sqlCon.Close(); } } if (dataSet.Tables[0].Rows.Count > 0) { for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++) { string str4 = dataSet.Tables[0].Rows[i]["sz_control_name"].ToString(); string str5 = dataSet.Tables[0].Rows[i]["sz_control_type"].ToString(); if (dataSet.Tables[0].Rows[i]["sz_access_type"].ToString() == "hidden") { } } } string str7 = ""; string str8 = ""; string str9 = ""; string str10 = ""; string cmdText = "select SZ_INSURANCE_ID FROM MST_SEC_INSURANCE_DETAIL WHERE SZ_CASE_ID='" + this.txtCaseID.Text + "' AND SZ_COMPANY_ID='" + this.txtCompanyID.Text + "'"; command = new SqlCommand(cmdText, this.sqlCon); SqlDataAdapter adapter2 = new SqlDataAdapter(command); try { this.sqlCon.Open(); command = new SqlCommand(cmdText, this.sqlCon); reader = command.ExecuteReader(); while (reader.Read()) { if (reader["SZ_INSURANCE_ID"] != DBNull.Value) { str7 = reader["SZ_INSURANCE_ID"].ToString(); } } } catch (SqlException exception2) { exception2.Message.ToString(); } finally { if (this.sqlCon.State == ConnectionState.Open) { this.sqlCon.Close(); } } if (str7 != "") { string str11 = "select SZ_INSURANCE_NAME FROM MST_INSURANCE_COMPANY WHERE SZ_INSURANCE_ID='" + str7 + "'"; try { this.sqlCon.Open(); reader = new SqlCommand(str11, this.sqlCon).ExecuteReader(); while (reader.Read()) { if (reader["SZ_INSURANCE_NAME"] != DBNull.Value) { //this.txtSecInsName.Text = reader["SZ_INSURANCE_NAME"].ToString(); } } } catch (SqlException exception3) { exception3.Message.ToString(); } finally { if (this.sqlCon.State == ConnectionState.Open) { this.sqlCon.Close(); } } //added for ticket # FR-244 //if (str10 != "") //{ string str13 = "select SZ_POLICY_NUMBER,SZ_CLAIM_NUMBER FROM TXN_PRIVATE_INTAKE WHERE SZ_INSURANCE_ID='" + str7 + "'"; try { this.sqlCon.Open(); reader = new SqlCommand(str13, this.sqlCon).ExecuteReader(); while (reader.Read()) { if (reader["SZ_POLICY_NUMBER"] != DBNull.Value) { // this.txtPolicy.Text = reader["SZ_POLICY_NUMBER"].ToString(); } if (reader["SZ_CLAIM_NUMBER"] != DBNull.Value) { // this.txtClaim.Text = reader["SZ_CLAIM_NUMBER"].ToString(); } } } catch (SqlException exception3) { exception3.Message.ToString(); } finally { if (this.sqlCon.State == ConnectionState.Open) { this.sqlCon.Close(); } } //} //added for ticket # FR-244 } else { // this.txtSecInsName.Text = ""; } string str12 = "select SZ_ADDRESS_ID, SZ_INSURANCE_TYPE from MST_SEC_INSURANCE_DETAIL where SZ_CASE_ID='" + this.txtCaseID.Text + "' and SZ_COMPANY_ID='" + this.txtCompanyID.Text + "' and SZ_INSURANCE_ID='" + str7 + "'"; try { this.sqlCon.Open(); reader = new SqlCommand(str12, this.sqlCon).ExecuteReader(); while (reader.Read()) { if (reader["SZ_ADDRESS_ID"] != DBNull.Value) { str8 = reader["SZ_ADDRESS_ID"].ToString(); } if (reader["SZ_INSURANCE_TYPE"] != DBNull.Value) { str9 = reader["SZ_INSURANCE_TYPE"].ToString(); } } } catch (SqlException exception4) { exception4.Message.ToString(); } finally { if (this.sqlCon.State == ConnectionState.Open) { this.sqlCon.Close(); } } if (str9 != "") { } if (str8 != "") { DataSet set3 = null; try { SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["Connection_String"].ToString()); SqlCommand selectCommand = new SqlCommand("SP_MST_INSURANCE_ADDRESS", connection); selectCommand.CommandType = CommandType.StoredProcedure; selectCommand.Parameters.Add("@SZ_INS_ADDRESS_ID", str8); selectCommand.Parameters.Add("@FLAG", "LIST"); adapter2 = new SqlDataAdapter(selectCommand); set3 = new DataSet(); adapter2.Fill(set3); connection.Close(); if (set3.Tables[0].Rows.Count > 0) { } // goto Label_2983; } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } } if ((patientInfo.Tables[0].Rows[0]["sz_company_name"].ToString() != " ") && (patientInfo.Tables[0].Rows[0]["sz_company_name"].ToString() != "")) { Label label14 = (Label)this.DtlView.Items[0].FindControl("lblcopyfrom"); label14.Text = patientInfo.Tables[0].Rows[0]["sz_company_name"].ToString(); } if (patientInfo.Tables[0].Rows[0]["sz_reffering_office_id"].ToString() != "") { } if (patientInfo.Tables[0].Rows[0]["sz_reffering_doctor_id"].ToString() != "") { } this.lblMsg.Visible = false; } } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void btnUpdate_Click(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { btnremove.Enabled = true; Bill_Sys_PatientBO _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); if (ChkOC.Checked) { _bill_Sys_PatientBO.UpdateInsuranceInfoeventforOC(txtCompanyID.Text, txtInsuranceid.Text, txtInsuranceaddid.Text, txteventid.Text, txtCaseID.Text, txtclaimno.Text, txtpoliccyno.Text, extddlCaseType.Text, txtpolicyholder.Text, txtdateofaccident.Text, txtPatientPhoneNo.Text, "1", extddlLocation.Text); } else { _bill_Sys_PatientBO.UpdateInsuranceInfoevent(txtCompanyID.Text, txtInsuranceid.Text, txtInsuranceaddid.Text, txteventid.Text, txtCaseID.Text, txtclaimno.Text, txtpoliccyno.Text, extddlCaseType.Text, txtpolicyholder.Text, txtdateofaccident.Text, txtPatientPhoneNo.Text, extddlLocation.Text); } if (extddlCoSignedby.Text != "NA") { DataSet dsMandetoryInfo = new DataSet(); DataSet dsDoctorInfo = new DataSet(); Bill_Sys_BillTransaction_BO _Bill_Sys_BillTransaction_BO = new Bill_Sys_BillTransaction_BO(); dsMandetoryInfo = _Bill_Sys_BillTransaction_BO.GetReferringDoctorMandetoryInfo(txtCompanyID.Text, extddlCaseType.Text); dsDoctorInfo = _Bill_Sys_BillTransaction_BO.GetReadingDoctorInformation(txtCompanyID.Text, extddlCoSignedby.Text); if (dsDoctorInfo.Tables.Count > 0 && dsMandetoryInfo.Tables.Count > 0) { if (dsDoctorInfo.Tables[0].Rows.Count > 0 && dsMandetoryInfo.Tables[0].Rows.Count > 0) { if (dsDoctorInfo != null && dsMandetoryInfo != null) { string szNPI, szLicenceNo, szWCBAuth, szWCBRating = ""; bool flag = false; szNPI = dsMandetoryInfo.Tables[0].Rows[0][0].ToString(); szLicenceNo = dsMandetoryInfo.Tables[0].Rows[0][1].ToString(); szWCBAuth = dsMandetoryInfo.Tables[0].Rows[0][2].ToString(); szWCBRating = dsMandetoryInfo.Tables[0].Rows[0][3].ToString(); if (szNPI.ToLower() == "true") { if (dsDoctorInfo.Tables[0].Rows[0]["SZ_NPI"].ToString() == "" || dsDoctorInfo.Tables[0].Rows[0]["SZ_NPI"].ToString() == " " || dsDoctorInfo.Tables[0].Rows[0]["SZ_NPI"].ToString() == null) { flag = true; } } if (szLicenceNo.ToLower() == "true") { if (dsDoctorInfo.Tables[0].Rows[0]["SZ_DOCTOR_LICENSE_NUMBER"].ToString() == "" || dsDoctorInfo.Tables[0].Rows[0]["SZ_DOCTOR_LICENSE_NUMBER"].ToString() == " " || dsDoctorInfo.Tables[0].Rows[0]["SZ_DOCTOR_LICENSE_NUMBER"].ToString() == null) { flag = true; } } if (szWCBAuth.ToLower() == "true") { if (dsDoctorInfo.Tables[0].Rows[0]["SZ_WCB_AUTHORIZATION"].ToString() == "" || dsDoctorInfo.Tables[0].Rows[0]["SZ_WCB_AUTHORIZATION"].ToString() == " " || dsDoctorInfo.Tables[0].Rows[0]["SZ_WCB_AUTHORIZATION"].ToString() == null) { flag = true; } } if (szWCBRating.ToLower() == "true") { if (dsDoctorInfo.Tables[0].Rows[0]["SZ_WCB_RATING_CODE"].ToString() == "" || dsDoctorInfo.Tables[0].Rows[0]["SZ_WCB_RATING_CODE"].ToString() == " " || dsDoctorInfo.Tables[0].Rows[0]["SZ_WCB_RATING_CODE"].ToString() == null) { flag = true; } } if (flag == true) { ScriptManager.RegisterClientScriptBlock(this, GetType(), "Done", "alert('Co-Signed doctor does not have mandetory fields.');", true); } else { Bill_Sys_ProcedureCode_BO _bill_Sys_ProcedureCode_BO = new Bill_Sys_ProcedureCode_BO(); _bill_Sys_ProcedureCode_BO.UpdateCoSignedBy(Convert.ToInt32(txtEventPRocID.Text), extddlCoSignedby.Text, "UPDATE"); usrMessage1.PutMessage("Update Successfully"); usrMessage1.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage); usrMessage1.Show(); } } } }//table count } else { Bill_Sys_ProcedureCode_BO _bill_Sys_ProcedureCode_BO = new Bill_Sys_ProcedureCode_BO(); _bill_Sys_ProcedureCode_BO.UpdateCoSignedBy(Convert.ToInt32(txtEventPRocID.Text), "", "UPDATE"); usrMessage1.PutMessage("Update Successfully"); usrMessage1.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage); usrMessage1.Show(); } //grdAllReports.XGridBindSearch(); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
public void LoadDataOnPage() { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { Bill_Sys_CaseObject _bill_Sys_CaseObject = new Bill_Sys_CaseObject(); _bill_Sys_CaseObject.SZ_PATIENT_ID = ""; //TreeMenuControl1.ROLE_ID = ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ROLE; txtCompanyID.Text = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; extddlCaseType.Flag_ID = txtCompanyID.Text.ToString(); extddlCaseStatus.Flag_ID = txtCompanyID.Text.ToString(); if (Session["PassedCaseID"] != null) { txtPatientID.Text = ((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_PATIENT_ID; GetPatientDetails(); Session["Associate_Case_ID"] = Session["PassedCaseID"]; txtCaseID.Text = Session["PassedCaseID"].ToString(); EditOperation _editOperation = new EditOperation(); _editOperation.Xml_File = "CaseDetails.xml"; _editOperation.WebPage = this.Page; _editOperation.Primary_Value = Session["PassedCaseID"].ToString(); _editOperation.LoadData(); _editOperation = new EditOperation(); _editOperation.Xml_File = "CaseDetailsForLabel.xml"; _editOperation.WebPage = this.Page; _editOperation.Primary_Value = Session["PassedCaseID"].ToString(); _editOperation.LoadData(); Bill_Sys_PatientBO _Bill_Sys_PatientBO = new Bill_Sys_PatientBO(); string sz_CaseCarrier = _Bill_Sys_PatientBO.CheckCarriercode(txtCaseID.Text, txtCompanyID.Text); } else { Response.Redirect("Bill_Sys_SearchCase.aspx", false); } } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void txtInsuranceCompany_TextChanged(object sender, EventArgs args) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } string strInsuranceID = hdninsurancecode.Value; txtInsuranceid.Text = hdninsurancecode.Value; if (txtInsuranceCompany.Text != "") { if (strInsuranceID != "0") { try { ClearInsurancecontrol(); Bill_Sys_PatientBO _bill_Sys_PatientBO = new Bill_Sys_PatientBO(); lstInsuranceCompanyAddress.DataSource = _bill_Sys_PatientBO.GetInsuranceCompanyAddress(txtInsuranceid.Text); lstInsuranceCompanyAddress.DataTextField = "DESCRIPTION"; lstInsuranceCompanyAddress.DataValueField = "CODE"; lstInsuranceCompanyAddress.DataBind(); Page.MaintainScrollPositionOnPostBack = true; } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } } else { lstInsuranceCompanyAddress.Items.Clear(); hdninsurancecode.Value = ""; } } else { lstInsuranceCompanyAddress.Items.Clear(); txtInsuranceAddress.Text = ""; txtInsuranceAddress.Text = ""; txtInsCity.Text = ""; txtInsState.Text = ""; txtInsZip.Text = ""; txtInsPhone.Text = ""; txtInsFax.Text = ""; hdninsurancecode.Value = ""; txtInsuranceid.Text = ""; Page.MaintainScrollPositionOnPostBack = true; } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }