USP_DATAFORMTEMPLATE_ADD_BANKACCOUNT_PRELOAD

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

Parameters

Parameter	Parameter Type	Mode	Description
@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_BANKACCOUNT_PRELOAD
        (
            @CURRENTAPPUSERID uniqueidentifier = null,
            @PDACCOUNTSYSTEMID uniqueidentifier = null output,
            @UKINSTALLED  bit = null output,
            @SHOWACCOUNTSYSTEM bit = null output,
            @BANKINGSYSTEMID uniqueidentifier = null output
        )
        as
            set nocount on;
            declare    @NUMBEROFACCOUNTSYSTEMSFORUSER smallint 
            declare @NUMBEROFACCOUNTSYSTEMS smallint    
            select @NUMBEROFACCOUNTSYSTEMS = count(ID) from PDACCOUNTSYSTEM

            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;