public void CreateLog()
{
var auditConfiguration = AuditConfiguration.Default;
auditConfiguration.IncludeRelationships = true;
auditConfiguration.LoadRelationships = true;
auditConfiguration.DefaultAuditable = true;
// customize the audit for Task entity
auditConfiguration.IsAuditable<Task>()
.NotAudited(t => t.TaskExtended)
.FormatWith(t => t.Status, v => FormatStatus(v));
// set name as the display member when status is a foreign key
auditConfiguration.IsAuditable<Status>()
.DisplayMember(t => t.Name);
var db = new TrackerContext();
var user1 = new User()
{
Id = 1
};
db.Users.Add(user1);
var audit = db.BeginAudit();
var user = db.Users.Find(1);
user.Comment = "Testing: " + DateTime.Now.Ticks;
var task = new Task()
{
Id = 1,
AssignedId = 1,
CreatedId = 1,
StatusId = 1,
PriorityId = 2,
Summary = "Summary: " + DateTime.Now.Ticks
};
db.Tasks.Add(task);
var task2 = db.Tasks.Find(1);
task2.PriorityId = 2;
task2.StatusId = 2;
task2.Summary = "Summary: " + DateTime.Now.Ticks;
var log = audit.CreateLog();
Assert.IsNotNull(log);
string xml = log.ToXml();
Assert.IsNotNull(xml);
}
public void CreateLogLoaded()
{
var auditConfiguration = AuditConfiguration.Default;
auditConfiguration.IncludeRelationships = true;
auditConfiguration.LoadRelationships = true;
auditConfiguration.DefaultAuditable = true;
// customize the audit for Task entity
//auditConfiguration.IsAuditable<Task>()
// .NotAudited(t => t.TaskExtended)
// .FormatWith(t => t.Status, v => FormatStatus(v));
// set name as the display member when status is a foreign key
auditConfiguration.IsAuditable<Status>()
.DisplayMember(t => t.Name);
var db = new TrackerContext();
var audit = db.BeginAudit();
var user = db.Users.Find(1);
user.Comment = "Testing: " + DateTime.Now.Ticks;
var newTask = new Task()
{
AssignedId = 1,
CreatedId = 1,
StatusId = 1,
PriorityId = 2,
Summary = "Summary: " + DateTime.Now.Ticks
};
db.Tasks.Add(newTask);
var p = db.Priorities.Find(2);
var updateTask = db.Tasks.Find(1);
updateTask.Priority = p;
updateTask.StatusId = 2;
updateTask.Summary = "Summary: " + DateTime.Now.Ticks;
var log = audit.CreateLog();
Assert.IsNotNull(log);
string xml = log.ToXml();
Assert.IsNotNull(xml);
foreach (var property in log.Entities.SelectMany(e => e.Properties))
{
Assert.AreNotEqual(property.Current, "{error}");
Assert.AreNotEqual(property.Original, "{error}");
}
}
public void CreateLogFormatWith()
{
var auditConfiguration = AuditConfiguration.Default;
auditConfiguration.IncludeRelationships = true;
auditConfiguration.LoadRelationships = true;
auditConfiguration.DefaultAuditable = true;
// customize the audit for Task entity
auditConfiguration.IsAuditable<Task>()
.NotAudited(t => t.TaskExtended)
.FormatWith(t => t.Status, v => FormatStatus(v));
var db = new TrackerContext();
var audit = db.BeginAudit();
var user = db.Users.Find(1);
user.Comment = "Testing: " + DateTime.Now.Ticks;
var task = new Task()
{
AssignedId = 1,
CreatedId = 1,
StatusId = 1,
PriorityId = 2,
Summary = "Summary: " + DateTime.Now.Ticks
};
db.Tasks.Add(task);
var task2 = db.Tasks.Find(1);
task2.PriorityId = 2;
task2.StatusId = 2;
task2.Summary = "Summary: " + DateTime.Now.Ticks;
var log = audit.CreateLog();
Assert.NotNull(log);
string xml = log.ToXml();
Assert.NotNull(xml);
foreach (var property in log.Entities.SelectMany(e => e.Properties))
{
Assert.NotEqual(property.Current, "{error}");
Assert.NotEqual(property.Original, "{error}");
}
}
public void CreateLog2()
{
AuditConfiguration.Default.IncludeRelationships = true;
AuditConfiguration.Default.LoadRelationships = true;
AuditConfiguration.Default.IsAuditable<Task>();
AuditConfiguration.Default.IsAuditable<User>();
var db = new TrackerContext();
var audit = db.BeginAudit();
var task = db.Tasks.Find(1);
Assert.IsNotNull(task);
task.PriorityId = 2;
task.StatusId = 2;
task.Summary = "Summary: " + DateTime.Now.Ticks;
var log = audit.CreateLog();
Assert.IsNotNull(log);
string xml = log.ToXml();
Assert.IsNotNull(xml);
}
public void CreateLog3()
{
AuditConfiguration.Default.IncludeRelationships = true;
AuditConfiguration.Default.LoadRelationships = true;
AuditConfiguration.Default.IsAuditable<Task>();
AuditConfiguration.Default.IsAuditable<User>();
var db = new TrackerContext();
var audit = db.BeginAudit();
var user = new User();
user.EmailAddress = string.Format("email.{0}@test.com", DateTime.Now.Ticks);
user.CreatedDate = DateTime.Now;
user.ModifiedDate = DateTime.Now;
user.PasswordHash = DateTime.Now.Ticks.ToString();
user.PasswordSalt = "abcde";
user.IsApproved = false;
user.LastActivityDate = DateTime.Now;
db.Users.Add(user);
var log = audit.CreateLog();
Assert.IsNotNull(log);
string beforeXml = log.ToXml();
Assert.IsNotNull(beforeXml);
db.SaveChanges();
log.Refresh();
string afterXml = log.ToXml();
Assert.IsNotNull(afterXml);
}
public void MaintainAcrossSaves()
{
var auditConfiguration = AuditConfiguration.Default;
auditConfiguration.IncludeRelationships = true;
auditConfiguration.LoadRelationships = true;
auditConfiguration.DefaultAuditable = true;
auditConfiguration.MaintainAcrossSaves = true;
// customize the audit for Task entity
//auditConfiguration.IsAuditable<Task>()
// .NotAudited(t => t.TaskExtended)
// .FormatWith(t => t.Status, v => FormatStatus(v));
// set name as the display member when status is a foreign key
auditConfiguration.IsAuditable<Status>()
.DisplayMember(t => t.Name);
var db = new TrackerContext();
var tran = db.BeginTransaction();
var audit = db.BeginAudit();
var user = db.Users.Find(1);
user.Comment = "Testing: " + DateTime.Now.Ticks;
var task = new Task()
{
AssignedId = 1,
StatusId = 1,
PriorityId = 2,
Summary = "Summary: " + DateTime.Now.Ticks,
CreatedId = 1,
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now
};
db.Tasks.Add(task);
db.SaveChanges();
Assert.IsNotNull(audit.LastLog);
Assert.AreEqual(2, audit.LastLog.Entities.Count);
var task2 = db.Tasks.Find(1);
task2.PriorityId = 2;
task2.StatusId = 2;
task2.Summary = "Summary: " + DateTime.Now.Ticks;
db.SaveChanges();
Assert.IsNotNull(audit.LastLog);
Assert.AreEqual(3, audit.LastLog.Entities.Count);
var log = audit.LastLog;
Assert.IsNotNull(log);
string xml = log.ToXml();
Assert.IsNotNull(xml);
foreach (var property in log.Entities.SelectMany(e => e.Properties))
{
Assert.AreNotEqual(property.Current, "{error}");
Assert.AreNotEqual(property.Original, "{error}");
}
//undo work
tran.Rollback();
}
public void Update()
{
AuditConfiguration.Default.IncludeRelationships = true;
AuditConfiguration.Default.LoadRelationships = true;
AuditConfiguration.Default.IsAuditable<Task>();
AuditConfiguration.Default.IsAuditable<User>().NotAudited(p => p.Avatar);
var db = new TrackerContext();
var audit = db.BeginAudit();
var user = new User();
user.EmailAddress = string.Format("email.{0}@test.com", DateTime.Now.Ticks);
user.CreatedDate = DateTime.Now;
user.ModifiedDate = DateTime.Now;
user.PasswordHash = DateTime.Now.Ticks.ToString();
user.PasswordSalt = "abcde";
user.IsApproved = false;
user.LastActivityDate = DateTime.Now;
db.Users.Add(user);
var log = audit.CreateLog();
Assert.IsNotNull(log);
string beforeXml = log.ToXml();
Assert.IsNotNull(beforeXml);
db.SaveChanges();
log.Refresh();
foreach (var property in log.Entities.SelectMany(e => e.Properties))
{
Assert.AreNotEqual(property.Current, "{error}");
Assert.AreNotEqual(property.Original, "{error}");
}
string afterXml = log.ToXml();
Assert.IsNotNull(afterXml);
var lastLog = audit.LastLog;
var lastXml = lastLog.Refresh().ToXml();
Assert.IsNotNull(lastXml);
Console.WriteLine(lastXml);
user.EmailAddress = string.Format("update.{0}@test.com", DateTime.Now.Ticks);
var updateLog = audit.CreateLog();
Assert.IsNotNull(updateLog);
foreach (var property in log.Entities.SelectMany(e => e.Properties))
{
Assert.AreNotEqual(property.Current, "{error}");
Assert.AreNotEqual(property.Original, "{error}");
}
db.SaveChanges();
var updateXml = updateLog.ToXml();
Assert.IsNotNull(updateXml);
Console.WriteLine(updateXml);
}
public void CreateLog2()
{
AuditConfiguration.Default.IncludeRelationships = true;
AuditConfiguration.Default.LoadRelationships = true;
AuditConfiguration.Default.IsAuditable<Task>();
AuditConfiguration.Default.IsAuditable<User>();
var db = new TrackerContext();
var audit = db.BeginAudit();
var task = db.Tasks.Find(1);
Assert.IsNotNull(task);
task.PriorityId = 2;
task.StatusId = 2;
task.Summary = "Summary: " + DateTime.Now.Ticks;
var log = audit.CreateLog();
Assert.IsNotNull(log);
foreach (var property in log.Entities.SelectMany(e => e.Properties))
{
Assert.AreNotEqual(property.Current, "{error}");
Assert.AreNotEqual(property.Original, "{error}");
}
string xml = log.ToXml();
Assert.IsNotNull(xml);
}
public void CompareXml()
{
var auditConfiguration = AuditConfiguration.Default;
auditConfiguration.IncludeRelationships = true;
auditConfiguration.LoadRelationships = true;
auditConfiguration.DefaultAuditable = true;
// customize the audit for Task entity
//auditConfiguration.IsAuditable<Task>()
// .NotAudited(t => t.TaskExtended)
// .FormatWith(t => t.Status, v => FormatStatus(v));
// set name as the display member when status is a foreign key
auditConfiguration.IsAuditable<Status>()
.DisplayMember(t => t.Name);
var db = new TrackerContext();
var audit = db.BeginAudit();
var user = db.Users.Find(1);
user.Comment = "Testing: " + DateTime.Now.Ticks;
var task = new Task()
{
AssignedId = 1,
CreatedId = 1,
StatusId = 1,
PriorityId = 2,
Summary = "Summary: " + DateTime.Now.Ticks
};
db.Tasks.Add(task);
var task2 = db.Tasks.Find(1);
task2.PriorityId = 2;
task2.StatusId = 2;
task2.Summary = "Summary: " + DateTime.Now.Ticks;
var log = audit.CreateLog();
Assert.IsNotNull(log);
string xml = log.ToXml();
Assert.IsNotNull(xml);
File.WriteAllText(@"test.xml.xml", xml);
foreach (var property in log.Entities.SelectMany(e => e.Properties))
{
Assert.AreNotEqual(property.Current, "{error}");
Assert.AreNotEqual(property.Original, "{error}");
}
var builder = new StringBuilder();
var settings = new XmlWriterSettings { Indent = true, OmitXmlDeclaration = true };
var writer = XmlWriter.Create(builder, settings);
var serializer = new DataContractSerializer(typeof(AuditLog));
serializer.WriteStartObject(writer, log);
writer.WriteAttributeString("xmlns", "xsd", null, "http://www.w3.org/2001/XMLSchema");
serializer.WriteObjectContent(writer, log);
serializer.WriteEndObject(writer);
writer.Flush();
string xml2 = builder.ToString();
File.WriteAllText(@"test.data.xml", xml2);
string json = JsonConvert.SerializeObject(log, Newtonsoft.Json.Formatting.Indented, new StringEnumConverter());
File.WriteAllText(@"test.data.json", json);
}
public void LogWithNullableRelationWithoutValueAndAllreadyLoadedRelation()
{
var auditConfiguration = AuditConfiguration.Default;
auditConfiguration.IncludeRelationships = true;
auditConfiguration.LoadRelationships = true;
auditConfiguration.DefaultAuditable = true;
auditConfiguration.MaintainAcrossSaves = false;
auditConfiguration.IsAuditable<Task>();
auditConfiguration.IsAuditable<Priority>().DisplayMember(t => t.Name);
var db = new TrackerContext();
var tran = db.Database.BeginTransaction();
var audit = db.BeginAudit();
var task = new Task()
{
AssignedId = 1,
StatusId = 1,
Priority = null,
Summary = "Summary: " + DateTime.Now.Ticks,
CreatedId = 1,
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now,
};
db.Tasks.Add(task);
var entries = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntries(EntityState.Added);
var relation = entries.First().RelationshipManager.GetRelatedReference<Priority>("Tracker.SqlServer.CodeFirst.Task_Priority", "Task_Priority_Target");
relation.Load();
db.SaveChanges();
foreach (var property in audit.LastLog.Entities.SelectMany(e => e.Properties))
{
Assert.NotEqual(property.Current, "{error}");
Assert.NotEqual(property.Original, "{error}");
}
//undo work
tran.Rollback();
}
public void LogWithNullableRelations()
{
var auditConfiguration = AuditConfiguration.Default;
auditConfiguration.IncludeRelationships = true;
auditConfiguration.LoadRelationships = true;
auditConfiguration.DefaultAuditable = true;
auditConfiguration.MaintainAcrossSaves = false;
auditConfiguration.IsAuditable<Task>();
auditConfiguration.IsAuditable<Priority>().DisplayMember(t => t.Name);
var db = new TrackerContext();
var tran = db.Database.BeginTransaction();
var audit = db.BeginAudit();
var task = new Task()
{
AssignedId = 1,
StatusId = 1,
PriorityId = 2,
Summary = "Summary: " + DateTime.Now.Ticks,
CreatedId = 1,
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now,
};
db.Tasks.Add(task);
db.SaveChanges();
foreach (var property in audit.LastLog.Entities.SelectMany(e => e.Properties))
{
Assert.NotEqual(property.Current, "{error}");
Assert.NotEqual(property.Original, "{error}");
}
task.PriorityId = null;
db.SaveChanges();
foreach (var property in audit.LastLog.Entities.SelectMany(e => e.Properties))
{
Assert.NotEqual(property.Current, "{error}");
Assert.NotEqual(property.Original, "{error}");
}
task.PriorityId = 1;
db.SaveChanges();
foreach (var property in audit.LastLog.Entities.SelectMany(e => e.Properties))
{
Assert.NotEqual(property.Current, "{error}");
Assert.NotEqual(property.Original, "{error}");
}
task.PriorityId = 2;
db.SaveChanges();
foreach (var property in audit.LastLog.Entities.SelectMany(e => e.Properties))
{
Assert.NotEqual(property.Current, "{error}");
Assert.NotEqual(property.Original, "{error}");
}
//undo work
tran.Rollback();
}
