USP_BBWORKFLOW_BUSINESSACTIVITY_ADD

create procedure dbo.USP_BBWORKFLOW_BUSINESSACTIVITY_ADD

/*

Used by the Workflow Library BusinessActivity workflow activity.

*/


  @ID uniqueidentifier = null output,
  @BBWORKFLOWINSTANCEINFOID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @DISPLAYNAME nvarchar(255),
  @DESCRIPTION nvarchar(500) ='',
  @ACTIVITYSTARTDATE datetimeoffset = null,
  @STARTMESSAGE nvarchar(max) = '',
  @DETAILLEVELCODE int =0,
  @PARENTBBWORKFLOWBUSINESSACTIVITYID uniqueidentifier  = null

as

  set nocount on;

  if @ID is null
      set @ID = newid();

  if @CHANGEAGENTID is null  
      exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

  declare @CURRENTDATE datetime
  set @CURRENTDATE = getdate();

  if @ACTIVITYSTARTDATE is null
      set @ACTIVITYSTARTDATE=SYSDATETIMEOFFSET();

  if @DESCRIPTION is null
      set @DESCRIPTION='';

  if @STARTMESSAGE is null
      set @STARTMESSAGE='';

  if @DETAILLEVELCODE is null
      set @DETAILLEVELCODE=0;



  begin try
      insert into dbo.BBWORKFLOWBUSINESSACTIVITY
          (ID, BBWORKFLOWINSTANCEINFOID, DISPLAYNAME, [DESCRIPTION], ACTIVITYSTARTDATE, STARTMESSAGE, DETAILLEVELCODE, ADDEDBYID, DATEADDED, PARENTBBWORKFLOWBUSINESSACTIVITYID)
      values
          (@ID, @BBWORKFLOWINSTANCEINFOID, @DISPLAYNAME, @DESCRIPTION, @ACTIVITYSTARTDATE,@STARTMESSAGE, @DETAILLEVELCODE, @CHANGEAGENTID, @CURRENTDATE, @PARENTBBWORKFLOWBUSINESSACTIVITYID);


      --add a row to the workflow log table.

      declare @LOGID uniqueidentifier=NEWID();

      declare @MSG nvarchar(max);
      set @MSG = N'biz activity started: ' + @DISPLAYNAME;

      exec dbo.USP_BBWORKFLOW_ADD_LOG_MESSAGE @LOGID, @CHANGEAGENTID, @BBWORKFLOWINSTANCEINFOID, 0,  @MSG, 1;


  end try

  begin catch
      exec dbo.USP_RAISE_ERROR;
      return 1;
  end catch

  return 0;