public DataSet GetEncIntakeResponseAllDS(BaseMaster BaseMstr,
string strEncounterID)
{
//status info
long lStatusCode = -1;
string strStatusComment = "";
//create a new parameter list with standard params from basemstr
CDataParameterList plist = new CDataParameterList(BaseMstr);
plist.AddInputParameter("pi_vEncounterID", strEncounterID);
CDataSet cds = new CDataSet();
DataSet ds = cds.GetOracleDataSet(BaseMstr.DBConn,
"PCK_ENCOUNTER_INTAKE.GetEncIntakeResponseAllRS",
plist,
out lStatusCode,
out strStatusComment);
//set the base master status code and status for display
BaseMstr.StatusCode = lStatusCode;
BaseMstr.StatusComment = strStatusComment;
if (lStatusCode == 0)
{
return(ds);
}
else
{
return(null);
}
}
// Get Menu Items (other than root level)
protected DataSet GetMenuItemsDS()
{
//status info
long lStatusCode = 0;
string strStatusComment = "";
//create a new parameter list with standard params from basemstr
CDataParameterList pList = new CDataParameterList(m_BaseMstr);
CDataSet cds = new CDataSet();
DataSet ds = cds.GetOracleDataSet(m_BaseMstr.DBConn,
"PCK_APP_MENU.GetMenuItemsRS",
pList,
out lStatusCode,
out strStatusComment);
//set the base master status code and status for display
m_BaseMstr.StatusCode = lStatusCode;
m_BaseMstr.StatusComment = strStatusComment;
if (lStatusCode == 0)
{
return(ds);
}
else
{
return(null);
}
}
/// <summary>
/// get a dataset of all specialties, used for patient lookups etc...
/// </summary>
/// <param name="ds"></param>
/// <returns></returns>
public CStatus GetClinicDS(out DataSet ds)
{
//initialize parameters
ds = null;
CStatus status = new CStatus();
//transfer from MDWS if needed
if (MDWSTransfer)
{
long lCount = 0;
CMDWSOps ops = new CMDWSOps(this);
status = ops.GetMDWSClinics(out lCount);
if (!status.Status)
{
return(status);
}
}
//load the paramaters list
CParameterList pList = new CParameterList(base.SessionID,
base.ClientIP,
base.UserID);
//get the dataset
CDataSet cds = new CDataSet();
status = cds.GetOracleDataSet(base.DBConn,
"PCK_CLINIC.GetClinicRS",
pList,
out ds);
return(status);
}
/// <summary>
/// method
/// retrieves a single service from the database
/// </summary>
/// <param name="lServiceID"></param>
/// <param name="di"></param>
/// <returns></returns>
public CStatus GetServiceDI(long lServiceID, out CServiceDataItem di)
{
//initialize parameters
di = null;
//create a status object and check for valid dbconnection
CStatus status = DBConnValid();
if (!status.Status)
{
return(status);
}
//load the paramaters list
CParameterList pList = new CParameterList(SessionID, ClientIP, UserID);
pList.AddInputParameter("pi_nServiceID", lServiceID);
//get the dataset
CDataSet cds = new CDataSet();
DataSet ds = null;
status = cds.GetOracleDataSet(DBConn,
"PCK_VARIABLE.GetServiceDI",
pList,
out ds);
if (!status.Status)
{
return(status);
}
di = new CServiceDataItem(ds);
return(status);
}
private DataSet GetQuestionnaireListRS()
{
//status info
long lStatusCode = -1;
string strStatusComment = "";
//create a new parameter list with standard params from basemstr
CDataParameterList plist = new CDataParameterList(m_BaseMstr);
//add params for the DB stored procedure call
//use helper to get a dataset from the sp call
CDataSet cds = new CDataSet();
DataSet ds = cds.GetOracleDataSet(m_BaseMstr.DBConn,
"PCK_CPAP_RESULTS.GetQuestionnaireListRS",
plist,
out lStatusCode,
out strStatusComment);
//set the base master status code and status for display
m_BaseMstr.StatusCode = lStatusCode;
m_BaseMstr.StatusComment = strStatusComment;
if (lStatusCode == 0)
{
return(ds);
}
else
{
return(null);
}
}
/// <summary>
/// returns a dataset of patient item components
/// filtered by patient checklist id (PAT_CL_ID)
public CStatus GetPatItemsByPatCLIDDS(long lPatCLID, out DataSet ds)
{
//initialize parameters
ds = null;
//create a status object and check for valid dbconnection
CStatus status = DBConnValid();
if (!status.Status)
{
return(status);
}
//load the paramaters list
CParameterList pList = new CParameterList(SessionID, ClientIP, UserID);
pList.AddInputParameter("pi_nPatCLID", lPatCLID);
//get the dataset
CDataSet cds = new CDataSet();
return(cds.GetOracleDataSet(
base.DBConn,
"PCK_PATIENT.GetPatItemsByPatCLIDRS",
pList,
out ds));
}
/// <summary>
/// get a list of patient checklist that are out of date
/// </summary>
/// <param name="strPatientID"></param>
/// <param name="ds"></param>
/// <returns></returns>
public CStatus GetOutOfDatePatCLDS(string strPatientID,
long lChecklistID,
out DataSet ds)
{
//initialize parameters
ds = null;
//create a status object and check for valid dbconnection
CStatus status = DBConnValid();
if (!status.Status)
{
return(status);
}
//load the paramaters list
CParameterList pList = new CParameterList(SessionID,
ClientIP,
UserID);
pList.AddInputParameter("pi_vPatientID", strPatientID);
pList.AddInputParameter("pi_nChecklistID", lChecklistID);
CDataSet cds = new CDataSet();
return(cds.GetOracleDataSet(DBConn,
"PCK_PAT_CHECKLIST.GetOutOfDatePatCLRS",
pList,
out ds));
}
//get a dataset of States
public DataSet GetProviderDS(BaseMaster BaseMstr,
string strDIMSID)
{
//status info
long lStatusCode = -1;
string strStatusComment = "";
//create a new parameter list with standard params from basemstr
CDataParameterList plist = new CDataParameterList(BaseMstr);
//add params for the DB stored procedure call
plist.AddInputParameter("pi_vDIMSID", strDIMSID);
//get and return a dataset
CDataSet cds = new CDataSet();
DataSet ds = cds.GetOracleDataSet(BaseMstr.DBConn,
"PCK_PROVIDER.GetProviderRS",
plist,
out lStatusCode,
out strStatusComment);
//set the base master status code and status for display
BaseMstr.StatusCode = lStatusCode;
BaseMstr.StatusComment = strStatusComment;
if (lStatusCode == 0)
{
return(ds);
}
return(null);
}
//get a dataset of system settings
public DataSet GetSystemSettingsDS(BaseMaster BaseMstr)
{
//status info
long lStatusCode = -1;
string strStatusComment = "";
//create a new parameter list with standard params from basemstr
CDataParameterList plist = new CDataParameterList(BaseMstr);
//add params for the DB stored procedure call
//plist.AddInputParameter("", BaseMstr.SelectedPatientID
//
CDataSet cds = new CDataSet();
DataSet ds = cds.GetOracleDataSet(BaseMstr.DBConn,
"PCK_SYSTEM_SETTINGS.GetSystemSettingsRS",
plist,
out lStatusCode,
out strStatusComment);
//set the base master status code and status for display
BaseMstr.StatusCode = lStatusCode;
BaseMstr.StatusComment = strStatusComment;
if (lStatusCode == 0)
{
return(ds);
}
else
{
return(null);
}
}
/// <summary>
/// Used to get a dataset holding 1 item group by id
/// </summary>
/// <param name="lCheckListID"></param>
/// <param name="cli"></param>
/// <returns></returns>
public CStatus GetCheckListDI(long lCheckListID, out CChecklistDataItem cli)
{
//initialize parameters
cli = null;
//create a status object and check for valid dbconnection
CStatus status = DBConnValid();
if (!status.Status)
{
return(status);
}
//load the paramaters list
CParameterList pList = new CParameterList(SessionID,
ClientIP,
UserID);
pList.AddInputParameter("pi_nCheckListID", lCheckListID);
//get the dataset
DataSet ds = null;
CDataSet cds = new CDataSet();
status = cds.GetOracleDataSet(DBConn,
"PCK_CHECKLIST.GetCheckListRS",
pList,
out ds);
if (status.Status)
{
cli = new CChecklistDataItem(ds);
}
return(status);
}
/// <summary>
/// Used to get a dataset of checklists matching search criteria
/// </summary>
/// <param name="strChecklistName"></param>
/// <param name="lServiceID"></param>
/// <param name="bActiveChecklistsOnly"></param>
/// <param name="ds"></param>
/// <returns></returns>
public CStatus GetCheckListSearchDS(string strChecklistName,
long lServiceID,
bool bActiveChecklistsOnly,
out DataSet ds)
{
//initialize parameters
ds = null;
//create a status object and check for valid dbconnection
CStatus status = DBConnValid();
if (!status.Status)
{
return(status);
}
//load the paramaters list
CParameterList pList = new CParameterList(SessionID, ClientIP, UserID);
pList.AddInputParameter("pi_vChecklistName", strChecklistName);
pList.AddInputParameter("pi_nServiceID", lServiceID);
pList.AddInputParameter("pi_nActiveChecklistsOnly", (bActiveChecklistsOnly) ? 1 : 0);
//get the dataset
CDataSet cds = new CDataSet();
return(cds.GetOracleDataSet(DBConn,
"PCK_CHECKLIST.GetChecklistSearchRS",
pList,
out ds));
}
/// <summary>
/// Used to get a dataset of item components that pertain
/// to an item
/// </summary>
/// <param name="lItemID"></param>
/// <param name="ds"></param>
/// <param name="lStatusCode"></param>
/// <param name="strStatus"></param>
/// <returns></returns>
public CStatus GetItemComponentDS(
long lItemID,
k_ACTIVE_ID lActiveFilter,
out DataSet ds)
{
//initialize parameters
ds = null;
//create a status object and check for valid dbconnection
CStatus status = DBConnValid();
if (!status.Status)
{
return(status);
}
//load the paramaters list
CParameterList pList = new CParameterList(SessionID, ClientIP, UserID);
// procedure specific parameters
pList.AddInputParameter("pi_nItemID", lItemID);
pList.AddInputParameter("pi_nActiveFilter", (long)lActiveFilter);
//get the dataset
CDataSet cds = new CDataSet();
return(cds.GetOracleDataSet(
DBConn,
"PCK_ITEM_COMPONENT.GetItemComponentRS",
pList,
out ds));
}
/// <summary>
/// US:1883 get the patients most recent collection item
/// </summary>
/// <param name="lCollectionItemID"></param>
/// <param name="strPatientID"></param>
/// <param name="ds"></param>
/// <returns></returns>
public CStatus GetItemColMostRecentPatICDS(long lCollectionItemID, string strPatientID, out DataSet ds)
{
//initialize parameters
ds = null;
//create a status object and check for valid dbconnection
CStatus status = DBConnValid();
if (!status.Status)
{
return(status);
}
//load the paramaters list
CParameterList pList = new CParameterList(SessionID, ClientIP, UserID);
pList.AddInputParameter("pi_nCollectionItemID", lCollectionItemID);
pList.AddInputParameter("pi_vPatientID", strPatientID);
//get the dataset
CDataSet cds = new CDataSet();
status = cds.GetOracleDataSet(
DBConn,
"PCK_ITEM_COLLECTION.GetItemColPatICRS",
pList,
out ds);
if (!status.Status)
{
return(status);
}
return(new CStatus());
}
//get a dataset of Intake Modules List
protected DataSet GetModulesListDS(BaseMaster BaseMstr)
{
//status info
long lStatusCode = 0;
string strStatusComment = "";
//create a new parameter list with standard params from basemstr
CDataParameterList plist = new CDataParameterList(BaseMstr);
CDataSet cds = new CDataSet();
DataSet ds = cds.GetOracleDataSet(BaseMstr.DBConn,
"PCK_INTAKE.GetModulesListRS",
plist,
out lStatusCode,
out strStatusComment);
//set the base master status code and status for display
BaseMstr.StatusCode = lStatusCode;
BaseMstr.StatusComment = strStatusComment;
if (lStatusCode == 0)
{
return(ds);
}
else
{
return(null);
}
}
public DataSet GetPatEthRaceSourceDS(
BaseMaster BaseMstr,
string strPatientID)
{
//status info
long lStatusCode = -1;
string strStatusComment = string.Empty;
//create a new parameter list with standard params from basemstr
CDataParameterList plist = new CDataParameterList(BaseMstr);
//add params for the DB stored procedure call
plist.AddInputParameter("pi_vPatientID", strPatientID);
CDataSet cds = new CDataSet();
DataSet ds = cds.GetOracleDataSet(
BaseMstr.DBConn,
"PCK_PAT_ETHNICITY_RACE.GetPatEthRaceSourceRS",
plist,
out lStatusCode,
out strStatusComment);
//set the base master status code and status for display
BaseMstr.StatusCode = lStatusCode;
BaseMstr.StatusComment = strStatusComment;
if (lStatusCode == 0)
{
return(ds);
}
else
{
return(null);
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public DataSet GetReportDS()
{
//status info
long lStatusCode = -1;
string strStatusComment = "";
//create a new parameter list with standard params from basemstr
CDataParameterList plist = new CDataParameterList(m_BaseMstr);
CDataSet cds = new CDataSet();
DataSet ds = cds.GetOracleDataSet(m_BaseMstr.DBConn,
"PCK_REVAMP_REPORT.GetReportRS",
plist,
out lStatusCode,
out strStatusComment);
//set the base master status code and status for display
m_BaseMstr.StatusCode = lStatusCode;
m_BaseMstr.StatusComment = strStatusComment;
if (lStatusCode == 0)
{
return(ds);
}
else
{
return(null);
}
}
/// <summary>
/// Used to get a dataset of decision state definitions
/// </summary>
/// <param name="ds"></param>
/// <param name="lStatusCode"></param>
/// <param name="strStatus"></param>
/// <returns></returns>
public CStatus GetDSDefinitionDS(out DataSet ds)
{
//initialize parameters
ds = null;
//create a status object and check for valid dbconnection
CStatus status = new CStatus();
status = DBConnValid();
if (!status.Status)
{
return(status);
}
//load the paramaters list
CParameterList pList = new CParameterList(SessionID,
ClientIP,
UserID);
//get the dataset
CDataSet cds = new CDataSet();
return(cds.GetOracleDataSet(DBConn,
"PCK_STAT.GetDSDefinitionRS",
pList,
out ds));
}
public DataSet GetAllPatientEventsDS()
{
//status info
long lStatusCode = -1;
string strStatusComment = "";
//create a new parameter list with standard params from basemstr
CDataParameterList plist = new CDataParameterList(m_BaseMstr);
//use helper to get a dataset from the sp call
CDataSet cds = new CDataSet();
DataSet ds = cds.GetOracleDataSet(m_BaseMstr.DBConn,
"PCK_PATIENT_EVENTS.GetAllPatientEventsRS",
plist,
out lStatusCode,
out strStatusComment);
//set the base master status code and status for display
m_BaseMstr.StatusCode = lStatusCode;
m_BaseMstr.StatusComment = strStatusComment;
if (lStatusCode == 0)
{
return(ds);
}
else
{
return(null);
}
}
//get a dataset of Genders
public DataSet GetGenderDS(BaseMaster BaseMstr)
{
//status info
long lStatusCode = -1;
string strStatusComment = "";
//create a new parameter list with standard params from basemstr
CDataParameterList plist = new CDataParameterList(BaseMstr);
//get and return a dataset
CDataSet cds = new CDataSet();
DataSet ds = cds.GetOracleDataSet(BaseMstr.DBConn,
"PCK_DEMOGRAPHICS.GetGenderRS",
plist,
out lStatusCode,
out strStatusComment);
//set the base master status code and status for display
BaseMstr.StatusCode = lStatusCode;
BaseMstr.StatusComment = strStatusComment;
if (lStatusCode == 0)
{
return(ds);
}
else
{
return(null);
}
}
/// <summary>
/// get a site dataset by egion
/// </summary>
/// <param name="ds"></param>
/// <returns></returns>
public CStatus GetSiteDS(long lRegionID,
out DataSet ds)
{
//initialize parameters
ds = null;
CStatus status = new CStatus();
//transfer from MDWS if needed
// if (MDWSTransfer)
// {
// CMDWSOps ops = new CMDWSOps(this);
// status = ops.GetMDWSSites();
// if (!status.Status)
// {
// return status;
// }
// }
//load the paramaters list
CParameterList pList = new CParameterList(base.SessionID,
base.ClientIP,
base.UserID);
pList.AddInputParameter("pi_nRegionID", lRegionID);
//get the dataset
CDataSet cds = new CDataSet();
status = cds.GetOracleDataSet(base.DBConn,
"PCK_SITE.GetSiteRS",
pList,
out ds);
return(status);
}
/// <summary>
/// method
/// US:877
/// get patient checklist by CLID
/// </summary>
/// <param name="lChecklistID"></param>
/// <param name="lChecklistStateID"></param>
/// <param name="strSelectedPatients"></param>
/// <param name="ds"></param>
/// <returns></returns>
public CStatus GetPatCLByCLIDCLSTATEDS(long lChecklistID,
long lChecklistStateID,
string strSelectedPatients,
out DataSet ds)
{
//initialize parameters
ds = null;
//create a status object and check for valid dbconnection
CStatus status = DBConnValid();
if (!status.Status)
{
return(status);
}
//load the paramaters list
CParameterList pList = new CParameterList(SessionID,
ClientIP,
UserID);
pList.AddInputParameter("pi_nChecklistID", lChecklistID);
pList.AddInputParameter("pi_nChecklistStateID", lChecklistStateID);
pList.AddInputParameter("pi_vSelectedPatients", strSelectedPatients);
//get the dataset
CDataSet cds = new CDataSet();
return(cds.GetOracleDataSet(DBConn,
"PCK_PAT_CHECKLIST.GetPatCLByCLIDCLSTATERS",
pList,
out ds));
}
//get Supervisors Dataset
public DataSet GetInternSupervisorsDS(BaseMaster BaseMstr)
{
//status info
long lStatusCode = -1;
string strStatusComment = "";
//create a new parameter list with standard params from basemstr
CDataParameterList plist = new CDataParameterList(BaseMstr);
//todo: add in additional params for the DB call
//add params for the DB stored procedure call
CDataSet cds = new CDataSet();
DataSet ds = cds.GetOracleDataSet(BaseMstr.DBConn,
"PCK_AP_USERADMIN.GetInternSupervisorsRS",
plist,
out lStatusCode,
out strStatusComment);
//set the base master status code and status for display
BaseMstr.StatusCode = lStatusCode;
BaseMstr.StatusComment = strStatusComment;
if (lStatusCode == 0)
{
return(ds);
}
else
{
return(null);
}
}
/// <summary>
/// Used to get a dataset of temporal states.
/// </summary>
/// <param name="lActiveFilter"></param>
/// <param name="ds"></param>
/// <param name="lStatusCode"></param>
/// <param name="strStatus"></param>
/// <returns></returns>
public CStatus GetTemporalStateDS(long lActiveFilter, out DataSet ds)
{
//initialize parameters
ds = null;
//create a status object and check for valid dbconnection
CStatus status = DBConnValid();
if (!status.Status)
{
return(status);
}
//load the paramaters list
CParameterList pList = new CParameterList(SessionID,
ClientIP,
UserID);
pList.AddInputParameter("pi_nActiveFilter", lActiveFilter);
//get the dataset
CDataSet cds = new CDataSet();
return(cds.GetOracleDataSet(DBConn,
"PCK_VARIABLE.GetTemporalStateRS",
pList,
out ds));
}
public DataSet GetUserLookupBySearchDS(BaseMaster BaseMstr,
string strSearchValue)
{
//status info
long lStatusCode = -1;
string strStatusComment = "";
//create a new parameter list with standard params from basemstr
CDataParameterList plist = new CDataParameterList(BaseMstr);
plist.AddInputParameter("pi_vSearchValue", strSearchValue);
//
CDataSet cds = new CDataSet();
DataSet ds = cds.GetOracleDataSet(BaseMstr.DBConn,
"PCK_USER_ADMIN.getUserLookupBySearchRS",
plist,
out lStatusCode,
out strStatusComment);
//set the base master status code and status for display
BaseMstr.StatusCode = lStatusCode;
BaseMstr.StatusComment = strStatusComment;
if (lStatusCode == 0)
{
return(ds);
}
else
{
return(null);
}
}
/// <summary>
/// Used to get a dataset of outcome states for a particular
/// checklist/item combination
/// </summary>
/// <param name="lChecklistID"></param>
/// <param name="lItemID"></param>
/// <param name="ds"></param>
/// <returns></returns>
public CStatus GetOutcomeStateDS(
long lChecklistID,
long lItemID,
out DataSet ds)
{
//initialize parameters
ds = null;
//create a status object and check for valid dbconnection
CStatus status = DBConnValid();
if (!status.Status)
{
return(status);
}
//load the paramaters list
CParameterList pList = new CParameterList(
SessionID,
ClientIP,
UserID);
pList.AddInputParameter("pi_nChecklistID", lChecklistID);
pList.AddInputParameter("pi_nItemID", lItemID);
//get the dataset
CDataSet cds = new CDataSet();
return(cds.GetOracleDataSet(
DBConn,
"PCK_CHECKLIST_ITEM.GetOutcomeStateRS",
pList,
out ds));
}
public DataSet GetSuatUserDS(BaseMaster BaseMstr)
{
//status info
long lStatusCode = -1;
string strStatusComment = "";
//create a new parameter list with standard params from basemstr
CDataParameterList plist = new CDataParameterList(BaseMstr);
//todo: add in additional params for the DB call
//add params for the DB stored procedure call
plist.AddInputParameter("pi_vProviderID", BaseMstr.SelectedProviderID);
CDataSet cds = new CDataSet();
DataSet ds = cds.GetOracleDataSet(BaseMstr.DBConn,
"PCK_USER_ADMIN.GetSuatUserRS",
plist,
out lStatusCode,
out strStatusComment);
//set the base master status code and status for display
BaseMstr.StatusCode = lStatusCode;
BaseMstr.StatusComment = strStatusComment;
if (lStatusCode == 0)
{
return(ds);
}
else
{
return(null);
}
}
protected DataSet GetPatientLock(string strPatientID)
{
//status info
long lStatusCode = -1;
string strStatusComment = "";
//create a new parameter list with standard params from basemstr
CDataParameterList pList = new CDataParameterList(m_BaseMstr);
pList.AddInputParameter("pi_vPatientID", strPatientID);
CDataSet cds = new CDataSet();
DataSet ds = cds.GetOracleDataSet(m_BaseMstr.DBConn,
"PCK_PATIENT_LOCK.GetPatientLock",
pList,
out lStatusCode,
out strStatusComment);
//set the base master status code and status for display
m_BaseMstr.StatusCode = lStatusCode;
m_BaseMstr.StatusComment = strStatusComment;
if (lStatusCode == 0)
{
return(ds);
}
else
{
return(null);
}
}
public DataSet GetRaceDS(BaseMaster BaseMstr)
{
//status info
long lStatusCode = -1;
string strStatusComment = string.Empty;
//create a new parameter list with standard params from basemstr
CDataParameterList plist = new CDataParameterList(BaseMstr);
CDataSet cds = new CDataSet();
DataSet ds = cds.GetOracleDataSet(
BaseMstr.DBConn,
"PCK_PAT_ETHNICITY_RACE.GetRaceRS",
plist,
out lStatusCode,
out strStatusComment);
//set the base master status code and status for display
BaseMstr.StatusCode = lStatusCode;
BaseMstr.StatusComment = strStatusComment;
if (lStatusCode == 0)
{
return(ds);
}
else
{
return(null);
}
}
public DataSet GetPatientDeviceDS()
{
//status info
long lStatusCode = -1;
string strStatusComment = "";
//create a new parameter list with standard params from basemstr
CDataParameterList plist = new CDataParameterList(m_BaseMstr);
//add params for the DB stored procedure call
plist.AddInputParameter("pi_vPatientID", m_BaseMstr.SelectedPatientID);
//use helper to get a dataset from the sp call
CDataSet cds = new CDataSet();
DataSet ds = cds.GetOracleDataSet(m_BaseMstr.DBConn,
"PCK_CPAP_DEVICE.GetPatientDeviceRS",
plist,
out lStatusCode,
out strStatusComment);
//set the base master status code and status for display
m_BaseMstr.StatusCode = lStatusCode;
m_BaseMstr.StatusComment = strStatusComment;
if (lStatusCode == 0)
{
return(ds);
}
else
{
return(null);
}
}
public DataSet GetReferralClinicLookupDS(BaseMaster BaseMstr,
string strSearchValue
)
{
//status info
long lStatusCode = -1;
string strStatusComment = "";
//create a new parameter list with standard params from basemstr
CDataParameterList plist = new CDataParameterList(BaseMstr);
//add params for the DB stored procedure call
plist.AddInputParameter("pi_vSearchValue", strSearchValue);
//
CDataSet cds = new CDataSet();
DataSet ds = cds.GetOracleDataSet(BaseMstr.DBConn,
"PCK_REFERRAL_CLINIC.GetReferralClinicLookUpRS",
plist,
out lStatusCode,
out strStatusComment);
//set the base master status code and status for display
BaseMstr.StatusCode = lStatusCode;
BaseMstr.StatusComment = strStatusComment;
if (lStatusCode == 0)
{
return(ds);
}
else
{
return(null);
}
}