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