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