//gets current mids from the stat_module_constant table public bool GetCurrentMIDS(BaseMaster BaseMstr, out int nReasonForReferralMID, out int nSuicideMID, out int nMSEMID, out int nSubsequentEventMID) { //status info long lStatusCode = -1; string strStatusComment = ""; //init the outs nReasonForReferralMID = -1; nSuicideMID = -1; nMSEMID = -1; nSubsequentEventMID = -1; //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.GetStatModuleConstantRS", plist, out lStatusCode, out strStatusComment); //set the base master status code and status for display BaseMstr.StatusCode = lStatusCode; BaseMstr.StatusComment = strStatusComment; if (lStatusCode == 0) { CDataUtils util = new CDataUtils(); nReasonForReferralMID = util.GetIntValueFromDS(ds, "RFR_MODULE"); nMSEMID = util.GetIntValueFromDS(ds, "MSE_MODULE"); nSuicideMID = util.GetIntValueFromDS(ds, "SUICIDE_MODULE"); nSubsequentEventMID = util.GetIntValueFromDS(ds, "RFR_SE_MODULE"); return(true); } return(false); }