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 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 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 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);
}
}
