USP_DATAFORMTEMPLATE_EDIT_REMINDEROPTION

Saves the reminder options.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CURRENTAPPUSERID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAMEFORMATPARAMETERID	uniqueidentifier	IN	Name format options
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	IN	Address processing
@EXCLUDEDSOLICITCODESXML	xml	IN	Constituents who will not be mailed
@FREQUENCY	int	IN
@LETTERS	xml	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REMINDEROPTION(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @NAMEFORMATPARAMETERID uniqueidentifier,
    @ADDRESSPROCESSINGOPTIONID uniqueidentifier,
    @EXCLUDEDSOLICITCODESXML xml,
    @FREQUENCY int,
    @LETTERS xml = null
)
as
begin
    set nocount on;

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getdate();

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    begin try
        exec dbo.USP_REMINDEROPTION_GETSOLICITCODES_UPDATEFROMXML @ID, @EXCLUDEDSOLICITCODESXML, @CHANGEAGENTID, @CURRENTDATE;

        if @LETTERS is not null
        begin
            exec dbo.USP_COMMUNICATIONLETTER_GETSCHEDULEINFO_UPDATEFROMXML @ID, @LETTERS, @CHANGEAGENTID, @CURRENTDATE;
        end

        update dbo.MKTSEGMENTATION
        set
            NAMEFORMATPARAMETERID = @NAMEFORMATPARAMETERID,
            ADDRESSPROCESSINGOPTIONID = @ADDRESSPROCESSINGOPTIONID,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where
            ID = @ID;

        declare @SEGMENTATIONACTIVATEPROCESSID uniqueidentifier = (select top(1) ID from dbo.MKTSEGMENTATIONACTIVATEPROCESS where SEGMENTATIONID = @ID);
        declare @EXCLUSIONS xml = (select @EXCLUDEDSOLICITCODESXML.query('/EXCLUDEDSOLICITCODESXML/node()') for xml raw('EXCLUSIONS'),type);

        exec dbo.[USP_BUSINESSPROCESSCOMMPREF_UPDATE]
            @CHANGEAGENTID = @CHANGEAGENTID,
            @BUSINESSPROCESSCATALOGID = '116332AF-BB79-4608-9709-4203BD2BA318',
            @BUSINESSPROCESSPARAMETERSETID = @SEGMENTATIONACTIVATEPROCESSID,
            @EXCLUSIONDATETYPECODE = 0,
            @EXCLUSIONASOFDATE = null,
            @EXCLUDEDECEASED = 1,
            @EXCLUDEINACTIVE = 1,
            @EXCLUSIONS = @EXCLUSIONS,
            @CURRENTAPPUSERID = @CURRENTAPPUSERID;
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;
end