USP_DATAFORMTEMPLATE_ADD_BANKACCOUNTAUTHORIZEDSIGNATURE

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@BANKACCOUNTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@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_ADD_BANKACCOUNTAUTHORIZEDSIGNATURE
            (
                @ID uniqueidentifier = null output,
                @BANKACCOUNTID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @AUTOSIGNATURECODE tinyint = 1,
                @NOTES nvarchar(255) = '',
                @SIGNATUREID uniqueidentifier = null,
                @MANUALSIGNATURENAME nvarchar(255) = ''
            )
            as

            set nocount on;

            if @ID is null
            set @ID = newid()

            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 inserting the data

            insert into dbo.BANKACCOUNTAUTHORIZEDSIGNATURE
                (ID, BANKACCOUNTID, AUTOSIGNATURECODE, NOTES,    SIGNATUREID, MANUALSIGNATURENAME, 
                ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
            values
                (@ID, @BANKACCOUNTID, @AUTOSIGNATURECODE, @NOTES,    @SIGNATUREID, @MANUALSIGNATURENAME,
                @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)

            end try

            begin catch
                exec dbo.USP_RAISE_ERROR
                return 1
            end catch

            return 0