public static void ApplyFilters(IListQueryBuilder listQuery, IDbQueryBuilder queryBuilder)
{
if (listQuery.Configuration.QueryDefinition.Filters != null)
{
var where = new DbQueryWhereClause(queryBuilder.Root, Csg.Data.Sql.SqlLogic.And);
//tODO: IsFilterable is not being enforced. Shoult it be?
foreach (var filter in listQuery.Configuration.QueryDefinition.Filters)
{
var hasConfig = listQuery.Configuration.Validations.TryGetValue(filter.Name, out ListFieldMetadata validationField);
if (listQuery.Configuration.Handlers.TryGetValue(filter.Name, out ListQueryFilterHandler handler))
{
handler(where, filter, validationField);
}
else if (hasConfig || !listQuery.Configuration.UseValidation)
{
where.AddFilter(filter.Name, filter.Operator ?? ListFilterOperator.Equal, filter.Value, validationField?.DataType ?? System.Data.DbType.String, validationField?.DataTypeSize);
}
else if (listQuery.Configuration.UseValidation)
{
throw new Exception($"No handler is defined for the filter '{filter.Name}'.");
}
}
if (where.Filters.Count > 0)
{
where.ApplyToQuery(queryBuilder);
}
}
}
