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.
442 lines
17 KiB
C#
442 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 ROFstInfoEvent(object sender);
|
|
/// <summary>
|
|
/// ROFstInfo Generated by MyGeneration using the CSLA Object Mapping template
|
|
/// </summary>
|
|
[Serializable()]
|
|
[TypeConverter(typeof(ROFstInfoConverter))]
|
|
public partial class ROFstInfo : ReadOnlyBase<ROFstInfo>, IDisposable
|
|
{
|
|
public event ROFstInfoEvent 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<ROFstInfo> _CacheList = new List<ROFstInfo>();
|
|
protected static void AddToCache(ROFstInfo rOFstInfo)
|
|
{
|
|
if (!_CacheList.Contains(rOFstInfo)) _CacheList.Add(rOFstInfo); // In AddToCache
|
|
}
|
|
protected static void RemoveFromCache(ROFstInfo rOFstInfo)
|
|
{
|
|
while (_CacheList.Contains(rOFstInfo)) _CacheList.Remove(rOFstInfo); // In RemoveFromCache
|
|
}
|
|
private static Dictionary<string, List<ROFstInfo>> _CacheByPrimaryKey = new Dictionary<string, List<ROFstInfo>>();
|
|
private static void ConvertListToDictionary()
|
|
{
|
|
List<ROFstInfo> remove = new List<ROFstInfo>();
|
|
foreach (ROFstInfo tmp in _CacheList)
|
|
{
|
|
if (!_CacheByPrimaryKey.ContainsKey(tmp.ROFstID.ToString()))
|
|
{
|
|
_CacheByPrimaryKey[tmp.ROFstID.ToString()] = new List<ROFstInfo>(); // Add new list for PrimaryKey
|
|
}
|
|
_CacheByPrimaryKey[tmp.ROFstID.ToString()].Add(tmp); // Add to Primary Key list
|
|
remove.Add(tmp);
|
|
}
|
|
foreach (ROFstInfo tmp in remove)
|
|
RemoveFromCache(tmp);
|
|
}
|
|
internal static void AddList(ROFstInfoList lst)
|
|
{
|
|
foreach (ROFstInfo item in lst) AddToCache(item);
|
|
}
|
|
protected static ROFstInfo GetCachedByPrimaryKey(int rOFstID)
|
|
{
|
|
ConvertListToDictionary();
|
|
string key = rOFstID.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 ROFst _Editable;
|
|
private IVEHasBrokenRules HasBrokenRules
|
|
{
|
|
get
|
|
{
|
|
IVEHasBrokenRules hasBrokenRules = null;
|
|
if (_Editable != null)
|
|
hasBrokenRules = _Editable.HasBrokenRules;
|
|
return hasBrokenRules;
|
|
}
|
|
}
|
|
private int _ROFstID;
|
|
[System.ComponentModel.DataObjectField(true, true)]
|
|
public int ROFstID
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _ROFstID;
|
|
}
|
|
}
|
|
private int _RODbID;
|
|
public int RODbID
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
if (_MyRODb != null) _RODbID = _MyRODb.RODbID;
|
|
return _RODbID;
|
|
}
|
|
}
|
|
private RODbInfo _MyRODb;
|
|
public RODbInfo MyRODb
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
if (_MyRODb == null && _RODbID != 0) _MyRODb = RODbInfo.Get(_RODbID);
|
|
return _MyRODb;
|
|
}
|
|
}
|
|
private byte[] _ROFST;
|
|
public byte[] ROFST
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _ROFST;
|
|
}
|
|
}
|
|
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;
|
|
}
|
|
}
|
|
private int _ROFstDocVersionROFstCount = 0;
|
|
/// <summary>
|
|
/// Count of ROFstDocVersionROFsts for this ROFst
|
|
/// </summary>
|
|
public int ROFstDocVersionROFstCount
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _ROFstDocVersionROFstCount;
|
|
}
|
|
}
|
|
private DocVersionROFstInfoList _ROFstDocVersionROFsts = null;
|
|
[TypeConverter(typeof(DocVersionROFstInfoListConverter))]
|
|
public DocVersionROFstInfoList ROFstDocVersionROFsts
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
if (_ROFstDocVersionROFstCount < 0 || (_ROFstDocVersionROFstCount > 0 && _ROFstDocVersionROFsts == null))
|
|
_ROFstDocVersionROFsts = DocVersionROFstInfoList.GetByROFstID(_ROFstID);
|
|
if (_ROFstDocVersionROFstCount < 0)
|
|
_ROFstDocVersionROFstCount = _ROFstDocVersionROFsts.Count;
|
|
return _ROFstDocVersionROFsts;
|
|
}
|
|
}
|
|
public void RefreshROFstDocVersionROFsts()
|
|
{
|
|
ConvertListToDictionary();
|
|
if (_CacheByPrimaryKey.ContainsKey(_ROFstID.ToString()))
|
|
foreach (ROFstInfo tmp in _CacheByPrimaryKey[_ROFstID.ToString()])
|
|
tmp._ROFstDocVersionROFstCount = -1; // This will cause the data to be requeried
|
|
}
|
|
private int _ROFstROFstImageCount = 0;
|
|
/// <summary>
|
|
/// Count of ROFstROFstImages for this ROFst
|
|
/// </summary>
|
|
public int ROFstROFstImageCount
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _ROFstROFstImageCount;
|
|
}
|
|
}
|
|
private ROFstImageInfoList _ROFstROFstImages = null;
|
|
[TypeConverter(typeof(ROFstImageInfoListConverter))]
|
|
public ROFstImageInfoList ROFstROFstImages
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
if (_ROFstROFstImageCount < 0 || (_ROFstROFstImageCount > 0 && _ROFstROFstImages == null))
|
|
_ROFstROFstImages = ROFstImageInfoList.GetByROFstID(_ROFstID);
|
|
if (_ROFstROFstImageCount < 0)
|
|
_ROFstROFstImageCount = _ROFstROFstImages.Count;
|
|
return _ROFstROFstImages;
|
|
}
|
|
}
|
|
public void RefreshROFstROFstImages()
|
|
{
|
|
ConvertListToDictionary();
|
|
if (_CacheByPrimaryKey.ContainsKey(_ROFstID.ToString()))
|
|
foreach (ROFstInfo tmp in _CacheByPrimaryKey[_ROFstID.ToString()])
|
|
tmp._ROFstROFstImageCount = -1; // This will cause the data to be requeried
|
|
}
|
|
// TODO: Replace base ROFstInfo.ToString function as necessary
|
|
/// <summary>
|
|
/// Overrides Base ToString
|
|
/// </summary>
|
|
/// <returns>A string representation of current ROFstInfo</returns>
|
|
//public override string ToString()
|
|
//{
|
|
// return base.ToString();
|
|
//}
|
|
// TODO: Check ROFstInfo.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 ROFstInfo</returns>
|
|
protected override object GetIdValue()
|
|
{
|
|
return _ROFstID;
|
|
}
|
|
#endregion
|
|
#region Factory Methods
|
|
private static int _ROFstInfoUnique = 0;
|
|
private static int ROFstInfoUnique
|
|
{ get { return ++_ROFstInfoUnique; } }
|
|
private int _MyROFstInfoUnique = ROFstInfoUnique;
|
|
public int MyROFstInfoUnique
|
|
{ get { return _MyROFstInfoUnique; } }
|
|
protected ROFstInfo()
|
|
{/* require use of factory methods */
|
|
AddToCache(this);
|
|
}
|
|
public void Dispose()
|
|
{
|
|
RemoveFromCache(this);
|
|
if (!_CacheByPrimaryKey.ContainsKey(ROFstID.ToString())) return;
|
|
List<ROFstInfo> listROFstInfo = _CacheByPrimaryKey[ROFstID.ToString()]; // Get the list of items
|
|
while (listROFstInfo.Contains(this)) listROFstInfo.Remove(this); // Remove the item from the list
|
|
if (listROFstInfo.Count == 0) // If there are no items left in the list
|
|
_CacheByPrimaryKey.Remove(ROFstID.ToString()); // remove the list
|
|
}
|
|
public virtual ROFst Get()
|
|
{
|
|
return _Editable = ROFst.Get(_ROFstID);
|
|
}
|
|
public static void Refresh(ROFst tmp)
|
|
{
|
|
string key = tmp.ROFstID.ToString();
|
|
ConvertListToDictionary();
|
|
if (_CacheByPrimaryKey.ContainsKey(key))
|
|
foreach (ROFstInfo tmpInfo in _CacheByPrimaryKey[key])
|
|
tmpInfo.RefreshFields(tmp);
|
|
}
|
|
protected virtual void RefreshFields(ROFst tmp)
|
|
{
|
|
if (_RODbID != tmp.RODbID)
|
|
{
|
|
if (MyRODb != null) MyRODb.RefreshRODbROFsts(); // Update List for old value
|
|
_RODbID = tmp.RODbID; // Update the value
|
|
}
|
|
_MyRODb = null; // Reset list so that the next line gets a new list
|
|
if (MyRODb != null) MyRODb.RefreshRODbROFsts(); // Update List for new value
|
|
_ROFST = tmp.ROFST;
|
|
_DTS = tmp.DTS;
|
|
_UserID = tmp.UserID;
|
|
_ROFstInfoExtension.Refresh(this);
|
|
if (_MyRODb != null)
|
|
{
|
|
_MyRODb.Dispose();// Dispose related value
|
|
_MyRODb = null;// Reset related value
|
|
}
|
|
OnChange();// raise an event
|
|
}
|
|
public static void Refresh(RODbROFst tmp)
|
|
{
|
|
string key = tmp.ROFstID.ToString();
|
|
ConvertListToDictionary();
|
|
if (_CacheByPrimaryKey.ContainsKey(key))
|
|
foreach (ROFstInfo tmpInfo in _CacheByPrimaryKey[key])
|
|
tmpInfo.RefreshFields(tmp);
|
|
}
|
|
protected virtual void RefreshFields(RODbROFst tmp)
|
|
{
|
|
_ROFST = tmp.ROFST;
|
|
_DTS = tmp.DTS;
|
|
_UserID = tmp.UserID;
|
|
_ROFstInfoExtension.Refresh(this);
|
|
if (_MyRODb != null)
|
|
{
|
|
_MyRODb.Dispose();// Dispose related value
|
|
_MyRODb = null;// Reset related value
|
|
}
|
|
OnChange();// raise an event
|
|
}
|
|
public static ROFstInfo Get(int rOFstID)
|
|
{
|
|
//if (!CanGetObject())
|
|
// throw new System.Security.SecurityException("User not authorized to view a ROFst");
|
|
try
|
|
{
|
|
ROFstInfo tmp = GetCachedByPrimaryKey(rOFstID);
|
|
if (tmp == null)
|
|
{
|
|
tmp = DataPortal.Fetch<ROFstInfo>(new PKCriteria(rOFstID));
|
|
AddToCache(tmp);
|
|
}
|
|
if (tmp.ErrorMessage == "No Record Found")
|
|
{
|
|
tmp.Dispose(); // Clean-up ROFstInfo
|
|
tmp = null;
|
|
}
|
|
return tmp;
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw new DbCslaException("Error on ROFstInfo.Get", ex);
|
|
}
|
|
}
|
|
#endregion
|
|
#region Data Access Portal
|
|
internal ROFstInfo(SafeDataReader dr)
|
|
{
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] ROFstInfo.Constructor", GetHashCode());
|
|
try
|
|
{
|
|
ReadData(dr);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
if (_MyLog.IsErrorEnabled) _MyLog.Error("ROFstInfo.Constructor", ex);
|
|
throw new DbCslaException("ROFstInfo.Constructor", ex);
|
|
}
|
|
}
|
|
[Serializable()]
|
|
protected class PKCriteria
|
|
{
|
|
private int _ROFstID;
|
|
public int ROFstID
|
|
{ get { return _ROFstID; } }
|
|
public PKCriteria(int rOFstID)
|
|
{
|
|
_ROFstID = rOFstID;
|
|
}
|
|
}
|
|
private void ReadData(SafeDataReader dr)
|
|
{
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] ROFstInfo.ReadData", GetHashCode());
|
|
try
|
|
{
|
|
_ROFstID = dr.GetInt32("ROFstID");
|
|
_RODbID = dr.GetInt32("RODbID");
|
|
_ROFST = (byte[])dr.GetValue("ROFST");
|
|
_DTS = dr.GetDateTime("DTS");
|
|
_UserID = dr.GetString("UserID");
|
|
_ROFstDocVersionROFstCount = dr.GetInt32("DocVersionROFstCount");
|
|
_ROFstROFstImageCount = dr.GetInt32("ROFstImageCount");
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
if (_MyLog.IsErrorEnabled) _MyLog.Error("ROFstInfo.ReadData", ex);
|
|
_ErrorMessage = ex.Message;
|
|
throw new DbCslaException("ROFstInfo.ReadData", ex);
|
|
}
|
|
}
|
|
private void DataPortal_Fetch(PKCriteria criteria)
|
|
{
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] ROFstInfo.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 = "getROFst";
|
|
cm.Parameters.AddWithValue("@ROFstID", criteria.ROFstID);
|
|
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("ROFstInfo.DataPortal_Fetch", ex);
|
|
_ErrorMessage = ex.Message;
|
|
throw new DbCslaException("ROFstInfo.DataPortal_Fetch", ex);
|
|
}
|
|
}
|
|
#endregion
|
|
// Standard Refresh
|
|
#region extension
|
|
ROFstInfoExtension _ROFstInfoExtension = new ROFstInfoExtension();
|
|
[Serializable()]
|
|
partial class ROFstInfoExtension : extensionBase { }
|
|
[Serializable()]
|
|
class extensionBase
|
|
{
|
|
// Default Refresh
|
|
public virtual void Refresh(ROFstInfo tmp) { }
|
|
}
|
|
#endregion
|
|
} // Class
|
|
#region Converter
|
|
internal class ROFstInfoConverter : ExpandableObjectConverter
|
|
{
|
|
public override object ConvertTo(ITypeDescriptorContext context, System.Globalization.CultureInfo culture, object value, Type destType)
|
|
{
|
|
if (destType == typeof(string) && value is ROFstInfo)
|
|
{
|
|
// Return the ToString value
|
|
return ((ROFstInfo)value).ToString();
|
|
}
|
|
return base.ConvertTo(context, culture, value, destType);
|
|
}
|
|
}
|
|
#endregion
|
|
} // Namespace
|