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 Task FetchLatestProducers_WithThreeProducers_ReturnsProducersOrderedByRegistrationNumber()
{
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");
Model.MemberUpload memberUpload2 = helper.CreateMemberUpload(scheme);
memberUpload2.ComplianceYear = 2015;
memberUpload2.IsSubmitted = true;
Model.ProducerSubmission producer2 = helper.CreateProducerAsCompany(memberUpload2, "CCCCC");
Model.MemberUpload memberUpload3 = helper.CreateMemberUpload(scheme);
memberUpload3.ComplianceYear = 2015;
memberUpload3.IsSubmitted = true;
Model.ProducerSubmission producer3 = helper.CreateProducerAsCompany(memberUpload3, "BBBBB");
database.Model.SaveChanges();
// Act
FetchProducerSearchResultsForCacheDataAccess dataAccess = new FetchProducerSearchResultsForCacheDataAccess(database.WeeeContext);
var results = await dataAccess.FetchLatestProducers();
// Assert
Assert.NotNull(results);
var result1 = results.SingleOrDefault(r => r.RegistrationNumber == "AAAAA");
var result2 = results.SingleOrDefault(r => r.RegistrationNumber == "BBBBB");
var result3 = results.SingleOrDefault(r => r.RegistrationNumber == "CCCCC");
Assert.NotNull(result1);
Assert.NotNull(result2);
Assert.NotNull(result3);
int result1index = results.IndexOf(result1);
int result2index = results.IndexOf(result2);
int result3index = results.IndexOf(result3);
Assert.True(result1index < result2index);
Assert.True(result2index < result3index);
}
}