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.
464 lines
17 KiB
C#
464 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 UserInfoEvent(object sender);
|
|
/// <summary>
|
|
/// UserInfo Generated by MyGeneration using the CSLA Object Mapping template
|
|
/// </summary>
|
|
[Serializable()]
|
|
[TypeConverter(typeof(UserInfoConverter))]
|
|
public partial class UserInfo : ReadOnlyBase<UserInfo>, IDisposable
|
|
{
|
|
public event UserInfoEvent 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<UserInfo> _CacheList = new List<UserInfo>();
|
|
protected static void AddToCache(UserInfo userInfo)
|
|
{
|
|
if (!_CacheList.Contains(userInfo)) _CacheList.Add(userInfo); // In AddToCache
|
|
}
|
|
protected static void RemoveFromCache(UserInfo userInfo)
|
|
{
|
|
while (_CacheList.Contains(userInfo)) _CacheList.Remove(userInfo); // In RemoveFromCache
|
|
}
|
|
private static Dictionary<string, List<UserInfo>> _CacheByPrimaryKey = new Dictionary<string, List<UserInfo>>();
|
|
private static void ConvertListToDictionary()
|
|
{
|
|
List<UserInfo> remove = new List<UserInfo>();
|
|
foreach (UserInfo tmp in _CacheList)
|
|
{
|
|
if (!_CacheByPrimaryKey.ContainsKey(tmp.UID.ToString()))
|
|
{
|
|
_CacheByPrimaryKey[tmp.UID.ToString()] = new List<UserInfo>(); // Add new list for PrimaryKey
|
|
}
|
|
_CacheByPrimaryKey[tmp.UID.ToString()].Add(tmp); // Add to Primary Key list
|
|
remove.Add(tmp);
|
|
}
|
|
foreach (UserInfo tmp in remove)
|
|
RemoveFromCache(tmp);
|
|
}
|
|
internal static void AddList(UserInfoList lst)
|
|
{
|
|
foreach (UserInfo item in lst) AddToCache(item);
|
|
}
|
|
protected static UserInfo GetCachedByPrimaryKey(int uid)
|
|
{
|
|
ConvertListToDictionary();
|
|
string key = uid.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 User _Editable;
|
|
private IVEHasBrokenRules HasBrokenRules
|
|
{
|
|
get
|
|
{
|
|
IVEHasBrokenRules hasBrokenRules = null;
|
|
if (_Editable != null)
|
|
hasBrokenRules = _Editable.HasBrokenRules;
|
|
return hasBrokenRules;
|
|
}
|
|
}
|
|
private int _UID;
|
|
[System.ComponentModel.DataObjectField(true, true)]
|
|
public int UID
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _UID;
|
|
}
|
|
}
|
|
private string _UserID = string.Empty;
|
|
public string UserID
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _UserID;
|
|
}
|
|
}
|
|
private string _FirstName = string.Empty;
|
|
public string FirstName
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _FirstName;
|
|
}
|
|
}
|
|
private string _MiddleName = string.Empty;
|
|
public string MiddleName
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _MiddleName;
|
|
}
|
|
}
|
|
private string _LastName = string.Empty;
|
|
public string LastName
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _LastName;
|
|
}
|
|
}
|
|
private string _Suffix = string.Empty;
|
|
public string Suffix
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _Suffix;
|
|
}
|
|
}
|
|
private string _CourtesyTitle = string.Empty;
|
|
public string CourtesyTitle
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _CourtesyTitle;
|
|
}
|
|
}
|
|
private string _PhoneNumber = string.Empty;
|
|
public string PhoneNumber
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _PhoneNumber;
|
|
}
|
|
}
|
|
private string _CFGName = string.Empty;
|
|
public string CFGName
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _CFGName;
|
|
}
|
|
}
|
|
private string _UserLogin = string.Empty;
|
|
public string UserLogin
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _UserLogin;
|
|
}
|
|
}
|
|
private string _UserName = string.Empty;
|
|
public string UserName
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _UserName;
|
|
}
|
|
}
|
|
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 _UserMembershipCount = 0;
|
|
/// <summary>
|
|
/// Count of UserMemberships for this User
|
|
/// </summary>
|
|
public int UserMembershipCount
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _UserMembershipCount;
|
|
}
|
|
}
|
|
private MembershipInfoList _UserMemberships = null;
|
|
[TypeConverter(typeof(MembershipInfoListConverter))]
|
|
public MembershipInfoList UserMemberships
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
if (_UserMembershipCount < 0 || (_UserMembershipCount > 0 && _UserMemberships == null))
|
|
_UserMemberships = MembershipInfoList.GetByUID(_UID);
|
|
if (_UserMembershipCount < 0)
|
|
_UserMembershipCount = _UserMemberships.Count;
|
|
return _UserMemberships;
|
|
}
|
|
}
|
|
public void RefreshUserMemberships()
|
|
{
|
|
ConvertListToDictionary();
|
|
if (_CacheByPrimaryKey.ContainsKey(_UID.ToString()))
|
|
foreach (UserInfo tmp in _CacheByPrimaryKey[_UID.ToString()])
|
|
tmp._UserMembershipCount = -1; // This will cause the data to be requeried
|
|
}
|
|
// TODO: Replace base UserInfo.ToString function as necessary
|
|
/// <summary>
|
|
/// Overrides Base ToString
|
|
/// </summary>
|
|
/// <returns>A string representation of current UserInfo</returns>
|
|
//public override string ToString()
|
|
//{
|
|
// return base.ToString();
|
|
//}
|
|
// TODO: Check UserInfo.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 UserInfo</returns>
|
|
protected override object GetIdValue()
|
|
{
|
|
return _UID;
|
|
}
|
|
#endregion
|
|
#region Factory Methods
|
|
private static int _UserInfoUnique = 0;
|
|
private static int UserInfoUnique
|
|
{ get { return ++_UserInfoUnique; } }
|
|
private int _MyUserInfoUnique = UserInfoUnique;
|
|
public int MyUserInfoUnique
|
|
{ get { return _MyUserInfoUnique; } }
|
|
protected UserInfo()
|
|
{/* require use of factory methods */
|
|
AddToCache(this);
|
|
}
|
|
public void Dispose()
|
|
{
|
|
RemoveFromCache(this);
|
|
if (!_CacheByPrimaryKey.ContainsKey(UID.ToString())) return;
|
|
List<UserInfo> listUserInfo = _CacheByPrimaryKey[UID.ToString()]; // Get the list of items
|
|
while (listUserInfo.Contains(this)) listUserInfo.Remove(this); // Remove the item from the list
|
|
if (listUserInfo.Count == 0) // If there are no items left in the list
|
|
_CacheByPrimaryKey.Remove(UID.ToString()); // remove the list
|
|
}
|
|
public virtual User Get()
|
|
{
|
|
return _Editable = User.Get(_UID);
|
|
}
|
|
public static void Refresh(User tmp)
|
|
{
|
|
string key = tmp.UID.ToString();
|
|
ConvertListToDictionary();
|
|
if (_CacheByPrimaryKey.ContainsKey(key))
|
|
foreach (UserInfo tmpInfo in _CacheByPrimaryKey[key])
|
|
tmpInfo.RefreshFields(tmp);
|
|
}
|
|
protected virtual void RefreshFields(User tmp)
|
|
{
|
|
_UserID = tmp.UserID;
|
|
_FirstName = tmp.FirstName;
|
|
_MiddleName = tmp.MiddleName;
|
|
_LastName = tmp.LastName;
|
|
_Suffix = tmp.Suffix;
|
|
_CourtesyTitle = tmp.CourtesyTitle;
|
|
_PhoneNumber = tmp.PhoneNumber;
|
|
_CFGName = tmp.CFGName;
|
|
_UserLogin = tmp.UserLogin;
|
|
_UserName = tmp.UserName;
|
|
_Config = tmp.Config;
|
|
_DTS = tmp.DTS;
|
|
_UsrID = tmp.UsrID;
|
|
_UserInfoExtension.Refresh(this);
|
|
OnChange();// raise an event
|
|
}
|
|
public static UserInfo Get(int uid)
|
|
{
|
|
//if (!CanGetObject())
|
|
// throw new System.Security.SecurityException("User not authorized to view a User");
|
|
try
|
|
{
|
|
UserInfo tmp = GetCachedByPrimaryKey(uid);
|
|
if (tmp == null)
|
|
{
|
|
tmp = DataPortal.Fetch<UserInfo>(new PKCriteria(uid));
|
|
AddToCache(tmp);
|
|
}
|
|
if (tmp.ErrorMessage == "No Record Found")
|
|
{
|
|
tmp.Dispose(); // Clean-up UserInfo
|
|
tmp = null;
|
|
}
|
|
return tmp;
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw new DbCslaException("Error on UserInfo.Get", ex);
|
|
}
|
|
}
|
|
#endregion
|
|
#region Data Access Portal
|
|
internal UserInfo(SafeDataReader dr)
|
|
{
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] UserInfo.Constructor", GetHashCode());
|
|
try
|
|
{
|
|
ReadData(dr);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
if (_MyLog.IsErrorEnabled) _MyLog.Error("UserInfo.Constructor", ex);
|
|
throw new DbCslaException("UserInfo.Constructor", ex);
|
|
}
|
|
}
|
|
[Serializable()]
|
|
protected class PKCriteria
|
|
{
|
|
private int _UID;
|
|
public int UID
|
|
{ get { return _UID; } }
|
|
public PKCriteria(int uid)
|
|
{
|
|
_UID = uid;
|
|
}
|
|
}
|
|
private void ReadData(SafeDataReader dr)
|
|
{
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] UserInfo.ReadData", GetHashCode());
|
|
try
|
|
{
|
|
_UID = dr.GetInt32("UID");
|
|
_UserID = dr.GetString("UserID");
|
|
_FirstName = dr.GetString("FirstName");
|
|
_MiddleName = dr.GetString("MiddleName");
|
|
_LastName = dr.GetString("LastName");
|
|
_Suffix = dr.GetString("Suffix");
|
|
_CourtesyTitle = dr.GetString("CourtesyTitle");
|
|
_PhoneNumber = dr.GetString("PhoneNumber");
|
|
_CFGName = dr.GetString("CFGName");
|
|
_UserLogin = dr.GetString("UserLogin");
|
|
_UserName = dr.GetString("UserName");
|
|
_Config = dr.GetString("Config");
|
|
_DTS = dr.GetDateTime("DTS");
|
|
_UsrID = dr.GetString("UsrID");
|
|
_UserMembershipCount = dr.GetInt32("MembershipCount");
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
if (_MyLog.IsErrorEnabled) _MyLog.Error("UserInfo.ReadData", ex);
|
|
_ErrorMessage = ex.Message;
|
|
throw new DbCslaException("UserInfo.ReadData", ex);
|
|
}
|
|
}
|
|
private void DataPortal_Fetch(PKCriteria criteria)
|
|
{
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] UserInfo.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 = "getUser";
|
|
cm.Parameters.AddWithValue("@UID", criteria.UID);
|
|
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("UserInfo.DataPortal_Fetch", ex);
|
|
_ErrorMessage = ex.Message;
|
|
throw new DbCslaException("UserInfo.DataPortal_Fetch", ex);
|
|
}
|
|
}
|
|
#endregion
|
|
// Standard Refresh
|
|
#region extension
|
|
UserInfoExtension _UserInfoExtension = new UserInfoExtension();
|
|
[Serializable()]
|
|
partial class UserInfoExtension : extensionBase { }
|
|
[Serializable()]
|
|
class extensionBase
|
|
{
|
|
// Default Refresh
|
|
public virtual void Refresh(UserInfo tmp) { }
|
|
}
|
|
#endregion
|
|
} // Class
|
|
#region Converter
|
|
internal class UserInfoConverter : ExpandableObjectConverter
|
|
{
|
|
public override object ConvertTo(ITypeDescriptorContext context, System.Globalization.CultureInfo culture, object value, Type destType)
|
|
{
|
|
if (destType == typeof(string) && value is UserInfo)
|
|
{
|
|
// Return the ToString value
|
|
return ((UserInfo)value).ToString();
|
|
}
|
|
return base.ConvertTo(context, culture, value, destType);
|
|
}
|
|
}
|
|
#endregion
|
|
} // Namespace
|