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