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