using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Tango.PPC.Shared.SQL
{
    /// <summary>
    /// Represents a <see cref="RemoteSqlDataSet"/> columns collection.
    /// </summary>
    /// <seealso cref="System.Collections.ObjectModel.Collection{Tango.PPC.Shared.SQL.RemoteSqlColumn}" />
    public class RemoteSqlColumnCollection : Collection<RemoteSqlColumn>
    {
        private Dictionary<String, RemoteSqlColumn> _dictionary;

        /// <summary>
        /// Initializes a new instance of the <see cref="RemoteSqlColumnCollection"/> class.
        /// </summary>
        public RemoteSqlColumnCollection()
        {
            _dictionary = new Dictionary<string, RemoteSqlColumn>();
        }

        /// <summary>
        /// Inserts an element into the <see cref="T:System.Collections.ObjectModel.Collection`1" /> at the specified index.
        /// </summary>
        /// <param name="index">The zero-based index at which <paramref name="item" /> should be inserted.</param>
        /// <param name="item">The object to insert. The value can be null for reference types.</param>
        protected override void InsertItem(int index, RemoteSqlColumn item)
        {
            item.Index = Count;
            _dictionary.Add(item.Name, item);
            base.InsertItem(index, item);
        }

        /// <summary>
        /// Removes the element at the specified index of the <see cref="T:System.Collections.ObjectModel.Collection`1" />.
        /// </summary>
        /// <param name="index">The zero-based index of the element to remove.</param>
        /// <exception cref="NotSupportedException"></exception>
        protected override void RemoveItem(int index)
        {
            throw new NotSupportedException();
        }

        /// <summary>
        /// Removes all elements from the <see cref="T:System.Collections.ObjectModel.Collection`1" />.
        /// </summary>
        protected override void ClearItems()
        {
            _dictionary.Clear();
            base.ClearItems();
        }

        /// <summary>
        /// Replaces the element at the specified index.
        /// </summary>
        /// <param name="index">The zero-based index of the element to replace.</param>
        /// <param name="item">The new value for the element at the specified index. The value can be null for reference types.</param>
        /// <exception cref="NotSupportedException"></exception>
        protected override void SetItem(int index, RemoteSqlColumn item)
        {
            throw new NotSupportedException();
        }

        /// <summary>
        /// Gets the column index by column name.
        /// </summary>
        /// <param name="columnName">Column name.</param>
        /// <returns></returns>
        public int GetIndexOf(String columnName)
        {
            return _dictionary[columnName].Index;
        }
    }
}