public async void Dispose()
{
var auditor = new StubAuditor(expectedUserId, () => DateTime.UtcNow);
var gateway = new UserGateway(auditor, connectionString);
await gateway.DeleteUserAsync(expectedUserId);
}
public async void CreateNewUser()
{
BeforeTest();
var expectedUsername = expectedUserId.ToString();
var auditor = new StubAuditor(expectedUserId, () => DateTime.UtcNow);
var gateway = new UserGateway(auditor, connectionString);
await gateway.CreateUserAsync(expectedUserId, expectedUsername);
var user = await gateway.FindUserAsync(auditor.UserId);
Assert.Equal(expectedUserId, user.Id);
Assert.Equal(expectedUsername, user.Username);
}
public void UpdateStatementTest()
{
var expectedSql = @"UPDATE [dbo].[Blog] SET [Name] = @Name, [UpdatedBy] = @UpdatedBy, [UpdatedOn] = @UpdatedOn WHERE [Id] = @Id";
var expectedUserId = Guid.NewGuid();
var expectedCreateDate = DateTime.Now;
var auditor = new StubAuditor(expectedUserId, () => expectedCreateDate);
var factory = new SqlCommandFactory(auditor);
var changes = new Dictionary <string, PropertyChange>()
{
{ "Name", new PropertyChange("A", "B") }
};
var command = factory.CreateUpdateStatement(changes, "[dbo].[Blog]", "Id", 4);
Assert.Equal(expectedSql, command.CommandText);
Assert.Equal(expectedUserId, command.Parameters["UpdatedBy"].Value);
Assert.Equal(expectedCreateDate, command.Parameters["UpdatedOn"].Value);
Assert.Equal("B", command.Parameters["Name"].Value);
}
