// ========================================================================
// Copyright 2007 - Volian Enterprises, Inc. All rights reserved.          
// Volian Enterprises - Proprietary Information - DO NOT COPY OR DISTRIBUTE
// ------------------------------------------------------------------------
// $Workfile: $     $Revision: $                                           
// $Author: $   $Date: $                                                   
//                                                                         
// $History: $                                                             
// ========================================================================

using System;
using System.Data;
using System.Data.SqlClient;
using Csla;
using Csla.Data;
using System.Configuration;
using System.IO;
using System.ComponentModel;
using System.Collections.Generic;
using Csla.Validation;
namespace VEPROMS.CSLA.Library
{
	/// <summary>
	///	ConnectionFolders Generated by MyGeneration using the CSLA Object Mapping template
	/// </summary>
	[Serializable()]
	[TypeConverter(typeof(ConnectionFoldersConverter))]
	public partial class ConnectionFolders : BusinessListBase<ConnectionFolders, ConnectionFolder>, ICustomTypeDescriptor, IVEHasBrokenRules , IDisposable
	{
		#region Log4Net
		private static readonly log4net.ILog _MyLog = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
		#endregion
		#region Business Methods
		private string _ErrorMessage = string.Empty;
		public string ErrorMessage
		{
			get { return _ErrorMessage; }
		}
		// One To Many
		public ConnectionFolder this[Folder myFolder]
		{
			get
			{
				foreach (ConnectionFolder folder in this)
					if (folder.FolderID == myFolder.FolderID)
						return folder;
				return null;
			}
		}
		public new System.Collections.Generic.IList<ConnectionFolder> Items
		{
			get { return base.Items; }
		}
		public ConnectionFolder GetItem(Folder myFolder)
		{
			foreach (ConnectionFolder folder in this)
				if (folder.FolderID == myFolder.FolderID)
					return folder;
			return null;
		}
		public ConnectionFolder Add(Folder myParent, string name, string shortName) // One to Many 
		{
			ConnectionFolder folder = ConnectionFolder.New(myParent, name, shortName);
			this.Add(folder);
			return folder;
		}
		public void Remove(Folder myFolder)
		{
			foreach (ConnectionFolder folder in this)
			{
				if (folder.FolderID == myFolder.FolderID)
				{
					Remove(folder);
					break;
				}
			}
		}
		public bool Contains(Folder myFolder)
		{
			foreach (ConnectionFolder folder in this)
				if (folder.FolderID == myFolder.FolderID)
					return true;
			return false;
		}
		public bool ContainsDeleted(Folder myFolder)
		{
			foreach (ConnectionFolder folder in DeletedList)
				if (folder.FolderID == myFolder.FolderID)
					return true;
			return false;
		}
		public bool IsDirtyList(List<object> list)
		{
			// any non-new deletions make us dirty
			foreach (ConnectionFolder item in DeletedList)
				if (!item.IsNew)
					return true;
			// run through all the child objects
			// and if any are dirty then then
			// collection is dirty
			foreach (ConnectionFolder child in this)
				if (child.IsDirtyList(list))
					return true;
			return false;
		}
		public override bool IsValid
		{
			get { return IsValidList(new List<object>()); }
		}
		public bool IsValidList(List<object> list)
    {
      // run through all the child objects
      // and if any are invalid then the
      // collection is invalid
      foreach (ConnectionFolder child in this)
				if (!child.IsValidList(list))
				{
					//Console.WriteLine("Valid {0} Child {1} - {2}", child.IsValid, child.GetType().Name,child.ToString());
					return false;
				}
       return true;
     }
		#endregion
		#region ValidationRules
		public IVEHasBrokenRules HasBrokenRules
		{
			get
			{
				IVEHasBrokenRules hasBrokenRules = null;
				foreach (ConnectionFolder connectionFolder in this)
					if ((hasBrokenRules = connectionFolder.HasBrokenRules) != null) return hasBrokenRules;
				return hasBrokenRules;
			}
		}
		public BrokenRulesCollection BrokenRules
		{
			get
			{
				IVEHasBrokenRules hasBrokenRules = HasBrokenRules;
				return (hasBrokenRules != null ? hasBrokenRules.BrokenRules : null);
			}
		}
		#endregion
		#region Factory Methods
		internal static ConnectionFolders New()
		{
			return new ConnectionFolders();
		}
		internal static ConnectionFolders Get(SafeDataReader dr)
		{
			return new ConnectionFolders(dr);
		}
		public static ConnectionFolders GetByDBID(int dbid)
		{
			try
			{
				return DataPortal.Fetch<ConnectionFolders>(new DBIDCriteria(dbid));
			}
			catch (Exception ex)
			{
				throw new DbCslaException("Error on ConnectionFolders.GetByDBID", ex);
			}
		}
		private ConnectionFolders()
		{
			MarkAsChild();
		}
		internal ConnectionFolders(SafeDataReader dr)
		{
			MarkAsChild();
			Fetch(dr);
		}
		private bool _Disposed = false;
		private static int _CountCreated = 0;
		private static int _CountDisposed = 0;
		private static int _CountFinalized = 0;
		private static int IncrementCountCreated
		{ get { return ++_CountCreated; } }
		private int _CountWhenCreated = IncrementCountCreated;
		public static int CountCreated
		{ get { return _CountCreated; } }
		public static int CountNotDisposed
		{ get { return _CountCreated - _CountDisposed; } }
		public static int CountNotFinalized
		{ get { return _CountCreated - _CountFinalized; } }
		~ConnectionFolders()
		{
			_CountFinalized++;
		}
		public void Dispose()
		{
			if (_Disposed) return;
			_CountDisposed++;
			_Disposed = true;
		}
		#endregion
		#region Data Access Portal
		// called to load data from the database
		private void Fetch(SafeDataReader dr)
		{
			this.RaiseListChangedEvents = false;
			while (dr.Read())
				this.Add(ConnectionFolder.Get(dr));
			this.RaiseListChangedEvents = true;
		}
		[Serializable()]
		private class DBIDCriteria
		{
			public DBIDCriteria(int dbid)
			{
				_DBID = dbid;
			}
			private int _DBID;
			public int DBID
			{
				get { return _DBID; }
				set { _DBID = value; }
			}
		}
		private void DataPortal_Fetch(DBIDCriteria criteria)
		{
			this.RaiseListChangedEvents = false;
			if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] ConnectionFolders.DataPortal_FetchDBID", GetHashCode());
			try
			{
				using (SqlConnection cn = Database.VEPROMS_SqlConnection)
				{
					using (SqlCommand cm = cn.CreateCommand())
					{
						cm.CommandType = CommandType.StoredProcedure;
						cm.CommandText = "getFoldersByDBID";
						cm.Parameters.AddWithValue("@DBID", criteria.DBID);
						cm.CommandTimeout = Database.DefaultTimeout;
						using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
						{
							while (dr.Read()) this.Add(new ConnectionFolder(dr));
						}
					}
				}
			}
			catch (Exception ex)
			{
				if (_MyLog.IsErrorEnabled) _MyLog.Error("ConnectionFolders.DataPortal_FetchDBID", ex);
				throw new DbCslaException("ConnectionFolders.DataPortal_Fetch", ex);
			}
			this.RaiseListChangedEvents = true;
		}
		internal void Update(Connection connection)
		{
			this.RaiseListChangedEvents = false;
			try
			{
				// update (thus deleting) any deleted child objects
				foreach (ConnectionFolder obj in DeletedList)
					obj.DeleteSelf(connection);// Deletes related record
				// now that they are deleted, remove them from memory too
				DeletedList.Clear();
				// add/update any current child objects
				foreach (ConnectionFolder obj in this)
				{
					if (obj.IsNew)
						obj.Insert(connection);
					else
						obj.Update(connection);
				}
			}
			finally
			{
				this.RaiseListChangedEvents = true;
			}
		}
		#endregion
		#region ICustomTypeDescriptor impl
		public String GetClassName()
		{ return TypeDescriptor.GetClassName(this, true); }
		public AttributeCollection GetAttributes()
		{ return TypeDescriptor.GetAttributes(this, true); }
		public String GetComponentName()
		{ return TypeDescriptor.GetComponentName(this, true); }
		public TypeConverter GetConverter()
		{ return TypeDescriptor.GetConverter(this, true); }
		public EventDescriptor GetDefaultEvent()
		{ return TypeDescriptor.GetDefaultEvent(this, true); }
		public PropertyDescriptor GetDefaultProperty()
		{ return TypeDescriptor.GetDefaultProperty(this, true); }
		public object GetEditor(Type editorBaseType)
		{ return TypeDescriptor.GetEditor(this, editorBaseType, true); }
		public EventDescriptorCollection GetEvents(Attribute[] attributes)
		{ return TypeDescriptor.GetEvents(this, attributes, true); }
		public EventDescriptorCollection GetEvents()
		{ return TypeDescriptor.GetEvents(this, true); }
		public object GetPropertyOwner(PropertyDescriptor pd)
		{ return this; }
		/// <summary>
		/// Called to get the properties of this type. Returns properties with certain
		/// attributes. this restriction is not implemented here.
		/// </summary>
		/// <param name="attributes"></param>
		/// <returns></returns>
		public PropertyDescriptorCollection GetProperties(Attribute[] attributes)
		{ return GetProperties(); }
		/// <summary>
		/// Called to get the properties of this type.
		/// </summary>
		/// <returns></returns>
		public PropertyDescriptorCollection GetProperties()
		{
			// Create a collection object to hold property descriptors
			PropertyDescriptorCollection pds = new PropertyDescriptorCollection(null);
			// Iterate the list 
			for (int i = 0; i < this.Items.Count; i++)
			{
				// Create a property descriptor for the item and add to the property descriptor collection
				ConnectionFoldersPropertyDescriptor pd = new ConnectionFoldersPropertyDescriptor(this, i);
				pds.Add(pd);
			}
			// return the property descriptor collection
			return pds;
		}
		#endregion
	} // Class
	#region Property Descriptor
	/// <summary>
	/// Summary description for CollectionPropertyDescriptor.
	/// </summary>
	public partial class ConnectionFoldersPropertyDescriptor : vlnListPropertyDescriptor
	{
		private ConnectionFolder Item { get { return (ConnectionFolder)_Item; } }
		public ConnectionFoldersPropertyDescriptor(ConnectionFolders collection, int index) : base(collection, index) { ;}
	}
	#endregion
	#region Converter
	internal class ConnectionFoldersConverter : ExpandableObjectConverter
	{
		public override object ConvertTo(ITypeDescriptorContext context, System.Globalization.CultureInfo culture, object value, Type destType)
		{
			if (destType == typeof(string) && value is ConnectionFolders)
			{
				// Return department and department role separated by comma.
				return ((ConnectionFolders)value).Items.Count.ToString() + " Folders";
			}
			return base.ConvertTo(context, culture, value, destType);
		}
	}
	#endregion
} // Namespace