USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNTAUTHORIZEDSIGNATURE

The save procedure used by the edit dataform template "Bank Account Authorized Signature Edit Data Form".

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.
@AUTOSIGNATURECODE	tinyint	IN	Allow auto-signatures
@NOTES	nvarchar(255)	IN	Notes
@SIGNATUREID	uniqueidentifier	IN	Signature name
@MANUALSIGNATURENAME	nvarchar(255)	IN	Name

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNTAUTHORIZEDSIGNATURE (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @AUTOSIGNATURECODE tinyint,
                @NOTES nvarchar(255),
                @SIGNATUREID uniqueidentifier,
                @MANUALSIGNATURENAME nvarchar(255)          
            )
            as

                set nocount on;

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

                declare @CURRENTDATE datetime
                set @CURRENTDATE = getdate()

                if @AUTOSIGNATURECODE = 1
                    set @MANUALSIGNATURENAME = ''
                else
                    set @SIGNATUREID = null

                begin try
                    -- handle updating the data

                    update dbo.BANKACCOUNTAUTHORIZEDSIGNATURE set
                        AUTOSIGNATURECODE = @AUTOSIGNATURECODE,
                        NOTES = @NOTES,
                        SIGNATUREID = @SIGNATUREID,    
                        MANUALSIGNATURENAME = @MANUALSIGNATURENAME,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE 
                    where ID = @ID
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1
                end catch

            return 0;