USP_DATAFORMTEMPLATE_EDIT_PAPERLESSMANDATESCONFIGURATION

The save procedure used by the edit dataform template "Paperless Mandates Configuration Edit Data Form".
Parameters

Parameter	Parameter Type	Mode	Description
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@ENABLED	bit	IN	Use paperless mandates
@DAYSADVANCEDNOTICE	int	IN	Days of advanced notice
Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PAPERLESSMANDATESCONFIGURATION (
                    @CHANGEAGENTID uniqueidentifier = null,
                    @ENABLED bit,
                    @DAYSADVANCEDNOTICE integer
                )
                as

                    set nocount on;

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

                    declare @CURRENTDATE datetime
                    set @CURRENTDATE = getdate()

                    begin try

                        if @ENABLED = 1
                        begin
                            if exists(select 1 from dbo.PAPERLESSMANDATESCONFIGURATION)
                            begin
                                update
                                    dbo.PAPERLESSMANDATESCONFIGURATION
                                set
                                    DAYSADVANCEDNOTICE = @DAYSADVANCEDNOTICE,
                                    CHANGEDBYID = @CHANGEAGENTID,
                                    DATECHANGED = @CURRENTDATE
                            end        
                            else
                            begin
                                insert into dbo.PAPERLESSMANDATESCONFIGURATION(
                                    DAYSADVANCEDNOTICE,
                                    ADDEDBYID,
                                    CHANGEDBYID,
                                    DATEADDED,
                                    DATECHANGED
                                )values(
                                    @DAYSADVANCEDNOTICE,
                                    @CHANGEAGENTID,
                                    @CHANGEAGENTID,
                                    @CURRENTDATE,
                                    @CURRENTDATE
                                )
                            end
                        end
                        else
                        begin
                            declare @CONTEXTCACHE varbinary(128);
                            set @CONTEXTCACHE = CONTEXT_INFO();

                            set CONTEXT_INFO @CHANGEAGENTID;

                            delete from dbo.PAPERLESSMANDATESCONFIGURATION

                            if not @CONTEXTCACHE is null
                                set CONTEXT_INFO @contextCache;
                        end

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

                return 0;