public async Task GetAlllisting_ListingExists_ReturnAllRowsInExistingListings() { // Arrange ITraditionalListingSearchRepository traditionalListingSearchRepository = new TraditionalListingSearchRepository(new SQLServerGateway(), new ConnectionStringData()); // Act IEnumerable <DALListingModel> dAlListings = await traditionalListingSearchRepository.GetAllListings(); // Assert int i = 1; foreach (DALListingModel listings in dAlListings) { if (listings.Id == i) { ++i; continue; } Assert.IsTrue(false); return; } Assert.IsTrue(true); }
public async Task CleanUp() { IDataGateway dataGateway = new SQLServerGateway(); IConnectionStringData connectionString = new ConnectionStringData(); ITraditionalListingSearchRepository traditionalListingSearchRepository = new TraditionalListingSearchRepository(new SQLServerGateway(), new ConnectionStringData()); var accounts = await traditionalListingSearchRepository.GetAllListings(); // Delete Listing is not cooperating... place it here once its working. await DataAccessTestHelper.ReseedAsync("Listing", 0, connectionString, dataGateway); }
public static async Task CleanDatabase() { IDataGateway dataGateway = new SQLServerGateway(); IConnectionStringData connectionString = new ConnectionStringData(); IUserAccountRepository userAccountRepository = new UserAccountRepository(dataGateway, connectionString); IUserProfileRepository userProfileRepository = new UserProfileRepository(dataGateway, connectionString); IUserAccountCodeRepository userAccountCodeRepository = new UserAccountCodeRepository(dataGateway, connectionString); IUserAccountSettingsRepository userAccountSettingsRepository = new UserAccountSettingRepository(dataGateway, connectionString); ILoginAttemptsRepository loginAttemptsRepository = new LoginAttemptsRepository(dataGateway, connectionString); IResourceRepository resourceRepository = new ResourceRepository(dataGateway, connectionString); IClaimRepository claimRepository = new ClaimRepository(dataGateway, connectionString); IScopeRepository scopeRepository = new ScopeRepository(dataGateway, connectionString); IScopeClaimRepository scopeClaimRepository = new ScopeClaimRepository(dataGateway, connectionString); IUserScopeRepository userScopeRepository = new UserScopeRepository(dataGateway, connectionString); IUserClaimRepository userClaimRepository = new UserClaimRepository(dataGateway, connectionString); IAssignmentPolicyRepository assignmentPolicyRepository = new AssignmentPolicyRepository(dataGateway, connectionString); IAssignmentPolicyPairingRepository assignmentPolicyPairingRepository = new AssignmentPolicyPairingRepository(dataGateway, connectionString); IUserScopeClaimRepository userScopeClaimRepository = new UserScopeClaimRepository(dataGateway, connectionString); IAccessPolicyRepository accessPolicyRepository = new AccessPolicyRepository(dataGateway, connectionString); IAccessPolicyPairingRepository accessPolicyPairingRepository = new AccessPolicyPairingRepository(dataGateway, connectionString); ITraditionalListingSearchRepository traditionalListingSearchRepository = new TraditionalListingSearchRepository(dataGateway, connectionString); var accounts = await userAccountRepository.GetAllAccounts(); var profiles = await userProfileRepository.GetAllUserProfiles(); var accountCodes = await userAccountCodeRepository.GetAllUserAccountCodes(); var accountSettings = await userAccountSettingsRepository.GetAllSettings(); var loginAttempts = await loginAttemptsRepository.GetAllLoginAttempts(); var resources = await resourceRepository.GetAllResources(); var claims = await claimRepository.GetAllClaims(); var scopes = await scopeRepository.GetAllScopes(); var scopeClaims = await scopeClaimRepository.GetAllScopeClaims(); var userClaims = await userClaimRepository.GetAllUserClaims(); var userScopes = await userScopeRepository.GetAllUserScopes(); var assignmentPolicies = await assignmentPolicyRepository.GetAllAssignmentPolicies(); var assignmentPolicyPairings = await assignmentPolicyPairingRepository.GetAllAssignmentPolicyPairings(); var userScopeClaims = await userScopeClaimRepository.GetAllUserScopeClaims(); var accessPolicies = await accessPolicyRepository.GetAllAccessPolicies(); var accesssPolicyPairings = await accessPolicyPairingRepository.GetAllAccessPoliciesPairings(); var listings = await traditionalListingSearchRepository.GetAllListings(); var collaborationListings = await traditionalListingSearchRepository.GetAllCollaborationListings(); var relationshipListings = await traditionalListingSearchRepository.GetAllRelationshipListings(); var teamListings = await traditionalListingSearchRepository.GetAllTeamListings(); if (resources != null) { await DeleteAllFromTable("Resource"); await ReseedAsync("Resource", 0, connectionString, dataGateway); } if (claimRepository != null) { await DeleteAllFromTable("Claim"); await ReseedAsync("Claim", 0, connectionString, dataGateway); } if (scopeRepository != null) { await DeleteAllFromTable("Scope"); await ReseedAsync("Scope", 0, connectionString, dataGateway); } if (scopeClaims != null) { await DeleteAllFromTable("ScopeClaim"); await ReseedAsync("ScopeClaim", 0, connectionString, dataGateway); } if (assignmentPolicies != null) { await DeleteAllFromTable("AssignmentPolicy"); await ReseedAsync("AssignmentPolicy", 0, connectionString, dataGateway); } if (assignmentPolicyPairings != null) { await DeleteAllFromTable("AssignmentPolicyPairing"); } if (userScopeClaims != null) { await DeleteAllFromTable("UserScopeClaim"); await ReseedAsync("UserScopeClaim", 0, connectionString, dataGateway); } if (userScopes != null) { await DeleteAllFromTable("UserScope"); await ReseedAsync("UserScope", 0, connectionString, dataGateway); } if (userClaims != null) { await DeleteAllFromTable("UserClaim"); await ReseedAsync("UserClaim", 0, connectionString, dataGateway); } if (accessPolicies != null) { await DeleteAllFromTable("AccessPolicy"); await ReseedAsync("AccessPolicy", 0, connectionString, dataGateway); } if (accesssPolicyPairings != null) { await DeleteAllFromTable("AccessPolicyPairing"); await ReseedAsync("AssignmentPolicyPairing", 0, connectionString, dataGateway); await ReseedAsync("AccessPolicyPairing", 0, connectionString, dataGateway); } if (loginAttempts != null) { await DeleteAllFromTable("LoginAttempts"); await ReseedAsync("LoginAttempts", 0, connectionString, dataGateway); } if (accounts != null) { await DeleteAllFromTable("UserProfile"); await DeleteAllFromTable("UserAccountSettings"); await DeleteAllFromTable("UserAccountCode"); await DeleteAllFromTable("UserAccount"); await ReseedAsync("UserAccount", 0, connectionString, dataGateway); await ReseedAsync("UserProfile", 0, connectionString, dataGateway); await ReseedAsync("UserAccountCode", 0, connectionString, dataGateway); await ReseedAsync("UserAccountSettings", 0, connectionString, dataGateway); } if (listings != null) { await DeleteAllFromTable("Listing"); await ReseedAsync("Listing", 0, connectionString, dataGateway); } if (collaborationListings != null) { await DeleteAllFromTable("Collaboration"); await ReseedAsync("Collaboration", 0, connectionString, dataGateway); } if (relationshipListings != null) { await DeleteAllFromTable("Relationship"); await ReseedAsync("Relationship", 0, connectionString, dataGateway); } if (teamListings != null) { await DeleteAllFromTable("TeamModel"); await ReseedAsync("TeamModel", 0, connectionString, dataGateway); } }