public async Task GetEffectiveUserLicenseAsync_QueryReturnsLicenseType_ReturnsFirst() { // Arrange var cxn = new SqlConnectionWrapperMock(); var repository = new SqlUserRepository(cxn.Object, cxn.Object); var userId = 1; var userIds = new[] { userId }; var userIdTable = SqlConnectionWrapper.ToDataTable(userIds); var result = new List <UserLicense> { new UserLicense { UserId = userId, LicenseType = 3 } }; cxn.SetupQueryAsync("GetEffectiveUserLicense", new Dictionary <string, object> { { "UserIds", userIdTable } }, result); // Act var licenseType = await repository.GetEffectiveUserLicenseAsync(userId); // Assert cxn.Verify(); Assert.AreEqual(result.First().LicenseType, licenseType); }
public async Task GetEffectiveUserLicenseAsync_QueryReturnsEmpty_ReturnsZero() { // Arrange var cxn = new SqlConnectionWrapperMock(); var repository = new SqlUserRepository(cxn.Object, cxn.Object); var userId = 1; var userIds = new[] { userId }; var userIdTable = SqlConnectionWrapper.ToDataTable(userIds); var result = Enumerable.Empty <UserLicense>(); cxn.SetupQueryAsync("GetEffectiveUserLicense", new Dictionary <string, object> { { "UserIds", userIdTable } }, result); // Act var licenseType = await repository.GetEffectiveUserLicenseAsync(userId); // Assert cxn.Verify(); Assert.AreEqual(0, licenseType); }