public async Task Execute_GivenAatfsWithReceivedDataAndCreatedReturn_DataShouldBeReturned() { using (var db = new DatabaseWrapper()) { var @return = SetupCreatedReturn(db); var aatf = SetupAatfWithApprovalDate(db, DateTime.MinValue, "AAA"); var aatf2 = SetupAatfWithApprovalDate(db, DateTime.MinValue, "AAB"); var scheme1 = new Scheme(organisation); scheme1.UpdateScheme("scheme1", "1111", "1111", fixture.Create <ObligationType>(), db.WeeeContext.UKCompetentAuthorities.First()); var scheme2 = new Scheme(organisation); scheme2.UpdateScheme("scheme2", "1111", "1111", fixture.Create <ObligationType>(), db.WeeeContext.UKCompetentAuthorities.First()); var weeeReceivedAatf1Scheme1 = new WeeeReceived(scheme1, aatf, @return); var weeeReceivedAatf1Scheme2 = new WeeeReceived(scheme2, aatf, @return); var weeeReceivedAatf2Scheme2 = new WeeeReceived(scheme2, aatf2, @return); foreach (var categoryValue in CategoryValues()) { db.WeeeContext.WeeeReceivedAmount.Add(new Domain.AatfReturn.WeeeReceivedAmount(weeeReceivedAatf1Scheme1, categoryValue.CategoryId, categoryValue.CategoryId, categoryValue.CategoryId + 1)); db.WeeeContext.WeeeReceivedAmount.Add(new Domain.AatfReturn.WeeeReceivedAmount(weeeReceivedAatf1Scheme2, categoryValue.CategoryId, categoryValue.CategoryId, categoryValue.CategoryId + 1)); db.WeeeContext.WeeeReceivedAmount.Add(new Domain.AatfReturn.WeeeReceivedAmount(weeeReceivedAatf2Scheme2, categoryValue.CategoryId, categoryValue.CategoryId, categoryValue.CategoryId + 1)); } db.WeeeContext.ReturnScheme.Add(new ReturnScheme(scheme1, @return)); db.WeeeContext.ReturnScheme.Add(new ReturnScheme(scheme2, @return)); db.WeeeContext.Returns.Add(@return); await db.WeeeContext.SaveChangesAsync(); db.WeeeContext.ReturnReportOns.Add(new Domain.AatfReturn.ReturnReportOn(@return.Id, 1)); await db.WeeeContext.SaveChangesAsync(); var results = await db.StoredProcedures.GetReturnObligatedCsvData(@return.Id); results.Rows.Count.Should().Be(56); foreach (var categoryValue in CategoryValues()) { var houseHoldResultAatf1 = results.Select($"AatfKey='{aatf.Id}' AND CategoryId={categoryValue.CategoryId} AND [Obligation Type]='{B2C}'"); var nonHouseHoldResultAatf1 = results.Select($"AatfKey='{aatf.Id}' AND CategoryId={categoryValue.CategoryId} AND [Obligation Type]='{B2B}'"); houseHoldResultAatf1[0][TotalReceivedHeading].Should().Be(categoryValue.CategoryId * 2); // two schemes houseHoldResultAatf1[0]["Obligated WEEE received on behalf of scheme1 (t)"].Should().Be(categoryValue.CategoryId); houseHoldResultAatf1[0]["Obligated WEEE received on behalf of scheme2 (t)"].Should().Be(categoryValue.CategoryId); nonHouseHoldResultAatf1[0][TotalReceivedHeading].Should().Be((categoryValue.CategoryId + 1) * 2); // two schemes nonHouseHoldResultAatf1[0]["Obligated WEEE received on behalf of scheme1 (t)"].Should().Be((categoryValue.CategoryId + 1)); nonHouseHoldResultAatf1[0]["Obligated WEEE received on behalf of scheme2 (t)"].Should().Be(categoryValue.CategoryId + 1); var houseHoldResultAatf2 = results.Select($"AatfKey='{aatf2.Id}' AND CategoryId={categoryValue.CategoryId} AND [Obligation Type]='{B2C}'"); var nonHouseHoldResultAatf2 = results.Select($"AatfKey='{aatf2.Id}' AND CategoryId={categoryValue.CategoryId} AND [Obligation Type]='{B2B}'"); houseHoldResultAatf2[0][TotalReceivedHeading].Should().Be(categoryValue.CategoryId); // single scheme houseHoldResultAatf2[0]["Obligated WEEE received on behalf of scheme2 (t)"].Should().Be(categoryValue.CategoryId); nonHouseHoldResultAatf2[0][TotalReceivedHeading].Should().Be((categoryValue.CategoryId + 1)); // single schemes nonHouseHoldResultAatf2[0]["Obligated WEEE received on behalf of scheme2 (t)"].Should().Be(categoryValue.CategoryId + 1); } results.Dispose(); } }
public async Task FetchObligatedWeeeForReturn_ReturnedListShouldContainAllTonnagesFromRequest() { using (var database = new DatabaseWrapper()) { var companyName = "Test Name" + Guid.NewGuid(); var tradingName = "Test Trading Name" + Guid.NewGuid(); const string companyRegistrationNumber = "ABC12345"; var organisation = Organisation.CreateRegisteredCompany(companyName, companyRegistrationNumber, tradingName); var scheme = new Scheme(organisation); var competentAuthority = database.WeeeContext.UKCompetentAuthorities.FirstOrDefault(); var country = await database.WeeeContext.Countries.SingleAsync(c => c.Name == "France"); var contact = new AatfContact("First Name", "Last Name", "Manager", "1 Address Lane", "Address Ward", "Town", "County", "Postcode", country, "01234 567890", "*****@*****.**"); var aatf = ObligatedWeeeIntegrationCommon.CreateAatf(database, organisation); var @return = new Return(organisation, new Quarter(2019, QuarterType.Q1), database.Model.AspNetUsers.First().Id, FacilityType.Aatf); database.WeeeContext.Organisations.Add(organisation); database.WeeeContext.Schemes.Add(scheme); database.WeeeContext.Aatfs.Add(aatf); database.WeeeContext.Returns.Add(@return); await database.WeeeContext.SaveChangesAsync(); var addObligatedReceivedDataAccess = new ObligatedReceivedDataAccess(database.WeeeContext); var categoryValues = new List <ObligatedValue>(); var weeeReceived = new WeeeReceived(scheme.Id, aatf.Id, @return.Id); foreach (var category in Enum.GetValues(typeof(WeeeCategory)).Cast <WeeeCategory>()) { categoryValues.Add(new ObligatedValue(Guid.NewGuid(), (int)category, (int)category, (int)category)); } var obligatedReceivedRequest = new AddObligatedReceived() { ReturnId = @return.Id, AatfId = aatf.Id, SchemeId = scheme.Id, OrganisationId = organisation.Id, CategoryValues = categoryValues }; var obligatedReusedRequest = new AddObligatedReused() { AatfId = aatf.Id, ReturnId = @return.Id, OrganisationId = organisation.Id, CategoryValues = categoryValues }; var weeeReceivedAmount = new List <WeeeReceivedAmount>(); var weeeReusedAmount = new List <WeeeReusedAmount>(); foreach (var categoryValue in obligatedReceivedRequest.CategoryValues) { weeeReceivedAmount.Add(new WeeeReceivedAmount(weeeReceived, categoryValue.CategoryId, categoryValue.HouseholdTonnage, categoryValue.NonHouseholdTonnage)); } var obligateReceivedDataAccess = new ObligatedReceivedDataAccess(database.WeeeContext); await obligateReceivedDataAccess.Submit(weeeReceivedAmount); var fetchDataAccess = new FetchObligatedWeeeForReturnDataAccess(database.WeeeContext); var receivedTonnageList = await fetchDataAccess.FetchObligatedWeeeReceivedForReturn(@return.Id); var receivedNonHouseholdList = receivedTonnageList.Select(t => t.NonHouseholdTonnage); var receivedHouseholdList = receivedTonnageList.Select(t => t.HouseholdTonnage); foreach (var category in weeeReceivedAmount) { receivedNonHouseholdList.Should().Contain(category.NonHouseholdTonnage); receivedHouseholdList.Should().Contain(category.HouseholdTonnage); } } }