USP_DATEFORTEMPLATE_ADD_MISCELLANEOUSPAYMENT_PRELOAD

The load procedure used by the edit dataform template "Miscellaneous Payment Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@PAYMENTMETHODCODE	tinyint	INOUT	Payment method
@DEPOSITID	uniqueidentifier	INOUT	Deposit
@OTHERPAYMENTMETHODCODEID	uniqueidentifier	INOUT	Other method
@CREDITTYPECODEID	uniqueidentifier	INOUT	Card type
@OTHERPAYMENTMETHODCODE	nvarchar(100)	INOUT	Other method description
@CREDITTYPECODE	nvarchar(100)	INOUT	Credit type description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT	Account system
@SHOWACCOUNTSYSTEM	bit	INOUT	Show Account System
@SHOWDEPOSIT	bit	INOUT	Show Deposit
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Transaction currency

Definition

Copy



                    CREATE procedure dbo.USP_DATEFORTEMPLATE_ADD_MISCELLANEOUSPAYMENT_PRELOAD
                    (
                        @PAYMENTMETHODCODE tinyint = null output,
                        @DEPOSITID uniqueidentifier = null output,
                        @OTHERPAYMENTMETHODCODEID uniqueidentifier = null output,
                        @CREDITTYPECODEID uniqueidentifier = null output,
                        @OTHERPAYMENTMETHODCODE nvarchar(100) = null output,
                        @CREDITTYPECODE nvarchar(100) = null output,
                        @CURRENTAPPUSERID uniqueidentifier = null,
                        @PDACCOUNTSYSTEMID uniqueidentifier = null output,
                        @SHOWACCOUNTSYSTEM bit = null output,
                        @SHOWDEPOSIT bit = null output,
                        @TRANSACTIONCURRENCYID uniqueidentifier = null output
                    )
                    as
                        set nocount on;

                        -- populate the fields that have default values that should be fetched from the database

                        set @PAYMENTMETHODCODE = 0;
                        set @SHOWDEPOSIT = 1

                        if @DEPOSITID is not null
                            begin
                                select 
                                    @OTHERPAYMENTMETHODCODEID=a.OTHERPAYMENTMETHODCODEID,
                                    @CREDITTYPECODEID=a.CREDITTYPECODEID,
                                    @OTHERPAYMENTMETHODCODE=(select DESCRIPTION from OTHERPAYMENTMETHODCODE where ID = @OTHERPAYMENTMETHODCODEID ),
                                    @CREDITTYPECODE=(select DESCRIPTION from CREDITTYPECODE where ID = @CREDITTYPECODEID ),
                                    @PDACCOUNTSYSTEMID = c.PDACCOUNTSYSTEMID
                                from
                                    dbo.BANKACCOUNTDEPOSIT as a 
                                join BANKACCOUNTTRANSACTION as b on a.ID = b.ID
                                join BANKACCOUNT as c on b.BANKACCOUNTID = c.ID
                                where
                                    a.ID=@DEPOSITID

                                set @SHOWACCOUNTSYSTEM = 0
                            end
                        else
                            begin
                                declare    @NUMBEROFACCOUNTSYSTEMSFORUSER smallint 

                                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
                            end
                            if @PDACCOUNTSYSTEMID is not null
                                select @TRANSACTIONCURRENCYID =  CURRENCYSET.BASECURRENCYID from dbo.PDACCOUNTSYSTEM inner join dbo.CURRENCYSET on CURRENCYSET.ID = PDACCOUNTSYSTEM.CURRENCYSETID where PDACCOUNTSYSTEM.ID = @PDACCOUNTSYSTEMID;

                        if dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('133F9BCA-00F1-4007-9792-586B931340C6') = 0
                            set @SHOWACCOUNTSYSTEM = 0

                        return 0;