/// <summary>
/// Save the entity to the database. This method will auto-generate activity tracking.
/// </summary>
public CustomerInfo Delete()
{
var writer = new StoredProcedureWriter <CustomerInfo>();
this.Fill(writer.Delete(this));
return(this);
}
public void Entity_StoredProcedureEntity_Delete()
{
var writer = new StoredProcedureWriter <CustomerInfo>();
var reader = new EntityReader <CustomerInfo>();
var dbCustomer = new CustomerInfo();
var lastKey = TypeExtension.DefaultGuid;
var originalId = TypeExtension.DefaultInteger;
var originalKey = TypeExtension.DefaultGuid;
Entity_StoredProcedureEntity_Create();
lastKey = StoredProcedureEntityTests.RecycleBin.Last();
dbCustomer = reader.GetByKey(lastKey);
originalId = dbCustomer.Id;
originalKey = dbCustomer.Key;
Assert.IsTrue(!dbCustomer.IsNew);
Assert.IsTrue(dbCustomer.Id != TypeExtension.DefaultInteger);
Assert.IsTrue(dbCustomer.Key != TypeExtension.DefaultGuid);
Assert.IsTrue(dbCustomer.CreatedDate.Date == DateTime.UtcNow.Date);
dbCustomer = writer.Delete(dbCustomer);
Assert.IsTrue(dbCustomer.IsNew);
dbCustomer = reader.GetById(originalId);
Assert.IsTrue(dbCustomer.IsNew);
Assert.IsTrue(dbCustomer.Id == TypeExtension.DefaultInteger);
Assert.IsTrue(dbCustomer.Key == TypeExtension.DefaultGuid);
}
public void Data_StoredProcWriter_Delete()
{
var writer = new StoredProcedureWriter <CustomerInfo>();
var testEntity = new CustomerInfo();
var oldId = TypeExtension.DefaultInteger;
var oldKey = TypeExtension.DefaultGuid;
// Insert and baseline test
this.Data_StoredProcWriter_Insert();
testEntity = new EntityReader <CustomerInfo>().GetAll().OrderByDescending(x => x.CreatedDate).FirstOrDefaultSafe();
oldId = testEntity.Id;
oldKey = testEntity.Key;
Assert.IsTrue(testEntity.IsNew == false);
Assert.IsTrue(testEntity.Id != TypeExtension.DefaultInteger);
Assert.IsTrue(testEntity.Key != TypeExtension.DefaultGuid);
// Do delete
writer.Delete(testEntity);
// Pull from DB and retest
testEntity = new EntityReader <CustomerInfo>().GetById(oldId);
Assert.IsTrue(testEntity.IsNew);
Assert.IsTrue(testEntity.Id != oldId);
Assert.IsTrue(testEntity.Key != oldKey);
Assert.IsTrue(testEntity.IsNew);
Assert.IsTrue(testEntity.Key == TypeExtension.DefaultGuid);
// Add to recycle bin for cleanup
DatabaseWriterTests.RecycleBin.Add(testEntity.Key);
}