public async Task CanCreateReturnReportOnEntry()
{
using (var database = new DatabaseWrapper())
{
var context = database.WeeeContext;
var dataAccess = new GenericDataAccess(context);
var organisation = ObligatedWeeeIntegrationCommon.CreateOrganisation();
var @return = await CreateReturn(context, database, organisation);
var questions = context.ReportOnQuestions.ToList();
var returnReportOn = new List <ReturnReportOn>();
foreach (var question in questions)
{
returnReportOn.Add(new ReturnReportOn(@return.Id, question.Id));
}
await dataAccess.AddMany <ReturnReportOn>(returnReportOn);
var result = context.ReturnReportOns.Where(r => r.ReturnId == @return.Id).ToList();
result.Count.Should().Be(questions.Count);
foreach (var question in questions)
{
result.Where(r => r.ReportOnQuestionId == question.Id).ToList().Count.Should().Be(1);
}
}
}
private async Task <Guid> CreateWeeeReceivedAmounts(ObligatedReceivedDataAccess dataAccess, DatabaseWrapper database)
{
var organisation = ObligatedWeeeIntegrationCommon.CreateOrganisation();
var scheme = ObligatedWeeeIntegrationCommon.CreateScheme(organisation);
var aatf = ObligatedWeeeIntegrationCommon.CreateAatf(database, organisation);
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);
await database.WeeeContext.SaveChangesAsync();
var weeeReceived = new WeeeReceived(scheme, aatf, @return);
var weeeReceivedAmount = new List <WeeeReceivedAmount>();
foreach (var category in Enum.GetValues(typeof(WeeeCategory)).Cast <WeeeCategory>())
{
weeeReceivedAmount.Add(new WeeeReceivedAmount(weeeReceived, (int)category, (int)category, (int)category + 1));
}
await dataAccess.Submit(weeeReceivedAmount);
return(@return.Id);
}
private async Task <Tuple <Guid, Guid> > CreateWeeeReusedSite(AatfSiteDataAccess dataAccess, AatfAddress aatfAddress, DatabaseWrapper database)
{
var organisation = ObligatedWeeeIntegrationCommon.CreateOrganisation();
var scheme = ObligatedWeeeIntegrationCommon.CreateScheme(organisation);
var aatf = ObligatedWeeeIntegrationCommon.CreateAatf(database, organisation);
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);
await database.WeeeContext.SaveChangesAsync();
var weeeReused = new WeeeReused(aatf.Id, @return.Id);
database.WeeeContext.WeeeReused.Add(weeeReused);
foreach (var category in Enum.GetValues(typeof(WeeeCategory)).Cast <WeeeCategory>())
{
database.WeeeContext.WeeeReusedAmount.Add(new WeeeReusedAmount(weeeReused, (int)category, (int)category, (int)category + 1));
}
await database.WeeeContext.SaveChangesAsync();
var weeeReusedSite = new WeeeReusedSite(weeeReused, aatfAddress);
await dataAccess.Submit(weeeReusedSite);
return(Tuple.Create(@return.Id, aatf.Id));
}
public async Task Add_EntityShouldBeAdded()
{
using (var database = new DatabaseWrapper())
{
var dataAccess = new GenericDataAccess(database.WeeeContext);
var organisation = ObligatedWeeeIntegrationCommon.CreateOrganisation();
var aatf = ObligatedWeeeIntegrationCommon.CreateAatf(database, organisation);
var result = await dataAccess.Add <Aatf>(aatf);
result.Should().NotBeEmpty();
}
}
private async Task <Guid> CreateContact(DatabaseWrapper database, AatfContact aatfAddress)
{
var organisation = ObligatedWeeeIntegrationCommon.CreateOrganisation();
var scheme = ObligatedWeeeIntegrationCommon.CreateScheme(organisation);
var aatf = ObligatedWeeeIntegrationCommon.CreateAatf(database, organisation);
database.WeeeContext.Organisations.Add(organisation);
database.WeeeContext.Schemes.Add(scheme);
database.WeeeContext.AatfContacts.Add(aatfAddress);
database.WeeeContext.Aatfs.Add(aatf);
await database.WeeeContext.SaveChangesAsync();
return(aatf.Id);
}
private async Task <WeeeSentOn> CreateWeeeSentOnOperatorInContext(WeeeSentOnDataAccess dataAccess, AatfAddress operatorAddress, AatfAddress siteAddress, DatabaseWrapper database)
{
var organisation = ObligatedWeeeIntegrationCommon.CreateOrganisation();
var scheme = ObligatedWeeeIntegrationCommon.CreateScheme(organisation);
var aatf = ObligatedWeeeIntegrationCommon.CreateAatf(database, organisation);
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);
await database.WeeeContext.SaveChangesAsync();
var weeeSentOn = new WeeeSentOn(operatorAddress, siteAddress, aatf, @return);
await dataAccess.Submit(weeeSentOn);
return(weeeSentOn);
}
public async Task Add_EntityShouldBeAdded()
{
using (var database = new DatabaseWrapper())
{
int originalSchemesCount = database.WeeeContext.Schemes.Count();
UpdateSchemeInformationDataAccess dataAccess = new UpdateSchemeInformationDataAccess(database.WeeeContext);
Organisation organisation = ObligatedWeeeIntegrationCommon.CreateOrganisation();
Scheme scheme = ObligatedWeeeIntegrationCommon.CreateScheme(organisation);
dataAccess.AddScheme(scheme);
await dataAccess.SaveAsync();
database.WeeeContext.Schemes.Where(p => Equals(scheme)).Should().NotBeNull();
int newSchemesCount = database.WeeeContext.Schemes.Count();
(newSchemesCount - originalSchemesCount).Should().Be(1);
}
}
public async Task DeselectedOptionAndDataIsDeleted()
{
using (var database = new DatabaseWrapper())
{
var context = database.WeeeContext;
var dataAccess = new GenericDataAccess(context);
var organisation = ObligatedWeeeIntegrationCommon.CreateOrganisation();
var @return = await CreateReturn(context, database, organisation);
var country = await context.Countries.SingleAsync(c => c.Name == "France");
var questions = context.ReportOnQuestions.ToList();
var returnReportOn = new List <ReturnReportOn>();
foreach (var question in questions)
{
returnReportOn.Add(new ReturnReportOn(@return.Id, question.Id));
}
var aatf = await CreateAatf(database, @return);
var scheme = await CreateScheme(context, organisation);
var sentOnSiteAddress = await CreateAddress(database);
var sentOnSOperatorAddress = await CreateAddress(database);
var reusedSiteAddress = await CreateAddress(database);
await dataAccess.AddMany <ReturnReportOn>(returnReportOn);
await CreateWeeeReusedAmounts(new ObligatedReusedDataAccess(context), new AatfSiteDataAccess(context, dataAccess), @return, aatf, reusedSiteAddress);
await CreateWeeeReceivedAmounts(new ObligatedReceivedDataAccess(context), new ReturnSchemeDataAccess(context), @return, aatf, scheme);
await CreateWeeeSentOnAmounts(new ObligatedSentOnDataAccess(context), @return, aatf, sentOnSiteAddress, sentOnSOperatorAddress);
await CreateNonObligatedWeee(new NonObligatedDataAccess(context), @return);
var submittedReturnOptions = context.ReturnReportOns.Where(r => r.ReturnId == @return.Id).ToList();
var(submittedWeeeReused, submittedWeeeReusedAddresses, submittedWeeeReusedAmounts, submittedWeeeReusedSites) = await RetrieveSubmittedWeeeReusedData(context, @return, dataAccess);
var(submittedWeeeReceived, submittedWeeeReturnScheme, submittedWeeeReceivedAmounts) = await RetrieveSubmittedWeeeReceivedData(context, @return, dataAccess);
var(submittedWeeeSentOn, submittedWeeeSentOnAddresses, submittedWeeeSentOnAmounts) = await RetrieveSubmittedWeeeSentOnData(context, @return, dataAccess);
var submittedNonObligatedWeee = context.NonObligatedWeee.Where(w => w.ReturnId == @return.Id).ToList();
var handler = new AddReturnReportOnHandler(A.Fake <IWeeeAuthorization>(), dataAccess, context);
var deselectOptions = new List <int>()
{
1, 2, 3, 4, 5
};
var coreReportOnQuestions = CreateReportQuestions();
var request = new AddReturnReportOn()
{
DeselectedOptions = deselectOptions, Options = coreReportOnQuestions, ReturnId = @return.Id, SelectedOptions = new List <int>()
};
await handler.HandleAsync(request);
AssertWeeeReceivedDeletion(context, submittedWeeeReceived, submittedWeeeReturnScheme, submittedWeeeReceivedAmounts);
AssertWeeeReusedDeletion(context, submittedWeeeReused, submittedWeeeReusedAddresses, submittedWeeeReusedAmounts, submittedWeeeReusedSites);
AssertWeeeSentOnDeletion(context, submittedWeeeSentOn, submittedWeeeSentOnAddresses, submittedWeeeSentOnAmounts);
AssertNonObligatedWeeeDeletion(context, submittedNonObligatedWeee);
}
}
