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);
}
}
}
