USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3

create procedure dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
    @EVENTID uniqueidentifier,
  @SUBJECT nvarchar(500) = null,
  @USERID int = null,
  @CLIENTSITEID int = null,
  @CONTENTHTML nvarchar(max) = null,
  @FAFTASKID uniqueidentifier,
  @ISDEFAULTFORTASK bit = 0
)
as

set nocount on;
declare @ClientsID int;

--set @EMAILTEMPLATEID = 0

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

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

  if @CLIENTSITEID is null or @CLIENTSITEID = 0
    select @CLIENTSITEID=CLIENTSITESID from EVENTEXTENSION where EVENTID=@EVENTID

  declare @NAME nvarchar(500)
  SET @NAME = 'PCT - ' + CAST(@ID AS nvarchar(40)) + ' - ' + (SELECT LEFT(NAME,100) FROM EVENT WHERE ID = @EVENTID)

begin try

  select @ClientsID = ClientsID from dbo.ClientSites where ID = @CLIENTSITEID

  exec dbo.USP_FAFEVENTEMAILTEMPLATE_ADDUPDATE @ID=@ID
    ,@EVENTID=@EVENTID
    ,@CLIENTSITEID=@CLIENTSITEID
    ,@CHANGEAGENTID=@CHANGEAGENTID
    ,@USERID=@USERID
    ,@ClientsID=@ClientsID
    ,@NAME=@NAME  
    ,@CONTENTHTML=@CONTENTHTML
    ,@SUBJECT=@SUBJECT
    ,@FAFEMAILTYPECODE=100
    ,@FAFTASKID=@FAFTASKID
    ,@ISDEFAULTFORTASK=@ISDEFAULTFORTASK

end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0