public async Task Execute_WithOneCurrentProducerAsCompany_ReturnsCompanyName()
{
using (DatabaseWrapper db = new DatabaseWrapper())
{
// Arrange
ModelHelper helper = new ModelHelper(db.Model);
Scheme scheme1 = helper.CreateScheme();
MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme1);
memberUpload1.ComplianceYear = 2016;
memberUpload1.IsSubmitted = true;
memberUpload1.SubmittedDate = new DateTime(2015, 1, 1);
ProducerSubmission producer1 = helper.CreateProducerAsCompany(memberUpload1, "WEE/11AAAA11");
db.Model.SaveChanges();
// Act
List <ProducerCsvData> results =
await db.StoredProcedures.SpgCSVDataByOrganisationIdAndComplianceYear(scheme1.OrganisationId, 2016);
// Assert
Assert.NotNull(results);
Assert.Equal(1, results.Count);
ProducerCsvData result = results[0];
Assert.Equal(producer1.Business.Company.Name, result.OrganisationName);
}
}
public async Task Execute_WithSeveralVersionsOfOneCurrentProducer_ReturnsLatestDataWithFirstRegistrationDate()
{
using (DatabaseWrapper db = new DatabaseWrapper())
{
// Arrange
ModelHelper helper = new ModelHelper(db.Model);
Scheme scheme1 = helper.CreateScheme();
MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme1);
memberUpload1.ComplianceYear = 2016;
memberUpload1.IsSubmitted = true;
memberUpload1.SubmittedDate = new DateTime(2015, 1, 1);
ProducerSubmission producer1 = helper.CreateProducerAsPartnership(memberUpload1, "WEE/11AAAA11");
MemberUpload memberUpload2 = helper.CreateMemberUpload(scheme1);
memberUpload2.ComplianceYear = 2016;
memberUpload2.IsSubmitted = true;
memberUpload2.SubmittedDate = new DateTime(2015, 1, 2);
ProducerSubmission producer2 = helper.CreateProducerAsPartnership(memberUpload2, "WEE/11AAAA11");
MemberUpload memberUpload3 = helper.CreateMemberUpload(scheme1);
memberUpload3.ComplianceYear = 2016;
memberUpload3.IsSubmitted = true;
memberUpload3.SubmittedDate = new DateTime(2015, 1, 3);
ProducerSubmission producer3 = helper.CreateProducerAsPartnership(memberUpload3, "WEE/11AAAA11");
db.Model.SaveChanges();
// Act
List <ProducerCsvData> results =
await db.StoredProcedures.SpgCSVDataByOrganisationIdAndComplianceYear(scheme1.OrganisationId, 2016);
// Assert
Assert.NotNull(results);
Assert.Equal(1, results.Count);
ProducerCsvData result = results[0];
Assert.Equal("WEE/11AAAA11", result.RegistrationNumber);
Assert.Equal(new DateTime(2015, 1, 1), result.DateRegistered);
Assert.Equal(new DateTime(2015, 1, 3), result.DateAmended);
}
}
public async Task Execute_WithAuthorisedRepresentative_ReturnsOverseasProducer()
{
using (DatabaseWrapper db = new DatabaseWrapper())
{
// Arrange
ModelHelper helper = new ModelHelper(db.Model);
Scheme scheme1 = helper.CreateScheme();
MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme1);
memberUpload1.ComplianceYear = 2016;
memberUpload1.IsSubmitted = true;
memberUpload1.SubmittedDate = new DateTime(2015, 1, 1);
ProducerSubmission producer1 = helper.CreateProducerAsCompany(memberUpload1, "WEE/11AAAA11");
AuthorisedRepresentative authorisedRepresentative = new AuthorisedRepresentative()
{
Id = new Guid("620E71A6-0E74-47AF-B82F-97BA64083E37"),
OverseasProducerName = "Overseas Producer Name",
};
db.Model.AuthorisedRepresentatives.Add(authorisedRepresentative);
producer1.AuthorisedRepresentative = authorisedRepresentative;
db.Model.SaveChanges();
// Act
List <ProducerCsvData> results =
await db.StoredProcedures.SpgCSVDataByOrganisationIdAndComplianceYear(scheme1.OrganisationId, 2016);
// Assert
Assert.NotNull(results);
Assert.Equal(1, results.Count);
ProducerCsvData result = results[0];
Assert.Equal("No", result.AuthorisedRepresentative);
Assert.Equal("Overseas Producer Name", result.OverseasProducer);
}
}
public async Task Execute_WithOneCurrentProducer_ReturnsFullSetOfData()
{
using (DatabaseWrapper db = new DatabaseWrapper())
{
// Arrange
ModelHelper helper = new ModelHelper(db.Model);
Scheme scheme1 = helper.CreateScheme();
MemberUpload memberUpload1 = helper.CreateMemberUpload(scheme1);
memberUpload1.ComplianceYear = 2016;
memberUpload1.IsSubmitted = true;
memberUpload1.SubmittedDate = new DateTime(2015, 1, 1);
ProducerSubmission producer1 = helper.CreateProducerAsCompany(memberUpload1, "WEE/11AAAA11");
producer1.ChargeBandAmount = helper.FetchChargeBandAmount(ChargeBand.C);
db.Model.SaveChanges();
// Act
List <ProducerCsvData> results =
await db.StoredProcedures.SpgCSVDataByOrganisationIdAndComplianceYear(scheme1.OrganisationId, 2016);
// Assert
Assert.NotNull(results);
Assert.Equal(1, results.Count);
ProducerCsvData result = results[0];
Assert.Equal(producer1.Business.Company.Name, result.OrganisationName);
Assert.Equal(producer1.TradingName, result.TradingName);
Assert.Equal("WEE/11AAAA11", result.RegistrationNumber);
Assert.Equal(producer1.Business.Company.CompanyNumber, result.CompanyNumber);
Assert.Equal("C", result.ChargeBand);
Assert.Equal(new DateTime(2015, 1, 1), result.DateRegistered);
Assert.Equal(new DateTime(2015, 1, 1), result.DateAmended);
Assert.Equal("No", result.AuthorisedRepresentative);
Assert.Equal(string.Empty, result.OverseasProducer);
}
}
