CompareTo() public method

public CompareTo ( SqlDecimal value ) : int
value SqlDecimal
return int
Example #1
0
        /**
         * Compares two instances of SqlDecimal to determine if the first is less than the second.
         * @param x A SqlDecimal instance
         * @param y A SqlDecimal instance
         * @return A SqlBoolean that is True if the first instance is less than the second instance, otherwise False.
         * If either instance of SqlDouble is null, the Value of the SqlBoolean will be Null.
         */
        public static SqlBoolean LessThanOrEqual(SqlDecimal x, SqlDecimal y)
        {
            if (x.IsNull || y.IsNull)
            {
                return(SqlBoolean.Null);
            }

            if (x.CompareTo(y) <= 0)
            {
                return(SqlBoolean.True);
            }

            return(SqlBoolean.False);
        }
Example #2
0
        /**
         * Compares two instances of SqlDecimal to determine if the first is greater than the second.
         * @param x A SqlDecimal instance
         * @param y A SqlDecimal instance
         * @return A SqlBoolean that is True if the first instance is greater than the second instance, otherwise False.
         * If either instance of SqlDouble is null, the Value of the SqlBoolean will be Null.
         */
        public static SqlBoolean GreaterThan(SqlDecimal x, SqlDecimal y)
        {
            if (x.IsNull || y.IsNull)
            {
                return(SqlBoolean.Null);
            }

            if (x.CompareTo(y) > 0)
            {
                return(SqlBoolean.True);
            }

            return(SqlBoolean.False);
        }
Example #3
0
        /**
         * Compares two instances of SqlDecimal to determine if the first is less than the second.
         * @param x A SqlDecimal instance
         * @param y A SqlDecimal instance
         * @return A SqlBoolean that is True if the first instance is less than the second instance, otherwise False.
         * If either instance of SqlDouble is null, the Value of the SqlBoolean will be Null.
         */
        public static SqlBoolean LessThanOrEqual(SqlDecimal x, SqlDecimal y)
        {
            if (x.IsNull || y.IsNull)
                return SqlBoolean.Null;

            if (x.CompareTo(y) <= 0)
                return SqlBoolean.True;

            return SqlBoolean.False;
        }
Example #4
0
        /**
         * Compares two instances of SqlDecimal to determine if the first is greater than the second.
         * @param x A SqlDecimal instance
         * @param y A SqlDecimal instance
         * @return A SqlBoolean that is True if the first instance is greater than the second instance, otherwise False.
         * If either instance of SqlDouble is null, the Value of the SqlBoolean will be Null.
         */
        public static SqlBoolean GreaterThan(SqlDecimal x, SqlDecimal y)
        {
            if (x.IsNull || y.IsNull)
                return SqlBoolean.Null;

            if (x.CompareTo(y) > 0)
                return SqlBoolean.True;

            return SqlBoolean.False;
        }