public async Task GetDataReturnComplianceYearsForSchemeHandler_ReturnsYearsInDescendingOrder()
{
using (var database = new DatabaseWrapper())
{
// Arrange
ModelHelper helper = new ModelHelper(database.Model);
var scheme = helper.CreateScheme();
var firstDataReturn = helper.CreateDataReturn(scheme, 2006, (int)QuarterType.Q1);
var firstDataReturnVersion = helper.CreateDataReturnVersion(scheme, 2006, 1, true, firstDataReturn);
helper.CreateDataReturnUpload(scheme, firstDataReturnVersion);
var secondDataReturn = helper.CreateDataReturn(scheme, 2007, (int)QuarterType.Q1);
var secondDataReturnVersion = helper.CreateDataReturnVersion(scheme, 2007, 1, true, secondDataReturn);
helper.CreateDataReturnUpload(scheme, secondDataReturnVersion);
database.Model.SaveChanges();
// Act
var dataAccess = new FetchDataReturnComplianceYearsForSchemeDataAccess(database.WeeeContext);
var yearsList = await dataAccess.GetDataReturnComplianceYearsForScheme(scheme.Id);
//Assert
Assert.NotNull(yearsList);
Assert.Equal(2, yearsList.Count);
Assert.Collection(yearsList,
r1 => Assert.Equal("2007", r1.ToString()),
r2 => Assert.Equal("2006", r2.ToString()));
}
}
public void FetchSumOfExistingCharges_WithProducerWithNoChargesInSpecifiedYear_ReturnsZero()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
// Arrange
ModelHelper helper = new ModelHelper(database.Model);
Scheme scheme = helper.CreateScheme();
MemberUpload memberUpload = helper.CreateMemberUpload(scheme);
memberUpload.ComplianceYear = 2015;
memberUpload.IsSubmitted = true;
ProducerSubmission producer = helper.CreateProducerAsCompany(memberUpload, "AAAAA");
producer.ChargeThisUpdate = 1;
database.Model.SaveChanges();
ProducerChargeCalculatorDataAccess dataAccess = new ProducerChargeCalculatorDataAccess(database.WeeeContext);
// Act
decimal result = dataAccess.FetchSumOfExistingCharges(scheme.ApprovalNumber, "AAAAA", 2016);
// Assert
Assert.Equal(0, result);
}
}
public void GetLatestProducerForComplianceYearAndScheme_PrnDoesNotMatch_ReturnsNull()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
ModelHelper helper = new ModelHelper(database.Model);
// Arrange
Scheme scheme = helper.CreateScheme();
MemberUpload memberUpload = helper.CreateMemberUpload(scheme);
memberUpload.ComplianceYear = 2016;
memberUpload.IsSubmitted = true;
Weee.Tests.Core.Model.ProducerSubmission producer = helper.CreateProducerAsCompany(memberUpload, "AAAAAAAA");
database.Model.SaveChanges();
ProducerQuerySet querySet = ProducerQuerySet(database.WeeeContext);
// Act
var result = querySet.GetLatestProducerForComplianceYearAndScheme("XXXXXXXX", "2016", scheme.OrganisationId);
// Assert
Assert.Null(result);
}
}
public async Task FetchLatestProducers_WithProducerRegisteredTwiceIn2015_ReturnsOnlyLatestProducer()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
ModelHelper helper = new ModelHelper(database.Model);
// Arrange
Model.Scheme scheme = helper.CreateScheme();
Model.MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme);
memberUpload1.ComplianceYear = 2015;
memberUpload1.IsSubmitted = true;
Model.ProducerSubmission producer1 = helper.CreateProducerAsCompany(memberUpload1, "AAAAA");
producer1.UpdatedDate = new DateTime(2015, 1, 1);
Model.MemberUpload memberUpload2 = helper.CreateMemberUpload(scheme);
memberUpload2.ComplianceYear = 2015;
memberUpload2.IsSubmitted = true;
Model.ProducerSubmission producer2 = helper.CreateProducerAsCompany(memberUpload2, "AAAAA");
producer2.UpdatedDate = new DateTime(2015, 1, 2);
database.Model.SaveChanges();
// Act
FetchProducerSearchResultsForCacheDataAccess dataAccess = new FetchProducerSearchResultsForCacheDataAccess(database.WeeeContext);
var results = await dataAccess.FetchLatestProducers();
// Assert
Assert.NotNull(results);
Assert.Contains(results, p => p.RegistrationNumber == "AAAAA" && p.Name == producer2.Business.Company.Name);
Assert.DoesNotContain(results, p => p.RegistrationNumber == "AAAAA" && p.Name == producer1.Business.Company.Name);
}
}
public async void HasMemberSubmissions_ForOganisationWithAssociatedScheme_AndNoSubmission_ReturnsFalse()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
ModelHelper helper = new ModelHelper(database.Model);
// Arrange
var scheme = helper.CreateScheme();
var upload1 = helper.CreateMemberUpload(scheme);
upload1.IsSubmitted = false;
upload1.ComplianceYear = 2016;
var upload2 = helper.CreateMemberUpload(scheme);
upload2.IsSubmitted = false;
upload2.ComplianceYear = 2016;
database.Model.SaveChanges();
var dataAccess = new GetOrganisationOverviewDataAccess(database.WeeeContext);
// Act
var result = await dataAccess.HasMemberSubmissions(scheme.OrganisationId);
// Assert
Assert.False(result);
}
}
public async void FetchSchemeByOrganisationId_WhenTwoSchemesHaveTheSameOrganisationId_ThrowsException()
{
using (var database = new DatabaseWrapper())
{
Guid organisationId = new Guid("72BB14DF-DCD5-4DBB-BBA9-4CFC26AD80F9");
GetSchemePublicInfoDataAccess dataAccess = new GetSchemePublicInfoDataAccess(database.WeeeContext);
// Arrange
ModelHelper modelHelper = new ModelHelper(database.Model);
var scheme1 = modelHelper.CreateScheme();
scheme1.Organisation.Id = organisationId;
var scheme2 = modelHelper.CreateScheme();
scheme2.Organisation = scheme1.Organisation;
database.Model.SaveChanges();
// Act
Func<Task<Domain.Scheme.Scheme>> action = async () => await dataAccess.FetchSchemeByOrganisationId(organisationId);
// Assert
await Assert.ThrowsAsync<Exception>(action);
}
}
public async Task FetchCompleteOrganisations_WithRejectedScheme_OrganisationNotReturned()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
// Arrange
Organisation organisation = new Organisation();
organisation.Id = new Guid("6BD77BBD-0BD8-4BAB-AA9F-A3E657D1CBB4");
organisation.TradingName = "Test organisation";
organisation.OrganisationType = EA.Weee.Domain.Organisation.OrganisationType.SoleTraderOrIndividual.Value;
organisation.OrganisationStatus = EA.Weee.Domain.Organisation.OrganisationStatus.Complete.Value;
Scheme scheme = new Scheme();
scheme.Id = new Guid("CFD9B56F-6C3C-4E49-825C-A125ACFFEC3B");
scheme.Organisation = organisation;
scheme.SchemeStatus = (int)Core.Shared.SchemeStatus.Rejected;
database.Model.Organisations.Add(organisation);
database.Model.Schemes.Add(scheme);
database.Model.SaveChanges();
var dataAccess = new FetchOrganisationSearchResultsForCacheDataAccess(database.WeeeContext);
// Act
IList<OrganisationSearchResult> results = await dataAccess.FetchCompleteOrganisations();
// Assert
Assert.DoesNotContain(results,
r => r.OrganisationId == new Guid("6BD77BBD-0BD8-4BAB-AA9F-A3E657D1CBB4"));
}
}
public void GetMigratedProducer_PrnDoesNotExist_ReturnsNull()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
// Arrange
MigratedProducerQuerySet querySet = new MigratedProducerQuerySet(database.WeeeContext);
// Act
EA.Weee.Domain.Producer.MigratedProducer result = querySet.GetMigratedProducer("XXX");
// Assert
Assert.Null(result);
}
}
public void FetchCurrentChargeBandAmount_WithChargeBandTypeA_ReturnsChargeBandAmountWithTypeA()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
// Arrange
ProducerChargeCalculatorDataAccess dataAccess = new ProducerChargeCalculatorDataAccess(database.WeeeContext);
// Act
var result = dataAccess.FetchCurrentChargeBandAmount(ChargeBand.A);
// Assert
Assert.NotNull(result);
Assert.Equal(ChargeBand.A, result.ChargeBand);
}
}
public async Task FetchOrganisationAsync_WithInvalidOrganisationId_ThrowsException()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
// Arrange
Guid organisationId = new Guid("5EC74E27-8D5C-4D4D-8A49-20BBD5E9611E");
OrganisationDetailsDataAccess dataAccess = new OrganisationDetailsDataAccess(database.WeeeContext);
// Act
Func<Task<Domain.Organisation.Organisation>> action = async () => await dataAccess.FetchOrganisationAsync(organisationId);
// Assert
await Assert.ThrowsAsync<Exception>(action);
}
}
public void GetSchemeApprovalNumberByOrganisationId_OrganisationIdDoesNotExist_ReturnsNull()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
// Arrange
var organisationId = Guid.NewGuid();
SchemeQuerySet schemeQuerySet = new SchemeQuerySet(database.WeeeContext);
// Act
string result = schemeQuerySet.GetSchemeApprovalNumberByOrganisationId(organisationId);
// Assert
Assert.Null(result);
}
}
public async Task FetchCountryAsync_WithValidCountryId_ReturnsCountry()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
// Arrange
Guid countryId = new Guid("184E1785-26B4-4AE4-80D3-AE319B103ACB"); // ID for UK - England
OrganisationDetailsDataAccess dataAccess = new OrganisationDetailsDataAccess(database.WeeeContext);
// Act
Domain.Country result = await dataAccess.FetchCountryAsync(countryId);
// Assert
Assert.NotNull(result);
Assert.Equal(countryId, result.Id);
Assert.Equal(result.Name, "UK - England");
}
}
public void FetchSumOfExistingCharges_WithUnknownProducer_ReturnsZero()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
ModelHelper helper = new ModelHelper(database.Model);
Scheme scheme = helper.CreateScheme();
database.Model.SaveChanges();
// Arrange
ProducerChargeCalculatorDataAccess dataAccess = new ProducerChargeCalculatorDataAccess(database.WeeeContext);
// Act
decimal result = dataAccess.FetchSumOfExistingCharges(scheme.ApprovalNumber, "XXXXXXX", 2016);
// Assert
Assert.Equal(0, result);
}
}
public void GetSchemeApprovalNumberByOrganisationId_OrganisationIdDoesExist_ReturnsApprovalNumber()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
ModelHelper helper = new ModelHelper(database.Model);
// Arrange
Scheme scheme = helper.CreateScheme();
scheme.ApprovalNumber = "ABC";
database.Model.SaveChanges();
SchemeQuerySet schemeQuerySet = new SchemeQuerySet(database.WeeeContext);
// Act
string result = schemeQuerySet.GetSchemeApprovalNumberByOrganisationId(scheme.OrganisationId);
// Assert
Assert.Equal("ABC", result);
}
}
public async Task InsertNonRemovedRegisteredProducer_WithExistingRemovedProducer_DoesntThrowAnException()
{
using (DatabaseWrapper wrapper = new DatabaseWrapper())
{
// Arrange
ModelHelper helper = new ModelHelper(wrapper.Model);
Scheme scheme = helper.CreateScheme();
RegisteredProducer registeredProducer1 = new RegisteredProducer()
{
Id = new Guid("834635D7-876D-47BD-B3E3-570E481B2C15"),
Scheme = scheme,
ComplianceYear = 2099,
ProducerRegistrationNumber = "WEE/HD6483TF",
Removed = true,
};
wrapper.Model.RegisteredProducers.Add(registeredProducer1);
await wrapper.Model.SaveChangesAsync();
// Act
RegisteredProducer registeredProducer2 = new RegisteredProducer()
{
Id = new Guid("65C1B132-2573-409C-B18E-E7C3AEC777AF"),
Scheme = scheme,
ComplianceYear = 2099,
ProducerRegistrationNumber = "WEE/HD6483TF",
Removed = false,
};
wrapper.Model.RegisteredProducers.Add(registeredProducer2);
await wrapper.Model.SaveChangesAsync();
// Assert
// No exception
}
}
public async void FetchSchemeByOrganisationId_WitValidOrganisationId_ReturnsScheme()
{
using (var database = new DatabaseWrapper())
{
Guid organisationId = new Guid("72BB14DF-DCD5-4DBB-BBA9-4CFC26AD80F9");
GetSchemePublicInfoDataAccess dataAccess = new GetSchemePublicInfoDataAccess(database.WeeeContext);
// Arrange
ModelHelper modelHelper = new ModelHelper(database.Model);
var scheme1 = modelHelper.CreateScheme();
scheme1.Organisation.Id = organisationId;
database.Model.SaveChanges();
// Act
var result = await dataAccess.FetchSchemeByOrganisationId(organisationId);
// Assert
Assert.NotNull(result);
Assert.Equal(organisationId, result.OrganisationId);
}
}
public async void Fetch_TwoUploadsForTheSameComplianceYear_OnlyReturnsTheYearOnce()
{
using (var database = new DatabaseWrapper())
{
const int complianceYear = 2005;
// Arrange
var modelHelper = new ModelHelper(database.Model);
var organisation = modelHelper.CreateOrganisation();
await database.Model.SaveChangesAsync();
var scheme = modelHelper.CreateScheme(organisation);
await database.Model.SaveChangesAsync();
var firstDataReturn = modelHelper.CreateDataReturn(scheme, complianceYear, (int)QuarterType.Q1);
await database.Model.SaveChangesAsync();
var firstDataReturnVersion = modelHelper.CreateDataReturnVersion(scheme, complianceYear, (int)QuarterType.Q1, true, firstDataReturn);
modelHelper.CreateDataReturnUpload(scheme, firstDataReturnVersion);
await database.Model.SaveChangesAsync();
var secondDataReturn = modelHelper.CreateDataReturn(scheme, complianceYear, (int)QuarterType.Q2);
await database.Model.SaveChangesAsync();
var secondDataReturnVersion = modelHelper.CreateDataReturnVersion(scheme, complianceYear, (int)QuarterType.Q2, true, secondDataReturn);
modelHelper.CreateDataReturnUpload(scheme, secondDataReturnVersion);
await database.Model.SaveChangesAsync();
// Act
var dataAccess = new FetchDataReturnComplianceYearsForSchemeDataAccess(database.WeeeContext);
var result = await dataAccess.GetDataReturnComplianceYearsForScheme(scheme.Id);
// Assert
Assert.Single(result.Where(y => y == complianceYear));
}
}
public void GetMigratedProducer_PrnExists_ReturnsMigratedProducer()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
// Arrange
MigratedProducer_ migratedProducer1 = new MigratedProducer_();
migratedProducer1.Id = new Guid("B1750CCE-77D9-4A11-9ACC-D29D692FAA52");
migratedProducer1.ProducerRegistrationNumber = "ABC";
migratedProducer1.ProducerName = "Test Producer 1";
database.Model.MigratedProducer_Set.Add(migratedProducer1);
database.Model.SaveChanges();
MigratedProducerQuerySet querySet = new MigratedProducerQuerySet(database.WeeeContext);
// Act
EA.Weee.Domain.Producer.MigratedProducer result = querySet.GetMigratedProducer("ABC");
// Assert
Assert.NotNull(result);
Assert.Equal(new Guid("B1750CCE-77D9-4A11-9ACC-D29D692FAA52"), result.Id);
Assert.Equal("Test Producer 1", result.ProducerName);
}
}
public async Task FetchOrganisationAsync_WithValidOrganisationId_ReturnsOrganisation()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
// Arrange
Guid organisationId = new Guid("C826DCE8-78EB-4BE4-B419-4DE73D1AD181");
Organisation organisation = new Organisation()
{
Id = organisationId
};
database.Model.Organisations.Add(organisation);
database.Model.SaveChanges();
OrganisationDetailsDataAccess dataAccess = new OrganisationDetailsDataAccess(database.WeeeContext);
// Act
Domain.Organisation.Organisation result = await dataAccess.FetchOrganisationAsync(organisationId);
// Assert
Assert.NotNull(result);
Assert.Equal(organisationId, result.Id);
}
}
public async Task FetchSchemeByOrganisationIdAsync_GetsSchemeForMatchingOrganisationId()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
// Arrange
ModelHelper helper = new ModelHelper(database.Model);
var organisation1 = helper.CreateOrganisation();
helper.CreateScheme(organisation1);
var organisation2 = helper.CreateOrganisation();
var scheme2 = helper.CreateScheme(organisation2);
database.Model.SaveChanges();
var dataAccess = new FetchDataReturnComplianceYearsForSchemeDataAccess(database.WeeeContext);
// Act
var result = await dataAccess.FetchSchemeByOrganisationIdAsync(organisation2.Id);
// Assert
Assert.Equal(scheme2.Id, result.Id);
}
}
public void GetAllRegistrationNumbers_ReturnsDistinctRegistrationNumbers()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
ModelHelper helper = new ModelHelper(database.Model);
// Arrange
Scheme scheme = helper.CreateScheme();
MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme);
memberUpload1.ComplianceYear = 2015;
memberUpload1.IsSubmitted = false;
Weee.Tests.Core.Model.ProducerSubmission producer1 = helper.CreateProducerAsCompany(memberUpload1, "AAAAAAA");
MemberUpload memberUpload2 = helper.CreateMemberUpload(scheme);
memberUpload2.ComplianceYear = 2015;
memberUpload2.IsSubmitted = true;
Weee.Tests.Core.Model.ProducerSubmission producer2 = helper.CreateProducerAsCompany(memberUpload2, "AAAAAAA");
database.Model.SaveChanges();
ProducerQuerySet querySet = ProducerQuerySet(database.WeeeContext);
// Act
List<string> results = querySet.GetAllRegistrationNumbers();
// Assert
Assert.NotNull(results);
Assert.Equal(1, results.Count(r => r == "AAAAAAA"));
}
}
public async Task FetchCountryAsync_WithInvalidCountryId_ThrowsException()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
// Arrange
Guid countryId = new Guid("5840BF0B-0CAF-4AF9-9881-F22DB7720F98");
OrganisationDetailsDataAccess dataAccess = new OrganisationDetailsDataAccess(database.WeeeContext);
// Act
Func<Task<Domain.Country>> action = async () => await dataAccess.FetchCountryAsync(countryId);
// Assert
await Assert.ThrowsAsync<Exception>(action);
}
}
public void GetProducerForOtherSchemeAndObligationType_ForAnotherSchemeSameObligationType_ReturnsAnotherSchemeProducer()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
ModelHelper helper = new ModelHelper(database.Model);
// Arrange
Scheme scheme1 = helper.CreateScheme();
Scheme scheme2 = helper.CreateScheme();
MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme2);
memberUpload1.ComplianceYear = 2015;
memberUpload1.IsSubmitted = true;
Weee.Tests.Core.Model.ProducerSubmission producer1 = helper.CreateProducerAsCompany(memberUpload1, "AAAAAAA");
producer1.ObligationType = "B2C";
database.Model.SaveChanges();
ProducerQuerySet querySet = ProducerQuerySet(database.WeeeContext);
// Act
var result = querySet.GetProducerForOtherSchemeAndObligationType("AAAAAAA", "2015", scheme1.OrganisationId, ObligationType.B2C);
// Assert
Assert.NotNull(result);
Assert.Equal(producer1.Id, result.Id);
}
}
public void GetLatestCompanyProducers_ReturnsCompaniesOnly()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
ModelHelper helper = new ModelHelper(database.Model);
// Arrange
Scheme scheme1 = helper.CreateScheme();
MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme1);
memberUpload1.ComplianceYear = 2015;
memberUpload1.IsSubmitted = true;
Weee.Tests.Core.Model.ProducerSubmission companyProducer1 = helper.CreateProducerAsCompany(memberUpload1, "AAAAAAA");
Weee.Tests.Core.Model.ProducerSubmission partnershipProducer = helper.CreateProducerAsPartnership(memberUpload1, "PPP1");
Weee.Tests.Core.Model.ProducerSubmission soleTraderProducer = helper.CreateProducerAsSoleTrader(memberUpload1, "SSS1");
Weee.Tests.Core.Model.ProducerSubmission companyProducer2 = helper.CreateProducerAsCompany(memberUpload1, "AAAAAAB");
database.Model.SaveChanges();
// Act
var result = ProducerQuerySet(database.WeeeContext).GetLatestCompanyProducers();
// Assert
Assert.Contains(result, p => p.Id == companyProducer1.Id);
Assert.Contains(result, p => p.Id == companyProducer2.Id);
Assert.DoesNotContain(result, p => p.Id == soleTraderProducer.Id);
Assert.DoesNotContain(result, p => p.Id == partnershipProducer.Id);
}
}
public async Task FetchSchemeAsync_ReturnsNull_WhenNoSchemeWithSpecifiedOrganisationId()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
// Arrange
var modelHelper = new ModelHelper(database.Model);
var organisationId = new Guid("C826DCE8-78EB-4BE4-B419-4DE73D1AD181");
database.Model.SaveChanges();
OrganisationDetailsDataAccess dataAccess = new OrganisationDetailsDataAccess(database.WeeeContext);
// Act
Domain.Scheme.Scheme result = await dataAccess.FetchSchemeAsync(organisationId);
// Assert
Assert.Null(result);
}
}
public void GetLatestCompanyProducers_ReturnsCurrentForComplianceYearCompaniesOnly()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
ModelHelper helper = new ModelHelper(database.Model);
// Arrange
Scheme scheme1 = helper.CreateScheme();
MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme1);
memberUpload1.ComplianceYear = 2015;
memberUpload1.IsSubmitted = true;
ProducerSubmission companyProducer1 = helper.CreateProducerAsCompany(memberUpload1, "AA");
ProducerSubmission companyProducer2 = helper.CreateProducerAsCompany(memberUpload1, "BB");
ProducerSubmission companyProducer3 = helper.CreateProducerAsCompany(memberUpload1, "AA");
database.Model.SaveChanges();
// Act
var result = ProducerQuerySet(database.WeeeContext).GetLatestCompanyProducers();
// Assert
Assert.DoesNotContain(result, p => p.Id == companyProducer1.Id);
Assert.Contains(result, p => p.Id == companyProducer2.Id);
Assert.Contains(result, p => p.Id == companyProducer3.Id);
}
}
public void FetchSumOfExistingCharges_WithSameProducerWithDifferentSchemesInSameYear_ReturnsChargesPerScheme()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
// Arrange
ModelHelper helper = new ModelHelper(database.Model);
Scheme scheme1 = helper.CreateScheme();
scheme1.ApprovalNumber = "FirstScheme";
MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme1);
memberUpload1.ComplianceYear = 2016;
memberUpload1.IsSubmitted = true;
ProducerSubmission producer1 = helper.CreateProducerAsCompany(memberUpload1, "AAAAA");
producer1.ChargeThisUpdate = 1;
Scheme scheme2 = helper.CreateScheme();
scheme2.ApprovalNumber = "SecondScheme";
MemberUpload memberUpload2 = helper.CreateMemberUpload(scheme2);
memberUpload2.ComplianceYear = 2016;
memberUpload2.IsSubmitted = true;
ProducerSubmission producer2 = helper.CreateProducerAsCompany(memberUpload2, "AAAAA");
producer2.ChargeThisUpdate = 2;
database.Model.SaveChanges();
ProducerChargeCalculatorDataAccess dataAccess = new ProducerChargeCalculatorDataAccess(database.WeeeContext);
// Act
decimal producer1Charge = dataAccess.FetchSumOfExistingCharges("FirstScheme", "AAAAA", 2016);
decimal producer2Charge = dataAccess.FetchSumOfExistingCharges("SecondScheme", "AAAAA", 2016);
// Assert
Assert.Equal(1, producer1Charge);
Assert.Equal(2, producer2Charge);
}
}
public void FetchSumOfExistingCharges_WithProducerWithSeveralCharges_ReturnsSumOfChargeAmounts()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
// Arrange
ModelHelper helper = new ModelHelper(database.Model);
Scheme scheme = helper.CreateScheme();
MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme);
memberUpload1.ComplianceYear = 2016;
memberUpload1.IsSubmitted = true;
ProducerSubmission producer1 = helper.CreateProducerAsCompany(memberUpload1, "AAAAA");
producer1.ChargeThisUpdate = 1;
MemberUpload memberUpload2 = helper.CreateMemberUpload(scheme);
memberUpload2.ComplianceYear = 2016;
memberUpload2.IsSubmitted = true;
ProducerSubmission producer2 = helper.CreateProducerAsCompany(memberUpload2, "AAAAA");
producer2.ChargeThisUpdate = 2;
MemberUpload memberUpload3 = helper.CreateMemberUpload(scheme);
memberUpload3.ComplianceYear = 2016;
memberUpload3.IsSubmitted = true;
ProducerSubmission producer3 = helper.CreateProducerAsCompany(memberUpload3, "AAAAA");
producer3.ChargeThisUpdate = 3;
database.Model.SaveChanges();
ProducerChargeCalculatorDataAccess dataAccess = new ProducerChargeCalculatorDataAccess(database.WeeeContext);
// Act
decimal result = dataAccess.FetchSumOfExistingCharges(scheme.ApprovalNumber, "AAAAA", 2016);
// Assert
Assert.Equal(6, result);
}
}
public async Task FetchCompleteOrganisations_WithCompleteCompany_UsesNameColumnToPopulateOrganisationName()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
// Arrange
Organisation organisation = new Organisation();
organisation.Id = new Guid("6BD77BBD-0BD8-4BAB-AA9F-A3E657D1CBB4");
organisation.Name = "Company Name";
organisation.OrganisationType = EA.Weee.Domain.Organisation.OrganisationType.RegisteredCompany.Value;
organisation.OrganisationStatus = EA.Weee.Domain.Organisation.OrganisationStatus.Complete.Value;
Scheme scheme = new Scheme();
scheme.Id = new Guid("CFD9B56F-6C3C-4E49-825C-A125ACFFEC3B");
scheme.Organisation = organisation;
scheme.SchemeStatus = (int)Core.Shared.SchemeStatus.Approved;
database.Model.Organisations.Add(organisation);
database.Model.Schemes.Add(scheme);
database.Model.SaveChanges();
var dataAccess = new FetchOrganisationSearchResultsForCacheDataAccess(database.WeeeContext);
// Act
IList<OrganisationSearchResult> results = await dataAccess.FetchCompleteOrganisations();
// Assert
Assert.Contains(results,
r => r.OrganisationId == new Guid("6BD77BBD-0BD8-4BAB-AA9F-A3E657D1CBB4") && r.Name == "Company Name");
}
}
public async Task FetchCompleteOrganisations_WithSeveralResults_ReturnsResultsOrderedByName()
{
using (DatabaseWrapper database = new DatabaseWrapper())
{
// Arrange
Organisation organisation1 = new Organisation();
organisation1.Id = new Guid("6BD77BBD-0BD8-4BAB-AA9F-A3E657D1CBB4");
organisation1.Name = "Company B";
organisation1.OrganisationType = EA.Weee.Domain.Organisation.OrganisationType.RegisteredCompany.Value;
organisation1.OrganisationStatus = EA.Weee.Domain.Organisation.OrganisationStatus.Complete.Value;
Scheme scheme1 = new Scheme();
scheme1.Id = new Guid("CFD9B56F-6C3C-4E49-825C-A125ACFFEC3B");
scheme1.Organisation = organisation1;
scheme1.SchemeStatus = (int)Core.Shared.SchemeStatus.Approved;
Organisation organisation2 = new Organisation();
organisation2.Id = new Guid("659A5E1B-90F8-4E5C-8939-436189424AB6");
organisation2.Name = "Company A";
organisation2.OrganisationType = EA.Weee.Domain.Organisation.OrganisationType.RegisteredCompany.Value;
organisation2.OrganisationStatus = EA.Weee.Domain.Organisation.OrganisationStatus.Complete.Value;
Scheme scheme2 = new Scheme();
scheme2.Id = new Guid("0F0CCEEF-849B-474A-A548-C52F99FD0C99");
scheme2.Organisation = organisation2;
scheme2.SchemeStatus = (int)Core.Shared.SchemeStatus.Approved;
Organisation organisation3 = new Organisation();
organisation3.Id = new Guid("D7C37279-C3F5-44C0-B6CF-D43A968F3F29");
organisation3.Name = "Company C";
organisation3.OrganisationType = EA.Weee.Domain.Organisation.OrganisationType.RegisteredCompany.Value;
organisation3.OrganisationStatus = EA.Weee.Domain.Organisation.OrganisationStatus.Complete.Value;
Scheme scheme3 = new Scheme();
scheme3.Id = new Guid("52DA530C-B09C-4C52-B354-F07E72EE6111");
scheme3.Organisation = organisation3;
scheme3.SchemeStatus = (int)Core.Shared.SchemeStatus.Approved;
database.Model.Organisations.Add(organisation1);
database.Model.Organisations.Add(organisation2);
database.Model.Organisations.Add(organisation3);
database.Model.Schemes.Add(scheme1);
database.Model.Schemes.Add(scheme2);
database.Model.Schemes.Add(scheme3);
database.Model.SaveChanges();
var dataAccess = new FetchOrganisationSearchResultsForCacheDataAccess(database.WeeeContext);
// Act
IList<OrganisationSearchResult> results = await dataAccess.FetchCompleteOrganisations();
// Assert
int indexOfCompanyA = results.IndexOf(results.First(r => r.OrganisationId == new Guid("659A5E1B-90F8-4E5C-8939-436189424AB6")));
int indexOfCompanyB = results.IndexOf(results.First(r => r.OrganisationId == new Guid("6BD77BBD-0BD8-4BAB-AA9F-A3E657D1CBB4")));
int indexOfCompanyC = results.IndexOf(results.First(r => r.OrganisationId == new Guid("D7C37279-C3F5-44C0-B6CF-D43A968F3F29")));
Assert.True(indexOfCompanyA < indexOfCompanyB, "Organisation search results must be returned ordered by organisation name.");
Assert.True(indexOfCompanyB < indexOfCompanyC, "Organisation search results must be returned ordered by organisation name.");
}
}
