public async Task Execute_WithoutSchemeFilter_ReturnsResultsForAllSchemes()
{
using (DatabaseWrapper wrapper = new DatabaseWrapper())
{
// Arrange
Domain.Organisation.Organisation organisation = Domain.Organisation.Organisation.CreateSoleTrader("Test Organisation");
Domain.UKCompetentAuthority authority = wrapper.WeeeContext.UKCompetentAuthorities.Single(c => c.Abbreviation == "EA");
Quarter quarter = new Quarter(2099, QuarterType.Q1);
// Arrange - Scheme 1
Domain.Scheme.Scheme scheme1 = new Domain.Scheme.Scheme(organisation);
scheme1.UpdateScheme("Test Scheme 1", "WEE/AH7453NF/SCH", "WEE9462846", ObligationType.B2C, authority);
scheme1.SetStatus(Domain.Scheme.SchemeStatus.Approved);
Domain.DataReturns.DataReturn dataReturn1 = new Domain.DataReturns.DataReturn(scheme1, quarter);
Domain.DataReturns.DataReturnVersion version1 = new Domain.DataReturns.DataReturnVersion(dataReturn1);
Domain.DataReturns.WeeeCollectedAmount amount1 = new Domain.DataReturns.WeeeCollectedAmount(
WeeeCollectedAmountSourceType.Dcf,
ObligationType.B2C,
WeeeCategory.LargeHouseholdAppliances,
123.456m);
version1.WeeeCollectedReturnVersion.AddWeeeCollectedAmount(amount1);
wrapper.WeeeContext.DataReturnVersions.Add(version1);
await wrapper.WeeeContext.SaveChangesAsync();
dataReturn1.SetCurrentVersion(version1);
await wrapper.WeeeContext.SaveChangesAsync();
// Arrange - Scheme 2
Domain.Scheme.Scheme scheme2 = new Domain.Scheme.Scheme(organisation);
scheme2.UpdateScheme("Test Scheme 2", "WEE/ZU6355HV/SCH", "WEE5746395", ObligationType.B2C, authority);
scheme2.SetStatus(Domain.Scheme.SchemeStatus.Approved);
Domain.DataReturns.DataReturn dataReturn2 = new Domain.DataReturns.DataReturn(scheme2, quarter);
Domain.DataReturns.DataReturnVersion version2 = new Domain.DataReturns.DataReturnVersion(dataReturn2);
Domain.DataReturns.WeeeCollectedAmount amount2 = new Domain.DataReturns.WeeeCollectedAmount(
WeeeCollectedAmountSourceType.Dcf,
ObligationType.B2C,
WeeeCategory.LargeHouseholdAppliances,
123.456m);
version2.WeeeCollectedReturnVersion.AddWeeeCollectedAmount(amount2);
wrapper.WeeeContext.DataReturnVersions.Add(version2);
await wrapper.WeeeContext.SaveChangesAsync();
dataReturn2.SetCurrentVersion(version2);
await wrapper.WeeeContext.SaveChangesAsync();
// Act
SpgSchemeWeeeCsvResult result = await wrapper.WeeeContext.StoredProcedures.SpgSchemeWeeeCsvAsync(
2099,
null,
"B2C");
// Assert
Assert.NotNull(result);
Assert.NotNull(result.Schemes);
Assert.Equal(2, result.Schemes.Count);
Assert.NotNull(result.CollectedAmounts);
Assert.Equal(2, result.CollectedAmounts.Count);
}
}
public async Task Execute_WithoutSchemeFilter_ReturnsResultsForAllSchemes()
{
using (DatabaseWrapper wrapper = new DatabaseWrapper())
{
// Arrange
Domain.Organisation.Organisation organisation = Domain.Organisation.Organisation.CreateSoleTrader("Test Organisation");
Domain.UKCompetentAuthority authority = wrapper.WeeeContext.UKCompetentAuthorities.Single(c => c.Abbreviation == UKCompetentAuthorityAbbreviationType.EA);
Quarter quarter = new Quarter(2099, QuarterType.Q1);
// Arrange - Scheme 1
Domain.Scheme.Scheme scheme1 = new Domain.Scheme.Scheme(organisation);
scheme1.UpdateScheme("Test Scheme 1", "WEE/AH7453NF/SCH", "WEE9462846", Domain.Obligation.ObligationType.B2C, authority);
scheme1.SetStatus(Domain.Scheme.SchemeStatus.Approved);
Domain.DataReturns.DataReturn dataReturn1 = new Domain.DataReturns.DataReturn(scheme1, quarter);
Domain.DataReturns.DataReturnVersion version1 = new Domain.DataReturns.DataReturnVersion(dataReturn1);
Domain.DataReturns.WeeeCollectedAmount amount1 = new Domain.DataReturns.WeeeCollectedAmount(
WeeeCollectedAmountSourceType.Dcf,
Domain.Obligation.ObligationType.B2C,
WeeeCategory.LargeHouseholdAppliances,
123.456m);
version1.WeeeCollectedReturnVersion.AddWeeeCollectedAmount(amount1);
wrapper.WeeeContext.DataReturnVersions.Add(version1);
await wrapper.WeeeContext.SaveChangesAsync();
dataReturn1.SetCurrentVersion(version1);
await wrapper.WeeeContext.SaveChangesAsync();
// Arrange - Scheme 2
Domain.Scheme.Scheme scheme2 = new Domain.Scheme.Scheme(organisation);
scheme2.UpdateScheme("Test Scheme 2", "WEE/ZU6355HV/SCH", "WEE5746395", Domain.Obligation.ObligationType.B2C, authority);
scheme2.SetStatus(Domain.Scheme.SchemeStatus.Approved);
Domain.DataReturns.DataReturn dataReturn2 = new Domain.DataReturns.DataReturn(scheme2, quarter);
Domain.DataReturns.DataReturnVersion version2 = new Domain.DataReturns.DataReturnVersion(dataReturn2);
Domain.DataReturns.WeeeCollectedAmount amount2 = new Domain.DataReturns.WeeeCollectedAmount(
WeeeCollectedAmountSourceType.Dcf,
Domain.Obligation.ObligationType.B2C,
WeeeCategory.LargeHouseholdAppliances,
123.456m);
version2.WeeeCollectedReturnVersion.AddWeeeCollectedAmount(amount2);
wrapper.WeeeContext.DataReturnVersions.Add(version2);
await wrapper.WeeeContext.SaveChangesAsync();
dataReturn2.SetCurrentVersion(version2);
await wrapper.WeeeContext.SaveChangesAsync();
// Act
SpgSchemeWeeeCsvResult result = await wrapper.WeeeContext.StoredProcedures.SpgSchemeWeeeCsvAsync(
2099,
null,
"B2C");
// Assert
Assert.NotNull(result);
Assert.NotNull(result.Schemes);
Assert.Equal(2, result.Schemes.Count);
Assert.NotNull(result.CollectedAmounts);
Assert.Equal(2, result.CollectedAmounts.Count);
}
}