public Where(string column, ComparisonOperators comparisonOperator, object value)
{
this.Column = column;
this.ComparisonOperator = comparisonOperator;
this.Value = value;
this._SubClauses = new List<SubClause>();
}
public Join(JoinTypes JoinType, string FromTable, string FromColumn, ComparisonOperators ComparisonOperator, string ToTable, string ToColumn)
{
this.JoinType = JoinType;
this.FromTable = FromTable;
this.FromColumn = FromColumn;
this.ComparisonOperator = ComparisonOperator;
this.ToTable = ToTable;
this.ToColumn = ToColumn;
}
public SubClause(LogicalOperators logicalOperator, ComparisonOperators comparisonOperator, object value)
{
this.LogicalOperator = logicalOperator;
this.ComparisonOperator = comparisonOperator;
this.Value = value;
}
public void AddSubClause(LogicalOperators logicalOperator, ComparisonOperators comparisonOperator, object value)
{
SubClause subClause = new SubClause(logicalOperator, comparisonOperator, value);
_SubClauses.Add(subClause);
}
public void AddJoin(JoinTypes joinType, string toTablename, string toColumn, string fromTablename, string fromColumn, ComparisonOperators comparisonOperator)
{
Join newJoin = new Join(joinType, toTablename, toColumn, comparisonOperator, fromTablename, fromColumn);
this._joins.Add(newJoin);
}
public Where AddWhere(Enum column, ComparisonOperators comparisonOperator, object value)
{
return this.AddWhere(column.ToString(), comparisonOperator, value, 1);
}
public Where AddWhere(string column, ComparisonOperators comparisonOperator, object value)
{
return this.AddWhere(column, comparisonOperator, value, 1);
}
public Where AddWhere(string column, ComparisonOperators comparisonOperator, object value, int level)
{
Where newWhere = new Where(column, comparisonOperator, value);
this._whereStatement.Add(newWhere, level);
return newWhere;
}