public WhereClause(string column, ComparisonSymbol comparisonSymbol, DBValue value, bool and)
{
this.column = column;
this.comparisonSymbol = comparisonSymbol;
this.value = value;
this.and = and;
}
/// <summary>
/// Returns the error type code depending on the comparison symbol
/// </summary>
private string GetErrorTypeCode()
{
string errorTypeCode;
string comparisonSymbol = ComparisonSymbol.Trim();
if (comparisonSymbol == "<")
{
if (Column.Type == "datetime")
{
errorTypeCode = LaterThanOrEqualsErrorTypeCode;
}
else
{
errorTypeCode = GreaterThanOrEqualsErrorTypeCode;
}
}
else if (comparisonSymbol == "<=")
{
if (Column.Type == "datetime")
{
errorTypeCode = LaterThanErrorTypeCode;
}
else
{
errorTypeCode = GreaterThanErrorType;
}
}
else if (comparisonSymbol == ">")
{
if (Column.Type == "datetime")
{
errorTypeCode = EarlierThanOrEqualsErrorTypeCode;
}
else
{
errorTypeCode = SmallerThanOrEqualsErrorTypeCode;
}
}
else if (comparisonSymbol == ">=")
{
if (Column.Type == "datetime")
{
errorTypeCode = EarlierThanErrorTypeCode;
}
else
{
errorTypeCode = SmallerThanErrorTypeCode;
}
}
else if (comparisonSymbol == "=")
{
errorTypeCode = NotEqualsErrorTypeCode;
}
else if (comparisonSymbol == "!=")
{
errorTypeCode = EqualsErrorTypeCode;
}
else
{
throw new ArgumentException(string.Format("Unknown comparison symbol: {0}", comparisonSymbol));
}
return(errorTypeCode);
}
