USP_DATAFORMTEMPLATE_EDIT_EXCHANGECALENDARSYNC_2

The save procedure used by the edit dataform template "Exchange Calendar Synchronization Process Edit Form 2".

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(100)	IN	Name
@DESCRIPTION	nvarchar(250)	IN	Description
@APPUSERIDSETREGISTERID	uniqueidentifier	IN	Selection
@APPLYTOCODE	tinyint	IN	Apply to
@CREATEITEMOPTIONCODE	tinyint	IN
@INCLUDEPENDINGINTERACTIONS	bit	IN	Pending constituent interactions
@INCLUDEPROSPECTPLANSTEPS	bit	IN	Prospect plan steps
@INCLUDEPENDINGSTEWARDSHIPSTEPS	bit	IN	Pending stewardship steps
@EXPECTEDDATEINTERVALCODE	tinyint	IN
@SPECIFICAPPUSERID	uniqueidentifier	IN	User
@PAGEDEFINITIONCATALOGID	uniqueidentifier	IN	Add link to
@DEFAULTREMINDERAMOUNT	int	IN	Reminder

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EXCHANGECALENDARSYNC_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(250),
    @APPUSERIDSETREGISTERID uniqueidentifier,
    @APPLYTOCODE tinyint,
    @CREATEITEMOPTIONCODE tinyint,
    @INCLUDEPENDINGINTERACTIONS bit,
    @INCLUDEPROSPECTPLANSTEPS bit,
    @INCLUDEPENDINGSTEWARDSHIPSTEPS bit,
    @EXPECTEDDATEINTERVALCODE tinyint,
    @SPECIFICAPPUSERID uniqueidentifier,
    @PAGEDEFINITIONCATALOGID uniqueidentifier,                        
    @DEFAULTREMINDERAMOUNT int
)
as
    set nocount on;

    declare @CURRENTDATE datetime;
    declare @CREATEDEFAULTREMINDER bit;

    set @CREATEDEFAULTREMINDER = 0;

    if @DEFAULTREMINDERAMOUNT <> -1 begin
        set @CREATEDEFAULTREMINDER = 1
    end;

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

    set @CURRENTDATE = getdate()

    begin try
        update
            dbo.EXCHANGECALENDARSYNC
        set
            NAME = @NAME,
            DESCRIPTION = @DESCRIPTION,
            APPUSERIDSETREGISTERID = @APPUSERIDSETREGISTERID,
            DATECHANGED = @CURRENTDATE, 
            CHANGEDBYID = @CHANGEAGENTID,
            APPLYTOCODE = @APPLYTOCODE,
            CREATEITEMOPTIONCODE = @CREATEITEMOPTIONCODE,
            INCLUDEPENDINGINTERACTIONS = @INCLUDEPENDINGINTERACTIONS,
            INCLUDEPROSPECTPLANSTEPS = @INCLUDEPROSPECTPLANSTEPS,
            INCLUDEPENDINGSTEWARDSHIPSTEPS = @INCLUDEPENDINGSTEWARDSHIPSTEPS,
            EXPECTEDDATEINTERVALCODE = @EXPECTEDDATEINTERVALCODE,
            SPECIFICAPPUSERID = @SPECIFICAPPUSERID,
            PAGEDEFINITIONCATALOGID = @PAGEDEFINITIONCATALOGID,
            CREATEDEFAULTREMINDER = @CREATEDEFAULTREMINDER,
            DEFAULTREMINDERAMOUNT = @DEFAULTREMINDERAMOUNT
        where
            EXCHANGECALENDARSYNC.ID = @ID;                    
    end try

    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;