public async Task FetchLatestProducers_WithProducerRegisteredTwiceIn2015_ReturnsOnlyLatestProducer() { using (DatabaseWrapper database = new DatabaseWrapper()) { ModelHelper helper = new ModelHelper(database.Model); // Arrange Model.Scheme scheme = helper.CreateScheme(); Model.MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme); memberUpload1.ComplianceYear = 2015; memberUpload1.IsSubmitted = true; Model.ProducerSubmission producer1 = helper.CreateProducerAsCompany(memberUpload1, "AAAAA"); producer1.UpdatedDate = new DateTime(2015, 1, 1); Model.MemberUpload memberUpload2 = helper.CreateMemberUpload(scheme); memberUpload2.ComplianceYear = 2015; memberUpload2.IsSubmitted = true; Model.ProducerSubmission producer2 = helper.CreateProducerAsCompany(memberUpload2, "AAAAA"); producer2.UpdatedDate = new DateTime(2015, 1, 2); database.Model.SaveChanges(); // Act FetchProducerSearchResultsForCacheDataAccess dataAccess = new FetchProducerSearchResultsForCacheDataAccess(database.WeeeContext); var results = await dataAccess.FetchLatestProducers(); // Assert Assert.NotNull(results); Assert.Contains(results, p => p.RegistrationNumber == "AAAAA" && p.Name == producer2.Business.Company.Name); Assert.DoesNotContain(results, p => p.RegistrationNumber == "AAAAA" && p.Name == producer1.Business.Company.Name); } }
public async void HasMemberSubmissions_ForOganisationWithAssociatedScheme_AndNoSubmission_ReturnsFalse() { using (DatabaseWrapper database = new DatabaseWrapper()) { ModelHelper helper = new ModelHelper(database.Model); // Arrange var scheme = helper.CreateScheme(); var upload1 = helper.CreateMemberUpload(scheme); upload1.IsSubmitted = false; upload1.ComplianceYear = 2016; var upload2 = helper.CreateMemberUpload(scheme); upload2.IsSubmitted = false; upload2.ComplianceYear = 2016; database.Model.SaveChanges(); var dataAccess = new GetOrganisationOverviewDataAccess(database.WeeeContext); // Act var result = await dataAccess.HasMemberSubmissions(scheme.OrganisationId); // Assert Assert.False(result); } }
public void FetchSumOfExistingCharges_WithProducerWithNoChargesInSpecifiedYear_ReturnsZero() { using (DatabaseWrapper database = new DatabaseWrapper()) { // Arrange ModelHelper helper = new ModelHelper(database.Model); Scheme scheme = helper.CreateScheme(); MemberUpload memberUpload = helper.CreateMemberUpload(scheme); memberUpload.ComplianceYear = 2015; memberUpload.IsSubmitted = true; ProducerSubmission producer = helper.CreateProducerAsCompany(memberUpload, "AAAAA"); producer.ChargeThisUpdate = 1; database.Model.SaveChanges(); ProducerChargeCalculatorDataAccess dataAccess = new ProducerChargeCalculatorDataAccess(database.WeeeContext); // Act decimal result = dataAccess.FetchSumOfExistingCharges(scheme.ApprovalNumber, "AAAAA", 2016); // Assert Assert.Equal(0, result); } }
public void GetLatestProducerForComplianceYearAndScheme_PrnDoesNotMatch_ReturnsNull() { using (DatabaseWrapper database = new DatabaseWrapper()) { ModelHelper helper = new ModelHelper(database.Model); // Arrange Scheme scheme = helper.CreateScheme(); MemberUpload memberUpload = helper.CreateMemberUpload(scheme); memberUpload.ComplianceYear = 2016; memberUpload.IsSubmitted = true; Weee.Tests.Core.Model.ProducerSubmission producer = helper.CreateProducerAsCompany(memberUpload, "AAAAAAAA"); database.Model.SaveChanges(); ProducerQuerySet querySet = ProducerQuerySet(database.WeeeContext); // Act var result = querySet.GetLatestProducerForComplianceYearAndScheme("XXXXXXXX", "2016", scheme.OrganisationId); // Assert Assert.Null(result); } }
public void FetchSumOfExistingCharges_WithSameProducerWithDifferentSchemesInSameYear_ReturnsChargesPerScheme() { using (DatabaseWrapper database = new DatabaseWrapper()) { // Arrange ModelHelper helper = new ModelHelper(database.Model); Scheme scheme1 = helper.CreateScheme(); scheme1.ApprovalNumber = "FirstScheme"; MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme1); memberUpload1.ComplianceYear = 2016; memberUpload1.IsSubmitted = true; ProducerSubmission producer1 = helper.CreateProducerAsCompany(memberUpload1, "AAAAA"); producer1.ChargeThisUpdate = 1; Scheme scheme2 = helper.CreateScheme(); scheme2.ApprovalNumber = "SecondScheme"; MemberUpload memberUpload2 = helper.CreateMemberUpload(scheme2); memberUpload2.ComplianceYear = 2016; memberUpload2.IsSubmitted = true; ProducerSubmission producer2 = helper.CreateProducerAsCompany(memberUpload2, "AAAAA"); producer2.ChargeThisUpdate = 2; database.Model.SaveChanges(); ProducerChargeCalculatorDataAccess dataAccess = new ProducerChargeCalculatorDataAccess(database.WeeeContext); // Act decimal producer1Charge = dataAccess.FetchSumOfExistingCharges("FirstScheme", "AAAAA", 2016); decimal producer2Charge = dataAccess.FetchSumOfExistingCharges("SecondScheme", "AAAAA", 2016); // Assert Assert.Equal(1, producer1Charge); Assert.Equal(2, producer2Charge); } }
public void FetchSumOfExistingCharges_WithProducerWithSeveralCharges_ReturnsSumOfChargeAmounts() { using (DatabaseWrapper database = new DatabaseWrapper()) { // Arrange ModelHelper helper = new ModelHelper(database.Model); Scheme scheme = helper.CreateScheme(); MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme); memberUpload1.ComplianceYear = 2016; memberUpload1.IsSubmitted = true; ProducerSubmission producer1 = helper.CreateProducerAsCompany(memberUpload1, "AAAAA"); producer1.ChargeThisUpdate = 1; MemberUpload memberUpload2 = helper.CreateMemberUpload(scheme); memberUpload2.ComplianceYear = 2016; memberUpload2.IsSubmitted = true; ProducerSubmission producer2 = helper.CreateProducerAsCompany(memberUpload2, "AAAAA"); producer2.ChargeThisUpdate = 2; MemberUpload memberUpload3 = helper.CreateMemberUpload(scheme); memberUpload3.ComplianceYear = 2016; memberUpload3.IsSubmitted = true; ProducerSubmission producer3 = helper.CreateProducerAsCompany(memberUpload3, "AAAAA"); producer3.ChargeThisUpdate = 3; database.Model.SaveChanges(); ProducerChargeCalculatorDataAccess dataAccess = new ProducerChargeCalculatorDataAccess(database.WeeeContext); // Act decimal result = dataAccess.FetchSumOfExistingCharges(scheme.ApprovalNumber, "AAAAA", 2016); // Assert Assert.Equal(6, result); } }
public void GetLatestCompanyProducers_ReturnsCurrentForComplianceYearCompaniesOnly() { using (DatabaseWrapper database = new DatabaseWrapper()) { ModelHelper helper = new ModelHelper(database.Model); // Arrange Scheme scheme1 = helper.CreateScheme(); MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme1); memberUpload1.ComplianceYear = 2015; memberUpload1.IsSubmitted = true; ProducerSubmission companyProducer1 = helper.CreateProducerAsCompany(memberUpload1, "AA"); ProducerSubmission companyProducer2 = helper.CreateProducerAsCompany(memberUpload1, "BB"); ProducerSubmission companyProducer3 = helper.CreateProducerAsCompany(memberUpload1, "AA"); database.Model.SaveChanges(); // Act var result = ProducerQuerySet(database.WeeeContext).GetLatestCompanyProducers(); // Assert Assert.DoesNotContain(result, p => p.Id == companyProducer1.Id); Assert.Contains(result, p => p.Id == companyProducer2.Id); Assert.Contains(result, p => p.Id == companyProducer3.Id); } }
public void GetLatestCompanyProducers_ReturnsCompaniesOnly() { using (DatabaseWrapper database = new DatabaseWrapper()) { ModelHelper helper = new ModelHelper(database.Model); // Arrange Scheme scheme1 = helper.CreateScheme(); MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme1); memberUpload1.ComplianceYear = 2015; memberUpload1.IsSubmitted = true; Weee.Tests.Core.Model.ProducerSubmission companyProducer1 = helper.CreateProducerAsCompany(memberUpload1, "AAAAAAA"); Weee.Tests.Core.Model.ProducerSubmission partnershipProducer = helper.CreateProducerAsPartnership(memberUpload1, "PPP1"); Weee.Tests.Core.Model.ProducerSubmission soleTraderProducer = helper.CreateProducerAsSoleTrader(memberUpload1, "SSS1"); Weee.Tests.Core.Model.ProducerSubmission companyProducer2 = helper.CreateProducerAsCompany(memberUpload1, "AAAAAAB"); database.Model.SaveChanges(); // Act var result = ProducerQuerySet(database.WeeeContext).GetLatestCompanyProducers(); // Assert Assert.Contains(result, p => p.Id == companyProducer1.Id); Assert.Contains(result, p => p.Id == companyProducer2.Id); Assert.DoesNotContain(result, p => p.Id == soleTraderProducer.Id); Assert.DoesNotContain(result, p => p.Id == partnershipProducer.Id); } }
public void GetProducerForOtherSchemeAndObligationType_ForAnotherSchemeSameObligationType_ReturnsAnotherSchemeProducer() { using (DatabaseWrapper database = new DatabaseWrapper()) { ModelHelper helper = new ModelHelper(database.Model); // Arrange Scheme scheme1 = helper.CreateScheme(); Scheme scheme2 = helper.CreateScheme(); MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme2); memberUpload1.ComplianceYear = 2015; memberUpload1.IsSubmitted = true; Weee.Tests.Core.Model.ProducerSubmission producer1 = helper.CreateProducerAsCompany(memberUpload1, "AAAAAAA"); producer1.ObligationType = "B2C"; database.Model.SaveChanges(); ProducerQuerySet querySet = ProducerQuerySet(database.WeeeContext); // Act var result = querySet.GetProducerForOtherSchemeAndObligationType("AAAAAAA", "2015", scheme1.OrganisationId, ObligationType.B2C); // Assert Assert.NotNull(result); Assert.Equal(producer1.Id, result.Id); } }
public void GetAllRegistrationNumbers_ReturnsDistinctRegistrationNumbers() { using (DatabaseWrapper database = new DatabaseWrapper()) { ModelHelper helper = new ModelHelper(database.Model); // Arrange Scheme scheme = helper.CreateScheme(); MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme); memberUpload1.ComplianceYear = 2015; memberUpload1.IsSubmitted = false; Weee.Tests.Core.Model.ProducerSubmission producer1 = helper.CreateProducerAsCompany(memberUpload1, "AAAAAAA"); MemberUpload memberUpload2 = helper.CreateMemberUpload(scheme); memberUpload2.ComplianceYear = 2015; memberUpload2.IsSubmitted = true; Weee.Tests.Core.Model.ProducerSubmission producer2 = helper.CreateProducerAsCompany(memberUpload2, "AAAAAAA"); database.Model.SaveChanges(); ProducerQuerySet querySet = ProducerQuerySet(database.WeeeContext); // Act List<string> results = querySet.GetAllRegistrationNumbers(); // Assert Assert.NotNull(results); Assert.Equal(1, results.Count(r => r == "AAAAAAA")); } }
public void GetLatestProducerFromPreviousComplianceYears_TwoProducerEntriesIn2015_AndOneIn2014_ReturnsLatestProducerByUpdatedDateIn2015() { using (DatabaseWrapper database = new DatabaseWrapper()) { ModelHelper helper = new ModelHelper(database.Model); // Arrange Scheme scheme = helper.CreateScheme(); MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme); memberUpload1.ComplianceYear = 2015; memberUpload1.IsSubmitted = true; Weee.Tests.Core.Model.ProducerSubmission producer1 = helper.CreateProducerAsCompany(memberUpload1, "AAAAAAA"); producer1.UpdatedDate = new DateTime(2015, 1, 1); MemberUpload memberUpload2 = helper.CreateMemberUpload(scheme); memberUpload2.ComplianceYear = 2015; memberUpload2.IsSubmitted = true; Weee.Tests.Core.Model.ProducerSubmission producer2 = helper.CreateProducerAsCompany(memberUpload2, "AAAAAAA"); producer2.UpdatedDate = new DateTime(2015, 1, 2); MemberUpload memberUpload3 = helper.CreateMemberUpload(scheme); memberUpload3.ComplianceYear = 2014; memberUpload3.IsSubmitted = true; Weee.Tests.Core.Model.ProducerSubmission producer3 = helper.CreateProducerAsCompany(memberUpload3, "AAAAAAA"); producer3.UpdatedDate = new DateTime(2014, 1, 1); database.Model.SaveChanges(); ProducerQuerySet querySet = ProducerQuerySet(database.WeeeContext); // Act var result = querySet.GetLatestProducerFromPreviousComplianceYears("AAAAAAA"); // Assert Assert.NotNull(result); Assert.Equal(producer2.Id, result.Id); } }
public async Task FetchLatestProducers_WithThreeProducers_ReturnsProducersOrderedByRegistrationNumber() { using (DatabaseWrapper database = new DatabaseWrapper()) { ModelHelper helper = new ModelHelper(database.Model); // Arrange Model.Scheme scheme = helper.CreateScheme(); Model.MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme); memberUpload1.ComplianceYear = 2015; memberUpload1.IsSubmitted = true; Model.ProducerSubmission producer1 = helper.CreateProducerAsCompany(memberUpload1, "AAAAA"); Model.MemberUpload memberUpload2 = helper.CreateMemberUpload(scheme); memberUpload2.ComplianceYear = 2015; memberUpload2.IsSubmitted = true; Model.ProducerSubmission producer2 = helper.CreateProducerAsCompany(memberUpload2, "CCCCC"); Model.MemberUpload memberUpload3 = helper.CreateMemberUpload(scheme); memberUpload3.ComplianceYear = 2015; memberUpload3.IsSubmitted = true; Model.ProducerSubmission producer3 = helper.CreateProducerAsCompany(memberUpload3, "BBBBB"); database.Model.SaveChanges(); // Act FetchProducerSearchResultsForCacheDataAccess dataAccess = new FetchProducerSearchResultsForCacheDataAccess(database.WeeeContext); var results = await dataAccess.FetchLatestProducers(); // Assert Assert.NotNull(results); var result1 = results.SingleOrDefault(r => r.RegistrationNumber == "AAAAA"); var result2 = results.SingleOrDefault(r => r.RegistrationNumber == "BBBBB"); var result3 = results.SingleOrDefault(r => r.RegistrationNumber == "CCCCC"); Assert.NotNull(result1); Assert.NotNull(result2); Assert.NotNull(result3); int result1index = results.IndexOf(result1); int result2index = results.IndexOf(result2); int result3index = results.IndexOf(result3); Assert.True(result1index < result2index); Assert.True(result2index < result3index); } }