* OdbcParameterTest.cs: Fixed compilation on 1.0 profile.
[mono.git] / mcs / class / System.Data / System.Data.SqlTypes / SqlBoolean.cs
index af224d895842ed196390747363247b8de190cdda..3219b02c21ec2055e9e99567b8ef2e112aa8288b 100644 (file)
 // (C) Copyright 2002 Tim Coleman
 //
 
+//
+// Copyright (C) 2004 Novell, Inc (http://www.novell.com)
+//
+// Permission is hereby granted, free of charge, to any person obtaining
+// a copy of this software and associated documentation files (the
+// "Software"), to deal in the Software without restriction, including
+// without limitation the rights to use, copy, modify, merge, publish,
+// distribute, sublicense, and/or sell copies of the Software, and to
+// permit persons to whom the Software is furnished to do so, subject to
+// the following conditions:
+// 
+// The above copyright notice and this permission notice shall be
+// included in all copies or substantial portions of the Software.
+// 
+// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
+// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
+// MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
+// NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
+// LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
+// OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
+// WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
+//
+
+using System;
+using System.Globalization;
+#if NET_2_0
+using System.Xml;
+using System.Xml.Schema;
+using System.Xml.Serialization;
+using System.Runtime.Serialization;
+#endif
+
 namespace System.Data.SqlTypes
 {
        /// <summary>
        /// Represents an integer value that is either 1 or 0 
        /// to be stored in or retrieved from a database.
        /// </summary>
-       public struct SqlBoolean : INullable, IComparable 
+#if NET_2_0
+       [SerializableAttribute]
+       [XmlSchemaProvider ("GetXsdType")]
+#endif
+       public struct SqlBoolean : INullable, IComparable
+#if NET_2_0
+                                  , IXmlSerializable
+#endif
        {
 
                #region Fields
 
                byte value;
+               
+               // default is false
+               private bool notNull;
 
                public static readonly SqlBoolean False = new SqlBoolean (false);
                public static readonly SqlBoolean Null;
@@ -36,11 +78,13 @@ namespace System.Data.SqlTypes
                public SqlBoolean (bool value) 
                {
                        this.value = (byte) (value ? 1 : 0);
+                       notNull = true;
                }
 
                public SqlBoolean (int value) 
                {
                        this.value = (byte) (value != 0 ? 1 : 0);
+                       notNull = true;
                }
 
                #endregion // Constructors
@@ -50,7 +94,7 @@ namespace System.Data.SqlTypes
                public byte ByteValue {
                        get {
                                if (this.IsNull)
-                                       throw new SqlNullValueException( "The property is set to null.");
+                                       throw new SqlNullValueException(Locale.GetText("The property is set to null."));
                                else
                                        return value;
                        }
@@ -66,7 +110,9 @@ namespace System.Data.SqlTypes
                }
 
                public bool IsNull {
-                       get { return (bool) (this == Null); }
+                       get { 
+                               return !notNull;
+                       }
                }
 
                public bool IsTrue {
@@ -81,7 +127,7 @@ namespace System.Data.SqlTypes
                public bool Value {
                        get { 
                                if (this.IsNull)
-                                       throw new SqlNullValueException( "The property is set to null.");
+                                       throw new SqlNullValueException(Locale.GetText("The property is set to null."));
                                else
                                        return this.IsTrue;
                        }
@@ -94,16 +140,36 @@ namespace System.Data.SqlTypes
                        return (x & y);
                }
 
-               [MonoTODO]
-               public int CompareTo (object value) 
+               public int CompareTo (object value)
                {
-                       throw new NotImplementedException ();
+                       if (value == null)
+                               return 1;
+                       if (!(value is SqlBoolean))
+                               throw new ArgumentException (Locale.GetText ("Value is not a System.Data.SqlTypes.SqlBoolean"));
+
+                       return CompareTo ((SqlBoolean) value);
+               }
+#if NET_2_0
+               public
+#endif
+               int CompareTo (SqlBoolean value) 
+               {
+                       if (value.IsNull)
+                               return 1;
+                       else
+                               return this.value.CompareTo (value.ByteValue);
                }
 
-               [MonoTODO]
                public override bool Equals(object value) 
                {
-                       throw new NotImplementedException ();
+                       if (!(value is SqlBoolean))
+                               return false;
+                       if (this.IsNull)
+                               return ((SqlBoolean)value).IsNull;
+                       else if (((SqlBoolean)value).IsNull)
+                               return false;
+                       else
+                               return (bool) (this == (SqlBoolean)value);
                }
 
                public static SqlBoolean Equals(SqlBoolean x, SqlBoolean y) 
@@ -111,9 +177,36 @@ namespace System.Data.SqlTypes
                        return (x == y);
                }
 
+#if NET_2_0
+               public static SqlBoolean GreaterThan (SqlBoolean x, SqlBoolean y) 
+               {
+                       return (x > y);
+               }
+
+               public static SqlBoolean GreaterThanOrEquals (SqlBoolean x, SqlBoolean y) 
+               {
+                       return (x >= y);
+               }
+
+               public static SqlBoolean LessThan (SqlBoolean x, SqlBoolean y) 
+               {
+                       return (x < y);
+               }
+
+               public static SqlBoolean LessThanOrEquals (SqlBoolean x, SqlBoolean y) 
+               {
+                       return (x <= y);
+               }
+#endif
                public override int GetHashCode() 
                {
-                       return (int)value;
+                       int hash;
+                       if (this.IsTrue)
+                               hash = 1;
+                       else 
+                               hash = 0;
+
+                       return hash;
                }
 
                public static SqlBoolean NotEquals(SqlBoolean x, SqlBoolean y) 
@@ -133,6 +226,12 @@ namespace System.Data.SqlTypes
 
                public static SqlBoolean Parse(string s) 
                {
+                       switch (s) {
+                       case "0":
+                               return new SqlBoolean (false);
+                       case "1":
+                               return new SqlBoolean (true);
+                       }
                        return new SqlBoolean (Boolean.Parse (s));
                }
 
@@ -180,16 +279,24 @@ namespace System.Data.SqlTypes
                        return ((SqlSingle)this);
                }
 
-               [MonoTODO]
                public SqlString ToSqlString() 
                {
-                       throw new NotImplementedException ();
+                       if (this.IsNull)
+                               return new SqlString ("Null");
+                       if (this.IsTrue)
+                               return new SqlString ("True");
+                       else
+                               return new SqlString ("False");
                }
 
-               [MonoTODO]
                public override string ToString() 
                {
-                       throw new NotImplementedException ();
+                       if (this.IsNull)
+                               return "Null";
+                       if (this.IsTrue)
+                               return "True";
+                       else
+                               return "False";
                }
 
                // Bitwise exclusive-OR (XOR)
@@ -257,9 +364,48 @@ namespace System.Data.SqlTypes
                // One's Complement
                public static SqlBoolean operator ~ (SqlBoolean x) 
                {
-                       return new SqlBoolean (~x.ByteValue);
+                       SqlBoolean b;
+                       if (x.IsTrue)
+                               b = new SqlBoolean(false);
+                       else
+                               b = new SqlBoolean(true);
+
+                       return b;
+               }
+
+#if NET_2_0
+               public static SqlBoolean operator > (SqlBoolean x, SqlBoolean y) 
+               {
+                       if (x.IsNull || y.IsNull) 
+                               return SqlBoolean.Null;
+
+                       return new SqlBoolean (Compare (x, y) > 0);
+               }
+
+               public static SqlBoolean operator >= (SqlBoolean x, SqlBoolean y) 
+               {
+                       if (x.IsNull || y.IsNull) 
+                               return SqlBoolean.Null;
+
+                       return new SqlBoolean (Compare (x, y) >= 0);
+               }
+
+               public static SqlBoolean operator < (SqlBoolean x, SqlBoolean y) 
+               {
+                       if (x.IsNull || y.IsNull) 
+                               return SqlBoolean.Null;
+
+                       return new SqlBoolean (Compare (x, y) < 0);
                }
 
+               public static SqlBoolean operator <= (SqlBoolean x, SqlBoolean y) 
+               {
+                       if (x.IsNull || y.IsNull) 
+                               return SqlBoolean.Null;
+
+                       return new SqlBoolean (Compare (x, y) <= 0);
+               }
+#endif
                // test to see if value is true
                public static bool operator true (SqlBoolean x) 
                {
@@ -281,80 +427,101 @@ namespace System.Data.SqlTypes
                // SqlByte to SqlBoolean
                public static explicit operator SqlBoolean (SqlByte x) 
                {
-                       if (x.IsNull)
-                               return Null;
-                       else
-                               return new SqlBoolean ((int)x.Value);
+                       checked {
+                               if (x.IsNull)
+                                       return Null;
+                               else
+                                       return new SqlBoolean ((int)x.Value);
+                       }
                }
 
                // SqlDecimal to SqlBoolean
                public static explicit operator SqlBoolean (SqlDecimal x) 
                {
-                       if (x.IsNull)
-                               return Null;
-                       else
-                               return new SqlBoolean ((int)x.Value);
+                       checked {
+                               if (x.IsNull)
+                                       return Null;
+                               else
+                                       return new SqlBoolean ((int)x.Value);
+                       }
                }
                
                // SqlDouble to SqlBoolean
                public static explicit operator SqlBoolean (SqlDouble x) 
                {
-                       if (x.IsNull)
-                               return Null;
-                       else
-                               return new SqlBoolean ((int)x.Value);
+                       // FIXME
+                       //checked {
+                               if (x.IsNull)
+                                       return Null;
+                               else
+                                       return new SqlBoolean ((int)x.Value);
+                               //}
                }
 
                // SqlInt16 to SqlBoolean
                public static explicit operator SqlBoolean (SqlInt16 x) 
                {
-                       if (x.IsNull)
-                               return Null;
-                       else
-                               return new SqlBoolean ((int)x.Value);
+                       checked {
+                               if (x.IsNull)
+                                       return Null;
+                               else
+                                       return new SqlBoolean ((int)x.Value);
+                       }
                }
 
                // SqlInt32 to SqlBoolean
                public static explicit operator SqlBoolean (SqlInt32 x) 
                {
-                       if (x.IsNull)
-                               return Null;
-                       else
-                               return new SqlBoolean (x.Value);
+                       checked {
+                               if (x.IsNull)
+                                       return Null;
+                               else
+                                       return new SqlBoolean (x.Value);
+                       }
                }
 
                // SqlInt64 to SqlBoolean
                public static explicit operator SqlBoolean (SqlInt64 x) 
                {
-                       if (x.IsNull)
-                               return Null;
-                       else
-                               return new SqlBoolean ((int)x.Value);
+                       checked {
+                               if (x.IsNull)
+                                       return Null;
+                               else
+                                       return new SqlBoolean ((int)x.Value);
+                       }
                }
 
                // SqlMoney to SqlBoolean
                public static explicit operator SqlBoolean (SqlMoney x) 
                {
-                       if (x.IsNull)
-                               return Null;
-                       else
-                               return new SqlBoolean ((int)x.Value);
+                       checked {
+                               if (x.IsNull)
+                                       return Null;
+                               else
+                                       return new SqlBoolean ((int)x.Value);
+                       }
                }
 
                // SqlSingle to SqlBoolean
                public static explicit operator SqlBoolean (SqlSingle x) 
                {
-                       if (x.IsNull)
-                               return Null;
-                       else
-                               return new SqlBoolean ((int)x.Value);
+                       // FIXME
+                       //checked {
+                               if (x.IsNull)
+                                       return Null;
+                               else
+                                       return new SqlBoolean ((int)x.Value);
+                               //}
                }
 
                // SqlString to SqlBoolean
-               [MonoTODO]
                public static explicit operator SqlBoolean (SqlString x) 
                {
-                       throw new NotImplementedException ();
+                       checked {
+                               if (x.IsNull)
+                                       return Null;
+                               return SqlBoolean.Parse (x.Value);
+                       }
                }
 
                // Boolean to SqlBoolean
@@ -362,5 +529,45 @@ namespace System.Data.SqlTypes
                {
                        return new SqlBoolean (x);
                }
+#if NET_2_0
+               // Helper method to Compare methods and operators.
+               // Returns 0 if x == y
+               //         1 if x > y
+               //        -1 if x < y
+               private static int Compare (SqlBoolean x, SqlBoolean y)
+               {
+                       if (x == y)
+                               return 0;
+                       if (x.IsTrue && y.IsFalse)
+                               return 1;
+                       if (x.IsFalse && y.IsTrue)
+                               return -1;
+                       return 0;
+               }
+
+               public static XmlQualifiedName GetXsdType (XmlSchemaSet schemaSet)
+               {
+                       XmlQualifiedName qualifiedName = new XmlQualifiedName ("boolean", "http://www.w3.org/2001/XMLSchema");
+                       return qualifiedName;
+               }
+               
+               [MonoTODO]
+               XmlSchema IXmlSerializable.GetSchema ()
+               {
+                       throw new NotImplementedException ();
+               }
+                                                                                
+               [MonoTODO]
+               void IXmlSerializable.ReadXml (XmlReader reader)
+               {
+                       throw new NotImplementedException ();
+               }
+                                                                                
+               [MonoTODO]
+               void IXmlSerializable.WriteXml (XmlWriter writer)
+               {
+                       throw new NotImplementedException ();
+               }
+#endif
        }
 }