mschill
378653c536
The purpose of this upgrade is to improve the user experience when using the Admin tool to Update ROs. Currently for larger RO dbs (like Barakah) we can run up against memory constraints that do not allow all the ROs to be updated at one time. This is based upon some initial resource where some places were identified where we could improve memory usage. Some of these should benefit PROMS as a whole while others will be specific to the RO Update option in Admin Tools.
410 lines
16 KiB
C#
410 lines
16 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
|
|
{
|
|
public delegate void GroupInfoEvent(object sender);
|
|
/// <summary>
|
|
/// GroupInfo Generated by MyGeneration using the CSLA Object Mapping template
|
|
/// </summary>
|
|
[Serializable()]
|
|
[TypeConverter(typeof(GroupInfoConverter))]
|
|
public partial class GroupInfo : ReadOnlyBase<GroupInfo>, IDisposable
|
|
{
|
|
public event GroupInfoEvent Changed;
|
|
private void OnChange()
|
|
{
|
|
if (Changed != null) Changed(this);
|
|
}
|
|
#region Log4Net
|
|
private static readonly log4net.ILog _MyLog = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
|
|
#endregion
|
|
#region Collection
|
|
private static List<GroupInfo> _CacheList = new List<GroupInfo>();
|
|
protected static void AddToCache(GroupInfo groupInfo)
|
|
{
|
|
if (!_CacheList.Contains(groupInfo)) _CacheList.Add(groupInfo); // In AddToCache
|
|
}
|
|
protected static void RemoveFromCache(GroupInfo groupInfo)
|
|
{
|
|
while (_CacheList.Contains(groupInfo)) _CacheList.Remove(groupInfo); // In RemoveFromCache
|
|
}
|
|
private static Dictionary<string, List<GroupInfo>> _CacheByPrimaryKey = new Dictionary<string, List<GroupInfo>>();
|
|
private static void ConvertListToDictionary()
|
|
{
|
|
List<GroupInfo> remove = new List<GroupInfo>();
|
|
foreach (GroupInfo tmp in _CacheList)
|
|
{
|
|
if (!_CacheByPrimaryKey.ContainsKey(tmp.GID.ToString()))
|
|
{
|
|
_CacheByPrimaryKey[tmp.GID.ToString()] = new List<GroupInfo>(); // Add new list for PrimaryKey
|
|
}
|
|
_CacheByPrimaryKey[tmp.GID.ToString()].Add(tmp); // Add to Primary Key list
|
|
remove.Add(tmp);
|
|
}
|
|
foreach (GroupInfo tmp in remove)
|
|
RemoveFromCache(tmp);
|
|
}
|
|
internal static void AddList(GroupInfoList lst)
|
|
{
|
|
foreach (GroupInfo item in lst) AddToCache(item);
|
|
}
|
|
protected static GroupInfo GetCachedByPrimaryKey(int gid)
|
|
{
|
|
ConvertListToDictionary();
|
|
string key = gid.ToString();
|
|
if (_CacheByPrimaryKey.ContainsKey(key)) return _CacheByPrimaryKey[key][0];
|
|
return null;
|
|
}
|
|
#endregion
|
|
#region Business Methods
|
|
private string _ErrorMessage = string.Empty;
|
|
public string ErrorMessage
|
|
{
|
|
get { return _ErrorMessage; }
|
|
}
|
|
protected Group _Editable;
|
|
private IVEHasBrokenRules HasBrokenRules
|
|
{
|
|
get
|
|
{
|
|
IVEHasBrokenRules hasBrokenRules = null;
|
|
if (_Editable != null)
|
|
hasBrokenRules = _Editable.HasBrokenRules;
|
|
return hasBrokenRules;
|
|
}
|
|
}
|
|
private int _GID;
|
|
[System.ComponentModel.DataObjectField(true, true)]
|
|
public int GID
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _GID;
|
|
}
|
|
}
|
|
private string _GroupName = string.Empty;
|
|
public string GroupName
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _GroupName;
|
|
}
|
|
}
|
|
private int? _GroupType;
|
|
public int? GroupType
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _GroupType;
|
|
}
|
|
}
|
|
private string _Config = string.Empty;
|
|
public string Config
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _Config;
|
|
}
|
|
}
|
|
private DateTime _DTS = new DateTime();
|
|
public DateTime DTS
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _DTS;
|
|
}
|
|
}
|
|
private string _UsrID = string.Empty;
|
|
public string UsrID
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _UsrID;
|
|
}
|
|
}
|
|
private int _GroupAssignmentCount = 0;
|
|
/// <summary>
|
|
/// Count of GroupAssignments for this Group
|
|
/// </summary>
|
|
public int GroupAssignmentCount
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _GroupAssignmentCount;
|
|
}
|
|
}
|
|
private AssignmentInfoList _GroupAssignments = null;
|
|
[TypeConverter(typeof(AssignmentInfoListConverter))]
|
|
public AssignmentInfoList GroupAssignments
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
if (_GroupAssignmentCount < 0 || (_GroupAssignmentCount > 0 && _GroupAssignments == null))
|
|
_GroupAssignments = AssignmentInfoList.GetByGID(_GID);
|
|
if (_GroupAssignmentCount < 0)
|
|
_GroupAssignmentCount = _GroupAssignments.Count;
|
|
return _GroupAssignments;
|
|
}
|
|
}
|
|
public void RefreshGroupAssignments()
|
|
{
|
|
ConvertListToDictionary();
|
|
if (_CacheByPrimaryKey.ContainsKey(_GID.ToString()))
|
|
foreach (GroupInfo tmp in _CacheByPrimaryKey[_GID.ToString()])
|
|
tmp._GroupAssignmentCount = -1; // This will cause the data to be requeried
|
|
}
|
|
private int _GroupMembershipCount = 0;
|
|
/// <summary>
|
|
/// Count of GroupMemberships for this Group
|
|
/// </summary>
|
|
public int GroupMembershipCount
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _GroupMembershipCount;
|
|
}
|
|
}
|
|
private MembershipInfoList _GroupMemberships = null;
|
|
[TypeConverter(typeof(MembershipInfoListConverter))]
|
|
public MembershipInfoList GroupMemberships
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
if (_GroupMembershipCount < 0 || (_GroupMembershipCount > 0 && _GroupMemberships == null))
|
|
_GroupMemberships = MembershipInfoList.GetByGID(_GID);
|
|
if (_GroupMembershipCount < 0)
|
|
_GroupMembershipCount = _GroupMemberships.Count;
|
|
return _GroupMemberships;
|
|
}
|
|
}
|
|
public void RefreshGroupMemberships()
|
|
{
|
|
ConvertListToDictionary();
|
|
if (_CacheByPrimaryKey.ContainsKey(_GID.ToString()))
|
|
foreach (GroupInfo tmp in _CacheByPrimaryKey[_GID.ToString()])
|
|
tmp._GroupMembershipCount = -1; // This will cause the data to be requeried
|
|
}
|
|
// TODO: Replace base GroupInfo.ToString function as necessary
|
|
/// <summary>
|
|
/// Overrides Base ToString
|
|
/// </summary>
|
|
/// <returns>A string representation of current GroupInfo</returns>
|
|
//public override string ToString()
|
|
//{
|
|
// return base.ToString();
|
|
//}
|
|
// TODO: Check GroupInfo.GetIdValue to assure that the ID returned is unique
|
|
/// <summary>
|
|
/// Overrides Base GetIdValue - Used internally by CSLA to determine equality
|
|
/// </summary>
|
|
/// <returns>A Unique ID for the current GroupInfo</returns>
|
|
protected override object GetIdValue()
|
|
{
|
|
return _GID;
|
|
}
|
|
#endregion
|
|
#region Factory Methods
|
|
private static int _GroupInfoUnique = 0;
|
|
private static int GroupInfoUnique
|
|
{ get { return ++_GroupInfoUnique; } }
|
|
private int _MyGroupInfoUnique = GroupInfoUnique;
|
|
public int MyGroupInfoUnique
|
|
{ get { return _MyGroupInfoUnique; } }
|
|
protected GroupInfo()
|
|
{/* require use of factory methods */
|
|
AddToCache(this);
|
|
}
|
|
public void Dispose()
|
|
{
|
|
RemoveFromCache(this);
|
|
if (!_CacheByPrimaryKey.ContainsKey(GID.ToString())) return;
|
|
List<GroupInfo> listGroupInfo = _CacheByPrimaryKey[GID.ToString()]; // Get the list of items
|
|
while (listGroupInfo.Contains(this)) listGroupInfo.Remove(this); // Remove the item from the list
|
|
if (listGroupInfo.Count == 0) // If there are no items left in the list
|
|
_CacheByPrimaryKey.Remove(GID.ToString()); // remove the list
|
|
}
|
|
public virtual Group Get()
|
|
{
|
|
return _Editable = Group.Get(_GID);
|
|
}
|
|
public static void Refresh(Group tmp)
|
|
{
|
|
string key = tmp.GID.ToString();
|
|
ConvertListToDictionary();
|
|
if (_CacheByPrimaryKey.ContainsKey(key))
|
|
foreach (GroupInfo tmpInfo in _CacheByPrimaryKey[key])
|
|
tmpInfo.RefreshFields(tmp);
|
|
}
|
|
protected virtual void RefreshFields(Group tmp)
|
|
{
|
|
_GroupName = tmp.GroupName;
|
|
_GroupType = tmp.GroupType;
|
|
_Config = tmp.Config;
|
|
_DTS = tmp.DTS;
|
|
_UsrID = tmp.UsrID;
|
|
_GroupInfoExtension.Refresh(this);
|
|
OnChange();// raise an event
|
|
}
|
|
public static GroupInfo Get(int gid)
|
|
{
|
|
//if (!CanGetObject())
|
|
// throw new System.Security.SecurityException("User not authorized to view a Group");
|
|
try
|
|
{
|
|
GroupInfo tmp = GetCachedByPrimaryKey(gid);
|
|
if (tmp == null)
|
|
{
|
|
tmp = DataPortal.Fetch<GroupInfo>(new PKCriteria(gid));
|
|
AddToCache(tmp);
|
|
}
|
|
if (tmp.ErrorMessage == "No Record Found")
|
|
{
|
|
tmp.Dispose(); // Clean-up GroupInfo
|
|
tmp = null;
|
|
}
|
|
return tmp;
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw new DbCslaException("Error on GroupInfo.Get", ex);
|
|
}
|
|
}
|
|
#endregion
|
|
#region Data Access Portal
|
|
internal GroupInfo(SafeDataReader dr)
|
|
{
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] GroupInfo.Constructor", GetHashCode());
|
|
try
|
|
{
|
|
ReadData(dr);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
if (_MyLog.IsErrorEnabled) _MyLog.Error("GroupInfo.Constructor", ex);
|
|
throw new DbCslaException("GroupInfo.Constructor", ex);
|
|
}
|
|
}
|
|
[Serializable()]
|
|
protected class PKCriteria
|
|
{
|
|
private int _GID;
|
|
public int GID
|
|
{ get { return _GID; } }
|
|
public PKCriteria(int gid)
|
|
{
|
|
_GID = gid;
|
|
}
|
|
}
|
|
private void ReadData(SafeDataReader dr)
|
|
{
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] GroupInfo.ReadData", GetHashCode());
|
|
try
|
|
{
|
|
_GID = dr.GetInt32("GID");
|
|
_GroupName = dr.GetString("GroupName");
|
|
_GroupType = (int?)dr.GetValue("GroupType");
|
|
_Config = dr.GetString("Config");
|
|
_DTS = dr.GetDateTime("DTS");
|
|
_UsrID = dr.GetString("UsrID");
|
|
_GroupAssignmentCount = dr.GetInt32("AssignmentCount");
|
|
_GroupMembershipCount = dr.GetInt32("MembershipCount");
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
if (_MyLog.IsErrorEnabled) _MyLog.Error("GroupInfo.ReadData", ex);
|
|
_ErrorMessage = ex.Message;
|
|
throw new DbCslaException("GroupInfo.ReadData", ex);
|
|
}
|
|
}
|
|
private void DataPortal_Fetch(PKCriteria criteria)
|
|
{
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] GroupInfo.DataPortal_Fetch", GetHashCode());
|
|
try
|
|
{
|
|
using (SqlConnection cn = Database.VEPROMS_SqlConnection)
|
|
{
|
|
ApplicationContext.LocalContext["cn"] = cn;
|
|
using (SqlCommand cm = cn.CreateCommand())
|
|
{
|
|
cm.CommandType = CommandType.StoredProcedure;
|
|
cm.CommandText = "getGroup";
|
|
cm.Parameters.AddWithValue("@GID", criteria.GID);
|
|
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
|
|
{
|
|
if (!dr.Read())
|
|
{
|
|
_ErrorMessage = "No Record Found";
|
|
return;
|
|
}
|
|
ReadData(dr);
|
|
}
|
|
}
|
|
// removing of item only needed for local data portal
|
|
if (ApplicationContext.ExecutionLocation == ApplicationContext.ExecutionLocations.Client)
|
|
ApplicationContext.LocalContext.Remove("cn");
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
if (_MyLog.IsErrorEnabled) _MyLog.Error("GroupInfo.DataPortal_Fetch", ex);
|
|
_ErrorMessage = ex.Message;
|
|
throw new DbCslaException("GroupInfo.DataPortal_Fetch", ex);
|
|
}
|
|
}
|
|
#endregion
|
|
// Standard Refresh
|
|
#region extension
|
|
GroupInfoExtension _GroupInfoExtension = new GroupInfoExtension();
|
|
[Serializable()]
|
|
partial class GroupInfoExtension : extensionBase { }
|
|
[Serializable()]
|
|
class extensionBase
|
|
{
|
|
// Default Refresh
|
|
public virtual void Refresh(GroupInfo tmp) { }
|
|
}
|
|
#endregion
|
|
} // Class
|
|
#region Converter
|
|
internal class GroupInfoConverter : ExpandableObjectConverter
|
|
{
|
|
public override object ConvertTo(ITypeDescriptorContext context, System.Globalization.CultureInfo culture, object value, Type destType)
|
|
{
|
|
if (destType == typeof(string) && value is GroupInfo)
|
|
{
|
|
// Return the ToString value
|
|
return ((GroupInfo)value).ToString();
|
|
}
|
|
return base.ConvertTo(context, culture, value, destType);
|
|
}
|
|
}
|
|
#endregion
|
|
} // Namespace
|