USP_DATAFORMTEMPLATE_EDIT_PARTICIPANTCOMMUNICATIONTEMPLATES2

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
@ISAVAILABLETOINDIVIDUAL	bit	IN
@ISAVAILABLETOHOUSEHOLD	bit	IN
@ISAVAILABLETOTEAMMEMBER	bit	IN
@ISAVAILABLETOTEAMLEADER	bit	IN
@ISAVAILABLETOCOMPANYLEADER	bit	IN
@ISAVAILABLETOFUNDRAISINGCOACH	bit	IN
@ISAVAILABLETOSPONSOR	bit	IN
@CONTENTHTML	nvarchar(max)	IN
@CONFIRMATIONTYPECODE	tinyint	IN
@FROMADDRESS	nvarchar(500)	IN
@FROMNAME	nvarchar(500)	IN
@REPLYADDRESS	nvarchar(500)	IN
@RECIPIENTDONOR	bit	IN
@RECIPIENTPROSPECT	bit	IN
@RECIPIENTINDIVIDUAL	bit	IN
@RECIPIENTHOUSEHOLDMEMBER	bit	IN
@RECIPIENTHOUSEHOLDLEADER	bit	IN
@RECIPIENTTEAMMEMBER	bit	IN
@RECIPIENTTEAMLEADER	bit	IN
@RECIPIENTCOMPANYLEADER	bit	IN
@RECIPIENTSTATUSPREVIOUS	bit	IN
@RECIPIENTSTATUSCURRENT	bit	IN
@AVAILABLEASLETTER	bit	IN
@ISAVAILABLETOHOUSEHOLDMEMBER	bit	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PARTICIPANTCOMMUNICATIONTEMPLATES2 (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(184),
    @DESCRIPTION nvarchar(500),
    @SUBJECT nvarchar(500), 
  @USERID int,
  @CLIENTSITEID int,
  @ISAVAILABLETOINDIVIDUAL bit,
    @ISAVAILABLETOHOUSEHOLD bit,
    @ISAVAILABLETOTEAMMEMBER bit,
    @ISAVAILABLETOTEAMLEADER bit,
    @ISAVAILABLETOCOMPANYLEADER bit,
    @ISAVAILABLETOFUNDRAISINGCOACH bit,
  @ISAVAILABLETOSPONSOR bit,
  @CONTENTHTML nvarchar(max),
  @CONFIRMATIONTYPECODE tinyint,
  @FROMADDRESS nvarchar(500),
  @FROMNAME nvarchar(500),
  @REPLYADDRESS nvarchar(500),

  @RECIPIENTDONOR bit,
  @RECIPIENTPROSPECT bit,
  @RECIPIENTINDIVIDUAL bit,
  @RECIPIENTHOUSEHOLDMEMBER bit,
  @RECIPIENTHOUSEHOLDLEADER bit,
  @RECIPIENTTEAMMEMBER bit,
  @RECIPIENTTEAMLEADER bit,
  @RECIPIENTCOMPANYLEADER bit,
  @RECIPIENTSTATUSPREVIOUS bit,
  @RECIPIENTSTATUSCURRENT bit,
  @AVAILABLEASLETTER bit,
  @ISAVAILABLETOHOUSEHOLDMEMBER 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
        ,@ISAVAILABLETOINDIVIDUAL=@ISAVAILABLETOINDIVIDUAL
        ,@ISAVAILABLETOHOUSEHOLD=@ISAVAILABLETOHOUSEHOLD
        ,@ISAVAILABLETOTEAMMEMBER=@ISAVAILABLETOTEAMMEMBER
        ,@ISAVAILABLETOTEAMLEADER=@ISAVAILABLETOTEAMLEADER
        ,@ISAVAILABLETOCOMPANYLEADER=@ISAVAILABLETOCOMPANYLEADER
        ,@ISAVAILABLETOFUNDRAISINGCOACH=@ISAVAILABLETOFUNDRAISINGCOACH
        ,@ISAVAILABLETOSPONSOR=@ISAVAILABLETOSPONSOR
        ,@RECIPIENTDONOR=@RECIPIENTDONOR
        ,@RECIPIENTPROSPECT=@RECIPIENTPROSPECT
        ,@RECIPIENTINDIVIDUAL=@RECIPIENTINDIVIDUAL
        ,@RECIPIENTHOUSEHOLDMEMBER=@RECIPIENTHOUSEHOLDMEMBER
        ,@RECIPIENTHOUSEHOLDLEADER=@RECIPIENTHOUSEHOLDLEADER
        ,@RECIPIENTTEAMMEMBER=@RECIPIENTTEAMMEMBER
        ,@RECIPIENTTEAMLEADER=@RECIPIENTTEAMLEADER
        ,@RECIPIENTCOMPANYLEADER=@RECIPIENTCOMPANYLEADER
        ,@RECIPIENTSTATUSPREVIOUS=@RECIPIENTSTATUSPREVIOUS
        ,@RECIPIENTSTATUSCURRENT=@RECIPIENTSTATUSCURRENT
        ,@AVAILABLEASLETTER=@AVAILABLEASLETTER
        ,@ISAVAILABLETOHOUSEHOLDMEMBER=@ISAVAILABLETOHOUSEHOLDMEMBER
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;