public void BindGrid()
{
DataSet dsPatient = new DataSet();
ReferanceProvider objDocBO = new ReferanceProvider();
RefferingProvioderPatientDAO objPatientDao = new RefferingProvioderPatientDAO();
objPatientDao.CaseNo = txtCaseNO.Text.ToString();
if (ddlcasetype.SelectedItem.Value.ToString() != "NA")
{
objPatientDao.CaseType = ddlcasetype.SelectedItem.Value.ToString();
}
else
{
objPatientDao.CaseType = "";
}
if (ddlcasestatus.SelectedItem.Value.ToString() != "NA")
{
objPatientDao.CaseStatus = ddlcasestatus.SelectedItem.Value.ToString();
}
else
{
objPatientDao.CaseStatus = "";
}
objPatientDao.PatientName = txtpatient.Text.ToString();
objPatientDao.Insurance = txtinsurance.Text.ToString();
objPatientDao.claimNumber = txtClaimnumber.Text.ToString();
objPatientDao.ssnNO = txtSSN.Text.ToString();
if (ddllocation.SelectedItem.Value.ToString() != "NA")
{
objPatientDao.location = ddllocation.SelectedItem.Value.ToString();
}
else
{
objPatientDao.location = "";
}
objPatientDao.companyID = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
objPatientDao.reffOfficeID = ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_REFF_PROVIDER_ID;
objPatientDao.userID = ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID;
dsPatient = objDocBO.getPatientList(objPatientDao);
grdVisits.DataSource = dsPatient;
grdVisits.DataBind();
}
public DataSet getPatientList(RefferingProvioderPatientDAO objPatientDao)
{
DataSet dsPatient = new DataSet();
conn = new SqlConnection(ConfigurationSettings.AppSettings["Connection_String"].ToString());
try
{
comm = new SqlCommand("SP_GET_PATIENT_FOR_REFERING_PROVIDER", conn);
comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString());
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.AddWithValue("@SZ_COMPANY_ID", objPatientDao.companyID);
comm.Parameters.AddWithValue("@SZ_REFFERING_OFFICE_ID", objPatientDao.reffOfficeID);
comm.Parameters.AddWithValue("@SZ_CASE_NO", objPatientDao.CaseNo);
comm.Parameters.AddWithValue("@SZ_CASE_TYPE", objPatientDao.CaseType);
comm.Parameters.AddWithValue("@SZ_PATIENT_NAME", objPatientDao.PatientName);
comm.Parameters.AddWithValue("@SZ_INSURANCE_ID", objPatientDao.Insurance);
comm.Parameters.AddWithValue("@SZ_SSNO", objPatientDao.ssnNO);
comm.Parameters.AddWithValue("@SZ_LOCATION_ID", objPatientDao.location);
comm.Parameters.AddWithValue("@DT_ACCIDENT_DATE", objPatientDao.accidentDate);
comm.Parameters.AddWithValue("@DT_OF_BIRTH", objPatientDao.birthDate);
comm.Parameters.AddWithValue("@SZ_CLAIM_NUMBER", objPatientDao.claimNumber);
comm.Parameters.AddWithValue("@SZ_CASE_STATUS", objPatientDao.CaseStatus);
SqlDataAdapter objDAdap = new SqlDataAdapter(comm);
objDAdap.Fill(dsPatient);
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
conn.Close();
}
return(dsPatient);
}
