USP_DATAFORMTEMPLATE_ADD_BANKBANKACCOUNT_PRELOAD

The load procedure used by the edit dataform template "Bank Bank Account Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@BANKID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@BANKDEFAULTROUTINGNUMBER	nvarchar(9)	INOUT	Default routing number
@BANKDEFAULTSORTCODE	nvarchar(6)	INOUT	Default sort code
@SORTCODE	nvarchar(6)	INOUT	Sort code
@ROUTINGNUMBER	nvarchar(9)	INOUT	Routing number
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT	Account system
@UKINSTALLED	bit	INOUT	UK Installed
@SHOWACCOUNTSYSTEM	bit	INOUT	Show Account System
@BANKINGSYSTEMID	uniqueidentifier	INOUT

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_BANKBANKACCOUNT_PRELOAD
                    (
                        @BANKID uniqueidentifier,                                                
                        @BANKDEFAULTROUTINGNUMBER nvarchar(9) = null output,
                        @BANKDEFAULTSORTCODE nvarchar(6) = null output,
                        @SORTCODE nvarchar(6) = null output,
                        @ROUTINGNUMBER nvarchar(9) = null output,
                        @CURRENTAPPUSERID uniqueidentifier = null,
                        @PDACCOUNTSYSTEMID uniqueidentifier = null output,
                        @UKINSTALLED  bit = null output,
                        @SHOWACCOUNTSYSTEM bit = null output,
                        @BANKINGSYSTEMID uniqueidentifier = null output
                    )
                    as
                        set nocount on;

                        -- populate the fields that have default values that should be fetched from the database
                        set @BANKDEFAULTROUTINGNUMBER = dbo.UFN_BANKACCOUNT_GETROUTINGNUMBER(@BANKID)
                        set @BANKDEFAULTSORTCODE = (select DEFAULTSORTCODE from dbo.BANK where ID = @BANKID)
                        if dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('9568A6C2-F7AA-45fd-8F54-21FE9654EE2D') = 1
                            set @SORTCODE = @BANKDEFAULTSORTCODE;
                        else
                            set @ROUTINGNUMBER = @BANKDEFAULTROUTINGNUMBER;

                        declare    @NUMBEROFACCOUNTSYSTEMSFORUSER smallint;

                        if dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('9568A6C2-F7AA-45FD-8F54-21FE9654EE2D') = 1
                            set @UKINSTALLED = 1;

                        set @NUMBEROFACCOUNTSYSTEMSFORUSER = dbo.UFN_PDACCOUNTSYSTEM_GETNUMBEROFSYSTEMSFORUSER(@CURRENTAPPUSERID);
                        if @NUMBEROFACCOUNTSYSTEMSFORUSER = 1
                            begin
                                set @SHOWACCOUNTSYSTEM = 0;
                                select @PDACCOUNTSYSTEMID = T1.ID from dbo.UFN_PDACCOUNTSYSTEM_GETSYSTEMIDSFORUSER(@CURRENTAPPUSERID) as T1;
                            end 
                        else
                            begin
                              set @SHOWACCOUNTSYSTEM = 1;
                              set @PDACCOUNTSYSTEMID = dbo.UFN_PDACCOUNTSYSTEM_GETDEFAULTSYSTEMIDSFORUSER(@CURRENTAPPUSERID);
                            end

                        exec dbo.USP_BANKINGSYSTEM_GETDEFAULT @DEFAULTBANKINGSYSTEMID = @BANKINGSYSTEMID output;

                        return 0;