USP_FAFEVENTEMAILTEMPLATE_COPY

Perform FAF Event acknowledgement, notifications, participant communication templates copy

Parameters

Parameter	Parameter Type	Mode
@SOURCEID	uniqueidentifier	IN
@TARGETEVENTID	uniqueidentifier	IN
@COPYBATCHGUID	uniqueidentifier	IN
@SOURCEXML	xml	IN
@CHANGEAGENTID	uniqueidentifier	IN
@USERID	int	IN
@CLIENTSITESID	int	IN

Definition

Copy



CREATE procedure dbo.USP_FAFEVENTEMAILTEMPLATE_COPY
(
  @SOURCEID uniqueidentifier,
  @TARGETEVENTID uniqueidentifier,  
  @COPYBATCHGUID uniqueidentifier,
  @SOURCEXML xml = null,
  @CHANGEAGENTID uniqueidentifier = null,
  @USERID int,
  @CLIENTSITESID int
)
as
    declare @CURRENTDATE datetime,
          @IsCopyEvent bit,
          @NEWEVENTNAME nvarchar(200)
  set @CURRENTDATE = getdate()

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

  select @IsCopyEvent = case when @SOURCEXML is null and @SOURCEID is not null then 1 else 0 end

  begin try

    if @SOURCEXML is null
      set @SOURCEXML = dbo.UFN_FAFEVENT_GETEVENTEMAILTEMPLATE_TOITEMLISTXML(@SOURCEID)

    select @NEWEVENTNAME = E.NAME from dbo.EVENT E where E.ID = @TARGETEVENTID

    set @SOURCEXML = CAST(REPLACE(CAST(@SOURCEXML AS NVARCHAR(MAX)), '[[EVENTNAME]]', @NEWEVENTNAME) AS XML)

    if @IsCopyEvent = 1
     set @SOURCEXML = CAST(REPLACE(CAST(@SOURCEXML AS NVARCHAR(MAX)), '<COPYBATCHGUID>'+CAST(@SOURCEID as nvarchar(40))+'</COPYBATCHGUID>', '<COPYBATCHGUID>'+CAST(@COPYBATCHGUID as nvarchar(40))+'</COPYBATCHGUID>') AS XML)

    exec dbo.USP_FAFEVENT_GETEVENTEMAILTEMPLATE_ADDFROMXML @EVENTID=@TARGETEVENTID, @XML=@SOURCEXML,@USERID=@USERID,@CHANGEAGENTID=@CHANGEAGENTID,@CHANGEDATE=@CURRENTDATE

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

  return 0;