public async void GetComplianceYearsWithSubmittedMemberUploads_SchemeWithTwoSubmittedMemberUploadsInSameYear_ReturnsYearOnce() { const int complianceYear = 1956; using (var databaseWrapper = new DatabaseWrapper()) { // Arrange var modelHelper = new ModelHelper(databaseWrapper.Model); var scheme = modelHelper.CreateScheme(); var firstMemberUpload = modelHelper.CreateMemberUpload(scheme); firstMemberUpload.IsSubmitted = true; firstMemberUpload.ComplianceYear = complianceYear; var secondMemberUpload = modelHelper.CreateMemberUpload(scheme); secondMemberUpload.IsSubmitted = true; secondMemberUpload.ComplianceYear = complianceYear; await databaseWrapper.Model.SaveChangesAsync(); // Act var dataAccess = new SchemeDataAccess(databaseWrapper.WeeeContext); var result = await dataAccess.GetComplianceYearsWithSubmittedMemberUploads(scheme.Id); // Assert Assert.Single(result); Assert.Equal(complianceYear, result.Single()); } }
public async void GetComplianceYearsWithSubmittedMemberUploads_SchemeWithTwoSubmittedMemberUploadsInDifferentYears_ReturnsBothYears() { const int firstComplianceYear = 1921; const int secondComplianceYear = 1922; using (var databaseWrapper = new DatabaseWrapper()) { // Arrange var modelHelper = new ModelHelper(databaseWrapper.Model); var scheme = modelHelper.CreateScheme(); var firstMemberUpload = modelHelper.CreateMemberUpload(scheme); firstMemberUpload.IsSubmitted = true; firstMemberUpload.ComplianceYear = firstComplianceYear; var secondMemberUpload = modelHelper.CreateMemberUpload(scheme); secondMemberUpload.IsSubmitted = true; secondMemberUpload.ComplianceYear = secondComplianceYear; await databaseWrapper.Model.SaveChangesAsync(); // Act var dataAccess = new SchemeDataAccess(databaseWrapper.WeeeContext); var result = await dataAccess.GetComplianceYearsWithSubmittedMemberUploads(scheme.Id); // Assert Assert.Equal(2, result.Count); Assert.Contains(firstComplianceYear, result); Assert.Contains(secondComplianceYear, result); } }
public async void GetComplianceYearsWithSubmittedMemberUploads_SchemeHasSubmittedMemberUpload_ReturnsCorrespondingComplianceYear() { const int complianceYear = 1923; using (var databaseWrapper = new DatabaseWrapper()) { // Arrange var modelHelper = new ModelHelper(databaseWrapper.Model); var scheme = modelHelper.CreateScheme(); var memberUpload = modelHelper.CreateMemberUpload(scheme); memberUpload.IsSubmitted = true; memberUpload.ComplianceYear = complianceYear; await databaseWrapper.Model.SaveChangesAsync(); // Act var dataAccess = new SchemeDataAccess(databaseWrapper.WeeeContext); var result = await dataAccess.GetComplianceYearsWithSubmittedMemberUploads(scheme.Id); // Assert Assert.Single(result); Assert.Equal(complianceYear, result.Single()); } }
public async void GetComplianceYearsWithSubmittedMemberUploads_SchemeHasNoMemberUploads_ReturnsNoYears() { using (var databaseWrapper = new DatabaseWrapper()) { // Arrange var modelHelper = new ModelHelper(databaseWrapper.Model); var scheme = modelHelper.CreateScheme(); await databaseWrapper.Model.SaveChangesAsync(); // Act var dataAccess = new SchemeDataAccess(databaseWrapper.WeeeContext); var result = await dataAccess.GetComplianceYearsWithSubmittedMemberUploads(scheme.Id); // Assert Assert.Empty(result); } }