public void SavePersistenceParameters(ProcessInstance processInstance)
{
var parametersToPersistList =
processInstance.ProcessParameters.Where(ptp => ptp.Purpose == ParameterPurpose.Persistence)
.Select(ptp =>
{
if (ptp.Type == typeof(UnknownParameterType))
{
return new { Parameter = ptp, SerializedValue = (string)ptp.Value }
}
;
return(new { Parameter = ptp, SerializedValue = ParametersSerializer.Serialize(ptp.Value, ptp.Type) });
})
.ToList();
using (OracleConnection connection = new OracleConnection(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);
}
}
}
}
WorkflowProcessInstancePersistence.Commit(connection);
}
}
