public void InvalidPaymentTypeRaisesException()
{
var formatter = new PaymentLineFormatter() as IPaymentLineFormatter;
Action act = () => formatter.GetAdditionalPaymentType(1);
act.Should().Throw <ApplicationException>().Where(e => e.Message.Equals("Unexpected TransactionType [1]"));
}
public void GroupingByPaymentType()
{
var payments = new List <Payment>
{
new Payment {
LearnerReferenceNumber = "ABC", TransactionType = 4, LearningStartDate = new DateTime(2020, 01, 01), LearningAimProgrammeType = 1, LearningAimStandardCode = 2, LearningAimFrameworkCode = 3, LearningAimPathwayCode = 10
},
new Payment {
LearnerReferenceNumber = "ABC", TransactionType = 5, LearningStartDate = new DateTime(2020, 01, 01), LearningAimProgrammeType = 1, LearningAimStandardCode = 2, LearningAimFrameworkCode = 3, LearningAimPathwayCode = 11
},
new Payment {
LearnerReferenceNumber = "ABC", TransactionType = 6, LearningStartDate = new DateTime(2020, 01, 01), LearningAimProgrammeType = 1, LearningAimStandardCode = 2, LearningAimFrameworkCode = 3, LearningAimPathwayCode = 12
},
new Payment {
LearnerReferenceNumber = "ABC", TransactionType = 7, LearningStartDate = new DateTime(2020, 01, 01), LearningAimProgrammeType = 1, LearningAimStandardCode = 2, LearningAimFrameworkCode = 3, LearningAimPathwayCode = 13
},
new Payment {
LearnerReferenceNumber = "ABC", TransactionType = 16, LearningStartDate = new DateTime(2020, 01, 01), LearningAimProgrammeType = 1, LearningAimStandardCode = 2, LearningAimFrameworkCode = 3, LearningAimPathwayCode = 14
},
};
var learners = new List <Learner>
{
new Learner {
LearnRefNumber = "ABC"
}
};
var LearningDeliveries = new List <AecLearningDelivery>
{
new AecLearningDelivery {
LearnRefNumber = "ABC", LearnStartDate = new DateTime(2020, 01, 01), ProgType = 1, StdCode = 2, FworkCode = 3, PwayCode = 10, AimSequenceNumber = 1
},
new AecLearningDelivery {
LearnRefNumber = "ABC", LearnStartDate = new DateTime(2020, 01, 01), ProgType = 1, StdCode = 2, FworkCode = 3, PwayCode = 11, AimSequenceNumber = 2
},
new AecLearningDelivery {
LearnRefNumber = "ABC", LearnStartDate = new DateTime(2020, 01, 01), ProgType = 1, StdCode = 2, FworkCode = 3, PwayCode = 12, AimSequenceNumber = 3
},
new AecLearningDelivery {
LearnRefNumber = "ABC", LearnStartDate = new DateTime(2020, 01, 01), ProgType = 1, StdCode = 2, FworkCode = 3, PwayCode = 13, AimSequenceNumber = 4
},
new AecLearningDelivery {
LearnRefNumber = "ABC", LearnStartDate = new DateTime(2020, 01, 01), ProgType = 1, StdCode = 2, FworkCode = 3, PwayCode = 14, AimSequenceNumber = 5
}
};
var periodisedValues = new List <ApprenticeshipPriceEpisodePeriodisedValues>();
var paymentLineFormatter = new PaymentLineFormatter() as IPaymentLineFormatter;
var earningsAndPaymentsBuilder = new EarningsAndPaymentsBuilder() as IEarningsAndPaymentsBuilder;
var appsAdditionalPaymentsModelBuilder = new AppsAdditionalPaymentsModelBuilder(paymentLineFormatter, earningsAndPaymentsBuilder);
var results = appsAdditionalPaymentsModelBuilder.Build(payments, learners, LearningDeliveries, periodisedValues);
results.Count().Should().Be(3);
}
public void GetValidPaymentTypes()
{
var formatter = new PaymentLineFormatter() as IPaymentLineFormatter;
formatter.GetAdditionalPaymentType(4).Should().Be("Employer");
formatter.GetAdditionalPaymentType(5).Should().Be("Provider");
formatter.GetAdditionalPaymentType(6).Should().Be("Employer");
formatter.GetAdditionalPaymentType(7).Should().Be("Provider");
formatter.GetAdditionalPaymentType(16).Should().Be("Apprentice");
}
public void GetApprenticeshipLegalEntityName(byte contractType, byte transactionType, string expected)
{
var formatter = new PaymentLineFormatter() as IPaymentLineFormatter;
var payment = new Payment
{
ContractType = contractType, TransactionType = transactionType,
LegalEntityName = "AppEntityName"
};
var result = formatter.GetApprenticeshipLegalEntityName(payment);
result.Should().Be(expected);
}
public void GetEmployerId(byte transactionType, int?learnDelEmpIdFirst, int?learnDelEmpIdSecond, string expected)
{
var formatter = new PaymentLineFormatter() as IPaymentLineFormatter;
var learningDeliver = new AecLearningDelivery
{
LearnDelEmpIdFirstAdditionalPaymentThreshold = learnDelEmpIdFirst,
LearnDelEmpIdSecondAdditionalPaymentThreshold = learnDelEmpIdSecond
}
;
var payment = new Payment {
TransactionType = transactionType
};
var result = formatter.GetEmployerId(learningDeliver, payment);
result.Should().Be(expected);
}
public void ReplaceOldWithNew()
{
var payments = new List <Payment>
{
new Payment {
ReportingAimFundingLineType = "16-18 Apprenticeship (Employer on App Service)"
},
new Payment {
ReportingAimFundingLineType = "16-18 Apprenticeship (Employer on App Service) Levy funding"
},
new Payment {
ReportingAimFundingLineType = "16-18 Apprenticeship (Employer on App Service) Non-Levy funding"
},
new Payment {
ReportingAimFundingLineType = "16-18 Apprenticeship (From May 2017) Levy Contract"
},
new Payment {
ReportingAimFundingLineType = FundLineConstants.NonLevyApprenticeship1618
},
new Payment {
ReportingAimFundingLineType = FundLineConstants.NonLevyApprenticeship1618NonProcured
},
new Payment {
ReportingAimFundingLineType = "16-18 Apprenticeship Non-Levy"
},
new Payment {
ReportingAimFundingLineType = "16-18 Apprenticeship Non-Levy Contract (procured)"
},
new Payment {
ReportingAimFundingLineType = "19+ Apprenticeship (Employer on App Service)"
},
new Payment {
ReportingAimFundingLineType = "19+ Apprenticeship (Employer on App Service) Levy funding"
},
new Payment {
ReportingAimFundingLineType = "19+ Apprenticeship (Employer on App Service) Non-Levy funding"
},
new Payment {
ReportingAimFundingLineType = "19+ Apprenticeship (From May 2017) Levy Contract"
},
new Payment {
ReportingAimFundingLineType = FundLineConstants.NonLevyApprenticeship19Plus
},
new Payment {
ReportingAimFundingLineType = FundLineConstants.NonLevyApprenticeship19PlusNonProcured
},
new Payment {
ReportingAimFundingLineType = "19+ Apprenticeship Non-Levy Contract (procured)"
},
};
var formatter = new PaymentLineFormatter() as IPaymentLineFormatter;
// Format the Funding Line Type before grouping by it (Update old entries to new line type
foreach (var payment in payments)
{
payment.ReportingAimFundingLineType =
formatter.GetUpdatedFindingLineType(payment.ReportingAimFundingLineType);
}
var groupedPayments = payments.GroupBy(p => p.ReportingAimFundingLineType).ToList();
payments.Count().Should().Be(15);
groupedPayments.Count().Should().Be(13);
groupedPayments
.Single(gp => gp.Key == FundLineConstants.NonLevyApprenticeship1618NonProcured).Count()
.Should().Be(2);
groupedPayments
.Single(gp => gp.Key == FundLineConstants.NonLevyApprenticeship19PlusNonProcured)
.Count().Should().Be(2);
groupedPayments.Any(gp => gp.Key == FundLineConstants.NonLevyApprenticeship1618).Should()
.BeFalse();
groupedPayments.Any(gp => gp.Key == FundLineConstants.NonLevyApprenticeship19Plus).Should()
.BeFalse();
}
public async void TestAgainstRealDb()
{
var ilrConnectionString =
"<ReplaceWithConnectionString>";
var dasConnectionString =
"<ReplaceWithConnectionString>";
var collectionYear = 1920;
var ukprn = 10000055;
SqlConnection ilrSqlFunc() => new SqlConnection(ilrConnectionString);
SqlConnection dasSqlFunc() => new SqlConnection(dasConnectionString);
var paymentsDataProvider = new PaymentsDataProvider(dasSqlFunc) as IPaymentsDataProvider;
var learnerDataProvider = new LearnerDataProvider(ilrSqlFunc) as ILearnerDataProvider;
var aecLearningDeliveryDataProvider = new AecLearningDeliveryDataProvider(ilrSqlFunc) as IAecLearningDeliveryDataProvider;
var appsPriceEpisodePeriodisedValuesDataProvider = new AppsPriceEpisodePeriodisedValuesDataProvider(ilrSqlFunc) as IAppsPriceEpisodePeriodisedValuesDataProvider;
var dataProvider = new AppsAdditionalPaymentsDataProvider(
paymentsDataProvider,
learnerDataProvider,
aecLearningDeliveryDataProvider,
appsPriceEpisodePeriodisedValuesDataProvider) as IAppsAdditionalPaymentsDataProvider;
var cancellationToken = new CancellationToken();
var reportServiceContext = new Mock <IReportServiceContext>();
reportServiceContext.Setup(rsc => rsc.CollectionYear).Returns(collectionYear);
reportServiceContext.Setup(rsc => rsc.Ukprn).Returns(ukprn);
var payments = await dataProvider.GetPaymentsAsync(reportServiceContext.Object, cancellationToken);
payments.Should().NotBeNull();
payments.Should().NotBeEmpty();
var learners = await dataProvider.GetLearnersAsync(reportServiceContext.Object, cancellationToken);
learners.Should().NotBeNull();
learners.Should().NotBeEmpty();
var aecLearningDeliveries = await dataProvider.GetAecLearningDeliveriesAsync(reportServiceContext.Object,
cancellationToken);
aecLearningDeliveries.Should().NotBeNull();
aecLearningDeliveries.Should().NotBeEmpty();
var appPriceEpisodePeriodisedValues = await dataProvider.GetPriceEpisodesAsync(reportServiceContext.Object, cancellationToken);
appPriceEpisodePeriodisedValues.Should().NotBeNull();
appPriceEpisodePeriodisedValues.Should().NotBeEmpty();
var paymentFundingLineFormatter = new PaymentLineFormatter() as IPaymentLineFormatter;
var earningsAndPaymentsBuilder = new EarningsAndPaymentsBuilder() as IEarningsAndPaymentsBuilder;
var appsAdditionalPaymentsModelBuilder =
new AppsAdditionalPaymentsModelBuilder(paymentFundingLineFormatter, earningsAndPaymentsBuilder) as IAppsAdditionalPaymentsModelBuilder;
var results = appsAdditionalPaymentsModelBuilder.Build(payments, learners, aecLearningDeliveries, appPriceEpisodePeriodisedValues);
results.Should().NotBeNull();
}
