public void ExtractGroupOperator()
{
int dayOfYear = DateTime.Now.DayOfYear;
BinaryOperator binaryOperator2;
CriteriaOperator groupOperator;
BinaryOperator binaryOperator = getGroupOperator(out binaryOperator2, out groupOperator);
var extractor = new CriteriaOperatorExtractor();
extractor.Extract(groupOperator);
Assert.AreEqual(binaryOperator, extractor.BinaryOperators[0]);
Assert.AreEqual(binaryOperator2, extractor.BinaryOperators[1]);
}
public void ExtractNestedGroupOperator()
{
BinaryOperator binaryOperator2;
CriteriaOperator nestedGroupOperator;
BinaryOperator binaryOperator1 = getGroupOperator(out binaryOperator2, out nestedGroupOperator);
var groupOperator = new GroupOperator(nestedGroupOperator, binaryOperator1, binaryOperator2);
CriteriaOperator containsOperator = new ContainsOperator("", groupOperator);
var extractor = new CriteriaOperatorExtractor();
extractor.Extract(containsOperator);
Assert.AreEqual(4, extractor.BinaryOperators.Count);
Assert.AreEqual(binaryOperator1, extractor.BinaryOperators[0]);
Assert.AreEqual(binaryOperator2, extractor.BinaryOperators[1]);
Assert.AreEqual(binaryOperator1, extractor.BinaryOperators[2]);
Assert.AreEqual(binaryOperator2, extractor.BinaryOperators[3]);
}
private CriteriaOperatorExtractor GetBinaryOperatorExtractor(CriteriaOperator criteriaOperator)
{
var binaryOperatorExtractor = new CriteriaOperatorExtractor();
binaryOperatorExtractor.Extract(criteriaOperator);
return binaryOperatorExtractor;
}
public SelectStatement ApplyCondition(SelectStatement statement) {
var extractor = new CriteriaOperatorExtractor();
extractor.Extract(statement.Condition);
foreach (FilterProviderBase provider in FilterProviderManager.Providers) {
FilterProviderBase providerBase = FilterProviderManager.GetFilterProvider(statement.TableName, provider.FilterMemberName, StatementContext.Select);
if (providerBase != null) {
IEnumerable<BinaryOperator> binaryOperators = GetBinaryOperators(extractor, providerBase);
if (!FilterIsShared(statement.TableName, providerBase.Name) && binaryOperators.Count() == 0) {
string nodeAlias = GetNodeAlias(statement, providerBase);
ApplyCondition(statement, providerBase, nodeAlias);
}
}
}
return statement;
}
public SelectStatement ApplyCondition(SelectStatement statement) {
var extractor = new CriteriaOperatorExtractor();
extractor.Extract(statement.Condition);
foreach (FilterProviderBase provider in FilterProviderManager.Providers) {
Type objectType = null;
if (!_tablesDictionary.TryGetValue(statement.TableName, out objectType))
continue;
FilterProviderBase providerBase = FilterProviderManager.GetFilterProvider(objectType, provider.FilterMemberName, StatementContext.Select);
if (providerBase != null) {
IEnumerable<BinaryOperator> binaryOperators = GetBinaryOperators(extractor, providerBase);
if (!FilterIsShared(statement.TableName, providerBase.Name) && !binaryOperators.Any()) {
string nodeAlias = GetNodeAlias(statement, providerBase);
if (!string.IsNullOrEmpty(nodeAlias))
ApplyCondition(statement, providerBase, nodeAlias);
}
}
}
return statement;
}
