// ======================================================================== // 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 Csla.Validation; namespace VEPROMS.CSLA.Library { /// /// ChildFolders Generated by MyGeneration using the CSLA Object Mapping template /// [Serializable()] [TypeConverter(typeof(ChildFoldersConverter))] public partial class ChildFolders : BusinessListBase, ICustomTypeDescriptor, IVEHasBrokenRules { #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 new Folder this[int folderID] { get { foreach (Folder folder in this) if (folder.FolderID == folderID) return folder; return null; } } public new System.Collections.Generic.IList Items { get { return base.Items; } } public Folder GetItem(int folderID) { foreach (Folder folder in this) if (folder.FolderID == folderID) return folder; return null; } public Folder Add(Folder myParent, string name, string shortName) // One to Many with unique fields { if (!Contains(name)) { Folder folder = Folder.New(myParent, name, shortName); this.Add(folder); return folder; } else throw new InvalidOperationException("folder already exists"); } public void Remove(int folderID) { foreach (Folder folder in this) { if (folder.FolderID == folderID) { Remove(folder); break; } } } public bool Contains(int folderID) { foreach (Folder folder in this) if (folder.FolderID == folderID) return true; return false; } public bool ContainsDeleted(int folderID) { foreach (Folder folder in DeletedList) if (folder.FolderID == folderID) return true; return false; } public bool Contains(string name) { foreach (Folder folder in this) if (folder.Name == name) return true; return false; } public bool ContainsDeleted(string name) { foreach (Folder folder in DeletedList) if (folder.Name == name) return true; return false; } #endregion #region ValidationRules public IVEHasBrokenRules HasBrokenRules { get { IVEHasBrokenRules hasBrokenRules = null; foreach (Folder folder in this) if ((hasBrokenRules = folder.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 ChildFolders New() { return new ChildFolders(); } internal static ChildFolders Get(SafeDataReader dr, Folder parent) { return new ChildFolders(dr, parent); } public static ChildFolders GetByParentID(int parentID) { try { return DataPortal.Fetch(new ParentIDCriteria(parentID)); } catch (Exception ex) { throw new DbCslaException("Error on ChildFolders.GetByParentID", ex); } } private ChildFolders() { MarkAsChild(); } internal ChildFolders(SafeDataReader dr, Folder parent) { MarkAsChild(); Fetch(dr, parent); } #endregion #region Data Access Portal // called to load data from the database private void Fetch(SafeDataReader dr, Folder parent) { this.RaiseListChangedEvents = false; while (dr.Read()) this.Add(Folder.Get(dr, parent)); this.RaiseListChangedEvents = true; } [Serializable()] private class ParentIDCriteria { public ParentIDCriteria(int parentID) { _ParentID = parentID; } private int _ParentID; public int ParentID { get { return _ParentID; } set { _ParentID = value; } } } private void DataPortal_Fetch(ParentIDCriteria criteria) { this.RaiseListChangedEvents = false; if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] ChildFolders.DataPortal_FetchParentID", GetHashCode()); try { using (SqlConnection cn = Database.VEPROMS_SqlConnection) { using (SqlCommand cm = cn.CreateCommand()) { cm.CommandType = CommandType.StoredProcedure; cm.CommandText = "getChildFolders"; cm.Parameters.AddWithValue("@ParentID", criteria.ParentID); using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader())) { while (dr.Read()) this.Add(new Folder(dr, criteria.ParentID)); } } } } catch (Exception ex) { if (_MyLog.IsErrorEnabled) _MyLog.Error("ChildFolders.DataPortal_FetchParentID", ex); throw new DbCslaException("ChildFolders.DataPortal_Fetch", ex); } this.RaiseListChangedEvents = true; } internal void Update(Folder folder) { this.RaiseListChangedEvents = false; try { // update (thus deleting) any deleted child objects foreach (Folder obj in DeletedList) obj.DeleteSelf(folder);// Deletes related record // now that they are deleted, remove them from memory too DeletedList.Clear(); // add/update any current child objects foreach (Folder obj in this) { if (obj.IsNew) obj.SQLInsert(); else obj.SQLUpdate(); } } 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; } /// /// Called to get the properties of this type. Returns properties with certain /// attributes. this restriction is not implemented here. /// /// /// public PropertyDescriptorCollection GetProperties(Attribute[] attributes) { return GetProperties(); } /// /// Called to get the properties of this type. /// /// 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 ChildFoldersPropertyDescriptor pd = new ChildFoldersPropertyDescriptor(this, i); pds.Add(pd); } // return the property descriptor collection return pds; } #endregion } // Class #region Property Descriptor /// /// Summary description for CollectionPropertyDescriptor. /// public partial class ChildFoldersPropertyDescriptor : vlnListPropertyDescriptor { private Folder Item { get { return (Folder)_Item; } } public ChildFoldersPropertyDescriptor(ChildFolders collection, int index) : base(collection, index) { ;} } #endregion #region Converter internal class ChildFoldersConverter : ExpandableObjectConverter { public override object ConvertTo(ITypeDescriptorContext context, System.Globalization.CultureInfo culture, object value, Type destType) { if (destType == typeof(string) && value is ChildFolders) { // Return department and department role separated by comma. return ((ChildFolders)value).Items.Count.ToString() + " Folders"; } return base.ConvertTo(context, culture, value, destType); } } #endregion } // Namespace