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.
431 lines
17 KiB
C#
431 lines
17 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 PartInfoEvent(object sender);
|
|
/// <summary>
|
|
/// PartInfo Generated by MyGeneration using the CSLA Object Mapping template
|
|
/// </summary>
|
|
[Serializable()]
|
|
[TypeConverter(typeof(PartInfoConverter))]
|
|
public partial class PartInfo : ReadOnlyBase<PartInfo>, IDisposable
|
|
{
|
|
public event PartInfoEvent 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<PartInfo> _CacheList = new List<PartInfo>();
|
|
protected static void AddToCache(PartInfo partInfo)
|
|
{
|
|
if (!_CacheList.Contains(partInfo)) _CacheList.Add(partInfo); // In AddToCache
|
|
}
|
|
protected static void RemoveFromCache(PartInfo partInfo)
|
|
{
|
|
while (_CacheList.Contains(partInfo)) _CacheList.Remove(partInfo); // In RemoveFromCache
|
|
}
|
|
private static Dictionary<string, List<PartInfo>> _CacheByPrimaryKey = new Dictionary<string, List<PartInfo>>();
|
|
private static void ConvertListToDictionary()
|
|
{
|
|
while (_CacheList.Count > 0) // Move PartInfo(s) from temporary _CacheList to _CacheByPrimaryKey
|
|
{
|
|
PartInfo tmp = _CacheList[0]; // Get the first PartInfo
|
|
string pKey = tmp.ContentID.ToString() + "_" + tmp.FromType.ToString();
|
|
if (!_CacheByPrimaryKey.ContainsKey(pKey))
|
|
{
|
|
_CacheByPrimaryKey[pKey] = new List<PartInfo>(); // Add new list for PrimaryKey
|
|
}
|
|
_CacheByPrimaryKey[pKey].Add(tmp); // Add to Primary Key list
|
|
_CacheList.RemoveAt(0); // Remove the first PartInfo
|
|
}
|
|
}
|
|
internal static void AddList(PartInfoList lst)
|
|
{
|
|
foreach (PartInfo item in lst) AddToCache(item);
|
|
}
|
|
protected static PartInfo GetCachedByPrimaryKey(int contentID, int fromType)
|
|
{
|
|
ConvertListToDictionary();
|
|
string key = contentID.ToString() + "_" + fromType.ToString();
|
|
if (_CacheByPrimaryKey.ContainsKey(key)) return _CacheByPrimaryKey[key][0];
|
|
return null;
|
|
}
|
|
public static void ClearPartInfoCache()
|
|
{
|
|
_CacheByPrimaryKey.Clear();
|
|
while (_CacheList.Count > 0)
|
|
{ _CacheList[0].Dispose(); }
|
|
|
|
}
|
|
#endregion
|
|
#region Business Methods
|
|
private string _ErrorMessage = string.Empty;
|
|
public string ErrorMessage
|
|
{
|
|
get { return _ErrorMessage; }
|
|
}
|
|
protected Part _Editable;
|
|
private IVEHasBrokenRules HasBrokenRules
|
|
{
|
|
get
|
|
{
|
|
IVEHasBrokenRules hasBrokenRules = null;
|
|
if (_Editable != null)
|
|
hasBrokenRules = _Editable.HasBrokenRules;
|
|
return hasBrokenRules;
|
|
}
|
|
}
|
|
private int _ContentID;
|
|
[System.ComponentModel.DataObjectField(true, true)]
|
|
public int ContentID
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
if (_MyContent != null) _ContentID = _MyContent.ContentID;
|
|
return _ContentID;
|
|
}
|
|
}
|
|
private ContentInfo _MyContent;
|
|
[System.ComponentModel.DataObjectField(true, true)]
|
|
public ContentInfo MyContent
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
if (_MyContent == null && _ContentID != 0) _MyContent = ContentInfo.Get(_ContentID);
|
|
return _MyContent;
|
|
}
|
|
}
|
|
private int _FromType;
|
|
[System.ComponentModel.DataObjectField(true, true)]
|
|
public int FromType
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _FromType;
|
|
}
|
|
}
|
|
private int _ItemID;
|
|
public int ItemID
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
if (_MyItem != null) _ItemID = _MyItem.ItemID;
|
|
return _ItemID;
|
|
}
|
|
}
|
|
private ItemInfo _MyItem;
|
|
public ItemInfo MyItem
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
if (_MyItem == null && _ItemID != 0) _MyItem = ItemInfo.Get(_ItemID);
|
|
return _MyItem;
|
|
}
|
|
}
|
|
private DateTime _DTS = new DateTime();
|
|
public DateTime DTS
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _DTS;
|
|
}
|
|
}
|
|
private string _UserID = string.Empty;
|
|
public string UserID
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _UserID;
|
|
}
|
|
}
|
|
// CSLATODO: Replace base PartInfo.ToString function as necessary
|
|
/// <summary>
|
|
/// Overrides Base ToString
|
|
/// </summary>
|
|
/// <returns>A string representation of current PartInfo</returns>
|
|
//public override string ToString()
|
|
//{
|
|
// return base.ToString();
|
|
//}
|
|
// CSLATODO: Check PartInfo.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 PartInfo</returns>
|
|
protected override object GetIdValue()
|
|
{
|
|
return MyPartInfoUnique; // Absolutely Unique ID
|
|
}
|
|
#endregion
|
|
#region Factory Methods
|
|
private static int _PartInfoUnique = 0;
|
|
private static int PartInfoUnique
|
|
{ get { return ++_PartInfoUnique; } }
|
|
private int _MyPartInfoUnique = PartInfoUnique;
|
|
public int MyPartInfoUnique // Absolutely Unique ID - Info
|
|
{ get { return _MyPartInfoUnique; } }
|
|
protected PartInfo()
|
|
{/* require use of factory methods */
|
|
AddToCache(this);
|
|
}
|
|
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; } }
|
|
~PartInfo()
|
|
{
|
|
_CountFinalized++;
|
|
}
|
|
public void Dispose()
|
|
{
|
|
if (_Disposed) return;
|
|
_CountDisposed++;
|
|
_Disposed = true;
|
|
Changed = null;
|
|
_MyItems?.Dispose();
|
|
RemoveFromCache(this);
|
|
if (!_CacheByPrimaryKey.ContainsKey(ContentID.ToString() + "_" + FromType.ToString())) return;
|
|
List<PartInfo> listPartInfo = _CacheByPrimaryKey[ContentID.ToString() + "_" + FromType.ToString()]; // Get the list of items
|
|
while (listPartInfo.Contains(this)) listPartInfo.Remove(this); // Remove the item from the list
|
|
if (listPartInfo.Count == 0) // If there are no items left in the list
|
|
_CacheByPrimaryKey.Remove(ContentID.ToString() + "_" + FromType.ToString()); // remove the list
|
|
}
|
|
public virtual Part Get()
|
|
{
|
|
return _Editable = Part.Get(_ContentID, _FromType);
|
|
}
|
|
public static void Refresh(Part tmp)
|
|
{
|
|
string key = tmp.ContentID.ToString() + "_" + tmp.FromType.ToString();
|
|
ConvertListToDictionary();
|
|
if (_CacheByPrimaryKey.ContainsKey(key))
|
|
foreach (PartInfo tmpInfo in _CacheByPrimaryKey[key])
|
|
tmpInfo.RefreshFields(tmp);
|
|
}
|
|
protected virtual void RefreshFields(Part tmp)
|
|
{
|
|
if (_ItemID != tmp.ItemID)
|
|
{
|
|
if (MyItem != null) MyItem.RefreshItemParts(); // Update List for old value
|
|
_ItemID = tmp.ItemID; // Update the value
|
|
}
|
|
_MyItem = null; // Reset list so that the next line gets a new list
|
|
if (MyItem != null) MyItem.RefreshItemParts(); // Update List for new value
|
|
_DTS = tmp.DTS;
|
|
_UserID = tmp.UserID;
|
|
_PartInfoExtension.Refresh(this);
|
|
OnChange();// raise an event
|
|
}
|
|
public static void Refresh(Content myContent, ContentPart tmp)
|
|
{
|
|
string key = myContent.ContentID.ToString() + "_" + tmp.FromType.ToString();
|
|
ConvertListToDictionary();
|
|
if (_CacheByPrimaryKey.ContainsKey(key))
|
|
foreach (PartInfo tmpInfo in _CacheByPrimaryKey[key])
|
|
tmpInfo.RefreshFields(tmp);
|
|
}
|
|
protected virtual void RefreshFields(ContentPart tmp)
|
|
{
|
|
if (_ItemID != tmp.ItemID)
|
|
{
|
|
if (MyItem != null) MyItem.RefreshItemParts(); // Update List for old value
|
|
_ItemID = tmp.ItemID; // Update the value
|
|
}
|
|
_MyItem = null; // Reset list so that the next line gets a new list
|
|
if (MyItem != null) MyItem.RefreshItemParts(); // Update List for new value
|
|
_DTS = tmp.DTS;
|
|
_UserID = tmp.UserID;
|
|
_PartInfoExtension.Refresh(this);
|
|
OnChange();// raise an event
|
|
}
|
|
public static void Refresh(ItemPart tmp)
|
|
{
|
|
string key = tmp.ContentID.ToString() + "_" + tmp.FromType.ToString();
|
|
ConvertListToDictionary();
|
|
if (_CacheByPrimaryKey.ContainsKey(key))
|
|
foreach (PartInfo tmpInfo in _CacheByPrimaryKey[key])
|
|
tmpInfo.RefreshFields(tmp);
|
|
}
|
|
protected virtual void RefreshFields(ItemPart tmp)
|
|
{
|
|
_DTS = tmp.DTS;
|
|
_UserID = tmp.UserID;
|
|
_PartInfoExtension.Refresh(this);
|
|
OnChange();// raise an event
|
|
}
|
|
public static PartInfo Get(int contentID, int fromType)
|
|
{
|
|
//if (!CanGetObject())
|
|
// throw new System.Security.SecurityException("User not authorized to view a Part");
|
|
try
|
|
{
|
|
PartInfo tmp = GetCachedByPrimaryKey(contentID, fromType);
|
|
if (tmp == null)
|
|
{
|
|
tmp = DataPortal.Fetch<PartInfo>(new PKCriteria(contentID, fromType));
|
|
AddToCache(tmp);
|
|
}
|
|
if (tmp.ErrorMessage == "No Record Found")
|
|
{
|
|
tmp.Dispose(); // Clean-up PartInfo
|
|
tmp = null;
|
|
}
|
|
return tmp;
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw new DbCslaException("Error on PartInfo.Get", ex);
|
|
}
|
|
}
|
|
#endregion
|
|
#region Data Access Portal
|
|
internal PartInfo(SafeDataReader dr)
|
|
{
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] PartInfo.Constructor", GetHashCode());
|
|
try
|
|
{
|
|
ReadData(dr);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
if (_MyLog.IsErrorEnabled) _MyLog.Error("PartInfo.Constructor", ex);
|
|
throw new DbCslaException("PartInfo.Constructor", ex);
|
|
}
|
|
}
|
|
[Serializable()]
|
|
protected class PKCriteria
|
|
{
|
|
private int _ContentID;
|
|
public int ContentID
|
|
{ get { return _ContentID; } }
|
|
private int _FromType;
|
|
public int FromType
|
|
{ get { return _FromType; } }
|
|
public PKCriteria(int contentID, int fromType)
|
|
{
|
|
_ContentID = contentID;
|
|
_FromType = fromType;
|
|
}
|
|
}
|
|
private void ReadData(SafeDataReader dr)
|
|
{
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] PartInfo.ReadData", GetHashCode());
|
|
try
|
|
{
|
|
_ContentID = dr.GetInt32("ContentID");
|
|
_FromType = dr.GetInt32("FromType");
|
|
_ItemID = dr.GetInt32("ItemID");
|
|
_DTS = dr.GetDateTime("DTS");
|
|
_UserID = dr.GetString("UserID");
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
if (_MyLog.IsErrorEnabled) _MyLog.Error("PartInfo.ReadData", ex);
|
|
_ErrorMessage = ex.Message;
|
|
throw new DbCslaException("PartInfo.ReadData", ex);
|
|
}
|
|
}
|
|
private void DataPortal_Fetch(PKCriteria criteria)
|
|
{
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] PartInfo.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 = "getPart";
|
|
cm.Parameters.AddWithValue("@ContentID", criteria.ContentID);
|
|
cm.Parameters.AddWithValue("@FromType", criteria.FromType);
|
|
cm.CommandTimeout = Database.DefaultTimeout;
|
|
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("PartInfo.DataPortal_Fetch", ex);
|
|
_ErrorMessage = ex.Message;
|
|
throw new DbCslaException("PartInfo.DataPortal_Fetch", ex);
|
|
}
|
|
}
|
|
#endregion
|
|
// Standard Refresh
|
|
#region extension
|
|
PartInfoExtension _PartInfoExtension = new PartInfoExtension();
|
|
[Serializable()]
|
|
partial class PartInfoExtension : extensionBase { }
|
|
[Serializable()]
|
|
class extensionBase
|
|
{
|
|
// Default Refresh
|
|
public virtual void Refresh(PartInfo tmp) { }
|
|
}
|
|
#endregion
|
|
} // Class
|
|
#region Converter
|
|
internal class PartInfoConverter : ExpandableObjectConverter
|
|
{
|
|
public override object ConvertTo(ITypeDescriptorContext context, System.Globalization.CultureInfo culture, object value, Type destType)
|
|
{
|
|
if (destType == typeof(string) && value is PartInfo)
|
|
{
|
|
// Return the ToString value
|
|
return ((PartInfo)value).ToString();
|
|
}
|
|
return base.ConvertTo(context, culture, value, destType);
|
|
}
|
|
}
|
|
#endregion
|
|
} // Namespace
|