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