private async Task <Guid> CreateWeeeSentOnAmounts(ObligatedSentOnDataAccess dataAccess, DatabaseWrapper database)
{
var organisation = ObligatedWeeeIntegrationCommon.CreateOrganisation();
var scheme = ObligatedWeeeIntegrationCommon.CreateScheme(organisation);
var aatf = ObligatedWeeeIntegrationCommon.CreateAatf(database, organisation);
var siteAddress = ObligatedWeeeIntegrationCommon.CreateAatfAddress(database);
var @return = ObligatedWeeeIntegrationCommon.CreateReturn(organisation, database.Model.AspNetUsers.First().Id);
database.WeeeContext.Organisations.Add(organisation);
database.WeeeContext.Schemes.Add(scheme);
database.WeeeContext.Aatfs.Add(aatf);
database.WeeeContext.Returns.Add(@return);
database.WeeeContext.AatfAddress.Add(siteAddress);
await database.WeeeContext.SaveChangesAsync();
var weeeSentOn = new WeeeSentOn(siteAddress.Id, aatf.Id, @return.Id);
var weeeSentOnAmount = new List <WeeeSentOnAmount>();
foreach (var category in Enum.GetValues(typeof(WeeeCategory)).Cast <WeeeCategory>())
{
weeeSentOnAmount.Add(new WeeeSentOnAmount(weeeSentOn, (int)category, (decimal?)category, (decimal?)category + 1));
}
await dataAccess.Submit(weeeSentOnAmount);
return(weeeSentOn.Id);
}
public async Task Execute_GivenNullWeeeSentOnData_ReturnsWeeeSentOnAatfDataShouldBeNull()
{
using (var db = new DatabaseWrapper())
{
var @return = CreateSubmittedReturn(db);
var aatf = ObligatedWeeeIntegrationCommon.CreateAatf(db, @return.Organisation);
var weeeSentOn = new EA.Weee.Domain.AatfReturn.WeeeSentOn(ObligatedWeeeIntegrationCommon.CreateAatfAddress(db), aatf, @return);
var weeeSentOnAmounts = new List <WeeeSentOnAmount>()
{
new Domain.AatfReturn.WeeeSentOnAmount(weeeSentOn, 1, null, null),
new Domain.AatfReturn.WeeeSentOnAmount(weeeSentOn, 2, null, null)
};
db.WeeeContext.Returns.Add(@return);
db.WeeeContext.ReturnAatfs.Add(new ReturnAatf(aatf, @return));
db.WeeeContext.WeeeSentOn.Add(weeeSentOn);
db.WeeeContext.WeeeSentOnAmount.AddRange(weeeSentOnAmounts);
await db.WeeeContext.SaveChangesAsync();
var results = await db.StoredProcedures.GetAatfSubmissions(aatf.Id, aatf.ComplianceYear);
results.Count.Should().Be(1);
results.ElementAt(0).WeeeSentOnHouseHold.Should().BeNull();
results.ElementAt(0).WeeeSentOnNonHouseHold.Should().BeNull();
AssertFixedPropertiesForReturn(results, db, @return);
}
}
public Aatf CreateAatf(DatabaseWrapper database, Organisation organisation, DateTime approvalDate, int count, string cA)
{
var aatfContact = ObligatedWeeeIntegrationCommon.CreateDefaultContact(database.WeeeContext.Countries.First());
var aatfAddress = ObligatedWeeeIntegrationCommon.CreateAatfAddress(database);
var aatf = new Aatf("aatfname" + count, database.WeeeContext.UKCompetentAuthorities.First(c => c.Abbreviation == cA), "number", AatfStatus.Approved, organisation, aatfAddress, AatfSize.Large, approvalDate, aatfContact, FacilityType.Aatf, 2019, database.WeeeContext.LocalAreas.First(), database.WeeeContext.PanAreas.First());
return(aatf);
}
private static async Task <AatfAddress> CreateAddress(DatabaseWrapper database)
{
var address = ObligatedWeeeIntegrationCommon.CreateAatfAddress(database);
database.WeeeContext.AatfAddress.Add(address);
await database.WeeeContext.SaveChangesAsync();
return(address);
}
private static async Task CreateWeeSentOnData(DatabaseWrapper db, EA.Weee.Domain.AatfReturn.Aatf aatf, Return @return)
{
var weeeSentOn = new EA.Weee.Domain.AatfReturn.WeeeSentOn(ObligatedWeeeIntegrationCommon.CreateAatfAddress(db), ObligatedWeeeIntegrationCommon.CreateAatfAddress(db), aatf, @return);
var weeeSentOnAmounts = new List <WeeeSentOnAmount>()
{
new Domain.AatfReturn.WeeeSentOnAmount(weeeSentOn, 1, 1, 2),
new Domain.AatfReturn.WeeeSentOnAmount(weeeSentOn, 2, 3, 4)
};
db.WeeeContext.Returns.Add(@return);
db.WeeeContext.ReturnAatfs.Add(new ReturnAatf(aatf, @return));
db.WeeeContext.WeeeSentOn.Add(weeeSentOn);
db.WeeeContext.WeeeSentOnAmount.AddRange(weeeSentOnAmounts);
await db.WeeeContext.SaveChangesAsync();
db.WeeeContext.ReturnReportOns.Add(new ReturnReportOn(@return.Id, 2));
await db.WeeeContext.SaveChangesAsync();
}
public async Task Execute_GivenAatfsWithSentOnDataAndCreatedReturn_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 siteAddressAatf1Address1 = ObligatedWeeeIntegrationCommon.CreateAatfAddress(db);
var siteAddressAatf1Address2 = ObligatedWeeeIntegrationCommon.CreateAatfAddress(db);
var siteAddressAatf2Address1 = ObligatedWeeeIntegrationCommon.CreateAatfAddress(db);
var weeeSentOnAatf1SentOn1 =
new WeeeSentOn(siteAddressAatf1Address1, ObligatedWeeeIntegrationCommon.CreateAatfAddress(db), aatf, @return);
var weeeSentOnAatf1SentOn2 =
new WeeeSentOn(siteAddressAatf1Address2, ObligatedWeeeIntegrationCommon.CreateAatfAddress(db), aatf, @return);
var weeeSentOnAatf2SentOn1 =
new WeeeSentOn(siteAddressAatf2Address1, ObligatedWeeeIntegrationCommon.CreateAatfAddress(db), aatf2, @return);
foreach (var categoryValue in CategoryValues())
{
db.WeeeContext.WeeeSentOnAmount.Add(new Domain.AatfReturn.WeeeSentOnAmount(weeeSentOnAatf1SentOn1, categoryValue.CategoryId, categoryValue.CategoryId, categoryValue.CategoryId + 1));
db.WeeeContext.WeeeSentOnAmount.Add(new Domain.AatfReturn.WeeeSentOnAmount(weeeSentOnAatf1SentOn2, categoryValue.CategoryId, categoryValue.CategoryId, categoryValue.CategoryId + 1));
db.WeeeContext.WeeeSentOnAmount.Add(new Domain.AatfReturn.WeeeSentOnAmount(weeeSentOnAatf2SentOn1, categoryValue.CategoryId, categoryValue.CategoryId, categoryValue.CategoryId + 1));
}
db.WeeeContext.Returns.Add(@return);
await db.WeeeContext.SaveChangesAsync();
db.WeeeContext.ReturnReportOns.Add(new Domain.AatfReturn.ReturnReportOn(@return.Id, 2));
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][TotalSentOnHeading].Should().Be(categoryValue.CategoryId * 2);
houseHoldResultAatf1[0][$"Obligated WEEE sent to {siteAddressAatf1Address1.Name} (t)"].Should().Be(categoryValue.CategoryId);
houseHoldResultAatf1[0][$"Obligated WEEE sent to {siteAddressAatf1Address2.Name} (t)"].Should().Be(categoryValue.CategoryId);
nonHouseHoldResultAatf1[0][TotalSentOnHeading].Should().Be((categoryValue.CategoryId + 1) * 2);
nonHouseHoldResultAatf1[0][$"Obligated WEEE sent to {siteAddressAatf1Address1.Name} (t)"].Should().Be((categoryValue.CategoryId + 1));
nonHouseHoldResultAatf1[0][$"Obligated WEEE sent to {siteAddressAatf1Address2.Name} (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][TotalSentOnHeading].Should().Be(categoryValue.CategoryId);
houseHoldResultAatf2[0][$"Obligated WEEE sent to {siteAddressAatf2Address1.Name} (t)"].Should().Be(categoryValue.CategoryId);
nonHouseHoldResultAatf2[0][TotalSentOnHeading].Should().Be((categoryValue.CategoryId + 1));
nonHouseHoldResultAatf2[0][$"Obligated WEEE sent to {siteAddressAatf2Address1.Name} (t)"].Should().Be(categoryValue.CategoryId + 1);
}
results.Dispose();
}
}
public async Task Execute_GivenAatfWithApprovalDateExpectedToReportAndResubmissionCreatedAndResubmissionsRequested_RecordDataIsAsExpected()
{
using (var db = new DatabaseWrapper())
{
var date = new DateTime(2019, 1, 1, 11, 10, 1);
SystemTime.Freeze(date);
var organisation = Domain.Organisation.Organisation.CreateSoleTrader(fixture.Create <string>());
var aatf = new Aatf(fixture.Create <string>(), GetAuthority(db), fixture.Create <string>().Substring(0, 10), AatfStatus.Approved, organisation, ObligatedWeeeIntegrationCommon.CreateAatfAddress(db), AatfSize.Large, Convert.ToDateTime("01/02/2019"), ObligatedWeeeIntegrationCommon.CreateDefaultContact(db.WeeeContext.Countries.First()), FacilityType.Aatf, 2019, db.WeeeContext.LocalAreas.First(), db.WeeeContext.PanAreas.First());
var @return = ObligatedWeeeIntegrationCommon.CreateReturn(organisation, db.Model.AspNetUsers.First().Id, FacilityType.Aatf, 2019,
QuarterType.Q1);
@return.UpdateSubmitted(db.Model.AspNetUsers.First().Id, false);
SystemTime.Unfreeze();
SystemTime.Freeze(date.Date.AddDays(1));
var @return2 = ObligatedWeeeIntegrationCommon.CreateReturn(organisation, db.Model.AspNetUsers.First().Id, FacilityType.Aatf, 2019,
QuarterType.Q1);
SystemTime.Unfreeze();
db.WeeeContext.Aatfs.Add(aatf);
db.WeeeContext.Returns.Add(@return);
db.WeeeContext.Returns.Add(@return2);
db.WeeeContext.ReturnAatfs.Add(new ReturnAatf(aatf, @return));
await db.WeeeContext.SaveChangesAsync();
var results = await db.StoredProcedures.GetAatfAeReturnDataCsvData(2019, 1,
1, null, null, null, null, true);
var initialSubmission = results.Where(x => x.AatfId == aatf.Id).ElementAt(0);
initialSubmission.ApprovalNumber.Should().Be(aatf.ApprovalNumber);
initialSubmission.CompetentAuthorityAbbr.Should().Be("EA");
initialSubmission.Name.Should().Be(aatf.Name);
initialSubmission.OrganisationName.Should().Be(organisation.OrganisationName);
initialSubmission.CreatedDate.Should().Be(date);
initialSubmission.ReturnStatus.Should().Be("Submitted");
initialSubmission.SubmittedBy.Should().Be($"{db.Model.AspNetUsers.First().FirstName} {db.Model.AspNetUsers.First().Surname}");
initialSubmission.SubmittedDate.Should().Be(date);
initialSubmission.ReSubmission.Should().Be("First submission");
var resubmission = results.Where(x => x.AatfId == aatf.Id).ElementAt(1);
resubmission.ApprovalNumber.Should().Be(aatf.ApprovalNumber);
resubmission.CompetentAuthorityAbbr.Should().Be("EA");
resubmission.Name.Should().Be(aatf.Name);
resubmission.OrganisationName.Should().Be(organisation.OrganisationName);
resubmission.CreatedDate.Should().Be(date.Date.AddDays(1));
resubmission.ReturnStatus.Should().Be("Started");
resubmission.SubmittedBy.Should().BeNullOrWhiteSpace();
resubmission.SubmittedDate.Should().BeNull();
resubmission.ReSubmission.Should().Be("Resubmission");
}
}
public async Task Execute_GivenAatfWithApprovalDateExpectedToReportAndReturnNotStarted_RecordDataIsAsExpected()
{
using (var db = new DatabaseWrapper())
{
var organisation = Domain.Organisation.Organisation.CreateSoleTrader(fixture.Create <string>());
var aatf = new Aatf(fixture.Create <string>(), GetAuthority(db), fixture.Create <string>().Substring(0, 10), AatfStatus.Approved, organisation, ObligatedWeeeIntegrationCommon.CreateAatfAddress(db), AatfSize.Large, Convert.ToDateTime("01/02/2019"), ObligatedWeeeIntegrationCommon.CreateDefaultContact(db.WeeeContext.Countries.First()), FacilityType.Aatf, 2019, db.WeeeContext.LocalAreas.First(), db.WeeeContext.PanAreas.First());
db.WeeeContext.Aatfs.Add(aatf);
await db.WeeeContext.SaveChangesAsync();
var results = await db.StoredProcedures.GetAatfAeReturnDataCsvData(2019, 1,
1, null, null, null, null, false);
var record = results.First(x => x.AatfId == aatf.Id);
record.ApprovalNumber.Should().Be(aatf.ApprovalNumber);
record.CompetentAuthorityAbbr.Should().Be("EA");
record.Name.Should().Be(aatf.Name);
record.OrganisationName.Should().Be(organisation.OrganisationName);
record.CreatedDate.Should().BeNull();
record.ReturnStatus.Should().Be("Not Started");
record.SubmittedBy.Should().BeNullOrWhiteSpace();
record.SubmittedDate.Should().BeNull();
record.ReSubmission.Should().Be("First submission");
}
}
public async Task Execute_GivenAaatfWithApprovalDateExpectedToReportWithFacilityParameter_CorrectRecordsShouldBeReturned()
{
using (var db = new DatabaseWrapper())
{
var organisation1 = Domain.Organisation.Organisation.CreateSoleTrader("Test Organisation");
var aatf1 = new Aatf("aatfname1", GetAuthority(db), "number", AatfStatus.Approved, organisation1, ObligatedWeeeIntegrationCommon.CreateAatfAddress(db), AatfSize.Large, Convert.ToDateTime("01/02/2019"), ObligatedWeeeIntegrationCommon.CreateDefaultContact(db.WeeeContext.Countries.First()), FacilityType.Aatf, 2019, db.WeeeContext.LocalAreas.First(), GetPanArea(db, "North"));
var aatf2 = new Aatf("aatfname2", GetAuthority(db), "number", AatfStatus.Approved, organisation1, ObligatedWeeeIntegrationCommon.CreateAatfAddress(db), AatfSize.Large, Convert.ToDateTime("01/02/2019"), ObligatedWeeeIntegrationCommon.CreateDefaultContact(db.WeeeContext.Countries.First()), FacilityType.Aatf, 2019, db.WeeeContext.LocalAreas.First(), GetPanArea(db, "North"));
var ae = new Aatf("aatfname3", GetAuthority(db), "number", AatfStatus.Approved, organisation1, ObligatedWeeeIntegrationCommon.CreateAatfAddress(db), AatfSize.Large, Convert.ToDateTime("01/02/2019"), ObligatedWeeeIntegrationCommon.CreateDefaultContact(db.WeeeContext.Countries.First()), FacilityType.Ae, 2019, db.WeeeContext.LocalAreas.First(), GetPanArea(db, "North"));
db.WeeeContext.Aatfs.Add(aatf1);
db.WeeeContext.Aatfs.Add(aatf2);
db.WeeeContext.Aatfs.Add(ae);
await db.WeeeContext.SaveChangesAsync();
var results = await db.StoredProcedures.GetAatfAeReturnDataCsvData(2019, 1,
1, null, null, null, null, false);
results.Count(x => x.AatfId == aatf1.Id).Should().Be(1);
results.Count(x => x.AatfId == aatf2.Id).Should().Be(1);
results.Count(x => x.AatfId == ae.Id).Should().Be(0);
}
}
public async Task GetManyByExpression_Specification_AatfsByAatfFacilityTypeShouldBeReturned()
{
using (var database = new DatabaseWrapper())
{
var dataAccess = new GenericDataAccess(database.WeeeContext);
var organisation = Organisation.CreateSoleTrader("Test Organisation");
var aatf1 = ObligatedWeeeIntegrationCommon.CreateAatf(database, organisation);
var aatf2 = ObligatedWeeeIntegrationCommon.CreateAatf(database, organisation);
var aatf3 = new Aatf("aatfname", database.WeeeContext.UKCompetentAuthorities.First(), "number", AatfStatus.Approved, organisation, ObligatedWeeeIntegrationCommon.CreateAatfAddress(database), AatfSize.Large, DateTime.Now, ObligatedWeeeIntegrationCommon.CreateDefaultContact(database.WeeeContext.Countries.First()), FacilityType.Ae, 2019, database.WeeeContext.LocalAreas.First(), database.WeeeContext.PanAreas.First());
database.WeeeContext.Aatfs.Add(aatf1);
database.WeeeContext.Aatfs.Add(aatf2);
database.WeeeContext.Aatfs.Add(aatf3);
await database.WeeeContext.SaveChangesAsync();
var aatfInfo = await dataAccess.GetManyByExpression(new AatfsByOrganisationAndFacilityTypeSpecification(organisation.Id, Core.AatfReturn.FacilityType.Aatf));
aatfInfo.Count.Should().Be(2);
aatfInfo.Where(a => Equals(aatf1)).Should().NotBeNull();
aatfInfo.Where(a => Equals(aatf2)).Should().NotBeNull();
aatfInfo.Where(a => Equals(aatf3)).Should().BeEmpty();
}
}
public async Task Execute_GivenMultipleReturns_ReturnDataShouldBeCorrect()
{
using (var db = new DatabaseWrapper())
{
var @return1 = CreateSubmittedReturn(db);
var @return2 = CreateSubmittedReturn(db);
var scheme = ObligatedWeeeIntegrationCommon.CreateScheme(@return1.Organisation);
var aatf = ObligatedWeeeIntegrationCommon.CreateAatf(db, @return1.Organisation);
var weeeSentOn1 = new EA.Weee.Domain.AatfReturn.WeeeSentOn(ObligatedWeeeIntegrationCommon.CreateAatfAddress(db), aatf, @return1);
var weeeSentOnAmount1 = new EA.Weee.Domain.AatfReturn.WeeeSentOnAmount(weeeSentOn1, 1, 1, 2);
var weeeReceived1 = new EA.Weee.Domain.AatfReturn.WeeeReceived(scheme, aatf, @return1);
var weeeReceivedAmount1 = new EA.Weee.Domain.AatfReturn.WeeeReceivedAmount(weeeReceived1, 1, 3, 4);
var weeeReused1 = new EA.Weee.Domain.AatfReturn.WeeeReused(aatf, @return1);
var weeeReusedAmount1 = new Domain.AatfReturn.WeeeReusedAmount(weeeReused1, 1, 5, 6);
var weeeSentOn2 = new EA.Weee.Domain.AatfReturn.WeeeSentOn(ObligatedWeeeIntegrationCommon.CreateAatfAddress(db), aatf, @return2);
var weeeSentOnAmount2 = new EA.Weee.Domain.AatfReturn.WeeeSentOnAmount(weeeSentOn2, 1, 7, 8);
var weeeReceived2 = new EA.Weee.Domain.AatfReturn.WeeeReceived(scheme, aatf, @return2);
var weeeReceivedAmount2 = new EA.Weee.Domain.AatfReturn.WeeeReceivedAmount(weeeReceived2, 1, 9, 10);
var weeeReused2 = new EA.Weee.Domain.AatfReturn.WeeeReused(aatf, @return2);
var weeeReusedAmount2 = new Domain.AatfReturn.WeeeReusedAmount(weeeReused2, 1, 11, 12);
db.WeeeContext.Returns.Add(@return1);
db.WeeeContext.Returns.Add(@return2);
db.WeeeContext.ReturnAatfs.Add(new ReturnAatf(aatf, @return1));
db.WeeeContext.ReturnAatfs.Add(new ReturnAatf(aatf, @return2));
db.WeeeContext.WeeeSentOn.Add(weeeSentOn1);
db.WeeeContext.WeeeSentOn.Add(weeeSentOn2);
db.WeeeContext.WeeeSentOnAmount.Add(weeeSentOnAmount1);
db.WeeeContext.WeeeSentOnAmount.Add(weeeSentOnAmount2);
db.WeeeContext.WeeeReceived.Add(weeeReceived1);
db.WeeeContext.WeeeReceived.Add(weeeReceived2);
db.WeeeContext.WeeeReceivedAmount.Add(weeeReceivedAmount1);
db.WeeeContext.WeeeReceivedAmount.Add(weeeReceivedAmount2);
db.WeeeContext.WeeeReused.Add(weeeReused1);
db.WeeeContext.WeeeReused.Add(weeeReused2);
db.WeeeContext.WeeeReusedAmount.Add(weeeReusedAmount1);
db.WeeeContext.WeeeReusedAmount.Add(weeeReusedAmount2);
await db.WeeeContext.SaveChangesAsync();
var results = await db.StoredProcedures.GetAatfSubmissions(aatf.Id, aatf.ComplianceYear);
results.Count.Should().Be(2);
results.First(r => r.ReturnId.Equals(@return1.Id)).WeeeSentOnHouseHold.Should().Be(1);
results.First(r => r.ReturnId.Equals(@return1.Id)).WeeeSentOnNonHouseHold.Should().Be(2);
results.First(r => r.ReturnId.Equals(@return1.Id)).WeeeReceivedHouseHold.Should().Be(3);
results.First(r => r.ReturnId.Equals(@return1.Id)).WeeeReceivedNonHouseHold.Should().Be(4);
results.First(r => r.ReturnId.Equals(@return1.Id)).WeeeReusedHouseHold.Should().Be(5);
results.First(r => r.ReturnId.Equals(@return1.Id)).WeeeReusedNonHouseHold.Should().Be(6);
results.First(r => r.ReturnId.Equals(@return2.Id)).WeeeSentOnHouseHold.Should().Be(7);
results.First(r => r.ReturnId.Equals(@return2.Id)).WeeeSentOnNonHouseHold.Should().Be(8);
results.First(r => r.ReturnId.Equals(@return2.Id)).WeeeReceivedHouseHold.Should().Be(9);
results.First(r => r.ReturnId.Equals(@return2.Id)).WeeeReceivedNonHouseHold.Should().Be(10);
results.First(r => r.ReturnId.Equals(@return2.Id)).WeeeReusedHouseHold.Should().Be(11);
results.First(r => r.ReturnId.Equals(@return2.Id)).WeeeReusedNonHouseHold.Should().Be(12);
}
}
