public override IEnumerable <UserDisplayData> Execute() { IEnumerable <UserDisplayData> accounts = null; string query = BASE_QUERY; SqlFilterCriterion criterion = (SqlFilterCriterion)Filter; bool usesParameter = criterion.UsesParameter; DbParameter[] parameters = null; if (criterion != null) { query += $"WHERE {criterion.Evaluate()} "; parameters = criterion.GetParameters(); } if (Ordering != null) { query += string.Format("ORDER BY {0} ", Ordering.Evaluate()); } MySQLProvider provider = new MySQLProvider(DBConfiguration.ConnectionString); SQLCaller caller = new SQLCaller(provider); DbCommand command = criterion.UsesParameter ? provider.CreateCommand(query, parameters) : provider.CreateCommand(query); accounts = caller.Get(MapUserDisplay, command); return(accounts); }
public CompoundSqlFilterCriterion(SqlFilterCriterion left, SqlFilterCriterion right, string link) { LeftFilter = left; RightFilter = right; Link = link; UsesParameter = LeftFilter.UsesParameter || RightFilter.UsesParameter; }
public SqlFilterCriterion And(SqlFilterCriterion filterCriterion) { return(new CompoundSqlFilterCriterion(this, filterCriterion, CompoundSqlFilterCriterion.LINK_AND)); }
public SqlFilterCriterion Or(SqlFilterCriterion filterCriterion) { return(new CompoundSqlFilterCriterion(this, filterCriterion, CompoundSqlFilterCriterion.LINK_OR)); }
public ParenthesizedSqlFilterCriterion(SqlFilterCriterion groupedCriterion) { GroupedCriterion = groupedCriterion; UsesParameter = GroupedCriterion.UsesParameter; }