Basic class audit information
I am creating an ASP.NET MVC3 Application using NHIBERNATE. I have a base Entity class that is used to capture some audit data such as CreatedBy, CreatedOn, UpdateBy, UpdateOn, etc. These properties should be populated automatically when the derived class is created and saved / updated.
Since the Entity type and all other types are defined in the DOMAIN clause , what would be the best way to percolate USER information from the Web for DOMAIN to populate the information in the base Entity class
EDIT
Further
- I am currently defining all properties as public virtual , so how do I implement them so that the dates / userId is created on the fly during save.
- I want base class properties to persist in every table for derived concrete classes (table for specific class). How to specify it using FLUENT NHIBERNATE (I am not using Automapping)
+3
source to share
1 answer
Use interceptor when opening session:
sessionFactory.OpenSession(new AuditInterceptor());
File: AuditInterceptor.cs
using System;
using NHibernate;
using NHibernate.Type;
using System.Threading;
using System.Security;
namespace bla
{
/// <summary>
/// NHibernate Interceptor that stores audit information (idlogin and datetime.now) on every save and update
/// </summary>
public class AuditInterceptor : EmptyInterceptor
{
private int updates;
private int creates;
private int loads;
private ISession session;
public override void OnDelete(object entity,
object id,
object[] state,
string[] propertyNames,
IType[] types)
{
// do nothing
}
public override bool OnFlushDirty(object obj, object id, object[] currentState, object[] previousState, string[] propertyNames, IType[] types)
{
bool found = false;
if (obj is Entity)
{
updates++;
for (int i = 0; i < propertyNames.Length; i++)
{
if ("dtlastchanged".Equals(propertyNames[i].ToLower()))
{
currentState[i] = DateTime.Now;
found = true;
}
if ("lastchangedby".Equals(propertyNames[i].ToLower()))
{
currentState[i] = this.session.Get<Login>(IdLogin, LockMode.None);
found = true;
}
}
}
return found;
}
public override bool OnLoad(object obj, object id, object[] state, string[] propertyNames, IType[] types)
{
if (obj is Entity)
{
loads++;
}
return false;
}
public override bool OnSave(object entity,
object id,
object[] state,
string[] propertyNames,
IType[] types)
{
bool found = false;
if (entity is Entity)
{
creates++;
for (int i = 0; i < propertyNames.Length; i++)
{
if ("dtlastchanged".Equals(propertyNames[i].ToLower()))
{
state[i] = DateTime.Now;
found = true;
}
if ("lastchangedby".Equals(propertyNames[i].ToLower()) && !(entity is Login && (entity as Login).IsInVerification))
{
state[i] = this.session.Get<Login>(IdLogin, LockMode.None);
found = true;
}
}
}
return found;
}
public override void AfterTransactionCompletion(ITransaction tx)
{
//if (tx.WasCommitted)
//{
// System.Console.WriteLine("Creations: " + creates + ", Updates: " + updates, "Loads: " + loads);
//}
updates = 0;
creates = 0;
loads = 0;
}
public override void SetSession(ISession session)
{
this.session = session;
base.SetSession(session);
}
protected long IdLogin
{
get
{
return (Thread.CurrentPrincipal.Identity as CustomIdentity).IdLogin; // or something else that holds the id of the current logged in user
}
}
}
}
+2
source to share