* OdbcParameterTest.cs: Fixed compilation on 1.0 profile.
[mono.git] / mcs / class / System.Data / System.Data.SqlTypes / SqlBoolean.cs
index e4353d09edacde2509daddfcc383a604e01592d8..3219b02c21ec2055e9e99567b8ef2e112aa8288b 100644 (file)
@@ -4,49 +4,87 @@
 // Author:
 //   Rodrigo Moya (rodrigo@ximian.com)
 //   Daniel Morgan (danmorg@sc.rr.com)
+//   Tim Coleman (tim@timcoleman.com)
 //
 // (C) Ximian, Inc. 2002
+// (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
 
-               // FIXME: populate the static Fields?
-
-               // Value
-               public static readonly SqlBoolean False;
-
-               // Value
-               public static readonly SqlBoolean Null;
-
-               // ByteValue
-               public static readonly SqlBoolean One;
+               byte value;
                
-               // Value
-               public static readonly SqlBoolean True;
+               // default is false
+               private bool notNull;
 
-               // ByteValue
-               public static readonly SqlBoolean Zero;
+               public static readonly SqlBoolean False = new SqlBoolean (false);
+               public static readonly SqlBoolean Null;
+               public static readonly SqlBoolean One = new SqlBoolean (1);
+               public static readonly SqlBoolean True = new SqlBoolean (true);
+               public static readonly SqlBoolean Zero = new SqlBoolean (0);
 
                #endregion // Fields
 
                #region Constructors
 
-               [MonoTODO]
-               public SqlBoolean(bool value) {
-                       throw new NotImplementedException ();
+               public SqlBoolean (bool value) 
+               {
+                       this.value = (byte) (value ? 1 : 0);
+                       notNull = true;
                }
 
-               [MonoTODO]
-               public SqlBoolean(int value) {
-                       throw new NotImplementedException ();
+               public SqlBoolean (int value) 
+               {
+                       this.value = (byte) (value != 0 ? 1 : 0);
+                       notNull = true;
                }
 
                #endregion // Constructors
@@ -54,127 +92,217 @@ namespace System.Data.SqlTypes
                #region Properties
 
                public byte ByteValue {
-                       [MonoTODO]
                        get {
-                               throw new NotImplementedException ();
+                               if (this.IsNull)
+                                       throw new SqlNullValueException(Locale.GetText("The property is set to null."));
+                               else
+                                       return value;
                        }
                }
 
                public bool IsFalse {
-                       [MonoTODO]
-                       get {
-                               throw new NotImplementedException ();
+                       get { 
+                               if (this.IsNull) 
+                                       return false;
+                               else 
+                                       return (value == 0);
                        }
                }
 
                public bool IsNull {
-                       [MonoTODO]
-                       get {
-                               throw new NotImplementedException ();
+                       get { 
+                               return !notNull;
                        }
                }
 
                public bool IsTrue {
-                       [MonoTODO]
-                       get {
-                               throw new NotImplementedException ();
+                       get { 
+                               if (this.IsNull) 
+                                       return false;
+                               else    
+                                       return (value != 0);
                        }
                }
 
                public bool Value {
-                       [MonoTODO]
-                       get {
-                               throw new NotImplementedException ();
+                       get { 
+                               if (this.IsNull)
+                                       throw new SqlNullValueException(Locale.GetText("The property is set to null."));
+                               else
+                                       return this.IsTrue;
                        }
                }
 
                #endregion // Properties
 
-               [MonoTODO]
-               public static SqlBoolean And(SqlBoolean x, SqlBoolean y) {
-                       throw new NotImplementedException ();
+               public static SqlBoolean And (SqlBoolean x, SqlBoolean y) 
+               {
+                       return (x & y);
                }
 
-               [MonoTODO]
-               public int CompareTo(object value) {
-                       throw new NotImplementedException ();
+               public int CompareTo (object value)
+               {
+                       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) {
+               public override bool Equals(object value) 
+               {
+                       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);
                }
 
-               [MonoTODO]
-               public static SqlBoolean Equals(SqlBoolean x, SqlBoolean y) {
+               public static SqlBoolean Equals(SqlBoolean x, SqlBoolean y) 
+               {
+                       return (x == y);
                }
 
-               [MonoTODO]
-               public override int GetHashCode() {
+#if NET_2_0
+               public static SqlBoolean GreaterThan (SqlBoolean x, SqlBoolean y) 
+               {
+                       return (x > y);
                }
 
-               [MonoTODO]
-               public static SqlBoolean NotEquals(SqlBoolean x, SqlBoolean y) {
+               public static SqlBoolean GreaterThanOrEquals (SqlBoolean x, SqlBoolean y) 
+               {
+                       return (x >= y);
                }
 
-               [MonoTODO]
-               public static SqlBoolean OnesComplement(SqlBoolean x) {
+               public static SqlBoolean LessThan (SqlBoolean x, SqlBoolean y) 
+               {
+                       return (x < y);
                }
 
-               [MonoTODO]
-               public static SqlBoolean Or(SqlBoolean x, SqlBoolean y) {
+               public static SqlBoolean LessThanOrEquals (SqlBoolean x, SqlBoolean y) 
+               {
+                       return (x <= y);
                }
+#endif
+               public override int GetHashCode() 
+               {
+                       int hash;
+                       if (this.IsTrue)
+                               hash = 1;
+                       else 
+                               hash = 0;
 
-               [MonoTODO]
-               public static SqlBoolean Parse(string s) {
+                       return hash;
                }
 
-               [MonoTODO]
-               public SqlByte ToSqlByte() {
+               public static SqlBoolean NotEquals(SqlBoolean x, SqlBoolean y) 
+               {
+                       return (x != y);
+               }
+
+               public static SqlBoolean OnesComplement(SqlBoolean x) 
+               {
+                       return ~x;
+               }
+
+               public static SqlBoolean Or(SqlBoolean x, SqlBoolean y) 
+               {
+                       return (x | y);
+               }
+
+               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));
+               }
+
+               public SqlByte ToSqlByte() 
+               {
+                       return new SqlByte (value);
                }
 
                // **************************************************
                // Conversion from SqlBoolean to other SqlTypes
                // **************************************************
 
-               [MonoTODO]
-               public SqlDecimal ToSqlDecimal() {
+               public SqlDecimal ToSqlDecimal() 
+               {
+                       return ((SqlDecimal)this);
                }
 
-               [MonoTODO]
-               public SqlDouble ToSqlDouble() {
+               public SqlDouble ToSqlDouble() 
+               {
+                       return ((SqlDouble)this);
                }
 
-               [MonoTODO]
-               public SqlInt16 ToSqlInt16() {
+               public SqlInt16 ToSqlInt16() 
+               {
+                       return ((SqlInt16)this);
                }
 
-               [MonoTODO]
-               public SqlInt32 ToSqlInt32() {
+               public SqlInt32 ToSqlInt32() 
+               {
+                       return ((SqlInt32)this);
                }
 
-               [MonoTODO]
-               public SqlInt64 ToSqlInt64() {
+               public SqlInt64 ToSqlInt64() 
+               {
+                       return ((SqlInt64)this);
                }
 
-               [MonoTODO]
-               public SqlMoney ToSqlMoney() {
+               public SqlMoney ToSqlMoney() 
+               {
+                       return ((SqlMoney)this);
                }
 
-               [MonoTODO]
-               public SqlSingle ToSqlSingle() {
+               public SqlSingle ToSqlSingle() 
+               {
+                       return ((SqlSingle)this);
                }
 
-               [MonoTODO]
-               public SqlString ToSqlString() {
+               public SqlString ToSqlString() 
+               {
+                       if (this.IsNull)
+                               return new SqlString ("Null");
+                       if (this.IsTrue)
+                               return new SqlString ("True");
+                       else
+                               return new SqlString ("False");
                }
 
-               [MonoTODO]
-               public override string ToString() {
+               public override string ToString() 
+               {
+                       if (this.IsNull)
+                               return "Null";
+                       if (this.IsTrue)
+                               return "True";
+                       else
+                               return "False";
                }
 
                // Bitwise exclusive-OR (XOR)
-               [MonoTODO]
-               public static SqlBoolean Xor(SqlBoolean x, SqlBoolean y) {
+               public static SqlBoolean Xor(SqlBoolean x, SqlBoolean y) 
+               {
+                       return (x ^ y);
                }
 
                // **************************************************
@@ -182,48 +310,106 @@ namespace System.Data.SqlTypes
                // **************************************************
 
                // Bitwise AND
-               [MonoTODO]
-               public static SqlBoolean operator &(SqlBoolean x, SqlBoolean y) {
+               public static SqlBoolean operator & (SqlBoolean x, SqlBoolean y)
+               {
+                       return new SqlBoolean (x.Value & y.Value);
                }
 
                // Bitwise OR
-               [MonoTODO]
-               public static SqlBoolean operator |(SqlBoolean x, SqlBoolean y) {\r
+               public static SqlBoolean operator | (SqlBoolean x, SqlBoolean y)
+               {
+                       return new SqlBoolean (x.Value | y.Value);
+
                }
 
                // Compares two instances for equality
-               [MonoTODO]
-               public static SqlBoolean operator ==(SqlBoolean x, SqlBoolean y) {
+               public static SqlBoolean operator == (SqlBoolean x, SqlBoolean y)
+               {
+                       if (x.IsNull || y.IsNull) 
+                               return SqlBoolean.Null;
+                       else
+                               return new SqlBoolean (x.Value == y.Value);
                }
                
                // Bitwize exclusive-OR (XOR)
-               [MonoTODO]
-               public static SqlBoolean operator ^(SqlBoolean x, SqlBoolean y) {
+               public static SqlBoolean operator ^ (SqlBoolean x, SqlBoolean y) 
+               {
+                       return new SqlBoolean (x.Value ^ y.Value);
                }
 
                // test Value of SqlBoolean to determine it is false.
-               [MonoTODO]
-               public static bool operator false(SqlBoolean x) {
+               public static bool operator false (SqlBoolean x) 
+               {
+                       return x.IsFalse;
                }
 
                // in-equality
-               [MonoTODO]
-               public static SqlBoolean operator !=(SqlBoolean x, SqlBoolean y) {
+               public static SqlBoolean operator != (SqlBoolean x, SqlBoolean y)
+               {
+                       if (x.IsNull || y.IsNull) 
+                               return SqlBoolean.Null;
+                       else
+                               return new SqlBoolean (x.Value != y.Value);
                }
 
                // Logical NOT
-               [MonoTODO]
-               public static SqlBoolean operator !(SqlBoolean x) {
+               public static SqlBoolean operator ! (SqlBoolean x) 
+               {
+                       if (x.IsNull)
+                               return SqlBoolean.Null;
+                       else
+                               return new SqlBoolean (!x.Value);
                }
 
                // One's Complement
-               [MonoTODO]
-               public static SqlBoolean operator ~(SqlBoolean x) {
+               public static SqlBoolean operator ~ (SqlBoolean x) 
+               {
+                       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
-               [MonoTODO]
-               public static bool operator true(SqlBoolean x) {
+               public static bool operator true (SqlBoolean x) 
+               {
+                       return x.IsTrue;
                }
 
                // ****************************************
@@ -232,59 +418,156 @@ namespace System.Data.SqlTypes
 
                
                // SqlBoolean to Boolean
-               [MonoTODO]
-               public static explicit operator bool(SqlBoolean x) {
+               public static explicit operator bool (SqlBoolean x) 
+               {
+                       return x.Value;
                }
 
                
                // SqlByte to SqlBoolean
-               [MonoTODO]
-               public static explicit operator SqlBoolean(SqlByte x) {
+               public static explicit operator SqlBoolean (SqlByte x) 
+               {
+                       checked {
+                               if (x.IsNull)
+                                       return Null;
+                               else
+                                       return new SqlBoolean ((int)x.Value);
+                       }
                }
 
                // SqlDecimal to SqlBoolean
-               [MonoTODO]
-               public static explicit operator SqlBoolean(SqlDecimal x) {
+               public static explicit operator SqlBoolean (SqlDecimal x) 
+               {
+                       checked {
+                               if (x.IsNull)
+                                       return Null;
+                               else
+                                       return new SqlBoolean ((int)x.Value);
+                       }
                }
                
                // SqlDouble to SqlBoolean
-               [MonoTODO]
-               public static explicit operator SqlBoolean(SqlDouble x) {
+               public static explicit operator SqlBoolean (SqlDouble x) 
+               {
+                       // FIXME
+                       //checked {
+                               if (x.IsNull)
+                                       return Null;
+                               else
+                                       return new SqlBoolean ((int)x.Value);
+                               //}
                }
 
                // SqlInt16 to SqlBoolean
-               [MonoTODO]
-               public static explicit operator SqlBoolean(SqlInt16 x) {
+               public static explicit operator SqlBoolean (SqlInt16 x) 
+               {
+                       checked {
+                               if (x.IsNull)
+                                       return Null;
+                               else
+                                       return new SqlBoolean ((int)x.Value);
+                       }
                }
 
                // SqlInt32 to SqlBoolean
-               [MonoTODO]
-               public static explicit operator SqlBoolean(SqlInt32 x) {
+               public static explicit operator SqlBoolean (SqlInt32 x) 
+               {
+                       checked {
+                               if (x.IsNull)
+                                       return Null;
+                               else
+                                       return new SqlBoolean (x.Value);
+                       }
                }
 
                // SqlInt64 to SqlBoolean
-               [MonoTODO]
-               public static explicit operator SqlBoolean(SqlInt64 x) {
+               public static explicit operator SqlBoolean (SqlInt64 x) 
+               {
+                       checked {
+                               if (x.IsNull)
+                                       return Null;
+                               else
+                                       return new SqlBoolean ((int)x.Value);
+                       }
                }
 
                // SqlMoney to SqlBoolean
-               [MonoTODO]
-               public static explicit operator SqlBoolean(SqlMoney x) {
+               public static explicit operator SqlBoolean (SqlMoney x) 
+               {
+                       checked {
+                               if (x.IsNull)
+                                       return Null;
+                               else
+                                       return new SqlBoolean ((int)x.Value);
+                       }
                }
 
                // SqlSingle to SqlBoolean
-               [MonoTODO]
-               public static explicit operator SqlBoolean(SqlSingle x) {
+               public static explicit operator SqlBoolean (SqlSingle x) 
+               {
+                       // 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) {
+               public static explicit operator SqlBoolean (SqlString x) 
+               {
+                       checked {
+                               if (x.IsNull)
+                                       return Null;
+                               return SqlBoolean.Parse (x.Value);
+                       }
                }
 
                // Boolean to SqlBoolean
+               public static implicit operator SqlBoolean (bool x) 
+               {
+                       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]
-               public static implicit operator SqlBoolean(bool x) {
+               void IXmlSerializable.WriteXml (XmlWriter writer)
+               {
+                       throw new NotImplementedException ();
                }
+#endif
        }
 }