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