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