public void Handle(WorkflowMessageAdvancedEvent message) { using (var connection = _connectionFactory.CreateConnection()) { connection.Execute( @"UPDATE [MessageModule].[WorkflowMessage] SET InitiatingAssessmentDefinitionCode = @InitiatingAssessmentDefinitionCode, InitiatingAssessmentDefinitionKey = @InitiatingAssessmentDefinitionKey, RecommendedAssessmentDefinitionCode = @RecommendedAssessmentDefinitionCode, RecommendedAssessmentDefinitionKey = @RecommendedAssessmentDefinitionKey, RecommendedAssessmentDefinitionName = a.AssessmentName, InitiatingAssessmentScore = @InitiatingAssessmentScore FROM [MessageModule].[WorkflowMessage] w JOIN [AssessmentModule].[AssessmentDefinition] a ON w.WorkflowMessageKey = @WorkflowMessageKey AND w.RecommendedAssessmentDefinitionKey = a.AssessmentDefinitionKey", new { WorkflowMessageKey = message.Key, InitiatingAssessmentDefinitionCode = message.InitiatingAssessmentCode, InitiatingAssessmentDefinitionKey = message.InitiatingAssessmentKey, message.RecommendedAssessmentDefinitionCode, message.RecommendedAssessmentDefinitionKey, InitiatingAssessmentScore = message.InitiatingAssessmentScore == null ? (string)null : message.InitiatingAssessmentScore.Value.ToString(), }); } }
private void Apply(WorkflowMessageAdvancedEvent workflowMessageAdvancedEvent) { InitiatingAssessmentKey = workflowMessageAdvancedEvent.InitiatingAssessmentKey; InitiatingAssessmentCode = workflowMessageAdvancedEvent.InitiatingAssessmentCode; RecommendedAssessmentDefinitionKey = workflowMessageAdvancedEvent.RecommendedAssessmentDefinitionKey; RecommendedAssessmentDefinitionCode = workflowMessageAdvancedEvent.RecommendedAssessmentDefinitionCode; InitiatingAssessmentScore = workflowMessageAdvancedEvent.InitiatingAssessmentScore; _workflowAssessments.Add(InitiatingAssessmentCode, InitiatingAssessmentKey); }