public void Test_EF_TransactionId()
{
var evs = new List<AuditEvent>();
Audit.Core.Configuration.Setup()
.Use(_ => _.OnInsert(ev =>
{
evs.Add(ev);
}));
var id = Guid.NewGuid().ToString().Substring(0, 8);
using (var context = new BlogsContext())
{
using (var tran = context.Database.BeginTransaction())
{
var blog = context.Blogs.First();
blog.Title = id;
context.SaveChanges();
tran.Commit();
}
}
Assert.AreEqual(1, evs.Count);
Assert.IsTrue(!string.IsNullOrWhiteSpace(evs[0].GetEntityFrameworkEvent().TransactionId));
}
public void Test_EF_MapMultipleTypesToSameAuditType()
{
var guid = Guid.NewGuid().ToString();
Audit.Core.Configuration.Setup()
.UseEntityFramework(_ => _
.UseDbContext <BlogsContext>()
.AuditTypeExplicitMapper(m => m
.Map <Blog, CommonAudit>((blog, commonAudit) =>
{
commonAudit.EntityType = "Blog";
commonAudit.EntityId = blog.Id;
commonAudit.Title = blog.Title;
commonAudit.Group = guid;
})
.Map <Post, CommonAudit>((post, commonAudit) =>
{
commonAudit.EntityType = "Post";
commonAudit.EntityId = post.Id;
commonAudit.Title = post.Title;
commonAudit.Group = guid;
})
.AuditEntityAction <IAuditEntity>((ev, entry, entity) =>
{
entity.AuditAction = entry.Action;
entity.AuditDate = DateTime.Now;
entity.AuditUser = Environment.UserName;
entity.Exception = ev.GetEntityFrameworkEvent().ErrorMessage;
})));
using (var context = new BlogsContext())
{
context.Blogs.Add(new Blog {
BloggerName = guid, Title = "TestBlog"
});
context.SaveChanges();
var blog = context.Blogs.First(b => b.BloggerName == guid);
context.Posts.Add(new Post()
{
BlogId = blog.Id, Title = "TestPost", Content = guid
});
context.SaveChanges();
var post = context.Posts.First(b => b.Content == guid);
var audits = context.CommonAudits.Where(a => a.Group == guid).OrderBy(a => a.AuditDate).ToList();
Assert.AreEqual(2, audits.Count);
Assert.AreEqual("Blog", audits[0].EntityType);
Assert.AreEqual(blog.Id, audits[0].EntityId);
Assert.AreEqual(blog.Title, audits[0].Title);
Assert.AreEqual("Post", audits[1].EntityType);
Assert.AreEqual(post.Id, audits[1].EntityId);
Assert.AreEqual(post.Title, audits[1].Title);
Assert.AreEqual(Environment.UserName, audits[0].AuditUser);
Assert.AreEqual(Environment.UserName, audits[1].AuditUser);
}
}
public void Test_EF_MapOneTypeToMultipleAuditTypes()
{
var guid = Guid.NewGuid().ToString();
Audit.Core.Configuration.Setup()
.UseEntityFramework(_ => _
.UseDbContext <BlogsContext>()
.AuditTypeExplicitMapper(m => m
.Map <Blog>(mapper: entry => entry.Action == "Update" ? typeof(BlogAudit) : typeof(CommonAudit),
entityAction: (ev, entry, entity) =>
{
if (entry.Action == "Update")
{
Assert.AreEqual(typeof(BlogAudit), entity.GetType());
var ba = entity as BlogAudit;
ba.BlogId = (int)entry.PrimaryKey.First().Value;
}
else
{
Assert.AreEqual(typeof(CommonAudit), entity.GetType());
var ca = entity as CommonAudit;
ca.Group = guid;
ca.EntityType = entry.EntityType.Name;
ca.EntityId = (int)entry.PrimaryKey.First().Value;
}
})
.Map <Post, PostAudit>((post, postAudit) =>
{
postAudit.PostId = post.Id;
})
.AuditEntityAction <IAuditEntity>((ev, entry, entity) =>
{
entity.AuditAction = entry.Action;
entity.AuditDate = DateTime.Now;
entity.AuditUser = Environment.UserName;
entity.Exception = ev.GetEntityFrameworkEvent().ErrorMessage;
})));
using (var context = new BlogsContext())
{
context.Blogs.Add(new Blog {
BloggerName = guid, Title = "TestBlog"
});
context.SaveChanges(); // CommonAudit
var blog = context.Blogs.First(b => b.BloggerName == guid);
var newTitle = guid.Substring(0, 10);
blog.Title = newTitle;
context.SaveChanges(); // BlogAudit
var audits = context.CommonAudits.Where(a => a.Group == guid).OrderBy(a => a.AuditDate).ToList();
var blogaudits = context.BlogsAudits.Where(x => x.Title == newTitle).ToList();
Assert.IsNotNull(blogaudits);
Assert.AreEqual(1, blogaudits.Count);
Assert.AreEqual(blog.Id, blogaudits[0].BlogId);
Assert.AreEqual(1, audits.Count);
Assert.AreEqual("Blog", audits[0].EntityType);
Assert.AreEqual(blog.Id, audits[0].EntityId);
Assert.AreEqual("TestBlog", audits[0].Title);
Assert.AreEqual(Environment.UserName, audits[0].AuditUser);
}
}