public async Task Create(ApprenticeshipEventView @event)
{
await WithConnection(async c =>
{
var parameters = new DynamicParameters();
parameters.Add("@commitmentId", @event.Id, DbType.Int64);
parameters.Add("@paymentStatus", @event.PaymentStatus.ToString(), DbType.String);
parameters.Add("@apprenticeshipId", @event.ApprenticeshipId, DbType.Int64);
parameters.Add("@agreementStatus", @event.AgreementStatus.ToString(), DbType.String);
parameters.Add("@ukPrn", @event.ProviderId, DbType.String);
parameters.Add("@uln", @event.LearnerId, DbType.String);
parameters.Add("@employerAccountId", @event.EmployerAccountId, DbType.String);
parameters.Add("@trainingTypeId", @event.TrainingType.ToString(), DbType.String);
parameters.Add("@trainingId", @event.TrainingId, DbType.String);
parameters.Add("@trainingStartDate", @event.TrainingStartDate, DbType.Date);
parameters.Add("@trainingEndDate", @event.TrainingEndDate, DbType.Date);
parameters.Add("@trainingTotalCost", @event.TrainingTotalCost, DbType.Decimal);
parameters.Add("@legalEntityCode", @event.LegalEntityId, DbType.String);
parameters.Add("@legalEntityName", @event.LegalEntityName, DbType.String);
parameters.Add("@legalEntityOrganisationType", @event.LegalEntityOrganisationType, DbType.String);
parameters.Add("@dateOfBirth", @event.DateOfBirth, DbType.Date);
parameters.Add("@transferSenderAccountId", @event.TransferSenderId, DbType.Int64);
parameters.Add("@transferApprovalStatus", @event.TransferApprovalStatus == null ? null : @event.TransferApprovalStatus.ToString(), DbType.String);
parameters.Add("@transferApprovalDate", @event.TransferApprovalActionedOn, DbType.DateTime);
return(await c.ExecuteAsync(
sql: "[Data_Load].[CreateCommitmentApprenticeship]",
param: parameters,
commandType: CommandType.StoredProcedure));
});
}
public void InsertIntoCommitments(dynamic value, ICollection <string> columns)
{
var commitment = new ApprenticeshipEventView();
commitment.Id = columns.Contains("CommitmentID") ? ConvertToType <long>(value.CommitmentID) : null;
commitment.PaymentStatus = columns.Contains("PaymentStatus") ? Enum.Parse(typeof(PaymentStatus), value.PaymentStatus) : null;
commitment.ApprenticeshipId = columns.Contains("ApprenticeshipID") ? ConvertToType <long>(value.ApprenticeshipID) : null;
commitment.AgreementStatus = columns.Contains("AgreementStatus") ? Enum.Parse(typeof(AgreementStatus), value.AgreementStatus) : null;
commitment.ProviderId = columns.Contains("ProviderID") ? ConvertToType <string>(value.ProviderID) : null;
commitment.LearnerId = columns.Contains("LearnerID") ? ConvertToType <string>(value.LearnerID) : null;
commitment.EmployerAccountId = columns.Contains("EmployerAccountID") ? ConvertToType <string>(value.EmployerAccountID) : null;
commitment.TrainingType = Enum.Parse(typeof(TrainingTypes), value.TrainingTypeID);
commitment.TrainingId = columns.Contains("TrainingID") ? ConvertToType <string>(value.TrainingID) : null;
commitment.TrainingStartDate = columns.Contains("TrainingStartDate")
? ConvertToType <DateTime>(value.TrainingStartDate)
: null;
commitment.TrainingEndDate = columns.Contains("TrainingEndDate")
? ConvertToType <DateTime>(value.TrainingEndDate)
: null;
commitment.TrainingTotalCost = columns.Contains("TrainingTotalCost")
? ConvertToType <decimal>(value.TrainingTotalCost)
: null;
commitment.LegalEntityId = columns.Contains("LegalEntityCode") ? value.LegalEntityCode : null;
commitment.LegalEntityName = columns.Contains("LegalEntityName") ? value.LegalEntityName : null;
commitment.LegalEntityOrganisationType = columns.Contains("LegalEntityOrganisationType")
? value.LegalEntityOrganisationType
: null;
commitment.DateOfBirth =
columns.Contains("DateOfBirth") ? ConvertToType <DateTime>(value.DateOfBirth) : null;
var repo = new ApprenticeshipRepository(_connectionString);
repo.Create(commitment).Wait();
}
public void Arrange()
{
_apprenticeshipViewEvent = new ApprenticeshipEventView();
_eventService = new Mock <IEventService>();
_logger = new Mock <ILog>();
_eventService.Setup(x => x.GetUnprocessedApprenticeshipEvents())
.ReturnsAsync(new List <ApprenticeshipEventView> {
_apprenticeshipViewEvent
});
_collector = new ApprenticeshipEventsCollector(_eventService.Object, _logger.Object);
}
public void Arrange()
{
_mediator = new Mock <IMediator>();
_eventRepository = new Mock <IEventRepository>();
_logger = new Mock <ILog>();
_configuration = new Mock <IDataConfiguration>();
_configuration.SetupGet(x => x.FailureTolerance).Returns(5);
_handler = new ApprenticeshipEventHandler(
_mediator.Object, _eventRepository.Object,
_configuration.Object, _logger.Object);
_event = new ApprenticeshipEventView();
_mediator.Setup(x => x.SendAsync(It.IsAny <CreateCommitmentApprenticeshipEntryCommand>()))
.ReturnsAsync(new CreateCommitmentApprenticeshipEntryResponse());
}
