public static WhereStatement Copy(WhereStatement statement)
{
WhereStatement result = new WhereStatement();
int currentLevel = 0;
foreach (List <WhereClause> level in statement)
{
currentLevel++;
result.Add(new List <WhereClause>());
foreach (WhereClause clause in statement[currentLevel - 1])
{
WhereClause clauseCopy = new WhereClause(clause.FieldName, clause.ComparisonOperator, clause.Value);
foreach (WhereClause.SubClause subClause in clause.SubClauses)
{
WhereClause.SubClause subClauseCopy = new WhereClause.SubClause(subClause.LogicOperator, subClause.ComparisonOperator, subClause.Value, "");
clauseCopy.SubClauses.Add(subClauseCopy);
}
result[currentLevel - 1].Add(clauseCopy);
}
}
return(result);
}
/// <summary>
/// This static method combines 2 where statements with eachother to form a new statement
/// </summary>
/// <param name="statement1"></param>
/// <param name="statement2"></param>
/// <returns></returns>
public static WhereStatement CombineStatements(WhereStatement statement1, WhereStatement statement2)
{
// statement1: {Level1}((Age<15 OR Age>=20) AND (strEmail LIKE 'e%') OR {Level2}(Age BETWEEN 15 AND 20))
// Statement2: {Level1}((Name = 'Peter'))
// Return statement: {Level1}((Age<15 or Age>=20) AND (strEmail like 'e%') AND (Name = 'Peter'))
// Make a copy of statement1
WhereStatement result = WhereStatement.Copy(statement1);
// Add all clauses of statement2 to result
for (int i = 0; i < statement2.ClauseLevels; i++) // for each clause level in statement2
{
List <WhereClause> level = statement2[i];
foreach (WhereClause clause in level) // for each clause in level i
{
for (int j = 0; j < result.ClauseLevels; j++) // for each level in result, add the clause
{
result.AddWhereClauseToLevel(clause, j);
}
}
}
return(result);
}
