USP_FAFEVENTTEAMFAFCONFIG_COPY

CREATE procedure dbo.USP_FAFEVENTTEAMFAFCONFIG_COPY
(
  @SOURCEID uniqueidentifier,
  @TARGETEVENTID uniqueidentifier,  
  @SOURCEXML xml = null,
  @CHANGEAGENTID uniqueidentifier = null,
  @COPYBATCHGUID uniqueidentifier
)
as
    declare @CURRENTDATE datetime,
          @IsCopyEvent bit
  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_GETEVENTTEAMFAFCONFIG_TOITEMLISTXML(@SOURCEID)

  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_GETEVENTTEAMFAFCONFIG_ADDFROMXML @EVENTID=@TARGETEVENTID, @XML=@SOURCEXML, @CHANGEAGENTID=@CHANGEAGENTID, @CHANGEDATE=@CURRENTDATE

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

return 0;