USP_DATAFORMTEMPLATE_EDIT_PARTICIPANTCOMMUNICATIONTEMPLATES_3

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(184)	IN
@DESCRIPTION	nvarchar(500)	IN
@SUBJECT	nvarchar(500)	IN
@USERID	int	IN
@CLIENTSITEID	int	IN
@CONTENTHTML	nvarchar(max)	IN
@CONFIRMATIONTYPECODE	tinyint	IN
@FROMADDRESS	nvarchar(500)	IN
@FROMNAME	nvarchar(500)	IN
@REPLYADDRESS	nvarchar(500)	IN
@FAFTASKID	uniqueidentifier	IN
@ISDEFAULTFORTASK	bit	IN

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PARTICIPANTCOMMUNICATIONTEMPLATES_3 (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(184),
    @DESCRIPTION nvarchar(500),
    @SUBJECT nvarchar(500), 
  @USERID int,
  @CLIENTSITEID int,
  @CONTENTHTML nvarchar(max),
  @CONFIRMATIONTYPECODE tinyint,
  @FROMADDRESS nvarchar(500),
  @FROMNAME nvarchar(500),
  @REPLYADDRESS nvarchar(500),
  @FAFTASKID uniqueidentifier,
  @ISDEFAULTFORTASK bit
)
as

    set nocount on;  

  declare @EMAILTEMPLATEID int
  declare @EVENTID uniqueidentifier
  declare @ClientsID int;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try      
     select @EMAILTEMPLATEID = EET.EMAILTEMPLATEID,@EVENTID = EET.EVENTID
      from EVENTEMAILTEMPLATE EET where EET.ID = @ID

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

    exec dbo.USP_FAFEVENTEMAILTEMPLATE_ADDUPDATE @ID=@ID
        ,@EVENTID=@EVENTID
        ,@CLIENTSITEID=@CLIENTSITEID
        ,@CHANGEAGENTID=@CHANGEAGENTID
        ,@EMAILTEMPLATEID=@EMAILTEMPLATEID
        ,@USERID=@USERID
        ,@ClientsID=@ClientsID
        ,@NAME=@NAME
        ,@DESCRIPTION=@DESCRIPTION        
        ,@CONTENTHTML=@CONTENTHTML
        ,@SUBJECT=@SUBJECT
        ,@FROMADDRESS=@FROMADDRESS
        ,@FROMNAME=@FROMNAME
        ,@REPLYADDRESS=@REPLYADDRESS
        ,@FAFEMAILTYPECODE=@CONFIRMATIONTYPECODE
        ,@FAFTASKID=@FAFTASKID
        ,@ISDEFAULTFORTASK=@ISDEFAULTFORTASK
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;