private static IEnumerable <EeeOutputAmount> CreateEeeOutputAmounts(RegisteredProducer registeredProducer)
{
ObligationType obligationType = registeredProducer.CurrentSubmission.ObligationType;
IEnumerable <IReturnItem> returnItems = CreateReturnItems(obligationType);
return(returnItems.Select(x => new EeeOutputAmount(x.ObligationType, x.WeeeCategory, x.Tonnage, registeredProducer)));
}
public async Task <List <ErrorData> > Validate(string producerRegistrationNumber, string producerName,
WeeeCategory category, ObligationType obligationType, decimal tonnage)
{
List <ErrorData> errorsAndWarnings = new List <ErrorData>();
RegisteredProducer producer = await schemeQuarterDataAccess.GetRegisteredProducer(producerRegistrationNumber);
// If producer is null, add an error as it is not registered with the current scheme for the compliance year.
if (producer == null)
{
var errorMessage = string.Format(
"The producer with producer registration number {0} is not a registered member of your producer compliance scheme for {1}. "
+ "Remove this producer from your return, or ensure they are a registered member of your scheme.",
producerRegistrationNumber,
quarter.Year);
errorsAndWarnings.Add(new ErrorData(errorMessage, ErrorLevel.Error));
}
else
{
errorsAndWarnings.AddIfNotDefault(ValidateProducerName(producer, producerRegistrationNumber, producerName));
errorsAndWarnings.AddIfNotDefault(ValidateProducerObligationType(producer, producerRegistrationNumber, producerName, obligationType));
}
return(errorsAndWarnings);
}
public void AssignToInvoiceRun_SetsProducerSubmissionAsInvoiced()
{
Scheme scheme = A.Fake <Scheme>();
MemberUpload memberUpload = new MemberUpload(A.Dummy <Guid>(), "data", null, 100, 2015, scheme, "fileName");
var registeredProducer = new RegisteredProducer("PRN", 2015, scheme);
var producer = new ProducerSubmission(
registeredProducer,
memberUpload,
new ProducerBusiness(),
null,
new DateTime(2015, 1, 1),
0,
false,
null,
"Trading Name 1",
EEEPlacedOnMarketBandType.Lessthan5TEEEplacedonmarket,
SellingTechniqueType.Both,
ObligationType.Both,
AnnualTurnOverBandType.Greaterthanonemillionpounds,
new List <BrandName>(),
new List <SICCode>(),
A.Dummy <ChargeBandAmount>(),
0,
A.Dummy <StatusType>());
memberUpload.ProducerSubmissions.Add(producer);
memberUpload.Submit(A.Dummy <User>());
memberUpload.AssignToInvoiceRun(A.Dummy <InvoiceRun>());
Assert.True(producer.Invoiced);
}
public EeeOutputAmount(ObligationType obligationType, WeeeCategory weeeCategory, decimal tonnage, RegisteredProducer registeredProducer) :
base(obligationType, weeeCategory, tonnage)
{
Guard.ArgumentNotNull(() => registeredProducer, registeredProducer);
RegisteredProducer = registeredProducer;
}
public bool Equals(EeeOutputAmount other)
{
if (other == null)
{
return(false);
}
return(Equals((ReturnItem)other) &&
RegisteredProducer.Equals(other.RegisteredProducer));
}
private DataReturnSubmissionEeeChangesCsvData ExtractProducerData(RegisteredProducer producer, List <EeeOutputAmount> producerAmounts,
int year, int quarter, DateTime submittedDate, DataReturnSubmissionChangeType?changeType = null)
{
var data = new DataReturnSubmissionEeeChangesCsvData
{
ProducerName = producer.CurrentSubmission.OrganisationName,
ProducerRegistrationNumber = producer.ProducerRegistrationNumber,
ChangeType = changeType,
ComplianceYear = year,
Quarter = quarter,
SubmissionDate = submittedDate,
};
if (producerAmounts != null)
{
data.Cat1B2B = GetEeeDataTonnes(producerAmounts, ObligationType.B2B, 1);
data.Cat2B2B = GetEeeDataTonnes(producerAmounts, ObligationType.B2B, 2);
data.Cat3B2B = GetEeeDataTonnes(producerAmounts, ObligationType.B2B, 3);
data.Cat4B2B = GetEeeDataTonnes(producerAmounts, ObligationType.B2B, 4);
data.Cat5B2B = GetEeeDataTonnes(producerAmounts, ObligationType.B2B, 5);
data.Cat6B2B = GetEeeDataTonnes(producerAmounts, ObligationType.B2B, 6);
data.Cat7B2B = GetEeeDataTonnes(producerAmounts, ObligationType.B2B, 7);
data.Cat8B2B = GetEeeDataTonnes(producerAmounts, ObligationType.B2B, 8);
data.Cat9B2B = GetEeeDataTonnes(producerAmounts, ObligationType.B2B, 9);
data.Cat10B2B = GetEeeDataTonnes(producerAmounts, ObligationType.B2B, 10);
data.Cat11B2B = GetEeeDataTonnes(producerAmounts, ObligationType.B2B, 11);
data.Cat12B2B = GetEeeDataTonnes(producerAmounts, ObligationType.B2B, 12);
data.Cat13B2B = GetEeeDataTonnes(producerAmounts, ObligationType.B2B, 13);
data.Cat14B2B = GetEeeDataTonnes(producerAmounts, ObligationType.B2B, 14);
data.Cat1B2C = GetEeeDataTonnes(producerAmounts, ObligationType.B2C, 1);
data.Cat2B2C = GetEeeDataTonnes(producerAmounts, ObligationType.B2C, 2);
data.Cat3B2C = GetEeeDataTonnes(producerAmounts, ObligationType.B2C, 3);
data.Cat4B2C = GetEeeDataTonnes(producerAmounts, ObligationType.B2C, 4);
data.Cat5B2C = GetEeeDataTonnes(producerAmounts, ObligationType.B2C, 5);
data.Cat6B2C = GetEeeDataTonnes(producerAmounts, ObligationType.B2C, 6);
data.Cat7B2C = GetEeeDataTonnes(producerAmounts, ObligationType.B2C, 7);
data.Cat8B2C = GetEeeDataTonnes(producerAmounts, ObligationType.B2C, 8);
data.Cat9B2C = GetEeeDataTonnes(producerAmounts, ObligationType.B2C, 9);
data.Cat10B2C = GetEeeDataTonnes(producerAmounts, ObligationType.B2C, 10);
data.Cat11B2C = GetEeeDataTonnes(producerAmounts, ObligationType.B2C, 11);
data.Cat12B2C = GetEeeDataTonnes(producerAmounts, ObligationType.B2C, 12);
data.Cat13B2C = GetEeeDataTonnes(producerAmounts, ObligationType.B2C, 13);
data.Cat14B2C = GetEeeDataTonnes(producerAmounts, ObligationType.B2C, 14);
}
return(data);
}
public ErrorData ValidateProducerObligationType(RegisteredProducer producer, string producerRegistrationNumber, string producerName, ObligationType obligationType)
{
ErrorData error = null;
if (!producer.CurrentSubmission.ObligationType.HasFlag(obligationType))
{
var errorMessage = string.Format(
"Producer registration number {0} {1} has submitted a {2} return for one or more categories but is only registered for {3}. Amend the return or submit an update for the producer's details.",
producerRegistrationNumber,
producerName,
obligationType,
producer.CurrentSubmission.ObligationType);
error = new ErrorData(errorMessage, ErrorLevel.Error);
}
return(error);
}
public ErrorData ValidateProducerName(RegisteredProducer producer, string producerRegistrationNumber, string producerName)
{
ErrorData error = null;
if (!string.Equals(producer.CurrentSubmission.OrganisationName, producerName, StringComparison.InvariantCultureIgnoreCase))
{
var errorMessage = string.Format(
"The producer name {0} registered with producer registration number {1} for {2} does not match the registered producer name of {3}. Ensure the registration number and producer name match the registered details.",
producerName,
producerRegistrationNumber,
quarter.Year,
producer.CurrentSubmission.OrganisationName);
error = new ErrorData(errorMessage, ErrorLevel.Error);
}
return(error);
}
public ErrorData ValidateProducerObligationType(RegisteredProducer producer, string producerRegistrationNumber, string producerName, ObligationType obligationType)
{
ErrorData error = null;
if (!producer.CurrentSubmission.ObligationType.HasFlag(obligationType))
{
var errorMessage = string.Format(
"Producer registration number {0} {1} has submitted a {2} return for one or more categories but is only registered for {3}. Amend the return or submit an update for the producer's details.",
producerRegistrationNumber,
producerName,
obligationType,
producer.CurrentSubmission.ObligationType);
error = new ErrorData(errorMessage, ErrorLevel.Error);
}
return error;
}
public ErrorData ValidateProducerName(RegisteredProducer producer, string producerRegistrationNumber, string producerName)
{
ErrorData error = null;
if (!string.Equals(producer.CurrentSubmission.OrganisationName, producerName, StringComparison.InvariantCultureIgnoreCase))
{
var errorMessage = string.Format(
"The producer name {0} registered with producer registration number {1} for {2} does not match the registered producer name of {3}. Ensure the registration number and producer name match the registered details.",
producerName,
producerRegistrationNumber,
quarter.Year,
producer.CurrentSubmission.OrganisationName);
error = new ErrorData(errorMessage, ErrorLevel.Error);
}
return error;
}
public static ProducerSubmission Create(
ObligationType obligationType,
string prn,
Guid? schemeOrganisationId = null,
int? complianceYear = null,
ProducerBusiness producerBusiness = null,
params string[] brandNames)
{
Scheme scheme = new Scheme(
schemeOrganisationId ?? Guid.Empty);
RegisteredProducer registeredProducer = new RegisteredProducer(
prn,
complianceYear ?? 2016,
scheme);
MemberUpload memberUpload = new MemberUpload(
Guid.NewGuid(),
"<xml>SomeData</xml>",
new List<MemberUploadError>(),
0,
complianceYear ?? 2016,
scheme,
"File name");
return new ProducerSubmission(
registeredProducer,
memberUpload,
producerBusiness ?? new ProducerBusiness(),
new AuthorisedRepresentative("authrep"),
DateTime.Now,
0,
true,
null,
"trading name",
EEEPlacedOnMarketBandType.Lessthan5TEEEplacedonmarket,
SellingTechniqueType.Both,
obligationType,
AnnualTurnOverBandType.Greaterthanonemillionpounds,
brandNames.Select(bn => new BrandName(bn)).ToList(),
new List<SICCode>(),
new ChargeBandAmount(Guid.NewGuid(), ChargeBand.A, 123),
999);
}
private void PopulateProducer(RegisteredProducer registeredProducer, IEnumerable <EeeOutputAmount> eeeOutputAmounts, XElement xmlProducer)
{
XElement xmlRegistrationNo = new XElement(XmlNamespace.DataReturns + "RegistrationNo");
xmlProducer.Add(xmlRegistrationNo);
xmlRegistrationNo.Value = registeredProducer.ProducerRegistrationNumber;
XElement xmlProducerCompanyName = new XElement(XmlNamespace.DataReturns + "ProducerCompanyName");
xmlProducer.Add(xmlProducerCompanyName);
xmlProducerCompanyName.Value = registeredProducer.CurrentSubmission.OrganisationName;
XElement xmlReturns = new XElement(XmlNamespace.DataReturns + "Returns");
xmlProducer.Add(xmlReturns);
foreach (var eeeOutputAmount in eeeOutputAmounts)
{
XElement xmlReturn = new XElement(XmlNamespace.DataReturns + "Return");
xmlReturns.Add(xmlReturn);
PopulateReturn(eeeOutputAmount, xmlReturn);
}
}
public async Task HandleAsync_HappyPath_ReturnsProducerDetailsSchemeObjectWithPerfectValue()
{
// Arrange
Scheme scheme = new Scheme(
A.Dummy<Guid>());
MemberUpload memberUpload = new MemberUpload(
A.Dummy<Guid>(),
A.Dummy<string>(),
A.Dummy<List<MemberUploadError>>(),
A.Dummy<decimal>(),
2017,
scheme,
A.Dummy<string>(),
A.Dummy<string>());
RegisteredProducer registeredProducer = new RegisteredProducer(
"WEE/AA1111AA",
2017,
scheme);
var producer = new ProducerSubmission(
registeredProducer,
memberUpload,
new EA.Weee.Domain.Producer.ProducerBusiness(
new Company("CompanyName", "RegisteredNo",
new ProducerContact(A.Dummy<string>(), A.Dummy<string>(), A.Dummy<string>(), A.Dummy<string>(), A.Dummy<string>(), A.Dummy<string>(), A.Dummy<string>(),
new ProducerAddress(A.Dummy<string>(), A.Dummy<string>(), A.Dummy<string>(), A.Dummy<string>(), A.Dummy<string>(), A.Dummy<string>(),
new Country(Guid.NewGuid(), A.Dummy<string>()), A.Dummy<string>())))),
null,
new DateTime(2015, 1, 1),
0,
false,
null,
"Trading Name 1",
EEEPlacedOnMarketBandType.Lessthan5TEEEplacedonmarket,
SellingTechniqueType.Both,
Domain.Obligation.ObligationType.Both,
AnnualTurnOverBandType.Greaterthanonemillionpounds,
new List<Domain.Producer.BrandName>(),
new List<Domain.Producer.SICCode>(),
A.Dummy<ChargeBandAmount>(),
0);
registeredProducer.SetCurrentSubmission(producer);
registeredProducer.Scheme.UpdateScheme("SchemeName", "WEE/FA9999KE/SCH", "test", ObligationType.B2B, Guid.NewGuid());
IGetProducerDetailsByRegisteredProducerIdDataAccess dataAccess = A.Fake<IGetProducerDetailsByRegisteredProducerIdDataAccess>();
A.CallTo(() => dataAccess.Fetch(registeredProducer.Id))
.Returns(registeredProducer);
IWeeeAuthorization authorization = AuthorizationBuilder.CreateUserWithAllRights();
GetProducerDetailsByRegisteredProducerIdHandler handler = new GetProducerDetailsByRegisteredProducerIdHandler(dataAccess, authorization);
Requests.Admin.GetProducerDetailsByRegisteredProducerId request =
new Requests.Admin.GetProducerDetailsByRegisteredProducerId(registeredProducer.Id);
// Act
ProducerDetailsScheme result = await handler.HandleAsync(request);
// Assert
Assert.Equal(result.ComplianceYear, registeredProducer.ComplianceYear);
Assert.Equal(result.ProducerName, registeredProducer.CurrentSubmission.OrganisationName);
Assert.Equal(result.SchemeName, registeredProducer.Scheme.SchemeName);
Assert.Equal(result.RegistrationNumber, registeredProducer.ProducerRegistrationNumber);
}
public async Task HandleAsync_WithDataReturnWithNoEee_SetsHasSubmittedEEEToFalse()
{
// Arrange
IWeeeAuthorization authorization = AuthorizationBuilder.CreateUserWithAllRights();
Organisation organisation = Organisation.CreateSoleTrader("Trading Name");
Scheme scheme = new Scheme(organisation);
RegisteredProducer registeredProducer = new RegisteredProducer("WEE/AA1111AA", 2016, scheme);
Guid registeredProducerId = new Guid("75B6B4E7-BA92-477D-A6CA-C43C8C0E9823");
typeof(Entity).GetProperty("Id").SetValue(registeredProducer, registeredProducerId);
MemberUpload memberUpload = new MemberUpload(
A.Dummy<Guid>(),
"data",
new List<MemberUploadError>(),
0,
2016,
scheme,
"file.xml",
"UserID");
ProducerSubmission producerSubmission = new ProducerSubmission(
registeredProducer,
memberUpload,
A.Dummy<ProducerBusiness>(),
A.Dummy<AuthorisedRepresentative>(),
A.Dummy<DateTime>(),
A.Dummy<decimal?>(),
A.Dummy<bool>(),
A.Dummy<DateTime?>(),
A.Dummy<string>(),
A.Dummy<EEEPlacedOnMarketBandType>(),
A.Dummy<SellingTechniqueType>(),
A.Dummy<ObligationType>(),
A.Dummy<AnnualTurnOverBandType>(),
A.Dummy<List<BrandName>>(),
A.Dummy<List<SICCode>>(),
A.Dummy<ChargeBandAmount>(),
A.Dummy<decimal>());
registeredProducer.SetCurrentSubmission(producerSubmission);
DataReturn dataReturn = new DataReturn(scheme, new Quarter(2016, QuarterType.Q4));
DataReturnVersion dataReturnVersion = new DataReturnVersion(dataReturn);
dataReturnVersion.Submit("UserID");
IGetProducerDetailsByRegisteredProducerIdDataAccess dataAccess = A.Fake<IGetProducerDetailsByRegisteredProducerIdDataAccess>();
A.CallTo(() => dataAccess.Fetch(registeredProducerId)).Returns(registeredProducer);
A.CallTo(() => dataAccess.FetchDataReturns(scheme, 2016)).Returns(new List<DataReturn>() { dataReturn });
GetProducerDetailsByRegisteredProducerIdHandler handler = new GetProducerDetailsByRegisteredProducerIdHandler(dataAccess, authorization);
// Act
GetProducerDetailsByRegisteredProducerId request = new GetProducerDetailsByRegisteredProducerId(registeredProducerId);
ProducerDetailsScheme result = await handler.HandleAsync(request);
// Assert
Assert.Equal(false, result.HasSubmittedEEE);
}
private ProducerSubmission Build()
{
Scheme scheme = new Scheme(
A.Dummy<Guid>());
var memberUpload = new MemberUpload(
A.Dummy<Guid>(),
A.Dummy<string>(),
A.Dummy<List<MemberUploadError>>(),
A.Dummy<decimal>(),
2017,
scheme,
A.Dummy<string>(),
A.Dummy<string>());
var updatedDate = A.Dummy<DateTime>();
RegisteredProducer registeredProducer = new RegisteredProducer(
registrationNumber,
2017,
scheme);
ProducerSubmission producerSubmission = new ProducerSubmission(
registeredProducer,
memberUpload,
producerBusiness,
authorisedRepresentative,
updatedDate,
annualTurnover,
vatRegistered,
ceaseToExist,
tradingName,
eeePlacedOnMarketBandType,
sellingTechniqueType,
obligationType,
annualTurnOverBandType,
brandNames,
sicCodes,
chargeBandAmount,
(decimal)5.0);
registeredProducer.SetCurrentSubmission(producerSubmission);
return producerSubmission;
}
public async Task FetchResultsAsync_WithOneAmountOfEachTypeAndSourceAndObligationType_ReturnsResultForEachAmountWithCorrectOrdering()
{
using (Weee.Tests.Core.Model.DatabaseWrapper wrapper = new Weee.Tests.Core.Model.DatabaseWrapper())
{
// Arrange
Organisation organisation = Organisation.CreateSoleTrader("Test Organisation");
Scheme scheme = new Scheme(organisation);
RegisteredProducer registeredProducer1 = new RegisteredProducer("WEE/AA9365AA", 2099, scheme);
Quarter quarter = new Quarter(2099, QuarterType.Q1);
DataReturn dataReturn = new DataReturn(scheme, quarter);
DataReturnVersion version = new DataReturnVersion(dataReturn);
WeeeCollectedAmount amountCollectedDcfB2C = new WeeeCollectedAmount(
WeeeCollectedAmountSourceType.Dcf,
ObligationType.B2C,
WeeeCategory.LargeHouseholdAppliances,
123.456m);
version.WeeeCollectedReturnVersion.AddWeeeCollectedAmount(amountCollectedDcfB2C);
WeeeCollectedAmount amountCollectedDistributor = new WeeeCollectedAmount(
WeeeCollectedAmountSourceType.Distributor,
ObligationType.B2C,
WeeeCategory.LargeHouseholdAppliances,
123.456m);
version.WeeeCollectedReturnVersion.AddWeeeCollectedAmount(amountCollectedDistributor);
WeeeCollectedAmount amountCollectedFinalHolder = new WeeeCollectedAmount(
WeeeCollectedAmountSourceType.FinalHolder,
ObligationType.B2C,
WeeeCategory.LargeHouseholdAppliances,
123.456m);
version.WeeeCollectedReturnVersion.AddWeeeCollectedAmount(amountCollectedFinalHolder);
WeeeDeliveredAmount amountDeliveredAatfB2C = new WeeeDeliveredAmount(
ObligationType.B2C,
WeeeCategory.LargeHouseholdAppliances,
123.456m,
new AatfDeliveryLocation("WEE/AA6845AA/ATF", string.Empty));
version.WeeeDeliveredReturnVersion.AddWeeeDeliveredAmount(amountDeliveredAatfB2C);
WeeeDeliveredAmount amountDeliveredAeB2C = new WeeeDeliveredAmount(
ObligationType.B2C,
WeeeCategory.LargeHouseholdAppliances,
123.456m,
new AeDeliveryLocation("WEE/AA2658AA/AE", string.Empty));
version.WeeeDeliveredReturnVersion.AddWeeeDeliveredAmount(amountDeliveredAeB2C);
EeeOutputAmount amountOutputB2C = new EeeOutputAmount(
ObligationType.B2C,
WeeeCategory.LargeHouseholdAppliances,
123.456m,
registeredProducer1);
version.EeeOutputReturnVersion.AddEeeOutputAmount(amountOutputB2C);
WeeeCollectedAmount amountCollectedDcfB2B = new WeeeCollectedAmount(
WeeeCollectedAmountSourceType.Dcf,
ObligationType.B2B,
WeeeCategory.LargeHouseholdAppliances,
123.456m);
version.WeeeCollectedReturnVersion.AddWeeeCollectedAmount(amountCollectedDcfB2B);
WeeeDeliveredAmount amountDeliveredAatfB2B = new WeeeDeliveredAmount(
ObligationType.B2B,
WeeeCategory.LargeHouseholdAppliances,
123.456m,
new AatfDeliveryLocation("WEE/AA7445AA/ATF", string.Empty));
version.WeeeDeliveredReturnVersion.AddWeeeDeliveredAmount(amountDeliveredAatfB2B);
WeeeDeliveredAmount amountDeliveredAeB2B = new WeeeDeliveredAmount(
ObligationType.B2B,
WeeeCategory.LargeHouseholdAppliances,
123.456m,
new AeDeliveryLocation("WEE/AA3658AA/AE", string.Empty));
version.WeeeDeliveredReturnVersion.AddWeeeDeliveredAmount(amountDeliveredAeB2B);
EeeOutputAmount amountOutputB2B = new EeeOutputAmount(
ObligationType.B2B,
WeeeCategory.LargeHouseholdAppliances,
123.456m,
registeredProducer1);
version.EeeOutputReturnVersion.AddEeeOutputAmount(amountOutputB2B);
wrapper.WeeeContext.DataReturns.Add(dataReturn);
await wrapper.WeeeContext.SaveChangesAsync();
dataReturn.SetCurrentVersion(version);
await wrapper.WeeeContext.SaveChangesAsync();
// Act
FetchSummaryCsvDataAccess dataAccess = new FetchSummaryCsvDataAccess(wrapper.WeeeContext);
List<DataReturnSummaryCsvData> results = await dataAccess.FetchResultsAsync(scheme.Id, 2099);
// Assert
Assert.NotNull(results);
Assert.Equal(10, results.Count);
Assert.Collection(results,
r => { Assert.Equal(0, r.Type); Assert.Equal(0, r.Source); Assert.Equal("B2C", r.ObligationType); },
r => { Assert.Equal(0, r.Type); Assert.Equal(0, r.Source); Assert.Equal("B2B", r.ObligationType); },
r => { Assert.Equal(0, r.Type); Assert.Equal(1, r.Source); Assert.Equal("B2C", r.ObligationType); },
r => { Assert.Equal(0, r.Type); Assert.Equal(2, r.Source); Assert.Equal("B2C", r.ObligationType); },
r => { Assert.Equal(1, r.Type); Assert.Equal(0, r.Source); Assert.Equal("B2C", r.ObligationType); },
r => { Assert.Equal(1, r.Type); Assert.Equal(0, r.Source); Assert.Equal("B2B", r.ObligationType); },
r => { Assert.Equal(1, r.Type); Assert.Equal(1, r.Source); Assert.Equal("B2C", r.ObligationType); },
r => { Assert.Equal(1, r.Type); Assert.Equal(1, r.Source); Assert.Equal("B2B", r.ObligationType); },
r => { Assert.Equal(2, r.Type); Assert.Equal(null, r.Source); Assert.Equal("B2C", r.ObligationType); },
r => { Assert.Equal(2, r.Type); Assert.Equal(null, r.Source); Assert.Equal("B2B", r.ObligationType); });
}
}
public async Task FetchResultsAsync_WithSeveralOutputAmounts_ReturnsSumOfAmounts()
{
using (Weee.Tests.Core.Model.DatabaseWrapper wrapper = new Weee.Tests.Core.Model.DatabaseWrapper())
{
// Arrange
Organisation organisation = Organisation.CreateSoleTrader("Test Organisation");
Scheme scheme = new Scheme(organisation);
RegisteredProducer registeredProducer1 = new RegisteredProducer("WEE/AA1111AA", 2099, scheme);
RegisteredProducer registeredProducer2 = new RegisteredProducer("WEE/BB2222BB", 2099, scheme);
Quarter quarter = new Quarter(2099, QuarterType.Q1);
DataReturn dataReturn = new DataReturn(scheme, quarter);
DataReturnVersion version = new DataReturnVersion(dataReturn);
EeeOutputAmount amount1 = new EeeOutputAmount(
ObligationType.B2C,
WeeeCategory.LargeHouseholdAppliances,
100,
registeredProducer1);
version.EeeOutputReturnVersion.AddEeeOutputAmount(amount1);
EeeOutputAmount amount2 = new EeeOutputAmount(
ObligationType.B2C,
WeeeCategory.LargeHouseholdAppliances,
200,
registeredProducer2);
version.EeeOutputReturnVersion.AddEeeOutputAmount(amount2);
wrapper.WeeeContext.DataReturns.Add(dataReturn);
await wrapper.WeeeContext.SaveChangesAsync();
dataReturn.SetCurrentVersion(version);
await wrapper.WeeeContext.SaveChangesAsync();
// Act
FetchSummaryCsvDataAccess dataAccess = new FetchSummaryCsvDataAccess(wrapper.WeeeContext);
List<DataReturnSummaryCsvData> results = await dataAccess.FetchResultsAsync(scheme.Id, 2099);
// Assert
Assert.NotNull(results);
Assert.Equal(1, results.Count);
DataReturnSummaryCsvData result = results[0];
Assert.NotNull(result);
Assert.Equal(300, result.Category1);
}
}
private static IEnumerable<EeeOutputAmount> CreateEeeOutputAmounts(RegisteredProducer registeredProducer)
{
ObligationType obligationType = registeredProducer.CurrentSubmission.ObligationType;
IEnumerable<IReturnItem> returnItems = CreateReturnItems(obligationType);
return returnItems.Select(x => new EeeOutputAmount(x.ObligationType, x.WeeeCategory, x.Tonnage, registeredProducer));
}
public void Add(RegisteredProducer registeredProducer)
{
context.AllRegisteredProducers.Add(registeredProducer);
}
public async Task CreateTransactionFile_ProducerSubmissionWithNoCharge_NotIncludedInTransactionFile()
{
// Arrange
UKCompetentAuthority authority = A.Dummy<UKCompetentAuthority>();
Organisation organisation = Organisation.CreateSoleTrader("Test organisation");
Scheme scheme = new Scheme(organisation);
scheme.UpdateScheme(
"Test scheme",
"WEE/AA1111AA/SCH",
"WEE00000001",
A.Dummy<ObligationType>(),
authority);
int complianceYear = A.Dummy<int>();
MemberUpload memberUpload = new MemberUpload(
A.Dummy<Guid>(),
A.Dummy<string>(),
A.Dummy<List<MemberUploadError>>(),
A.Dummy<decimal>(),
complianceYear,
scheme,
A.Dummy<string>());
RegisteredProducer registeredProducer = new RegisteredProducer("WEE/11AAAA11", complianceYear, scheme);
ProducerSubmission producerSubmission = new ProducerSubmission(
registeredProducer,
memberUpload,
A.Dummy<ProducerBusiness>(),
A.Dummy<AuthorisedRepresentative>(),
A.Dummy<DateTime>(),
A.Dummy<decimal>(),
A.Dummy<bool>(),
A.Dummy<DateTime?>(),
A.Dummy<string>(),
A.Dummy<EEEPlacedOnMarketBandType>(),
A.Dummy<SellingTechniqueType>(),
A.Dummy<ObligationType>(),
A.Dummy<AnnualTurnOverBandType>(),
A.Dummy<List<BrandName>>(),
A.Dummy<List<SICCode>>(),
A.Dummy<Domain.Lookup.ChargeBandAmount>(),
0);
memberUpload.ProducerSubmissions.Add(producerSubmission);
memberUpload.Submit(A.Dummy<User>());
List<MemberUpload> memberUploads = new List<MemberUpload>();
memberUploads.Add(memberUpload);
InvoiceRun invoiceRun = new InvoiceRun(authority, memberUploads, A.Dummy<User>());
ByChargeValueTransactionFileGenerator generator = new ByChargeValueTransactionFileGenerator(
A.Dummy<ITransactionReferenceGenerator>());
// Act
var result = await generator.CreateAsync(0, invoiceRun);
TransactionFile transactionFile = result.IbisFile;
// Assert
Assert.NotNull(transactionFile);
Assert.Equal(0, transactionFile.Invoices.Count);
}
public async Task CreateTransactionFile_WithExceptionThrown_ReturnsError_AndNoTransactionFile()
{
// Arrange
UKCompetentAuthority authority = A.Dummy<UKCompetentAuthority>();
Organisation organisation = Organisation.CreateSoleTrader("Test organisation");
Scheme scheme = new Scheme(organisation);
scheme.UpdateScheme(
"Test scheme",
"WEE/AA1111AA/SCH",
"WEE00000001",
A.Dummy<ObligationType>(),
authority);
int complianceYear = A.Dummy<int>();
MemberUpload memberUpload = new MemberUpload(
A.Dummy<Guid>(),
A.Dummy<string>(),
A.Dummy<List<MemberUploadError>>(),
A.Dummy<decimal>(),
complianceYear,
scheme,
A.Dummy<string>());
RegisteredProducer registeredProducer = new RegisteredProducer("WEE/11AAAA11", complianceYear, scheme);
ProducerSubmission producerSubmission = new ProducerSubmission(
registeredProducer,
memberUpload,
A.Dummy<ProducerBusiness>(),
A.Dummy<AuthorisedRepresentative>(),
A.Dummy<DateTime>(),
A.Dummy<decimal>(),
A.Dummy<bool>(),
A.Dummy<DateTime?>(),
A.Dummy<string>(),
A.Dummy<EEEPlacedOnMarketBandType>(),
A.Dummy<SellingTechniqueType>(),
A.Dummy<ObligationType>(),
A.Dummy<AnnualTurnOverBandType>(),
A.Dummy<List<BrandName>>(),
A.Dummy<List<SICCode>>(),
A.Dummy<Domain.Lookup.ChargeBandAmount>(),
100M);
memberUpload.ProducerSubmissions.Add(producerSubmission);
memberUpload.Submit(A.Dummy<User>());
List<MemberUpload> memberUploads = new List<MemberUpload>();
memberUploads.Add(memberUpload);
InvoiceRun invoiceRun = new InvoiceRun(authority, memberUploads, A.Dummy<User>());
ITransactionReferenceGenerator transactionReferenceGenerator = A.Fake<ITransactionReferenceGenerator>();
A.CallTo(() => transactionReferenceGenerator.GetNextTransactionReferenceAsync()).Returns((string)null); // A null value will cause the Ibis object to throw an exception.
ByChargeValueTransactionFileGenerator generator = new ByChargeValueTransactionFileGenerator(
transactionReferenceGenerator);
// Act
var result = await generator.CreateAsync(0, invoiceRun);
// Assert
Assert.Null(result.IbisFile);
Assert.NotEmpty(result.Errors);
}
private void PopulateProducer(RegisteredProducer registeredProducer, IEnumerable<EeeOutputAmount> eeeOutputAmounts, XElement xmlProducer)
{
XElement xmlRegistrationNo = new XElement(XmlNamespace.DataReturns + "RegistrationNo");
xmlProducer.Add(xmlRegistrationNo);
xmlRegistrationNo.Value = registeredProducer.ProducerRegistrationNumber;
XElement xmlProducerCompanyName = new XElement(XmlNamespace.DataReturns + "ProducerCompanyName");
xmlProducer.Add(xmlProducerCompanyName);
xmlProducerCompanyName.Value = registeredProducer.CurrentSubmission.OrganisationName;
XElement xmlReturns = new XElement(XmlNamespace.DataReturns + "Returns");
xmlProducer.Add(xmlReturns);
foreach (var eeeOutputAmount in eeeOutputAmounts)
{
XElement xmlReturn = new XElement(XmlNamespace.DataReturns + "Return");
xmlReturns.Add(xmlReturn);
PopulateReturn(eeeOutputAmount, xmlReturn);
}
}
public async Task CreateTransactionFile_WithOneProducerSubmission_CreatesOneInvoiceWithOneLineItem()
{
// Arrange
UKCompetentAuthority authority = A.Dummy<UKCompetentAuthority>();
Organisation organisation = Organisation.CreateSoleTrader("Test organisation");
Scheme scheme = new Scheme(organisation);
scheme.UpdateScheme(
"Test scheme",
"WEE/AA1111AA/SCH",
"WEE00000001",
A.Dummy<ObligationType>(),
authority);
int complianceYear = A.Dummy<int>();
MemberUpload memberUpload = new MemberUpload(
A.Dummy<Guid>(),
A.Dummy<string>(),
A.Dummy<List<MemberUploadError>>(),
A.Dummy<decimal>(),
complianceYear,
scheme,
A.Dummy<string>());
RegisteredProducer registeredProducer = new RegisteredProducer("WEE/11AAAA11", complianceYear, scheme);
ProducerSubmission producerSubmission = new ProducerSubmission(
registeredProducer,
memberUpload,
A.Dummy<ProducerBusiness>(),
A.Dummy<AuthorisedRepresentative>(),
A.Dummy<DateTime>(),
A.Dummy<decimal>(),
A.Dummy<bool>(),
A.Dummy<DateTime?>(),
A.Dummy<string>(),
A.Dummy<EEEPlacedOnMarketBandType>(),
A.Dummy<SellingTechniqueType>(),
A.Dummy<ObligationType>(),
A.Dummy<AnnualTurnOverBandType>(),
A.Dummy<List<BrandName>>(),
A.Dummy<List<SICCode>>(),
A.Dummy<Domain.Lookup.ChargeBandAmount>(),
123.45m);
memberUpload.ProducerSubmissions.Add(producerSubmission);
memberUpload.Submit(A.Dummy<User>());
List<MemberUpload> memberUploads = new List<MemberUpload>();
memberUploads.Add(memberUpload);
SystemTime.Freeze(new DateTime(2015, 12, 31));
InvoiceRun invoiceRun = new InvoiceRun(authority, memberUploads, A.Dummy<User>());
SystemTime.Unfreeze();
ITransactionReferenceGenerator transactionReferenceGenerator = A.Fake<ITransactionReferenceGenerator>();
A.CallTo(() => transactionReferenceGenerator.GetNextTransactionReferenceAsync()).Returns("WEE800001H");
ByChargeValueTransactionFileGenerator generator = new ByChargeValueTransactionFileGenerator(transactionReferenceGenerator);
// Act
var result = await generator.CreateAsync(0, invoiceRun);
TransactionFile transactionFile = result.IbisFile;
// Assert
Assert.NotNull(transactionFile);
Assert.Equal(1, transactionFile.Invoices.Count);
Invoice invoice = transactionFile.Invoices[0];
Assert.NotNull(invoice);
Assert.Equal(TransactionType.Invoice, invoice.TransactionType);
Assert.Equal("WEE800001H", invoice.TransactionReference);
Assert.Equal(123.45m, invoice.TransactionTotal);
Assert.Equal(null, invoice.TransactionHeaderNarrative);
Assert.Equal(new DateTime(2015, 12, 31), invoice.TransactionDate);
Assert.Equal(null, invoice.RelatedTransactionReference);
Assert.Equal(CurrencyCode.GBP, invoice.CurrencyCode);
Assert.Equal("WEE00000001", invoice.CustomerReference);
Assert.NotNull(invoice.LineItems);
Assert.Equal(1, invoice.LineItems.Count);
InvoiceLineItem lineItem = invoice.LineItems[0];
Assert.NotNull(lineItem);
Assert.Equal(123.45m, lineItem.AmountExcludingVAT);
Assert.Equal("1 producer registration charge at £123.45.", lineItem.Description);
Assert.Equal("H", lineItem.AreaCode);
Assert.Equal("H", lineItem.ContextCode);
Assert.Equal("W", lineItem.IncomeStreamCode);
Assert.Equal((ulong)1, lineItem.Quantity);
Assert.Equal(UnitOfMeasure.Each, lineItem.UnitOfMeasure);
Assert.Equal(null, lineItem.VatCode);
}
public async Task<IEnumerable<ProducerSubmission>> GenerateProducerData(schemeType scheme, MemberUpload memberUpload, Dictionary<string, ProducerCharge> producerCharges)
{
if (memberUpload.ComplianceYear == null)
{
string errorMessage = "Producers cannot be generated for a member upload "
+ "that does not have a compliance year.";
throw new InvalidOperationException(errorMessage);
}
List<ProducerSubmission> producers = new List<ProducerSubmission>();
int numberOfPrnsNeeded = scheme.producerList.Count(p => p.status == statusType.I);
Queue<string> generatedPrns = await dataAccess.ComputePrns(numberOfPrnsNeeded);
foreach (producerType producerData in scheme.producerList)
{
var producerName = producerData.GetProducerName();
if (producerCharges == null)
{
throw new ApplicationException("No charges have been supplied");
}
if (!producerCharges.ContainsKey(producerName))
{
throw new ApplicationException(string.Format("No charges have been supplied for the {0}.", producerName));
}
var chargeBandAmount = producerCharges[producerName].ChargeBandAmount;
var chargeThisUpdate = producerCharges[producerName].Amount;
List<BrandName> brandNames = producerData.producerBrandNames.Select(name => new BrandName(name)).ToList();
List<SICCode> codes = producerData.SICCodeList.Select(name => new SICCode(name)).ToList();
ProducerBusiness producerBusiness = await SetProducerBusiness(producerData.producerBusiness);
AuthorisedRepresentative authorisedRepresentative = await SetAuthorisedRepresentative(producerData.authorisedRepresentative);
EEEPlacedOnMarketBandType eeebandType = Enumeration.FromValue<EEEPlacedOnMarketBandType>((int)producerData.eeePlacedOnMarketBand);
SellingTechniqueType sellingTechniqueType = Enumeration.FromValue<SellingTechniqueType>((int)producerData.sellingTechnique);
ObligationType obligationType = producerData.obligationType.ToDomainObligationType();
AnnualTurnOverBandType annualturnoverType = Enumeration.FromValue<AnnualTurnOverBandType>((int)producerData.annualTurnoverBand);
DateTime? ceaseDate = null;
if (producerData.ceaseToExistDateSpecified)
{
ceaseDate = producerData.ceaseToExistDate;
}
RegisteredProducer registeredProducer = null;
string producerRegistrationNo;
switch (producerData.status)
{
case statusType.I:
producerRegistrationNo = generatedPrns.Dequeue();
break;
case statusType.A:
producerRegistrationNo = producerData.registrationNo;
await EnsureProducerRegistrationNumberExists(producerRegistrationNo);
registeredProducer = await dataAccess.FetchRegisteredProducerOrDefault(
producerRegistrationNo,
memberUpload.ComplianceYear.Value,
memberUpload.Scheme.Id);
break;
default:
throw new NotSupportedException();
}
if (registeredProducer == null)
{
registeredProducer = new RegisteredProducer(
producerRegistrationNo,
memberUpload.ComplianceYear.Value,
memberUpload.Scheme);
}
ProducerSubmission producer = new ProducerSubmission(
registeredProducer,
memberUpload,
producerBusiness,
authorisedRepresentative,
SystemTime.UtcNow,
producerData.annualTurnover,
producerData.VATRegistered,
ceaseDate,
producerData.tradingName,
eeebandType,
sellingTechniqueType,
obligationType,
annualturnoverType,
brandNames,
codes,
chargeBandAmount,
chargeThisUpdate);
// modify producer data
switch (producerData.status)
{
case statusType.A:
if (registeredProducer.CurrentSubmission == null)
{
producers.Add(producer);
}
else
{
if (!registeredProducer.CurrentSubmission.Equals(producer))
{
producers.Add(producer);
}
else
{
/*
* The producer's details are the same as the current submission for this
* registration so we don't need to update them.
*/
}
}
break;
case statusType.I:
producers.Add(producer);
break;
}
}
return producers;
}
public async Task CreateTransactionFile_WithTwoMemberUploads_CreatesTwoInvoices()
{
// Arrange
UKCompetentAuthority authority = A.Dummy<UKCompetentAuthority>();
Organisation organisation = Organisation.CreateSoleTrader("Test organisation");
Scheme scheme = new Scheme(organisation);
scheme.UpdateScheme(
"Test scheme",
"WEE/AA1111AA/SCH",
"WEE00000001",
A.Dummy<ObligationType>(),
authority);
int complianceYear = A.Dummy<int>();
MemberUpload memberUpload1 = new MemberUpload(
A.Dummy<Guid>(),
A.Dummy<string>(),
A.Dummy<List<MemberUploadError>>(),
A.Dummy<decimal>(),
complianceYear,
scheme,
A.Dummy<string>());
RegisteredProducer registeredProducer1 = new RegisteredProducer("WEE/11AAAA11", complianceYear, scheme);
ProducerSubmission producerSubmission1 = new ProducerSubmission(
registeredProducer1,
memberUpload1,
A.Dummy<ProducerBusiness>(),
A.Dummy<AuthorisedRepresentative>(),
A.Dummy<DateTime>(),
A.Dummy<decimal>(),
A.Dummy<bool>(),
A.Dummy<DateTime?>(),
A.Dummy<string>(),
A.Dummy<EEEPlacedOnMarketBandType>(),
A.Dummy<SellingTechniqueType>(),
A.Dummy<ObligationType>(),
A.Dummy<AnnualTurnOverBandType>(),
A.Dummy<List<BrandName>>(),
A.Dummy<List<SICCode>>(),
A.Dummy<Domain.Lookup.ChargeBandAmount>(),
100m);
memberUpload1.ProducerSubmissions.Add(producerSubmission1);
memberUpload1.Submit(A.Dummy<User>());
MemberUpload memberUpload2 = new MemberUpload(
A.Dummy<Guid>(),
A.Dummy<string>(),
A.Dummy<List<MemberUploadError>>(),
A.Dummy<decimal>(),
complianceYear,
scheme,
A.Dummy<string>());
RegisteredProducer registeredProducer2 = new RegisteredProducer("WEE/22BBBB22", complianceYear, scheme);
ProducerSubmission producerSubmission2 = new ProducerSubmission(
registeredProducer2,
memberUpload2,
A.Dummy<ProducerBusiness>(),
A.Dummy<AuthorisedRepresentative>(),
A.Dummy<DateTime>(),
A.Dummy<decimal>(),
A.Dummy<bool>(),
A.Dummy<DateTime?>(),
A.Dummy<string>(),
A.Dummy<EEEPlacedOnMarketBandType>(),
A.Dummy<SellingTechniqueType>(),
A.Dummy<ObligationType>(),
A.Dummy<AnnualTurnOverBandType>(),
A.Dummy<List<BrandName>>(),
A.Dummy<List<SICCode>>(),
A.Dummy<Domain.Lookup.ChargeBandAmount>(),
100m);
memberUpload2.ProducerSubmissions.Add(producerSubmission2);
memberUpload2.Submit(A.Dummy<User>());
List<MemberUpload> memberUploads = new List<MemberUpload>();
memberUploads.Add(memberUpload1);
memberUploads.Add(memberUpload2);
InvoiceRun invoiceRun = new InvoiceRun(authority, memberUploads, A.Dummy<User>());
ITransactionReferenceGenerator transactionReferenceGenerator = A.Fake<ITransactionReferenceGenerator>();
A.CallTo(() => transactionReferenceGenerator.GetNextTransactionReferenceAsync()).Returns("WEE800001H");
ByChargeValueTransactionFileGenerator generator = new ByChargeValueTransactionFileGenerator(transactionReferenceGenerator);
// Act
var result = await generator.CreateAsync(0, invoiceRun);
TransactionFile transactionFile = result.IbisFile;
// Assert
Assert.NotNull(transactionFile);
Assert.Equal(2, transactionFile.Invoices.Count);
Invoice invoice1 = transactionFile.Invoices[0];
Assert.NotNull(invoice1);
Assert.Equal(100m, invoice1.TransactionTotal);
Invoice invoice2 = transactionFile.Invoices[1];
Assert.NotNull(invoice2);
Assert.Equal(100m, invoice2.TransactionTotal);
}
public void AssignToInvoiceRun_DoesNotSetRemovedProducerSubmissionAsInvoiced()
{
Scheme scheme = A.Fake<Scheme>();
MemberUpload memberUpload = new MemberUpload(A.Dummy<Guid>(), "data", null, 100, 2015, scheme, "fileName");
var registeredProducer = new RegisteredProducer("PRN", 2015, scheme);
registeredProducer.Remove();
var producer = new ProducerSubmission(
registeredProducer,
memberUpload,
new ProducerBusiness(),
null,
new DateTime(2015, 1, 1),
0,
false,
null,
"Trading Name 1",
EEEPlacedOnMarketBandType.Lessthan5TEEEplacedonmarket,
SellingTechniqueType.Both,
ObligationType.Both,
AnnualTurnOverBandType.Greaterthanonemillionpounds,
new List<BrandName>(),
new List<SICCode>(),
A.Dummy<ChargeBandAmount>(),
0);
memberUpload.ProducerSubmissions.Add(producer);
memberUpload.Submit(A.Dummy<User>());
memberUpload.AssignToInvoiceRun(A.Dummy<InvoiceRun>());
Assert.False(producer.Invoiced);
}
