USP_DATAFORM_EDITSAVE_MAILPREFERENCE_3

Edits a mail preference record.

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

Definition

Copy



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

set nocount on;

    declare @DONOTSENDOTHERCHANNEL bit;

    exec dbo.USP_DATAFORM_EDITLOAD_MAILPREFERENCE_3 @ID = @ID, @DONOTSENDOTHERCHANNEL = @DONOTSENDOTHERCHANNEL output;

    exec dbo.USP_DATAFORM_EDITSAVE_MAILPREFERENCE_4
            @ID,
            @CHANGEAGENTID,
            @MAILTYPECODE,
            @ACKNOWLEDGEMENTID,
            @CORRESPONDENCEID,
            @PLEDGEREMINDERID,
            @BUSINESSUNITCODEID,
            @CATEGORYCODEID,
            @EVENTCATEGORYCODEID,
            @SITEID,
            @CORRESPONDENCECODEID,
            @RECEIPTTYPECODE,
            @SENDMAIL,
            @DELIVERYMETHODCODE,
            @CONTACTTYPES,
            @ADDRESSID,
            @EMAILADDRESSID,
            @USESEASONALADDRESS,
            @COMMENTS,
            @GROUPCONTACTS,
            @PURPOSEID,
            @DONOTSENDOTHERCHANNEL;

    return 0;