USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES

The save procedure used by the add dataform template "Participant Communication Templates Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@NAME	nvarchar(180)	IN	Name
@DESCRIPTION	nvarchar(500)	IN	Description
@SUBJECT	nvarchar(500)	IN	Subject
@USERID	int	IN	User ID
@CLIENTSITEID	int	IN	Client Site ID
@ISAVAILABLETOINDIVIDUAL	bit	IN	Individuals
@ISAVAILABLETOHOUSEHOLD	bit	IN	Households
@ISAVAILABLETOTEAMMEMBER	bit	IN	Team members
@ISAVAILABLETOTEAMLEADER	bit	IN	Team leaders
@ISAVAILABLETOCOMPANYLEADER	bit	IN	Company leaders
@ISAVAILABLETOFUNDRAISINGCOACH	bit	IN	Fundraising coach
@ISAVAILABLETOSPONSOR	bit	IN	Sponsors
@CONTENTHTML	nvarchar(max)	IN	Content HTML
@RECIPIENTDONOR	bit	IN	Donors
@RECIPIENTPROSPECT	bit	IN	Prospects
@RECIPIENTINDIVIDUAL	bit	IN	Individuals
@RECIPIENTHOUSEHOLDMEMBER	bit	IN	Household members
@RECIPIENTHOUSEHOLDLEADER	bit	IN	Household leaders
@RECIPIENTTEAMMEMBER	bit	IN	Team members
@RECIPIENTTEAMLEADER	bit	IN	Team leaders
@RECIPIENTCOMPANYLEADER	bit	IN	Company leaders
@RECIPIENTSTATUSPREVIOUS	bit	IN	Previous
@RECIPIENTSTATUSCURRENT	bit	IN	Current
@AVAILABLEASLETTER	bit	IN	Available as Letter
@ISAVAILABLETOHOUSEHOLDMEMBER	bit	IN

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES
(
  @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()

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