public void Test_EFDataProvider_ProxiedLazyLoading()
{
var evs = new List <AuditEvent>();
Audit.Core.Configuration.AddCustomAction(ActionType.OnEventSaved, scope =>
{
evs.Add(scope.Event);
});
var dp = new EntityFrameworkDataProvider();
dp.AuditTypeMapper = t =>
{
if (t == typeof(Order))
{
return(typeof(OrderAudit));
}
if (t == typeof(Orderline))
{
return(typeof(OrderlineAudit));
}
return(null);
};
dp.AuditEntityAction = (ev, entry, obj) =>
{
var ab = obj as AuditBase;
if (ab != null)
{
ab.AuditDate = DateTime.UtcNow;
ab.UserName = ev.Environment.UserName;
ab.AuditStatus = entry.Action;
}
return(true);
};
Audit.Core.Configuration.Setup()
.UseCustomProvider(dp);
var id = Guid.NewGuid().ToString();
using (var ctx = new AuditPerTableContext())
{
var o = ctx.Order.FirstOrDefault();
o.Number = id;
ctx.SaveChanges();
}
using (var ctx = new AuditPerTableContext())
{
var orderAudits = ctx.OrderAudit.AsNoTracking().Where(a => a.Number.Equals(id)).OrderByDescending(a => a.AuditDate).ToList();
Assert.AreEqual(1, orderAudits.Count);
Assert.AreEqual("Update", orderAudits[0].AuditStatus);
Assert.AreEqual(id, orderAudits[0].Number);
}
Assert.AreEqual(1, evs.Count);
Assert.AreEqual(1, evs[0].GetEntityFrameworkEvent().Entries.Count);
Assert.IsTrue(evs[0].GetEntityFrameworkEvent().Entries[0].GetEntry().Entity.GetType().FullName.StartsWith("Castle.Proxies."));
}
public void Test_EFDataProvider_AuditEntityDisabled()
{
var dp = new EntityFrameworkDataProvider();
dp.AuditTypeMapper = t =>
{
if (t == typeof(Order))
{
return(typeof(OrderAudit));
}
if (t == typeof(Orderline))
{
return(typeof(OrderlineAudit));
}
return(null);
};
dp.AuditEntityAction = (ev, entry, obj) =>
{
// return false to avoid saving
return(false);
};
Audit.Core.Configuration.Setup()
.UseCustomProvider(dp);
var id = Guid.NewGuid().ToString();
using (var ctx = new AuditPerTableContext())
{
var o = new Order()
{
Number = id,
Status = "Pending",
OrderLines = new Collection <Orderline>()
{
new Orderline()
{
Product = "p1: " + id, Quantity = 2
},
new Orderline()
{
Product = "p2: " + id, Quantity = 3
}
}
};
ctx.Add(o);
ctx.SaveChanges();
}
using (var ctx = new AuditPerTableContext())
{
var order = ctx.Order.Single(a => a.Number.Equals(id));
var orderlineAudits = ctx.OrderlineAudit.AsNoTracking().Where(a => a.OrderId.Equals(order.Id)).ToList();
Assert.AreEqual(0, orderlineAudits.Count);
}
}
public void Test_EFDataProvider_AuditEntityDisabled_Fluent()
{
Audit.Core.Configuration.Setup()
.UseEntityFramework(config => config
.AuditTypeMapper(typeName => Type.GetType(typeName + "Audit"))
.AuditEntityAction((ev, ent, audEnt) =>
{
return(false);
})
);
var id = Guid.NewGuid().ToString();
using (var ctx = new AuditPerTableContext())
{
var o = new Order()
{
Number = id,
Status = "Pending",
OrderLines = new Collection <Orderline>()
{
new Orderline()
{
Product = "p1: " + id, Quantity = 2
},
new Orderline()
{
Product = "p2: " + id, Quantity = 3
}
}
};
ctx.Add(o);
ctx.SaveChanges();
}
using (var ctx = new AuditPerTableContext())
{
var order = ctx.Order.Single(a => a.Number.Equals(id));
var orderlineAudits = ctx.OrderlineAudit.AsNoTracking().Where(a => a.OrderId.Equals(order.Id)).ToList();
Assert.AreEqual(0, orderlineAudits.Count);
}
}
public void Test_EFDataProvider()
{
var dp = new EntityFrameworkDataProvider();
dp.AuditTypeMapper = t =>
{
if (t == typeof(Order))
{
return(typeof(OrderAudit));
}
if (t == typeof(Orderline))
{
return(typeof(OrderlineAudit));
}
return(null);
};
dp.AuditEntityAction = (ev, entry, obj) =>
{
var ab = obj as AuditBase;
if (ab != null)
{
ab.AuditDate = DateTime.UtcNow;
ab.UserName = ev.Environment.UserName;
ab.AuditStatus = entry.Action;
}
return(true);
};
Audit.Core.Configuration.Setup()
.UseCustomProvider(dp);
var id = Guid.NewGuid().ToString();
using (var ctx = new AuditPerTableContext())
{
var o = new Order()
{
Number = id, Status = "Pending", OrderLines = new Collection <Orderline>()
{
new Orderline()
{
Product = "p1: " + id, Quantity = 2
},
new Orderline()
{
Product = "p2: " + id, Quantity = 3
}
}
};
ctx.Add(o);
ctx.SaveChanges();
}
using (var ctx = new AuditPerTableContext())
{
var orderAudit = ctx.OrderAudit.AsNoTracking().SingleOrDefault(a => a.Number.Equals(id));
Assert.NotNull(orderAudit);
var orderlineAudits = ctx.OrderlineAudit.AsNoTracking().Where(a => a.OrderId.Equals(orderAudit.Id)).ToList();
Assert.AreEqual(2, orderlineAudits.Count);
Assert.AreEqual("p1: " + id, orderlineAudits[0].Product);
Assert.AreEqual("p2: " + id, orderlineAudits[1].Product);
Assert.AreEqual("Insert", orderAudit.AuditStatus);
Assert.AreEqual("Insert", orderlineAudits[0].AuditStatus);
Assert.AreEqual("Insert", orderlineAudits[1].AuditStatus);
Assert.AreEqual(orderlineAudits[0].UserName, orderlineAudits[1].UserName);
Assert.AreEqual(orderlineAudits[0].UserName, orderAudit.UserName);
Assert.IsFalse(string.IsNullOrWhiteSpace(orderlineAudits[0].UserName));
Assert.IsFalse(string.IsNullOrWhiteSpace(orderlineAudits[1].UserName));
}
using (var ctx = new AuditPerTableContext())
{
var o = ctx.Order.Single(a => a.Number.Equals(id));
o.Status = "Cancelled";
ctx.SaveChanges();
}
using (var ctx = new AuditPerTableContext())
{
var orderAudits = ctx.OrderAudit.AsNoTracking().Where(a => a.Number.Equals(id)).OrderByDescending(a => a.AuditDate).ToList();
Assert.AreEqual(2, orderAudits.Count);
Assert.AreEqual("Update", orderAudits[0].AuditStatus);
Assert.AreEqual("Cancelled", orderAudits[0].Status);
Assert.AreEqual("Pending", orderAudits[1].Status);
Assert.AreEqual("Insert", orderAudits[1].AuditStatus);
}
using (var ctx = new AuditPerTableContext())
{
var order = ctx.Order.Single(a => a.Number.Equals(id));
var ol = ctx.Orderline.Single(a => a.OrderId.Equals(order.Id) && a.Product.StartsWith("p1"));
ctx.Remove(ol);
ctx.SaveChanges();
}
using (var ctx = new AuditPerTableContext())
{
var order = ctx.Order.Single(a => a.Number.Equals(id));
var orderlineAudits = ctx.OrderlineAudit.AsNoTracking().Where(a => a.OrderId.Equals(order.Id)).OrderByDescending(a => a.AuditDate).ToList();
Assert.AreEqual(3, orderlineAudits.Count);
Assert.AreEqual("Delete", orderlineAudits[0].AuditStatus);
Assert.IsTrue(orderlineAudits[0].Product.StartsWith("p1"));
}
}
public void Test_EFDataProvider()
{
Audit.Core.Configuration.Setup()
.UseEntityFramework(x => x
.AuditTypeExplicitMapper(_ => _
.Map <Order, OrderAudit>((order, auditOrder) => { auditOrder.Status = "Order-" + order.Status; })
.Map <Orderline, OrderlineAudit>()
.AuditEntityAction <AuditBase>((ev, ent, auditEntity) =>
{
auditEntity.AuditDate = DateTime.UtcNow;
auditEntity.UserName = ev.Environment.UserName;
auditEntity.AuditStatus = ent.Action;
})));
var id = Guid.NewGuid().ToString();
using (var ctx = new AuditPerTableContext())
{
var o = new Order()
{
Number = id,
Status = "Pending",
OrderLines = new Collection <Orderline>()
{
new Orderline()
{
Product = "p1: " + id, Quantity = 2
},
new Orderline()
{
Product = "p2: " + id, Quantity = 3
}
}
};
ctx.Set(typeof(Order)).Add(o);
ctx.SaveChanges();
}
using (var ctx = new AuditPerTableContext())
{
var order = ctx.Order.Single(a => a.Number.Equals(id));
var orderAudit = ctx.OrderAudit.AsNoTracking().SingleOrDefault(a => a.Id.Equals(order.Id));
Assert.NotNull(orderAudit);
var orderlineAudits = ctx.OrderlineAudit.AsNoTracking().Where(a => a.OrderId.Equals(order.Id)).ToList();
Assert.AreEqual(2, orderlineAudits.Count);
Assert.AreEqual("p1: " + id, orderlineAudits[0].Product);
Assert.AreEqual("p2: " + id, orderlineAudits[1].Product);
Assert.AreEqual("Insert", orderAudit.AuditStatus);
Assert.AreEqual("Insert", orderlineAudits[0].AuditStatus);
Assert.AreEqual("Insert", orderlineAudits[1].AuditStatus);
Assert.AreEqual(orderlineAudits[0].UserName, orderlineAudits[1].UserName);
Assert.AreEqual(orderlineAudits[0].UserName, orderAudit.UserName);
Assert.IsFalse(string.IsNullOrWhiteSpace(orderlineAudits[0].UserName));
Assert.IsFalse(string.IsNullOrWhiteSpace(orderlineAudits[1].UserName));
}
using (var ctx = new AuditPerTableContext())
{
var o = ctx.Order.Single(a => a.Number.Equals(id));
o.Status = "Cancelled";
ctx.SaveChanges();
}
using (var ctx = new AuditPerTableContext())
{
var orderAudits = ctx.OrderAudit.AsNoTracking().Where(a => a.Number.Equals(id)).OrderByDescending(a => a.AuditDate).ToList();
Assert.AreEqual(2, orderAudits.Count);
Assert.AreEqual("Update", orderAudits[0].AuditStatus);
Assert.AreEqual("Order-Cancelled", orderAudits[0].Status);
Assert.AreEqual("Order-Pending", orderAudits[1].Status);
Assert.AreEqual("Insert", orderAudits[1].AuditStatus);
}
using (var ctx = new AuditPerTableContext())
{
var order = ctx.Order.Single(a => a.Number.Equals(id));
var ol = ctx.Orderline.Single(a => a.OrderId.Equals(order.Id) && a.Product.StartsWith("p1"));
ctx.Orderline.Remove(ol);
ctx.SaveChanges();
}
using (var ctx = new AuditPerTableContext())
{
var order = ctx.Order.Single(a => a.Number.Equals(id));
var orderlineAudits = ctx.OrderlineAudit.AsNoTracking().Where(a => a.OrderId.Equals(order.Id)).OrderByDescending(a => a.AuditDate).ToList();
Assert.AreEqual(3, orderlineAudits.Count);
Assert.AreEqual("Delete", orderlineAudits[0].AuditStatus);
Assert.IsTrue(orderlineAudits[0].Product.StartsWith("p1"));
}
}
