public void Return_None()
{
TestContext.DeleteAll(x => x.AuditEntryProperties);
TestContext.DeleteAll(x => x.AuditEntries);
TestContext.DeleteAll(x => x.Entity_Basics);
TestContext.Insert(x => x.Entity_Basics, 3);
var audit = AuditHelper.AutoSaveAudit();
Entity_Basic auditedItem = null;
using (var ctx = new TestContext())
{
TestContext.Insert(ctx, x => x.Entity_Basics, 3);
ctx.SaveChanges(audit);
}
// GET the audited item
auditedItem = TestContext.Insert(x => x.Entity_Basics, 3)[0];
// UnitTest - Audit
{
using (var ctx = new TestContext())
{
var auditEntries = ctx.AuditEntries.Where <Entity_Basic>(auditedItem.ID).ToList();
Assert.AreEqual(0, auditEntries.Count);
}
}
}
public void Array_Equal()
{
TestContext.DeleteAll(x => x.AuditEntryProperties);
TestContext.DeleteAll(x => x.AuditEntries);
TestContext.DeleteAll(x => x.Entity_Basics);
TestContext.Insert(x => x.Entity_Basics, 3);
var audit = AuditHelper.AutoSaveAudit();
Entity_Basic auditedItem = null;
using (var ctx = new TestContext())
{
auditedItem = TestContext.Insert(ctx, x => x.Entity_Basics, 3)[2];
ctx.SaveChanges(audit);
}
// UnitTest - Audit
{
using (var ctx = new TestContext())
{
var auditEntries = ctx.AuditEntries.Where <Entity_Basic>(auditedItem.ID).ToList();
Assert.AreEqual(1, auditEntries.Count);
{
var auditEntry = auditEntries[0];
Assert.AreEqual(auditedItem.ID.ToString(), auditEntry.Properties.Single(x => x.PropertyName == "ID").NewValueFormatted);
Assert.AreEqual(auditedItem.ColumnInt.ToString(), auditEntry.Properties.Single(x => x.PropertyName == "ColumnInt").NewValueFormatted);
}
}
}
}
public void Array_Null()
{
TestContext.DeleteAll(x => x.AuditEntryProperties);
TestContext.DeleteAll(x => x.AuditEntries);
TestContext.DeleteAll(x => x.Entity_Basics);
TestContext.Insert(x => x.Entity_Basics, 3);
var audit = AuditHelper.AutoSaveAudit();
Entity_Basic auditedItem = null;
using (var ctx = new TestContext())
{
auditedItem = TestContext.Insert(ctx, x => x.Entity_Basics, 3)[2];
ctx.SaveChanges(audit);
}
// UnitTest - Audit
{
using (var ctx = new TestContext())
{
try
{
var auditEntries = ctx.AuditEntries.Where <Entity_Basic>((object[])null).ToList();
throw new Exception("Oops! Invalid exception message.");
}
catch (Exception ex)
{
Assert.AreEqual(ExceptionMessage.Audit_Key_Null, ex.Message);
}
}
}
}
public void Value_New()
{
TestContext.DeleteAll(x => x.AuditEntryProperties);
TestContext.DeleteAll(x => x.AuditEntries);
TestContext.DeleteAll(x => x.Entity_Basics);
TestContext.Insert(x => x.Entity_Basics, 3);
var audit = AuditHelper.AutoSaveAudit();
Entity_Basic auditedItem = null;
using (var ctx = new TestContext())
{
TestContext.Insert(ctx, x => x.Entity_Basics, 3);
ctx.SaveChanges(audit);
}
auditedItem = new Entity_Basic();
// UnitTest - Audit
{
using (var ctx = new TestContext())
{
var auditEntries = ctx.AuditEntries.Where(auditedItem).ToList();
Assert.AreEqual(0, auditEntries.Count);
}
}
}
public void Return_Many()
{
TestContext.DeleteAll(x => x.AuditEntryProperties);
TestContext.DeleteAll(x => x.AuditEntries);
TestContext.DeleteAll(x => x.Entity_Basics);
TestContext.Insert(x => x.Entity_Basics, 3);
var audit = AuditHelper.AutoSaveAudit();
var audit2 = AuditHelper.AutoSaveAudit();
Entity_Basic auditedItem = null;
int originalValue;
using (var ctx = new TestContext())
{
auditedItem = TestContext.Insert(ctx, x => x.Entity_Basics, 3)[2];
ctx.SaveChanges(audit);
originalValue = auditedItem.ColumnInt;
auditedItem.ColumnInt += 2;
ctx.SaveChanges(audit2);
}
// UnitTest - Audit
{
using (var ctx = new TestContext())
{
var auditEntries = ctx.AuditEntries.Where <Entity_Basic>(auditedItem.ID).ToList();
Assert.AreEqual(2, auditEntries.Count);
{
var auditEntry = auditEntries[0];
Assert.AreEqual(auditedItem.ID.ToString(), auditEntry.Properties.Single(x => x.PropertyName == "ID").NewValueFormatted);
Assert.AreEqual(originalValue.ToString(), auditEntry.Properties.Single(x => x.PropertyName == "ColumnInt").NewValueFormatted);
Assert.AreEqual("2", auditEntry.Properties.Single(x => x.PropertyName == "ColumnInt").NewValueFormatted);
}
{
var auditEntry = auditEntries[1];
Assert.AreEqual(auditedItem.ID.ToString(), auditEntry.Properties.Single(x => x.PropertyName == "ID").NewValueFormatted);
Assert.AreEqual(originalValue.ToString(), auditEntry.Properties.Single(x => x.PropertyName == "ColumnInt").OldValueFormatted);
Assert.AreEqual(auditedItem.ColumnInt.ToString(), auditEntry.Properties.Single(x => x.PropertyName == "ColumnInt").NewValueFormatted);
Assert.AreEqual("2", auditEntry.Properties.Single(x => x.PropertyName == "ColumnInt").OldValueFormatted);
Assert.AreEqual("4", auditEntry.Properties.Single(x => x.PropertyName == "ColumnInt").NewValueFormatted);
}
}
}
}
public void Single_Property_Type()
{
TestContext.DeleteAll(x => x.Entity_Basics);
TestContext.Insert(x => x.Entity_Basics, 50);
using (var ctx = new TestContext())
{
// BEFORE
Assert.AreEqual(1225, ctx.Entity_Basics.Sum(x => x.ColumnInt));
// ACTION
var entity = new Entity_Basic {ColumnInt = 99};
var rowsAffected = ctx.Entity_Basics.Where(x => x.ColumnInt > 10 && x.ColumnInt <= 40).Update(x => new Entity_Basic {ColumnInt = entity.ColumnInt});
// AFTER
Assert.AreEqual(3430, ctx.Entity_Basics.Sum(x => x.ColumnInt));
Assert.AreEqual(30, rowsAffected);
}
}
public void Single_Property_Type()
{
TestContext.DeleteAll(x => x.Entity_Basics);
TestContext.Insert(x => x.Entity_Basics, 50);
using (var ctx = new TestContext())
{
// BEFORE
Assert.AreEqual(1225, ctx.Entity_Basics.Sum(x => x.ColumnInt));
// ACTION
var entity = new Entity_Basic {
ColumnInt = 99
};
var rowsAffected = ctx.Entity_Basics.Where(x => x.ColumnInt > 10 && x.ColumnInt <= 40).Update(x => new Entity_Basic {
ColumnInt = entity.ColumnInt
});
// AFTER
Assert.AreEqual(3430, ctx.Entity_Basics.Sum(x => x.ColumnInt));
Assert.AreEqual(30, rowsAffected);
}
}
