// ======================================================================== // 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; namespace VEPROMS.CSLA.Library { /// /// DocVersionROFstInfoList Generated by MyGeneration using the CSLA Object Mapping template /// [Serializable()] [TypeConverter(typeof(DocVersionROFstInfoListConverter))] public partial class DocVersionROFstInfoList : ReadOnlyListBase, ICustomTypeDescriptor, IDisposable { #region Log4Net private static readonly log4net.ILog _MyLog = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); #endregion #region Business Methods internal new IList Items { get { return base.Items; } } public void AddEvents() { foreach (DocVersionROFstInfo tmp in this) { tmp.Changed += new DocVersionROFstInfoEvent(tmp_Changed); } } void tmp_Changed(object sender) { for (int i = 0; i < Count; i++) { if (base[i] == sender) this.OnListChanged(new ListChangedEventArgs(ListChangedType.ItemChanged, i)); } } public void Dispose() { foreach (DocVersionROFstInfo tmp in this) { tmp.Changed -= new DocVersionROFstInfoEvent(tmp_Changed); } } #endregion #region Factory Methods public static DocVersionROFstInfoList _DocVersionROFstInfoList = null; /// /// Return a list of all projects. /// public static DocVersionROFstInfoList Get() { try { if (_DocVersionROFstInfoList != null) return _DocVersionROFstInfoList; DocVersionROFstInfoList tmp = DataPortal.Fetch(); DocVersionROFstInfo.AddList(tmp); tmp.AddEvents(); _DocVersionROFstInfoList = tmp; return tmp; } catch (Exception ex) { throw new DbCslaException("Error on DocVersionROFstInfoList.Get", ex); } } // TODO: Add alternative gets - //public static DocVersionROFstInfoList Get() //{ // try // { // return DataPortal.Fetch(new FilteredCriteria()); // } // catch (Exception ex) // { // throw new DbCslaException("Error on DocVersionROFstInfoList.Get", ex); // } //} public static DocVersionROFstInfoList GetByVersionID(int versionID) { try { DocVersionROFstInfoList tmp = DataPortal.Fetch(new VersionIDCriteria(versionID)); DocVersionROFstInfo.AddList(tmp); tmp.AddEvents(); return tmp; } catch (Exception ex) { throw new DbCslaException("Error on DocVersionROFstInfoList.GetByVersionID", ex); } } public static DocVersionROFstInfoList GetByROFstID(int rOFstID) { try { DocVersionROFstInfoList tmp = DataPortal.Fetch(new ROFstIDCriteria(rOFstID)); DocVersionROFstInfo.AddList(tmp); tmp.AddEvents(); return tmp; } catch (Exception ex) { throw new DbCslaException("Error on DocVersionROFstInfoList.GetByROFstID", ex); } } private DocVersionROFstInfoList() { /* require use of factory methods */ } #endregion #region Data Access Portal private void DataPortal_Fetch() { this.RaiseListChangedEvents = false; if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] DocVersionROFstInfoList.DataPortal_Fetch", GetHashCode()); try { using (SqlConnection cn = Database.VEPROMS_SqlConnection) { using (SqlCommand cm = cn.CreateCommand()) { cm.CommandType = CommandType.StoredProcedure; cm.CommandText = "getDocVersionROFsts"; using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader())) { IsReadOnly = false; while (dr.Read()) this.Add(new DocVersionROFstInfo(dr)); IsReadOnly = true; } } } } catch (Exception ex) { if (_MyLog.IsErrorEnabled) _MyLog.Error("DocVersionROFstInfoList.DataPortal_Fetch", ex); throw new DbCslaException("DocVersionROFstInfoList.DataPortal_Fetch", ex); } this.RaiseListChangedEvents = true; } [Serializable()] private class VersionIDCriteria { public VersionIDCriteria(int versionID) { _VersionID = versionID; } private int _VersionID; public int VersionID { get { return _VersionID; } set { _VersionID = value; } } } private void DataPortal_Fetch(VersionIDCriteria criteria) { this.RaiseListChangedEvents = false; if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] DocVersionROFstInfoList.DataPortal_FetchVersionID", GetHashCode()); try { using (SqlConnection cn = Database.VEPROMS_SqlConnection) { using (SqlCommand cm = cn.CreateCommand()) { cm.CommandType = CommandType.StoredProcedure; cm.CommandText = "getDocVersionROFstsByVersionID"; cm.Parameters.AddWithValue("@VersionID", criteria.VersionID); using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader())) { IsReadOnly = false; while (dr.Read()) this.Add(new DocVersionROFstInfo(dr)); IsReadOnly = true; } } } } catch (Exception ex) { if (_MyLog.IsErrorEnabled) _MyLog.Error("DocVersionROFstInfoList.DataPortal_FetchVersionID", ex); throw new DbCslaException("DocVersionROFstInfoList.DataPortal_Fetch", ex); } this.RaiseListChangedEvents = true; } [Serializable()] private class ROFstIDCriteria { public ROFstIDCriteria(int rOFstID) { _ROFstID = rOFstID; } private int _ROFstID; public int ROFstID { get { return _ROFstID; } set { _ROFstID = value; } } } private void DataPortal_Fetch(ROFstIDCriteria criteria) { this.RaiseListChangedEvents = false; if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] DocVersionROFstInfoList.DataPortal_FetchROFstID", GetHashCode()); try { using (SqlConnection cn = Database.VEPROMS_SqlConnection) { using (SqlCommand cm = cn.CreateCommand()) { cm.CommandType = CommandType.StoredProcedure; cm.CommandText = "getDocVersionROFstsByROFstID"; cm.Parameters.AddWithValue("@ROFstID", criteria.ROFstID); using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader())) { IsReadOnly = false; while (dr.Read()) this.Add(new DocVersionROFstInfo(dr)); IsReadOnly = true; } } } } catch (Exception ex) { if (_MyLog.IsErrorEnabled) _MyLog.Error("DocVersionROFstInfoList.DataPortal_FetchROFstID", ex); throw new DbCslaException("DocVersionROFstInfoList.DataPortal_Fetch", ex); } 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 DocVersionROFstInfoListPropertyDescriptor pd = new DocVersionROFstInfoListPropertyDescriptor(this, i); pds.Add(pd); } // return the property descriptor collection return pds; } #endregion } // Class #region Property Descriptor /// /// Summary description for CollectionPropertyDescriptor. /// public partial class DocVersionROFstInfoListPropertyDescriptor : vlnListPropertyDescriptor { private DocVersionROFstInfo Item { get { return (DocVersionROFstInfo)_Item; } } public DocVersionROFstInfoListPropertyDescriptor(DocVersionROFstInfoList collection, int index) : base(collection, index) { ;} } #endregion #region Converter internal class DocVersionROFstInfoListConverter : ExpandableObjectConverter { public override object ConvertTo(ITypeDescriptorContext context, System.Globalization.CultureInfo culture, object value, Type destType) { if (destType == typeof(string) && value is DocVersionROFstInfoList) { // Return department and department role separated by comma. return ((DocVersionROFstInfoList)value).Items.Count.ToString() + " DocVersionROFsts"; } return base.ConvertTo(context, culture, value, destType); } } #endregion } // Namespace