USP_DATAFORM_EDITSAVE_MAILPREFERENCE_4

The save procedure used by the edit dataform template "Mail Preference Edit Form 3".

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.
@MAILTYPECODE	tinyint	IN	Mail type
@ACKNOWLEDGEMENTID	uniqueidentifier	IN	Selected communication
@CORRESPONDENCEID	uniqueidentifier	IN	Selected communication
@PLEDGEREMINDERID	uniqueidentifier	IN	Selected communication
@BUSINESSUNITCODEID	uniqueidentifier	IN	Business unit
@CATEGORYCODEID	uniqueidentifier	IN	Category
@EVENTCATEGORYCODEID	uniqueidentifier	IN	Category
@SITEID	uniqueidentifier	IN	Site
@CORRESPONDENCECODEID	uniqueidentifier	IN	Correspondence code
@RECEIPTTYPECODE	int	IN	Receipt type
@SENDMAIL	bit	IN	Send mail
@DELIVERYMETHODCODE	tinyint	IN	Send by
@CONTACTTYPES	xml	IN	Send to contact(s)
@ADDRESSID	uniqueidentifier	IN	Selected address
@EMAILADDRESSID	uniqueidentifier	IN	Selected address
@USESEASONALADDRESS	bit	IN	Send to seasonal address when valid
@COMMENTS	nvarchar(500)	IN	Comments
@GROUPCONTACTS	xml	IN
@PURPOSEID	uniqueidentifier	IN	Fundraising Purpose
@DONOTSENDOTHERCHANNEL	bit	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORM_EDITSAVE_MAILPREFERENCE_4(
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier,
                        @MAILTYPECODE tinyint,
                        @ACKNOWLEDGEMENTID uniqueidentifier,
                        @CORRESPONDENCEID uniqueidentifier,
                        @PLEDGEREMINDERID uniqueidentifier,
                        @BUSINESSUNITCODEID uniqueidentifier,
                        @CATEGORYCODEID uniqueidentifier,
                        @EVENTCATEGORYCODEID uniqueidentifier,
                        @SITEID uniqueidentifier,
                        @CORRESPONDENCECODEID uniqueidentifier,
                        @RECEIPTTYPECODE int,
                        @SENDMAIL bit,
                        @DELIVERYMETHODCODE tinyint,
                        @CONTACTTYPES xml,
                        @ADDRESSID uniqueidentifier,
                        @EMAILADDRESSID uniqueidentifier,
                        @USESEASONALADDRESS bit,
                        @COMMENTS nvarchar(500),
                        @GROUPCONTACTS xml,
            @PURPOSEID uniqueidentifier,
                        @DONOTSENDOTHERCHANNEL bit
                    )
                    as
          begin
                        set nocount on;

            declare @ISNOPREFERENCE bit;

              exec dbo.USP_DATAFORM_EDITLOAD_MAILPREFERENCE_3 @ID = @ID, @ISNOPREFERENCE = @ISNOPREFERENCE;

            exec USP_DATAFORM_EDITSAVE_MAILPREFERENCE_5 @ID, @CHANGEAGENTID, @MAILTYPECODE, @ACKNOWLEDGEMENTID, @CORRESPONDENCEID, @PLEDGEREMINDERID ,
                        @BUSINESSUNITCODEID,@CATEGORYCODEID, @EVENTCATEGORYCODEID, @SITEID, @CORRESPONDENCECODEID, @RECEIPTTYPECODE, @SENDMAIL, @DELIVERYMETHODCODE,
                        @CONTACTTYPES, @ADDRESSID, @EMAILADDRESSID, @USESEASONALADDRESS , @COMMENTS , @GROUPCONTACTS, @PURPOSEID, @DONOTSENDOTHERCHANNEL, 
            @ISNOPREFERENCE
          end