469 lines
14 KiB
C#
469 lines
14 KiB
C#
// ========================================================================
|
|
// 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
|
|
{
|
|
/// <summary>
|
|
/// RoUsageInfoList Generated by MyGeneration using the CSLA Object Mapping template
|
|
/// </summary>
|
|
[Serializable()]
|
|
[TypeConverter(typeof(RoUsageInfoListConverter))]
|
|
public partial class RoUsageInfoList : ReadOnlyListBase<RoUsageInfoList, RoUsageInfo>, 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<RoUsageInfo> Items
|
|
{ get { return base.Items; } }
|
|
public void AddEvents()
|
|
{
|
|
foreach (RoUsageInfo tmp in this)
|
|
{
|
|
tmp.Changed += new RoUsageInfoEvent(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));
|
|
}
|
|
}
|
|
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; } }
|
|
~RoUsageInfoList()
|
|
{
|
|
_CountFinalized++;
|
|
}
|
|
public void Dispose()
|
|
{
|
|
if (_Disposed) return;
|
|
_CountDisposed++;
|
|
_Disposed = true;
|
|
foreach (RoUsageInfo tmp in this)
|
|
{
|
|
tmp.Changed -= new RoUsageInfoEvent(tmp_Changed);
|
|
}
|
|
}
|
|
#endregion
|
|
#region Factory Methods
|
|
public static RoUsageInfoList _RoUsageInfoList = null;
|
|
/// <summary>
|
|
/// Return a list of all RoUsageInfo.
|
|
/// </summary>
|
|
public static RoUsageInfoList Get()
|
|
{
|
|
try
|
|
{
|
|
if (_RoUsageInfoList != null)
|
|
return _RoUsageInfoList;
|
|
RoUsageInfoList tmp = DataPortal.Fetch<RoUsageInfoList>();
|
|
RoUsageInfo.AddList(tmp);
|
|
tmp.AddEvents();
|
|
_RoUsageInfoList = tmp;
|
|
return tmp;
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw new DbCslaException("Error on RoUsageInfoList.Get", ex);
|
|
}
|
|
}
|
|
//public static RoUsageInfoList GetByFolder(FolderInfo fi)
|
|
//{
|
|
//}
|
|
public static RoUsageInfoList GetByDocVersion(DocVersionInfo dvi)
|
|
{
|
|
try
|
|
{
|
|
//if (_RoUsageInfoList != null)
|
|
// return _RoUsageInfoList;
|
|
RoUsageInfoList tmp = DataPortal.Fetch<RoUsageInfoList>(new VersionIDCriteria(dvi.VersionID));
|
|
RoUsageInfo.AddList(tmp);
|
|
tmp.AddEvents();
|
|
_RoUsageInfoList = tmp;
|
|
return tmp;
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw new DbCslaException("Error on RoUsageInfoList.Get", ex);
|
|
}
|
|
}
|
|
public static RoUsageInfoList GetByProcedure(ProcedureInfo pi)
|
|
{
|
|
try
|
|
{
|
|
//if (_RoUsageInfoList != null)
|
|
// return _RoUsageInfoList;
|
|
RoUsageInfoList tmp = DataPortal.Fetch<RoUsageInfoList>(new ItemIDCriteria(pi.ItemID));
|
|
RoUsageInfo.AddList(tmp);
|
|
tmp.AddEvents();
|
|
_RoUsageInfoList = tmp;
|
|
return tmp;
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw new DbCslaException("Error on RoUsageInfoList.Get", ex);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Reset the list of all RoUsageInfo.
|
|
/// </summary>
|
|
public static void Reset()
|
|
{
|
|
_RoUsageInfoList = null;
|
|
}
|
|
// CSLATODO: Add alternative gets -
|
|
//public static RoUsageInfoList Get(<criteria>)
|
|
//{
|
|
// try
|
|
// {
|
|
// return DataPortal.Fetch<RoUsageInfoList>(new FilteredCriteria(<criteria>));
|
|
// }
|
|
// catch (Exception ex)
|
|
// {
|
|
// throw new DbCslaException("Error on RoUsageInfoList.Get", ex);
|
|
// }
|
|
//}
|
|
public static RoUsageInfoList GetByContentID(int contentID)
|
|
{
|
|
try
|
|
{
|
|
RoUsageInfoList tmp = DataPortal.Fetch<RoUsageInfoList>(new ContentIDCriteria(contentID));
|
|
RoUsageInfo.AddList(tmp);
|
|
tmp.AddEvents();
|
|
return tmp;
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw new DbCslaException("Error on RoUsageInfoList.GetByContentID", ex);
|
|
}
|
|
}
|
|
public static RoUsageInfoList GetByRODbID(int rODbID)
|
|
{
|
|
try
|
|
{
|
|
RoUsageInfoList tmp = DataPortal.Fetch<RoUsageInfoList>(new RODbIDCriteria(rODbID));
|
|
RoUsageInfo.AddList(tmp);
|
|
tmp.AddEvents();
|
|
return tmp;
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw new DbCslaException("Error on RoUsageInfoList.GetByRODbID", ex);
|
|
}
|
|
}
|
|
private RoUsageInfoList()
|
|
{ /* require use of factory methods */ }
|
|
#endregion
|
|
#region Data Access Portal
|
|
[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}] RoUsageInfoList.DataPortal_Fetch", GetHashCode());
|
|
try
|
|
{
|
|
using (SqlConnection cn = Database.VEPROMS_SqlConnection)
|
|
{
|
|
using (SqlCommand cm = cn.CreateCommand())
|
|
{
|
|
cm.CommandType = CommandType.StoredProcedure;
|
|
cm.CommandText = "getRoUsagesForDocVersion";
|
|
cm.Parameters.AddWithValue("@VersionID", criteria.VersionID);
|
|
cm.CommandTimeout = Database.DefaultTimeout;
|
|
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
|
|
{
|
|
IsReadOnly = false;
|
|
while (dr.Read()) this.Add(new RoUsageInfo(dr));
|
|
IsReadOnly = true;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
if (_MyLog.IsErrorEnabled) _MyLog.Error("RoUsageInfoList.DataPortal_Fetch", ex);
|
|
throw new DbCslaException("RoUsageInfoList.DataPortal_Fetch", ex);
|
|
}
|
|
this.RaiseListChangedEvents = true;
|
|
}
|
|
[Serializable()]
|
|
private class ItemIDCriteria
|
|
{
|
|
public ItemIDCriteria(int itemID)
|
|
{
|
|
_ItemID = itemID;
|
|
}
|
|
private int _ItemID;
|
|
public int ItemID
|
|
{
|
|
get { return _ItemID; }
|
|
set { _ItemID = value; }
|
|
}
|
|
}
|
|
private void DataPortal_Fetch(ItemIDCriteria criteria)
|
|
{
|
|
this.RaiseListChangedEvents = false;
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] RoUsageInfoList.DataPortal_Fetch", GetHashCode());
|
|
try
|
|
{
|
|
using (SqlConnection cn = Database.VEPROMS_SqlConnection)
|
|
{
|
|
using (SqlCommand cm = cn.CreateCommand())
|
|
{
|
|
cm.CommandType = CommandType.StoredProcedure;
|
|
cm.CommandText = "getRoUsagesForProc";
|
|
cm.Parameters.AddWithValue("@ItemID", criteria.ItemID);
|
|
cm.CommandTimeout = Database.DefaultTimeout;
|
|
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
|
|
{
|
|
IsReadOnly = false;
|
|
while (dr.Read()) this.Add(new RoUsageInfo(dr));
|
|
IsReadOnly = true;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
if (_MyLog.IsErrorEnabled) _MyLog.Error("RoUsageInfoList.DataPortal_Fetch", ex);
|
|
throw new DbCslaException("RoUsageInfoList.DataPortal_Fetch", ex);
|
|
}
|
|
this.RaiseListChangedEvents = true;
|
|
}
|
|
private void DataPortal_Fetch()
|
|
{
|
|
this.RaiseListChangedEvents = false;
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] RoUsageInfoList.DataPortal_Fetch", GetHashCode());
|
|
try
|
|
{
|
|
using (SqlConnection cn = Database.VEPROMS_SqlConnection)
|
|
{
|
|
using (SqlCommand cm = cn.CreateCommand())
|
|
{
|
|
cm.CommandType = CommandType.StoredProcedure;
|
|
cm.CommandText = "getRoUsages";
|
|
cm.CommandTimeout = Database.DefaultTimeout;
|
|
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
|
|
{
|
|
IsReadOnly = false;
|
|
while (dr.Read()) this.Add(new RoUsageInfo(dr));
|
|
IsReadOnly = true;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
if (_MyLog.IsErrorEnabled) _MyLog.Error("RoUsageInfoList.DataPortal_Fetch", ex);
|
|
throw new DbCslaException("RoUsageInfoList.DataPortal_Fetch", ex);
|
|
}
|
|
this.RaiseListChangedEvents = true;
|
|
}
|
|
[Serializable()]
|
|
private class ContentIDCriteria
|
|
{
|
|
public ContentIDCriteria(int contentID)
|
|
{
|
|
_ContentID = contentID;
|
|
}
|
|
private int _ContentID;
|
|
public int ContentID
|
|
{
|
|
get { return _ContentID; }
|
|
set { _ContentID = value; }
|
|
}
|
|
}
|
|
private void DataPortal_Fetch(ContentIDCriteria criteria)
|
|
{
|
|
this.RaiseListChangedEvents = false;
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] RoUsageInfoList.DataPortal_FetchContentID", GetHashCode());
|
|
try
|
|
{
|
|
using (SqlConnection cn = Database.VEPROMS_SqlConnection)
|
|
{
|
|
using (SqlCommand cm = cn.CreateCommand())
|
|
{
|
|
cm.CommandType = CommandType.StoredProcedure;
|
|
cm.CommandText = "getRoUsagesByContentID";
|
|
cm.Parameters.AddWithValue("@ContentID", criteria.ContentID);
|
|
cm.CommandTimeout = Database.DefaultTimeout;
|
|
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
|
|
{
|
|
IsReadOnly = false;
|
|
while (dr.Read()) this.Add(new RoUsageInfo(dr));
|
|
IsReadOnly = true;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
if (_MyLog.IsErrorEnabled) _MyLog.Error("RoUsageInfoList.DataPortal_FetchContentID", ex);
|
|
throw new DbCslaException("RoUsageInfoList.DataPortal_Fetch", ex);
|
|
}
|
|
this.RaiseListChangedEvents = true;
|
|
}
|
|
[Serializable()]
|
|
private class RODbIDCriteria
|
|
{
|
|
public RODbIDCriteria(int rODbID)
|
|
{
|
|
_RODbID = rODbID;
|
|
}
|
|
private int _RODbID;
|
|
public int RODbID
|
|
{
|
|
get { return _RODbID; }
|
|
set { _RODbID = value; }
|
|
}
|
|
}
|
|
private void DataPortal_Fetch(RODbIDCriteria criteria)
|
|
{
|
|
this.RaiseListChangedEvents = false;
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] RoUsageInfoList.DataPortal_FetchRODbID", GetHashCode());
|
|
try
|
|
{
|
|
using (SqlConnection cn = Database.VEPROMS_SqlConnection)
|
|
{
|
|
using (SqlCommand cm = cn.CreateCommand())
|
|
{
|
|
cm.CommandType = CommandType.StoredProcedure;
|
|
cm.CommandText = "getRoUsagesByRODbID";
|
|
cm.Parameters.AddWithValue("@RODbID", criteria.RODbID);
|
|
cm.CommandTimeout = Database.DefaultTimeout;
|
|
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
|
|
{
|
|
IsReadOnly = false;
|
|
while (dr.Read()) this.Add(new RoUsageInfo(dr));
|
|
IsReadOnly = true;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
if (_MyLog.IsErrorEnabled) _MyLog.Error("RoUsageInfoList.DataPortal_FetchRODbID", ex);
|
|
throw new DbCslaException("RoUsageInfoList.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; }
|
|
/// <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
|
|
RoUsageInfoListPropertyDescriptor pd = new RoUsageInfoListPropertyDescriptor(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 RoUsageInfoListPropertyDescriptor : vlnListPropertyDescriptor
|
|
{
|
|
private RoUsageInfo Item { get { return (RoUsageInfo)_Item; } }
|
|
public RoUsageInfoListPropertyDescriptor(RoUsageInfoList collection, int index) : base(collection, index) { ;}
|
|
}
|
|
#endregion
|
|
#region Converter
|
|
internal class RoUsageInfoListConverter : ExpandableObjectConverter
|
|
{
|
|
public override object ConvertTo(ITypeDescriptorContext context, System.Globalization.CultureInfo culture, object value, Type destType)
|
|
{
|
|
if (destType == typeof(string) && value is RoUsageInfoList)
|
|
{
|
|
// Return department and department role separated by comma.
|
|
return ((RoUsageInfoList)value).Items.Count.ToString() + " RoUsages";
|
|
}
|
|
return base.ConvertTo(context, culture, value, destType);
|
|
}
|
|
}
|
|
#endregion
|
|
} // Namespace
|