private void LoadData()
{
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 ds_patient_info = new DataSet();
DataSet ds_get_patient_info = new DataSet();
_objOTPT = new OTPT();
_editOperation = new EditOperation();
try
{
string sz_Bill_No = txtBillNumber.Text;
string sz_Case_Id = txtCaseID.Text;
ds_patient_info = _objOTPT.GET_Patient_Info_OTPT(sz_Case_Id);
ds_get_patient_info = _objOTPT.GET_Patient_Information_OTPT(sz_Case_Id, txtCompanyID.Text);
if (ds_patient_info.Tables.Count > 0)
{
if (ds_patient_info.Tables[0].Rows.Count > 0)
{
if (ds_patient_info.Tables[0].Rows[0].ToString() != "" && ds_patient_info.Tables[0].Rows[0].ToString() != null)
{
txtPatientFirstName.Text = ds_patient_info.Tables[0].Rows[0]["SZ_PATIENT_FIRST_NAME"].ToString();
txtPatientMiddleName.Text = ds_patient_info.Tables[0].Rows[0]["MI"].ToString();
txtPatientLastName.Text = ds_patient_info.Tables[0].Rows[0]["SZ_PATIENT_LAST_NAME"].ToString();
txtPatientStreet.Text = ds_patient_info.Tables[0].Rows[0]["SZ_PATIENT_STREET"].ToString();
txtPatientCity.Text = ds_patient_info.Tables[0].Rows[0]["SZ_PATIENT_CITY"].ToString();
extddlPatientState.Text = ds_patient_info.Tables[0].Rows[0]["SZ_PATIENT_STATE"].ToString();
txtPatientZip.Text = ds_patient_info.Tables[0].Rows[0]["SZ_PATIENT_ZIP"].ToString();
txtPatientPhone.Text = ds_patient_info.Tables[0].Rows[0]["SZ_PATIENT_PHONE"].ToString();
txtDateOfInjury.Text = ds_patient_info.Tables[0].Rows[0]["DT_INJURY"].ToString();
txtPatientDOB.Text = ds_patient_info.Tables[0].Rows[0]["DT_DOB"].ToString();
txtSSN.Text = ds_patient_info.Tables[0].Rows[0]["SZ_SOCIAL_SECURITY_NO"].ToString();
txtEmployer.Text = ds_patient_info.Tables[0].Rows[0]["SZ_EMPLOYER_NAME"].ToString();
txtWCBCaseNumber.Text = ds_patient_info.Tables[0].Rows[0]["SZ_WCB_NO"].ToString();
txtCaseCarrierNo.Text = ds_patient_info.Tables[0].Rows[0]["SZ_CLAIM_NUMBER"].ToString();
txtInsuranceCarr.Text = ds_patient_info.Tables[0].Rows[0]["SZ_INSURANCE_NAME"].ToString();
if (txtDateOfInjury.Text.Trim() != "")
{
DateTime dt = new DateTime();
dt = Convert.ToDateTime(txtDateOfInjury.Text);
txtDateOfInjury.Text = dt.ToString("MM/dd/yyyy");
}
if (txtPatientDOB.Text != "")
{
DateTime dt = new DateTime();
dt = Convert.ToDateTime(txtPatientDOB.Text);
txtPatientDOB.Text = dt.ToString("MM/dd/yyyy");
}
}
}
}
if (ds_get_patient_info.Tables.Count > 0)
{
if (ds_get_patient_info.Tables[0].Rows.Count > 0)
{
if (ds_get_patient_info.Tables[0].Rows[0].ToString() != "" && ds_get_patient_info.Tables[0].Rows[0].ToString() != null)
{
txtaddcitytown.Text = ds_get_patient_info.Tables[0].Rows[0]["SZ_PATIENT_INJURY_PLACE"].ToString();
if (ds_get_patient_info.Tables[0].Rows[0]["SZ_TREATEMNET_UNDER"].ToString().Trim() == "0")
{
rdlstTaxType.SelectedIndex = 0;
}
else if (ds_get_patient_info.Tables[0].Rows[0]["SZ_TREATEMNET_UNDER"].ToString().Trim() == "1")
{
rdlstTaxType.SelectedIndex = 1;
}
else if (ds_get_patient_info.Tables[0].Rows[0]["SZ_TREATEMNET_UNDER"].ToString().Trim() == "2")
{
rdlstTaxType.SelectedIndex = 2;
}
string sztimeinjury = ds_get_patient_info.Tables[0].Rows[0]["SZ_TIME_OF_INJURY"].ToString();
//string sztreatmentunder = ds_get_patient_info.Tables[0].Rows[0]["SZ_TREATEMNET_UNDER"].ToString();
//if (sztreatmentunder == "0")
//{
// rdlstTaxType.SelectedIndex = 0;
//}
//else if (sztreatmentunder == "1")
//{
// rdlstTaxType.SelectedIndex = 1;
//}
txtHistoryInjuryDate.Text = ds_get_patient_info.Tables[0].Rows[0]["DT_DATE_OF_PRV_HISTROY"].ToString();
string ddltime = ds_get_patient_info.Tables[0].Rows[0]["SZ_TIME_TYPE"].ToString();
string strtimehr = sztimeinjury.Substring(0, 2);
string strtimemin = sztimeinjury.Substring(3, 2);
if (ddltime.Trim() == "AM")
{
ddlTime.SelectedIndex = 0;
}
else if (ddltime.Trim() == "PM")
{
ddlTime.SelectedIndex = 1;
}
int iHH = Convert.ToInt32(strtimehr.Trim());
ddlHours.SelectedIndex = iHH;
int iMM = Convert.ToInt32(strtimemin.Trim());
ddlMinutes.SelectedIndex = iMM;
txtReffering.Text = ds_get_patient_info.Tables[0].Rows[0]["SZ_REFFERING_PHYSICIAN"].ToString();
txtrefferingaddress.Text = ds_get_patient_info.Tables[0].Rows[0]["SZ_REFFERING_PHYSICIAN_ADDRESS"].ToString();
txtrefferingtelno.Text = ds_get_patient_info.Tables[0].Rows[0]["SZ_REFFERING_TELEPHONE_NO"].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 + ".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());
}
}