using System;

using System.Collections.Generic;

using System.Text;

using System.Data;

using System.Data.Common;



namespace MetX.Data

{

    /// <summary>C#CD: </summary>

    [Serializable]

    public class TableSchema

    {

        /// <summary>C#CD: </summary>

        [Serializable]

        public class TableColumnSettingCollection : Dictionary<string, TableColumnSetting>

        {

            bool Contains(string columnName)

            {

                return this.ContainsKey(columnName.ToLower());

            }



            /// <summary>C#CD: </summary>

            /// <param name="columnName">C#CD: </param>

            /// <returns>C#CD: </returns>

            public object GetValue(string columnName)

            {

                columnName = columnName.ToLower();

                if (this.ContainsKey(columnName))

                    return this[columnName].CurrentValue;

                return null;

            }



            /// <summary>C#CD: </summary>

            /// <param name="columnName">C#CD: </param>

            /// <param name="oVal">C#CD: </param>

            public void SetValue(string columnName, object oVal)

            {

                columnName = columnName.ToLower();

                if (!this.ContainsKey(columnName))

                {

                    TableColumnSetting setting = new TableColumnSetting();

                    setting.ColumnName = columnName;

                    setting.CurrentValue = oVal;

                    this.Add(columnName.ToLower(), setting);

                }

                else

                {

                    this[columnName].CurrentValue = oVal;

                }

            }



        }





        /// <summary>

        /// This is an intermediary class that holds the current value of a table column

        /// for each object instance.

        /// </summary>

        [Serializable]

        public class TableColumnSetting

        {



            /// <summary>C#CD: </summary>

            private string columnName;

            /// <summary>C#CD: </summary>

            public string ColumnName

            {

                get { return columnName; }

                set { columnName = value; }

            }



            /// <summary>C#CD: </summary>

            private object currentValue;

            /// <summary>C#CD: </summary>

            public object CurrentValue

            {

                get { return currentValue; }

                set

                {

                    if (value is int && (int)value == int.MinValue)

                        currentValue = DBNull.Value;

                    else if (value is DateTime && (DateTime)value == DateTime.MinValue)

                        currentValue = DBNull.Value;

                    else

                        currentValue = value;

                }

            }

        }

        /// <summary>

        /// Holds information about the base table - this class should be

        /// static for each object

        /// </summary>

        [Serializable]

        public class Table

        {

            public string Name;

            public TableColumnCollection Columns = new TableColumnCollection();

            public TableIndexCollection Indexes = new TableIndexCollection();

            public TableKeyCollection Keys = new TableKeyCollection();



            public DataProvider Instance;



            /// <summary>The basic INSERT INTO sql statement used for Insert type queries</summary>

            public string INSERT_SQL;

            /// <summary>The basic UPDATE sql statement used for Update type querie</summary>

            public string UPDATE_SQL;

            /// <summary>The basic SELECT sql statement used for Select, Count, Exists and paging type queries</summary>

            public string SELECT_SQL { get { return "SELECT " + FIELD_LIST + " FROM [" + Name + "] "; }  }

            /// <summary>The field list as it goes into the SELECT sql statement used for Select, Count, Exists and paging type queries</summary>

            public string FIELD_LIST;





            /// <summary>C#CD: </summary>

            public Table() { }



            /// <summary>C#CD: </summary>

            /// <param name="tableName">C#CD: </param>

            public Table(string tableName)

            {

                Name = tableName;

            }



            public TableColumn PrimaryKey

            {

                get

                {

                    if (Columns != null)

                        return Columns.GetPrimaryKey();

                    return null;

                }

            }

        }





        [Serializable]

        public class TableIndex

        {

            public string Name;

            public bool IsClustered;

            public List<string> Columns = new List<string>();

            public TableIndex() { }

            public TableIndex(IDataReader rdr)

            {

                this.Name = rdr["name"].ToString();

                this.IsClustered = rdr["isclustered"].ToString() == "1";

                this.Columns.Add(rdr["column"].ToString());

            }

        }





        [Serializable]

        public class TableIndexCollection : List<TableIndex>

        {

            public TableIndexCollection() { }

        }



        [Serializable]

        public class TableKeyCollection : List<TableKey>

        {

            public TableKeyCollection() { }



            public TableKey Find(string ToFind)

            {

                foreach (TableKey CurrKey in this)

                    if(CurrKey.Name.ToLower() == ToFind.ToLower())

                        return CurrKey;

                return null;

            }

        }



        [Serializable]

        public class TableKey

        {

            public string Name;

            public bool IsPrimary;

            public List<TableKeyColumn> Columns = new List<TableKeyColumn>();

            public TableKey() { }

        }



        [Serializable]

        public class TableKeyColumn

        {

            public string Column;

            public string Related;



            public TableKeyColumn() { }

            public TableKeyColumn(string Column, string Related) 

            {

                this.Column = Column;

                this.Related = Related;

            }

        }



        /// <summary>C#CD: </summary>

        [Serializable]

        public class TableColumnCollection : List<TableColumn>

        {

            public TableColumnCollection() { }



            private Dictionary<string, TableColumn> iList = new Dictionary<string, TableColumn>();

            public TableColumn PrimaryKeyColumn = null;



            #region Collection Methods

            public bool Contains(string columnName)

            {

                return iList.ContainsKey(columnName.ToLower());

            }



            public new void Add(TableColumn column)

            {

                iList.Add(column.ColumnName.ToLower(), column);

                base.Add(column);

            }



            /// <summary>C#CD: </summary>

            /// <param name="name">C#CD: </param>

            /// <param name="dbType">C#CD: </param>

            /// <param name="isNullable">C#CD: </param>

            /// <param name="isPrimaryKey">C#CD: </param>

            /// <param name="isForeignKey">C#CD: </param>

            public void Add(string name, DbType dbType, bool isNullable, bool isPrimaryKey, bool isForeignKey)

            {

                TableColumn col = new TableColumn();

                col.IsPrimaryKey = isPrimaryKey;

                col.IsForiegnKey = isForeignKey;

                col.IsNullable = isNullable;

                col.DataType = dbType;

                col.ColumnName = name;



                if (!Contains(name))

                {

                    Add(col);

                    iList.Add(name.ToLower(), col);

                }

                if (isPrimaryKey)

                    PrimaryKeyColumn = col;

            }

            /// <summary>C#CD: </summary>

            /// <param name="name">C#CD: </param>

            /// <param name="dbType">C#CD: </param>

            /// <param name="isNullable">C#CD: </param>

            public void Add(string name, DbType dbType, bool isNullable)

            {

                Add(name, dbType, isNullable, false, false);

            }





            #endregion



            /// <summary>C#CD: </summary>

            /// <param name="columnName">C#CD: </param>

            public TableColumn GetColumn(string columnName)

            {

                columnName = columnName.ToLower();

                if (iList.ContainsKey(columnName))

                    return iList[columnName];

                return null;

            }



            /// <summary>C#CD: </summary>

            public TableColumn GetPrimaryKey()

            {

                if (PrimaryKeyColumn != null)

                    return PrimaryKeyColumn;



                TableColumn coll = null;

                foreach (TableColumn child in this)

                {

                    if (child.IsPrimaryKey)

                    {

                        coll = child;

                        break;

                    }

                }

                PrimaryKeyColumn = this[0];

                return coll;

            }



        }



        /// <summary>

        /// A helper class to help define the columns in an underlying table

        /// </summary>

        [Serializable]

        public class TableColumn

        {

            public bool IsForiegnKey;

            public bool IsPrimaryKey;

            public bool IsNullable;

            public bool IsIdentity;

            public DbType DataType;

            public int MaxLength;

            public string ColumnName;

            public bool AutoIncrement;

            public bool IsIndexed;



            /// <summary>C#CD: </summary>

            public TableColumn(){ }



            /// <summary>C#CD: </summary>

            /// <param name="columnName">C#CD: </param>

            /// <param name="dbType">C#CD: </param>

            /// <param name="isPrimaryKey">C#CD: </param>

            /// <param name="isForeignKey">C#CD: </param>

            public TableColumn(string columnName, DbType dbType, bool isPrimaryKey, bool isForeignKey)

            {

                this.ColumnName = columnName;

                this.IsPrimaryKey = isPrimaryKey;

                this.IsForiegnKey = isForeignKey;

                this.DataType = dbType;

            }



            public TableColumn(string columnName, DbType dbType, bool AutoIncrement, int MaxLength, bool IsNullable, bool isPrimaryKey, bool isForeignKey)

            {

                this.ColumnName = columnName;

                this.IsPrimaryKey = isPrimaryKey;

                this.IsForiegnKey = isForeignKey;

                this.DataType = dbType;

                this.AutoIncrement = AutoIncrement;

                this.MaxLength = MaxLength;

                this.IsNullable = IsNullable;

            }

        }

    }

}