USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@EVENTID	uniqueidentifier	IN
@NAME	nvarchar(180)	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
@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_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES2
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
    @EVENTID uniqueidentifier,
  @NAME nvarchar(180) = null,
  @DESCRIPTION nvarchar(500) = null,
  @SUBJECT nvarchar(500) = null,
  @USERID int = null,
  @CLIENTSITEID int = null,
    @ISAVAILABLETOINDIVIDUAL bit = 0,
    @ISAVAILABLETOHOUSEHOLD bit = 0,
    @ISAVAILABLETOTEAMMEMBER bit = 0,
    @ISAVAILABLETOTEAMLEADER bit = 0,
    @ISAVAILABLETOCOMPANYLEADER bit = 0,
    @ISAVAILABLETOFUNDRAISINGCOACH bit = 0,
  @ISAVAILABLETOSPONSOR bit = 0,
  @CONTENTHTML nvarchar(max) = null,

  @RECIPIENTDONOR bit = 0,
  @RECIPIENTPROSPECT bit = 0,
  @RECIPIENTINDIVIDUAL bit = 0,
  @RECIPIENTHOUSEHOLDMEMBER bit = 0,
  @RECIPIENTHOUSEHOLDLEADER bit = 0,
  @RECIPIENTTEAMMEMBER bit = 0,
  @RECIPIENTTEAMLEADER bit = 0,
  @RECIPIENTCOMPANYLEADER bit = 0,
  @RECIPIENTSTATUSPREVIOUS bit = 0,
  @RECIPIENTSTATUSCURRENT bit = 0,
  @AVAILABLEASLETTER bit = 0,
  @ISAVAILABLETOHOUSEHOLDMEMBER 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




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
    ,@DESCRIPTION=@DESCRIPTION
    ,@CONTENTHTML=@CONTENTHTML
    ,@SUBJECT=@SUBJECT
    ,@FAFEMAILTYPECODE=100
    ,@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