public async Task GetUser_MatchEmailAddress_ReturnPostcode()
{
UserTemplate user = new UserTemplate();
UserAddressTemplate userA = new UserAddressTemplate(user);
await TestRunner.InsertTemplateAsync(user);
await TestRunner.InsertTemplateAsync(userA);
IList <QueryResult> result = await TestRunner.ExecuteStoredProcedureMultipleDataSetAsync("dbo.GetUser", new SqlQueryParameter("EmailAddress", "*****@*****.**"));
result[0]
.AssertRowCount(1)
.AssertColumnsExist("FirstName", "LastName", "Postcode")
.AssertRowValues(0, new DataSetRow
{
{ "FirstName", "Jamie" },
{ "LastName", "Burns" },
{ "Postcode", "HD6 3UB" }
});
result[1]
.AssertRowCount(1)
.AssertColumnsExist("TotalUsers")
.AssertValue(0, "TotalUsers", 1);
}
public UserWithAddressTemplate()
{
User = new UserTemplate();
UserAddress = new UserAddressTemplate();
}
public UserWithTwoAddressesTemplate()
{
User = new UserTemplate();
UserAddress1 = new UserAddressTemplate();
UserAddress2 = new UserAddressTemplate();
}
