public void SavePersistenceParameters(ProcessInstance processInstance)
{
var parametersToPersistList =
processInstance.ProcessParameters.Where(ptp => ptp.Purpose == ParameterPurpose.Persistence)
.Select(
ptp => new { Parameter = ptp, SerializedValue = _runtime.SerializeParameter(ptp.Value, ptp.Type) })
.ToList();
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
var persistedParameters = WorkflowProcessInstancePersistence.SelectByProcessId(connection, processInstance.ProcessId).ToList();
foreach (var parameterDefinitionWithValue in parametersToPersistList)
{
var persistence =
persistedParameters.SingleOrDefault(
pp => pp.ParameterName == parameterDefinitionWithValue.Parameter.Name);
{
if (persistence == null)
{
if (parameterDefinitionWithValue.SerializedValue != null)
{
persistence = new WorkflowProcessInstancePersistence()
{
Id = Guid.NewGuid(),
ProcessId = processInstance.ProcessId,
ParameterName = parameterDefinitionWithValue.Parameter.Name,
Value = parameterDefinitionWithValue.SerializedValue
};
persistence.Insert(connection);
}
}
else
{
if (parameterDefinitionWithValue.SerializedValue != null)
{
persistence.Value = parameterDefinitionWithValue.SerializedValue;
persistence.Update(connection);
}
else
{
WorkflowProcessInstancePersistence.Delete(connection, persistence.Id);
}
}
}
}
}
}
