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