public string ResolveCommandName(TrackingCommandName commandName)
{
switch (commandName)
{
case TrackingCommandName.DeleteInstanceTrackingProfile:
return "WORKFLOW_TRACKING_PKG.DeleteTrackingProfile";
case TrackingCommandName.DeleteTrackingProfile:
return "WORKFLOW_TRACKING_PKG.DeleteTrackingProfile";
case TrackingCommandName.GetCurrentDefaultTrackingProfile:
return "WORKFLOW_TRACKING_PKG.GetDefaultTrackingProfile";
case TrackingCommandName.GetDefaultTrackingProfile:
return "WORKFLOW_TRACKING_PKG.GetDefaultTrackingProfile";
case TrackingCommandName.GetInstanceTrackingProfile:
return "WORKFLOW_TRACKING_PKG.GetTrackingProfile";
case TrackingCommandName.GetTrackingProfile:
return "WORKFLOW_TRACKING_PKG.GetTrackingProfile";
case TrackingCommandName.GetTrackingProfileChanges:
return "WORKFLOW_TRACKING_PKG.GetTrackingProfileChanges";
case TrackingCommandName.InsertActivities:
return "WORKFLOW_TRACKING_PKG.InsertActivities";
case TrackingCommandName.InsertActivityAddedActions:
return "WORKFLOW_TRACKING_PKG.InsertActivityAddedActions";
case TrackingCommandName.InsertActivityRemovedActions:
return "WORKFLOW_TRACKING_PKG.InsertActivityRemovedActions";
case TrackingCommandName.InsertActivityTrackingRecords:
return "WORKFLOW_TRACKING_PKG.InsertActivityTrackingRecords";
case TrackingCommandName.InsertEventAnnotations:
return "WORKFLOW_TRACKING_PKG.InsertEventAnnotations";
case TrackingCommandName.InsertTrackingDataItems:
return "WORKFLOW_TRACKING_PKG.InsertTrackingDataItems";
case TrackingCommandName.InsertTrackingDataAnnotations:
return "WORKFLOW_TRACKING_PKG.InsertTrackingDataAnnotations";
case TrackingCommandName.InsertUserTrackingRecords:
return "WORKFLOW_TRACKING_PKG.InsertUserTrackingRecords";
case TrackingCommandName.InsertWorkflow:
return "WORKFLOW_TRACKING_PKG.InsertWorkflow";
case TrackingCommandName.InsertWorkflowInstance:
return "WORKFLOW_TRACKING_PKG.InsertWorkflowInstance";
case TrackingCommandName.InsertWorkflowTrackingRecords:
return "WORKFLOW_TRACKING_PKG.InsertWorkflowTrackingRecords";
case TrackingCommandName.UpdateDefaultTrackingProfile:
return "WORKFLOW_TRACKING_PKG.UpdateDefaultTrackingProfile";
case TrackingCommandName.UpdateInstanceTrackingProfile:
return "WORKFLOW_TRACKING_PKG.UpdateTrackingProfile";
case TrackingCommandName.UpdateTrackingProfile:
return "WORKFLOW_TRACKING_PKG.UpdateTrackingProfile";
}
throw new NotSupportedException(RM.Get_Error_CommandNamesNotSupported());
}
public string ResolveCommandName(TrackingCommandName commandName)
{
switch (commandName)
{
case TrackingCommandName.DeleteInstanceTrackingProfile :
return "DeleteInstanceTrackingProfile";
case TrackingCommandName.DeleteTrackingProfile :
return "DeleteTrackingProfile";
case TrackingCommandName.GetCurrentDefaultTrackingProfile :
return "GetCurrentDefaultTrackingProfile";
case TrackingCommandName.GetDefaultTrackingProfile :
return "GetDefaultTrackingProfile";
case TrackingCommandName.GetInstanceTrackingProfile :
return "GetInstanceTrackingProfile";
case TrackingCommandName.GetTrackingProfile :
return "GetTrackingProfile";
case TrackingCommandName.GetTrackingProfileChanges :
return "GetUpdatedTrackingProfiles";
case TrackingCommandName.InsertActivities :
return "InsertActivities";
case TrackingCommandName.InsertActivityAddedActions :
return "InsertAddedActivity";
case TrackingCommandName.InsertActivityRemovedActions :
return "InsertRemovedActivity";
case TrackingCommandName.InsertActivityTrackingRecords :
return "InsertActivityExecutionStatusEventMultiple";
case TrackingCommandName.InsertEventAnnotations :
return "InsertEventAnnotationMultiple";
case TrackingCommandName.InsertTrackingDataAnnotations :
return "InsertTrackingDataItemAnnotationMultiple";
case TrackingCommandName.InsertTrackingDataItems :
return "InsertTrackingDataItemMultiple";
case TrackingCommandName.InsertUserTrackingRecords :
return "InsertUserEvent";
case TrackingCommandName.InsertWorkflow :
return "InsertWorkflow";
case TrackingCommandName.InsertWorkflowInstance :
return "InsertWorkflowInstance";
case TrackingCommandName.InsertWorkflowTrackingRecords :
return "InsertWorkflowInstanceEvent";
case TrackingCommandName.UpdateDefaultTrackingProfile :
return "UpdateDefaultTrackingProfile";
case TrackingCommandName.UpdateInstanceTrackingProfile :
return "SetInstanceTrackingProfile";
case TrackingCommandName.UpdateTrackingProfile :
return "UpdateTrackingProfile";
}
throw new NotSupportedException(RM.Get_Error_CommandNamesNotSupported());
}
/// <summary>
/// Resolve a <see cref="TrackingParameterName" /> to its database-specific parameter name
/// including any additional batching information.
/// </summary>
/// <param name="commandName">
/// A <see cref="TrackingCommandName" /> indicating which command the parameter
/// name needs to be resolved for.
/// </param>
/// <param name="parameterName">
/// A <see cref="TrackingParameterName" /> indicating which parameter needs to be resolved.
/// </param>
/// <param name="parameterBatch">
/// <see cref="Int32" /> representing which parameter batch we're dealing with.
/// </param>
/// <returns>
/// </returns>
public String ResolveParameterName(TrackingCommandName commandName, TrackingParameterName parameterName, Int32 parameterBatch)
{
String resolvedParameterName = ResolveParameterName(commandName, parameterName);
switch (commandName)
{
// special cases that only support 1 parameter batch
case TrackingCommandName.InsertUserTrackingRecords:
case TrackingCommandName.InsertActivityAddedActions:
case TrackingCommandName.InsertActivityRemovedActions:
return(resolvedParameterName);
default:
return(String.Format("{0}{1}", resolvedParameterName, parameterBatch + 1));
}
}
/// <summary>
/// Resolve a <see cref="TrackingParameterName" /> to its database-specific parameter name
/// including any additional batching information.
/// </summary>
/// <param name="commandName">
/// A <see cref="TrackingCommandName" /> indicating which command the parameter
/// name needs to be resolved for.
/// </param>
/// <param name="parameterName">
/// A <see cref="TrackingParameterName" /> indicating which parameter needs to be resolved.
/// </param>
/// <param name="parameterBatch">
/// <see cref="Int32" /> representing which parameter batch we're dealing with.
/// </param>
/// <returns>
/// </returns>
public string ResolveParameterName(TrackingCommandName commandName, TrackingParameterName parameterName, Int32 parameterBatch)
{
return(String.Format("{0}_{1}", ResolveParameterName(
commandName, parameterName), parameterBatch + 1));
}
public string ResolveCommandName(TrackingCommandName commandName)
{
switch (commandName)
{
case TrackingCommandName.DeleteInstanceTrackingProfile:
return("WORKFLOW_TRACKING_PKG.DeleteTrackingProfile");
case TrackingCommandName.DeleteTrackingProfile:
return("WORKFLOW_TRACKING_PKG.DeleteTrackingProfile");
case TrackingCommandName.GetCurrentDefaultTrackingProfile:
return("WORKFLOW_TRACKING_PKG.GetDefaultTrackingProfile");
case TrackingCommandName.GetDefaultTrackingProfile:
return("WORKFLOW_TRACKING_PKG.GetDefaultTrackingProfile");
case TrackingCommandName.GetInstanceTrackingProfile:
return("WORKFLOW_TRACKING_PKG.GetTrackingProfile");
case TrackingCommandName.GetTrackingProfile:
return("WORKFLOW_TRACKING_PKG.GetTrackingProfile");
case TrackingCommandName.GetTrackingProfileChanges:
return("WORKFLOW_TRACKING_PKG.GetTrackingProfileChanges");
case TrackingCommandName.InsertActivities:
return("WORKFLOW_TRACKING_PKG.InsertActivities");
case TrackingCommandName.InsertActivityAddedActions:
return("WORKFLOW_TRACKING_PKG.InsertActivityAddedActions");
case TrackingCommandName.InsertActivityRemovedActions:
return("WORKFLOW_TRACKING_PKG.InsertActivityRemovedActions");
case TrackingCommandName.InsertActivityTrackingRecords:
return("WORKFLOW_TRACKING_PKG.InsertActivityTrackingRecords");
case TrackingCommandName.InsertEventAnnotations:
return("WORKFLOW_TRACKING_PKG.InsertEventAnnotations");
case TrackingCommandName.InsertTrackingDataItems:
return("WORKFLOW_TRACKING_PKG.InsertTrackingDataItems");
case TrackingCommandName.InsertTrackingDataAnnotations:
return("WORKFLOW_TRACKING_PKG.InsertTrackingDataAnnotations");
case TrackingCommandName.InsertUserTrackingRecords:
return("WORKFLOW_TRACKING_PKG.InsertUserTrackingRecords");
case TrackingCommandName.InsertWorkflow:
return("WORKFLOW_TRACKING_PKG.InsertWorkflow");
case TrackingCommandName.InsertWorkflowInstance:
return("WORKFLOW_TRACKING_PKG.InsertWorkflowInstance");
case TrackingCommandName.InsertWorkflowTrackingRecords:
return("WORKFLOW_TRACKING_PKG.InsertWorkflowTrackingRecords");
case TrackingCommandName.UpdateDefaultTrackingProfile:
return("WORKFLOW_TRACKING_PKG.UpdateDefaultTrackingProfile");
case TrackingCommandName.UpdateInstanceTrackingProfile:
return("WORKFLOW_TRACKING_PKG.UpdateTrackingProfile");
case TrackingCommandName.UpdateTrackingProfile:
return("WORKFLOW_TRACKING_PKG.UpdateTrackingProfile");
}
throw new NotSupportedException(RM.Get_Error_CommandNamesNotSupported());
}
public string ResolveParameterName(TrackingCommandName commandName, TrackingParameterName parameterName)
{
switch (parameterName)
{
case TrackingParameterName.ActivityXml:
return("p_ACTIVITY_XML");
case TrackingParameterName.ActivityXoml:
if (commandName == TrackingCommandName.InsertActivityAddedActions)
{
return("p_ADDED_ACTIVITY_ACTION");
}
else if (commandName == TrackingCommandName.InsertActivityRemovedActions)
{
return("p_REMOVED_ACTIVITY_ACTION");
}
break;
case TrackingParameterName.ActivityInstanceId:
return("p_ACTIVITY_INSTANCE_ID");
case TrackingParameterName.ActivityStatusId:
return("p_ACTIVITY_STATUS_ID");
case TrackingParameterName.ActivityStatusEventId:
return("p_ACTIVITY_STATUS_EVENT_ID");
case TrackingParameterName.Annotation:
return("p_ANNOTATION");
case TrackingParameterName.AssemblyFullName:
return("p_ASSEMBLY_FULL_NAME");
case TrackingParameterName.CallerContextGuid:
return("p_CALLER_CONTEXT_GUID");
case TrackingParameterName.CallerInstanceId:
return("p_CALLER_INSTANCE_ID");
case TrackingParameterName.CallerParentContextGuid:
return("p_CALLER_PARENT_CONTEXT_GUID");
case TrackingParameterName.CallPath:
return("p_CALL_PATH");
case TrackingParameterName.ContextGuid:
return("p_CONTEXT_GUID");
case TrackingParameterName.CreateDefault:
return("p_CREATE_DEFAULT");
case TrackingParameterName.DataBlob:
return("p_DATA_BLOB");
case TrackingParameterName.DataString:
return("p_DATA_STR");
case TrackingParameterName.DataNonSerialisable:
return("p_DATA_NON_SERIALISABLE");
case TrackingParameterName.EventArgs:
return("p_EVENT_ARG");
case TrackingParameterName.EventArgsAssemblyFullName:
return("p_EVENT_ARG_ASSEMBLY_NAME");
case TrackingParameterName.EventArgsTypeFullName:
return("p_EVENT_ARG_TYPE_NAME");
case TrackingParameterName.EventDateTime:
return("p_EVENT_DATE_TIME");
case TrackingParameterName.EventId:
return("p_EVENT_ID");
case TrackingParameterName.EventOrder:
return("p_EVENT_ORDER");
case TrackingParameterName.EventType:
return("p_EVENT_TYPE");
case TrackingParameterName.Exists:
return("p_EXISTS");
case TrackingParameterName.FieldName:
return("p_FIELD_NAME");
case TrackingParameterName.InitialisedDateTime:
return("p_INITIALISED_DATE_TIME");
case TrackingParameterName.InstanceId:
return("p_INSTANCE_ID");
case TrackingParameterName.IsInstanceType:
return("p_IS_INSTANCE_TYPE");
case TrackingParameterName.LastCheck:
return("p_LAST_CHECK");
case TrackingParameterName.NextCheck:
return("p_NEXT_CHECK");
case TrackingParameterName.Order:
return("p_ORDER");
case TrackingParameterName.ParentContextGuid:
return("p_PARENT_CONTEXT_GUID");
case TrackingParameterName.ParentQualifiedName:
return("p_PARENT_QUALIFIED_NAME");
case TrackingParameterName.QualifiedName:
return("p_QUALIFIED_NAME");
case TrackingParameterName.TrackingDataItemId:
return("p_TRACKING_DATA_ITEM_ID");
case TrackingParameterName.TrackingProfile:
return("p_TRACKING_PROFILE_XML");
case TrackingParameterName.TypeFullName:
return("p_TYPE_FULL_NAME");
case TrackingParameterName.Version:
return("p_VERSION");
case TrackingParameterName.UserDataAssemblyFullName:
return("p_USER_DATA_ASSEMBLY_NAME");
case TrackingParameterName.UserDataBlob:
return("p_USER_DATA_BLOB");
case TrackingParameterName.UserDataKey:
return("p_USER_DATA_KEY");
case TrackingParameterName.UserDataNonSerialisable:
return("p_USER_DATA_NON_SERIALISABLE");
case TrackingParameterName.UserDataString:
return("p_USER_DATA_STR");
case TrackingParameterName.UserDataTypeFullName:
return("p_USER_DATA_TYPE_NAME");
case TrackingParameterName.UserEventId:
return("p_USER_EVENT_ID");
case TrackingParameterName.WorkflowDefinition:
return("p_WORKFLOW_DEFINITION");
case TrackingParameterName.WorkflowTypeId:
return("p_WORKFLOW_TYPE_ID");
case TrackingParameterName.WorkflowInstanceEventId:
return("p_WORKFLOW_INSTANCE_EVENT_ID");
case TrackingParameterName.WorkflowInstanceId:
return("p_WORKFLOW_INSTANCE_ID");
case TrackingParameterName.WorkflowInstanceStatusId:
return("p_WORKFLOW_INSTANCE_STATUS");
}
throw new NotSupportedException(RM.Get_Error_CommandNameParameterNameNotSupported());
}
/// <summary>
/// Helper method used to build a <see cref="TrackingWorkflowInstance" />
/// from the specified <see cref="IDataRecord" />.
/// </summary>
/// <param name="dataRecord">
/// An <see cref="IDataRecord" />.
/// </param>
/// <returns>
/// An instance of <see cref="TrackingWorkflowInstance" />.
/// </returns>
private TrackingWorkflowInstance buildTrackingWorkflowInstance(IDataRecord dataRecord, TrackingCommandName commandName)
{
String assemblyName = ValueReader.GetString(dataRecord,
_nameResolver.ResolveParameterName(commandName,
TrackingParameterName.AssemblyFullName));
String typeName = ValueReader.GetString(dataRecord,
_nameResolver.ResolveParameterName(commandName,
TrackingParameterName.TypeFullName));
return(new TrackingWorkflowInstance(
WorkflowInstanceHelper.DeserialiseActivity(ValueReader.GetString(
dataRecord, _nameResolver.ResolveParameterName(commandName,
TrackingParameterName.ActivityXoml))),
ValueReader.GetGuid(dataRecord, _nameResolver.ResolveParameterName(
commandName, TrackingParameterName.InstanceId)),
ValueReader.GetDateTime(dataRecord, _nameResolver.ResolveParameterName(
commandName, TrackingParameterName.InitialisedDateTime)),
ValueReader.GetValue(dataRecord, _nameResolver.ResolveParameterName(
commandName, TrackingParameterName.WorkflowInstanceId)),
ValueReader.GetGuid(dataRecord, _nameResolver.ResolveParameterName(
commandName, TrackingParameterName.CallerInstanceId)),
ValueReader.GetEnum <WorkflowStatus>(dataRecord,
_nameResolver.ResolveParameterName(commandName,
TrackingParameterName.WorkflowInstanceStatusId)),
Type.GetType(String.Format("{0}, {1}", assemblyName, typeName), false)));
}
public string ResolveParameterName(TrackingCommandName commandName, TrackingParameterName parameterName)
{
switch (parameterName)
{
case TrackingParameterName.ActivityInstanceId :
return "ActivityInstanceId";
case TrackingParameterName.ActivityStatusEventId :
return "ActivityExecutionStatusEventId";
case TrackingParameterName.ActivityStatusId :
return "ExecutionStatusId";
case TrackingParameterName.ActivityXml :
return "Activities";
case TrackingParameterName.ActivityXoml :
if (commandName == TrackingCommandName.InsertActivityAddedActions)
return "AddedActivityAction";
else if (commandName == TrackingCommandName.InsertActivityRemovedActions)
return "RemovedActivityAction";
break;
case TrackingParameterName.Annotation :
return "Annotation";
case TrackingParameterName.AssemblyFullName:
return "AssemblyFullName";
case TrackingParameterName.CallerContextGuid:
return "CallerContextGuid";
case TrackingParameterName.CallerInstanceId:
return "CallerInstanceId";
case TrackingParameterName.CallerParentContextGuid:
return "CallerParentContextGuid";
case TrackingParameterName.CallPath:
return "CallPath";
case TrackingParameterName.ContextGuid:
return "ContextGuid";
case TrackingParameterName.CreateDefault:
return "CreateDefault";
case TrackingParameterName.DataBlob :
return "Data_Blob";
case TrackingParameterName.DataNonSerialisable :
return "DataNonSerializable";
case TrackingParameterName.DataString :
return "Data_Str";
case TrackingParameterName.EventArgs :
return "EventArg";
case TrackingParameterName.EventArgsAssemblyFullName :
return "EventArgAssemblyFullName";
case TrackingParameterName.EventArgsTypeFullName :
return "EventArgTypeFullName";
case TrackingParameterName.EventDateTime:
return "EventDateTime";
case TrackingParameterName.EventId :
return "EventId";
case TrackingParameterName.EventOrder :
return "EventOrder";
case TrackingParameterName.EventType :
return "EventTypeId";
case TrackingParameterName.Exists:
return "Exists";
case TrackingParameterName.FieldName :
return "FieldName";
case TrackingParameterName.InitialisedDateTime :
return "EventDateTime";
case TrackingParameterName.InstanceId:
switch (commandName)
{
case TrackingCommandName.DeleteInstanceTrackingProfile:
case TrackingCommandName.GetInstanceTrackingProfile:
case TrackingCommandName.UpdateInstanceTrackingProfile:
return "InstanceId";
case TrackingCommandName.InsertWorkflowInstance:
return "WorkflowInstanceId";
}
break;
case TrackingParameterName.IsInstanceType:
return "IsInstanceType";
case TrackingParameterName.LastCheck :
return "LastCheckDateTime";
case TrackingParameterName.NextCheck :
return "MaxCheckDateTime";
case TrackingParameterName.Order :
return "Order";
case TrackingParameterName.ParentContextGuid :
return "ParentContextGuid";
case TrackingParameterName.ParentQualifiedName :
return "ParentQualifiedName";
case TrackingParameterName.QualifiedName :
return "QualifiedName";
case TrackingParameterName.TrackingDataItemId :
return "TrackingDataItemId";
case TrackingParameterName.TrackingProfile:
return "TrackingProfileXml";
case TrackingParameterName.TypeFullName:
return "TypeFullName";
case TrackingParameterName.Version:
return "Version";
case TrackingParameterName.UserDataAssemblyFullName :
return "UserDataAssemblyFullName";
case TrackingParameterName.UserDataBlob :
return "UserData_Blob";
case TrackingParameterName.UserDataKey :
return "UserDataKey";
case TrackingParameterName.UserDataNonSerialisable :
return "UserDataNonSerializable";
case TrackingParameterName.UserDataString :
return "UserData_Str";
case TrackingParameterName.UserDataTypeFullName :
return "UserDataTypeFullName";
case TrackingParameterName.UserEventId :
return "UserEventId";
case TrackingParameterName.WorkflowDefinition :
return "WorkflowDefinition";
case TrackingParameterName.WorkflowInstanceEventId :
return "WorkflowInstanceEventId";
case TrackingParameterName.WorkflowInstanceId :
return "WorkflowInstanceInternalId";
case TrackingParameterName.WorkflowInstanceStatusId :
return "TrackingWorkflowEventId";
case TrackingParameterName.WorkflowTypeId:
switch (commandName)
{
case TrackingCommandName.InsertActivities:
return "WorkflowTypeId";
case TrackingCommandName.InsertWorkflow:
return "WorkflowId";
}
break;
}
throw new NotSupportedException(RM.Get_Error_CommandNameParameterNameNotSupported());
}
/// <summary>
/// Resolve a <see cref="TrackingParameterName" /> to its database-specific parameter name
/// including any additional batching information.
/// </summary>
/// <param name="commandName">
/// A <see cref="TrackingCommandName" /> indicating which command the parameter
/// name needs to be resolved for.
/// </param>
/// <param name="parameterName">
/// A <see cref="TrackingParameterName" /> indicating which parameter needs to be resolved.
/// </param>
/// <param name="parameterBatch">
/// <see cref="Int32" /> representing which parameter batch we're dealing with.
/// </param>
/// <returns>
/// </returns>
public string ResolveParameterName(TrackingCommandName commandName, TrackingParameterName parameterName, Int32 parameterBatch)
{
String resolvedParameterName = ResolveParameterName(commandName, parameterName);
switch (commandName)
{
// special cases that only support 1 parameter batch
case TrackingCommandName.InsertUserTrackingRecords :
case TrackingCommandName.InsertActivityAddedActions :
case TrackingCommandName.InsertActivityRemovedActions :
return resolvedParameterName;
default:
return String.Format("{0}{1}", resolvedParameterName, parameterBatch + 1);
}
}
public string ResolveParameterName(TrackingCommandName commandName, TrackingParameterName parameterName)
{
switch (parameterName)
{
case TrackingParameterName.ActivityXml:
return "p_ACTIVITY_XML";
case TrackingParameterName.ActivityXoml:
if (commandName == TrackingCommandName.InsertActivityAddedActions)
return "p_ADDED_ACTIVITY_ACTION";
else if (commandName == TrackingCommandName.InsertActivityRemovedActions)
return "p_REMOVED_ACTIVITY_ACTION";
break;
case TrackingParameterName.ActivityInstanceId:
return "p_ACTIVITY_INSTANCE_ID";
case TrackingParameterName.ActivityStatusId:
return "p_ACTIVITY_STATUS_ID";
case TrackingParameterName.ActivityStatusEventId:
return "p_ACTIVITY_STATUS_EVENT_ID";
case TrackingParameterName.Annotation:
return "p_ANNOTATION";
case TrackingParameterName.AssemblyFullName:
return "p_ASSEMBLY_FULL_NAME";
case TrackingParameterName.CallerContextGuid:
return "p_CALLER_CONTEXT_GUID";
case TrackingParameterName.CallerInstanceId:
return "p_CALLER_INSTANCE_ID";
case TrackingParameterName.CallerParentContextGuid:
return "p_CALLER_PARENT_CONTEXT_GUID";
case TrackingParameterName.CallPath:
return "p_CALL_PATH";
case TrackingParameterName.ContextGuid:
return "p_CONTEXT_GUID";
case TrackingParameterName.CreateDefault:
return "p_CREATE_DEFAULT";
case TrackingParameterName.DataBlob:
return "p_DATA_BLOB";
case TrackingParameterName.DataString:
return "p_DATA_STR";
case TrackingParameterName.DataNonSerialisable:
return "p_DATA_NON_SERIALISABLE";
case TrackingParameterName.EventArgs:
return "p_EVENT_ARG";
case TrackingParameterName.EventArgsAssemblyFullName:
return "p_EVENT_ARG_ASSEMBLY_NAME";
case TrackingParameterName.EventArgsTypeFullName:
return "p_EVENT_ARG_TYPE_NAME";
case TrackingParameterName.EventDateTime:
return "p_EVENT_DATE_TIME";
case TrackingParameterName.EventId:
return "p_EVENT_ID";
case TrackingParameterName.EventOrder:
return "p_EVENT_ORDER";
case TrackingParameterName.EventType:
return "p_EVENT_TYPE";
case TrackingParameterName.Exists:
return "p_EXISTS";
case TrackingParameterName.FieldName:
return "p_FIELD_NAME";
case TrackingParameterName.InitialisedDateTime:
return "p_INITIALISED_DATE_TIME";
case TrackingParameterName.InstanceId:
return "p_INSTANCE_ID";
case TrackingParameterName.IsInstanceType:
return "p_IS_INSTANCE_TYPE";
case TrackingParameterName.LastCheck:
return "p_LAST_CHECK";
case TrackingParameterName.NextCheck:
return "p_NEXT_CHECK";
case TrackingParameterName.Order:
return "p_ORDER";
case TrackingParameterName.ParentContextGuid:
return "p_PARENT_CONTEXT_GUID";
case TrackingParameterName.ParentQualifiedName:
return "p_PARENT_QUALIFIED_NAME";
case TrackingParameterName.QualifiedName:
return "p_QUALIFIED_NAME";
case TrackingParameterName.TrackingDataItemId:
return "p_TRACKING_DATA_ITEM_ID";
case TrackingParameterName.TrackingProfile:
return "p_TRACKING_PROFILE_XML";
case TrackingParameterName.TypeFullName:
return "p_TYPE_FULL_NAME";
case TrackingParameterName.Version:
return "p_VERSION";
case TrackingParameterName.UserDataAssemblyFullName:
return "p_USER_DATA_ASSEMBLY_NAME";
case TrackingParameterName.UserDataBlob:
return "p_USER_DATA_BLOB";
case TrackingParameterName.UserDataKey:
return "p_USER_DATA_KEY";
case TrackingParameterName.UserDataNonSerialisable:
return "p_USER_DATA_NON_SERIALISABLE";
case TrackingParameterName.UserDataString:
return "p_USER_DATA_STR";
case TrackingParameterName.UserDataTypeFullName:
return "p_USER_DATA_TYPE_NAME";
case TrackingParameterName.UserEventId:
return "p_USER_EVENT_ID";
case TrackingParameterName.WorkflowDefinition:
return "p_WORKFLOW_DEFINITION";
case TrackingParameterName.WorkflowTypeId:
return "p_WORKFLOW_TYPE_ID";
case TrackingParameterName.WorkflowInstanceEventId:
return "p_WORKFLOW_INSTANCE_EVENT_ID";
case TrackingParameterName.WorkflowInstanceId:
return "p_WORKFLOW_INSTANCE_ID";
case TrackingParameterName.WorkflowInstanceStatusId:
return "p_WORKFLOW_INSTANCE_STATUS";
}
throw new NotSupportedException(RM.Get_Error_CommandNameParameterNameNotSupported());
}
/// <summary>
/// Resolve a <see cref="TrackingParameterName" /> to its database-specific parameter name
/// including any additional batching information.
/// </summary>
/// <param name="commandName">
/// A <see cref="TrackingCommandName" /> indicating which command the parameter
/// name needs to be resolved for.
/// </param>
/// <param name="parameterName">
/// A <see cref="TrackingParameterName" /> indicating which parameter needs to be resolved.
/// </param>
/// <param name="parameterBatch">
/// <see cref="Int32" /> representing which parameter batch we're dealing with.
/// </param>
/// <returns>
/// </returns>
public string ResolveParameterName(TrackingCommandName commandName, TrackingParameterName parameterName, Int32 parameterBatch)
{
// for ODP.NET we use array binding so don't support parameter batching
return ResolveParameterName(commandName, parameterName);
}
public String ResolveCommandName(TrackingCommandName commandName)
{
switch (commandName)
{
case TrackingCommandName.DeleteInstanceTrackingProfile:
return("DeleteInstanceTrackingProfile");
case TrackingCommandName.DeleteTrackingProfile:
return("DeleteTrackingProfile");
case TrackingCommandName.GetCurrentDefaultTrackingProfile:
return("GetCurrentDefaultTrackingProfile");
case TrackingCommandName.GetDefaultTrackingProfile:
return("GetDefaultTrackingProfile");
case TrackingCommandName.GetInstanceTrackingProfile:
return("GetInstanceTrackingProfile");
case TrackingCommandName.GetTrackingProfile:
return("GetTrackingProfile");
case TrackingCommandName.GetTrackingProfileChanges:
return("GetUpdatedTrackingProfiles");
case TrackingCommandName.InsertActivities:
return("InsertActivities");
case TrackingCommandName.InsertActivityAddedActions:
return("InsertAddedActivity");
case TrackingCommandName.InsertActivityRemovedActions:
return("InsertRemovedActivity");
case TrackingCommandName.InsertActivityTrackingRecords:
return("InsertActivityExecutionStatusEventMultiple");
case TrackingCommandName.InsertEventAnnotations:
return("InsertEventAnnotationMultiple");
case TrackingCommandName.InsertTrackingDataAnnotations:
return("InsertTrackingDataItemAnnotationMultiple");
case TrackingCommandName.InsertTrackingDataItems:
return("InsertTrackingDataItemMultiple");
case TrackingCommandName.InsertUserTrackingRecords:
return("InsertUserEvent");
case TrackingCommandName.InsertWorkflow:
return("InsertWorkflow");
case TrackingCommandName.InsertWorkflowInstance:
return("InsertWorkflowInstance");
case TrackingCommandName.InsertWorkflowTrackingRecords:
return("InsertWorkflowInstanceEvent");
case TrackingCommandName.UpdateDefaultTrackingProfile:
return("UpdateDefaultTrackingProfile");
case TrackingCommandName.UpdateInstanceTrackingProfile:
return("SetInstanceTrackingProfile");
case TrackingCommandName.UpdateTrackingProfile:
return("UpdateTrackingProfile");
}
throw new NotSupportedException(RM.Get_Error_CommandNamesNotSupported());
}
public String ResolveParameterName(TrackingCommandName commandName, TrackingParameterName parameterName)
{
switch (parameterName)
{
case TrackingParameterName.ActivityInstanceId:
return("ActivityInstanceId");
case TrackingParameterName.ActivityStatusEventId:
return("ActivityExecutionStatusEventId");
case TrackingParameterName.ActivityStatusId:
return("ExecutionStatusId");
case TrackingParameterName.ActivityXml:
return("Activities");
case TrackingParameterName.ActivityXoml:
if (commandName == TrackingCommandName.InsertActivityAddedActions)
{
return("AddedActivityAction");
}
if (commandName == TrackingCommandName.InsertActivityRemovedActions)
{
return("RemovedActivityAction");
}
break;
case TrackingParameterName.Annotation:
return("Annotation");
case TrackingParameterName.AssemblyFullName:
return("AssemblyFullName");
case TrackingParameterName.CallerContextGuid:
return("CallerContextGuid");
case TrackingParameterName.CallerInstanceId:
return("CallerInstanceId");
case TrackingParameterName.CallerParentContextGuid:
return("CallerParentContextGuid");
case TrackingParameterName.CallPath:
return("CallPath");
case TrackingParameterName.ContextGuid:
return("ContextGuid");
case TrackingParameterName.CreateDefault:
return("CreateDefault");
case TrackingParameterName.DataBlob:
return("Data_Blob");
case TrackingParameterName.DataNonSerialisable:
return("DataNonSerializable");
case TrackingParameterName.DataString:
return("Data_Str");
case TrackingParameterName.EventArgs:
return("EventArg");
case TrackingParameterName.EventArgsAssemblyFullName:
return("EventArgAssemblyFullName");
case TrackingParameterName.EventArgsTypeFullName:
return("EventArgTypeFullName");
case TrackingParameterName.EventDateTime:
return("EventDateTime");
case TrackingParameterName.EventId:
return("EventId");
case TrackingParameterName.EventOrder:
return("EventOrder");
case TrackingParameterName.EventType:
return("EventTypeId");
case TrackingParameterName.Exists:
return("Exists");
case TrackingParameterName.FieldName:
return("FieldName");
case TrackingParameterName.InitialisedDateTime:
return("EventDateTime");
case TrackingParameterName.InstanceId:
switch (commandName)
{
case TrackingCommandName.DeleteInstanceTrackingProfile:
case TrackingCommandName.GetInstanceTrackingProfile:
case TrackingCommandName.UpdateInstanceTrackingProfile:
return("InstanceId");
case TrackingCommandName.InsertWorkflowInstance:
return("WorkflowInstanceId");
}
break;
case TrackingParameterName.IsInstanceType:
return("IsInstanceType");
case TrackingParameterName.LastCheck:
return("LastCheckDateTime");
case TrackingParameterName.NextCheck:
return("MaxCheckDateTime");
case TrackingParameterName.Order:
return("Order");
case TrackingParameterName.ParentContextGuid:
return("ParentContextGuid");
case TrackingParameterName.ParentQualifiedName:
return("ParentQualifiedName");
case TrackingParameterName.QualifiedName:
return("QualifiedName");
case TrackingParameterName.TrackingDataItemId:
return("TrackingDataItemId");
case TrackingParameterName.TrackingProfile:
return("TrackingProfileXml");
case TrackingParameterName.TypeFullName:
return("TypeFullName");
case TrackingParameterName.Version:
return("Version");
case TrackingParameterName.UserDataAssemblyFullName:
return("UserDataAssemblyFullName");
case TrackingParameterName.UserDataBlob:
return("UserData_Blob");
case TrackingParameterName.UserDataKey:
return("UserDataKey");
case TrackingParameterName.UserDataNonSerialisable:
return("UserDataNonSerializable");
case TrackingParameterName.UserDataString:
return("UserData_Str");
case TrackingParameterName.UserDataTypeFullName:
return("UserDataTypeFullName");
case TrackingParameterName.UserEventId:
return("UserEventId");
case TrackingParameterName.WorkflowDefinition:
return("WorkflowDefinition");
case TrackingParameterName.WorkflowInstanceEventId:
return("WorkflowInstanceEventId");
case TrackingParameterName.WorkflowInstanceId:
return("WorkflowInstanceInternalId");
case TrackingParameterName.WorkflowInstanceStatusId:
return("TrackingWorkflowEventId");
case TrackingParameterName.WorkflowTypeId:
switch (commandName)
{
case TrackingCommandName.InsertActivities:
return("WorkflowTypeId");
case TrackingCommandName.InsertWorkflow:
return("WorkflowId");
}
break;
}
throw new NotSupportedException(RM.Get_Error_CommandNameParameterNameNotSupported());
}
/// <summary>
/// Resolve a <see cref="TrackingParameterName" /> to its database-specific parameter name
/// including any additional batching information.
/// </summary>
/// <param name="commandName">
/// A <see cref="TrackingCommandName" /> indicating which command the parameter
/// name needs to be resolved for.
/// </param>
/// <param name="parameterName">
/// A <see cref="TrackingParameterName" /> indicating which parameter needs to be resolved.
/// </param>
/// <param name="parameterBatch">
/// <see cref="Int32" /> representing which parameter batch we're dealing with.
/// </param>
/// <returns>
/// </returns>
public string ResolveParameterName(TrackingCommandName commandName, TrackingParameterName parameterName, Int32 parameterBatch)
{
// for ODP.NET we use array binding so don't support parameter batching
return(ResolveParameterName(commandName, parameterName));
}
/// <summary>
/// Resolve a <see cref="TrackingParameterName" /> to its database-specific parameter name
/// including any additional batching information.
/// </summary>
/// <param name="commandName">
/// A <see cref="TrackingCommandName" /> indicating which command the parameter
/// name needs to be resolved for.
/// </param>
/// <param name="parameterName">
/// A <see cref="TrackingParameterName" /> indicating which parameter needs to be resolved.
/// </param>
/// <param name="parameterBatch">
/// <see cref="Int32" /> representing which parameter batch we're dealing with.
/// </param>
/// <returns>
/// </returns>
public string ResolveParameterName(TrackingCommandName commandName, TrackingParameterName parameterName, Int32 parameterBatch)
{
return String.Format("{0}_{1}", ResolveParameterName(
commandName, parameterName), parameterBatch + 1);
}
