// ounce 6.0 dependent public List <Rules> getListOfCustomRules(bool bMapActionObjects) { var sSqlForRule = "Select * from rec WHERE (rec.added=true OR rec.modified=true)"; //DataTable dtResults_forRule = o2.ounce.datalayer.mysql.OunceMySql.getDataTableFromSqlQuery(sSqlForRule); var lrCustomRules = new List <Rules>(); OunceMySql.populateListWithDataTable(sSqlForRule, lrCustomRules); foreach (Rules rRule in lrCustomRules) { rRule.lActionObjects = new List <ActionObject>(); if (bMapActionObjects) { String sSqlForActionObject = String.Format("Select * from actionobjects WHERE actionobjects.vuln_id = {0}", rRule.vuln_id); OunceMySql.populateListWithDataTable(sSqlForActionObject, rRule.lActionObjects); } } return(lrCustomRules); }