USP_DATAFORMTEMPLATE_EDIT_PARTICIPANTCOMMUNICATIONTEMPLATES

The save procedure used by the edit dataform template "Participant Communication Templates Edit Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(184)	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 coaches
@ISAVAILABLETOSPONSOR	bit	IN	Sponsors
@CONTENTHTML	nvarchar(max)	IN	Content
@CONFIRMATIONTYPECODE	tinyint	IN	Email type code
@FROMADDRESS	nvarchar(500)	IN	From address
@FROMNAME	nvarchar(500)	IN	From name
@REPLYADDRESS	nvarchar(500)	IN	Reply address
@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_EDIT_PARTICIPANTCOMMUNICATIONTEMPLATES (
    @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;  
  exec dbo.USP_DATAFORMTEMPLATE_EDIT_PARTICIPANTCOMMUNICATIONTEMPLATES_2
      @ID,
    @CHANGEAGENTID,
    @NAME,
    @DESCRIPTION,
    @SUBJECT, 
  @USERID,
  @CLIENTSITEID,
  @ISAVAILABLETOINDIVIDUAL,
    @ISAVAILABLETOHOUSEHOLD,
    @ISAVAILABLETOTEAMMEMBER,
    @ISAVAILABLETOTEAMLEADER,
    @ISAVAILABLETOCOMPANYLEADER,
    @ISAVAILABLETOFUNDRAISINGCOACH,
  @ISAVAILABLETOSPONSOR,
  @CONTENTHTML,
  @CONFIRMATIONTYPECODE,
  @FROMADDRESS,
  @FROMNAME,
  @REPLYADDRESS,

  @RECIPIENTDONOR,
  @RECIPIENTPROSPECT,
  @RECIPIENTINDIVIDUAL,
  @RECIPIENTHOUSEHOLDMEMBER,
  @RECIPIENTHOUSEHOLDLEADER,
  @RECIPIENTTEAMMEMBER,
  @RECIPIENTTEAMLEADER,
  @RECIPIENTCOMPANYLEADER,
  @RECIPIENTSTATUSPREVIOUS,
  @RECIPIENTSTATUSCURRENT,
  @AVAILABLEASLETTER,
  @ISAVAILABLETOHOUSEHOLDMEMBER

return 0;