/// <summary>
/// This function gets called by the database when converting into LINQ queries.
/// </summary>
public override object Invoke(object[] args)
{
double?Value1 = args[0] != DBNull.Value ? (double?)Convert.ToDouble(args[0]) : null;
OperatorConditionEnum CompareOp = (OperatorConditionEnum)(int)Convert.ToInt32(args[1]);
double Value2 = args[2] != DBNull.Value ? Convert.ToDouble(args[2]) : 0;
return(Calculate(Value1, CompareOp, Value2));
}
/// <summary>
/// Calculates the function.
/// </summary>
/// <param name="value1">The value to compare with.</param>
/// <param name="compareOp">The comparison operator.</param>
/// <param name="value2">The value to compare to.</param>
/// <returns>Whether both values match the operator condition.</returns>
public static bool Calculate(double? value1, OperatorConditionEnum compareOp, double? value2) {
if (value1 != null && value2 != null) {
if (compareOp == OperatorConditionEnum.Smaller)
return value1 < value2;
else if (compareOp == OperatorConditionEnum.GreaterOrEqual)
return value1 >= value2;
else // Equal
return value1 == value2;
} else
return false;
}
/// <summary>
/// Calculates the function.
/// </summary>
/// <param name="value1">The value to compare with.</param>
/// <param name="compareOp">The comparison operator.</param>
/// <param name="value2">The value to compare to.</param>
/// <returns>Whether both values match the operator condition.</returns>
public static bool Calculate(double?value1, OperatorConditionEnum compareOp, double?value2)
{
if (value1 != null && value2 != null)
{
if (compareOp == OperatorConditionEnum.Smaller)
{
return(value1 < value2);
}
else if (compareOp == OperatorConditionEnum.GreaterOrEqual)
{
return(value1 >= value2);
}
else // Equal
{
return(value1 == value2);
}
}
else
{
return(false);
}
}
public SearchRatingSetting(string category, OperatorConditionEnum op, double?value)
{
this.Category = category;
this.Operator = op;
this.Value = value;
}
public void SetRatingCategory(string ratingCategory, OperatorConditionEnum ratingOperator, double?ratingValue)
{
this.RatingCategory = ratingCategory;
this.RatingOperator = ratingOperator;
this.RatingValue = ratingValue;
}
public bool CompareValues(double?value1, OperatorConditionEnum compareOp, double?value2)
{
return(DbCompareValuesClass.Calculate(value1, compareOp, value2));
}
public bool CompareValues(double? value1, OperatorConditionEnum compareOp, double? value2) {
return DbCompareValuesClass.Calculate(value1, compareOp, value2);
}
public void SetRatingCategory(string ratingCategory, OperatorConditionEnum ratingOperator, double? ratingValue) {
this.RatingCategory = ratingCategory;
this.RatingOperator = ratingOperator;
this.RatingValue = ratingValue;
}
public SearchRatingSetting(string category, OperatorConditionEnum op, double? value) {
this.Category = category;
this.Operator = op;
this.Value = value;
}
