USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTACCOUNT_2

The load procedure used by the edit dataform template "Constituent Financial Account Edit Form 2"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@CONSTITUENTID	uniqueidentifier	INOUT	ConsitutentID
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@FINANCIALINSTITUTIONID	uniqueidentifier	INOUT	Financial institution
@FINANCIALINSTITUTIONBRANCHNAME	nvarchar(100)	INOUT	Branch
@FINANCIALINSTITUTIONROUTINGNUMBER	nvarchar(9)	INOUT	Routing number
@FINANCIALINSTITUTIONSORTCODE	nvarchar(8)	INOUT	Sort code
@ACCOUNTNUMBER	nvarchar(17)	INOUT	Account number
@ACCOUNTTYPE	tinyint	INOUT	Account type
@EFTSTATUSCODE	tinyint	INOUT	EFT status
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTACCOUNT_2
                    (
                    @ID uniqueidentifier,
                    @CONSTITUENTID uniqueidentifier = null output,
                    @DATALOADED bit = 0 output,
                    @FINANCIALINSTITUTIONID uniqueidentifier = null output,
                    @FINANCIALINSTITUTIONBRANCHNAME nvarchar(100) = null output,
                    @FINANCIALINSTITUTIONROUTINGNUMBER nvarchar(9) = null output,
                    @FINANCIALINSTITUTIONSORTCODE nvarchar(8) = null output,
                    @ACCOUNTNUMBER nvarchar(17) = null output,
                    @ACCOUNTTYPE tinyint = null output,
                    @EFTSTATUSCODE tinyint = null output,
                    @TSLONG bigint = 0 output
                    )
                    as
                        set nocount on;

                        set @DATALOADED = 0;
                        set @TSLONG = 0;

                        -- Open the symmetric key for decryption

                        exec dbo.USP_GET_KEY_ACCESS;

                        begin try
                            select 
                                @CONSTITUENTID = [CA].CONSTITUENTID,
                                @DATALOADED = 1,
                                @FINANCIALINSTITUTIONID = [FI].ID,
                                @FINANCIALINSTITUTIONBRANCHNAME = [FI].BRANCHNAME,
                                @FINANCIALINSTITUTIONROUTINGNUMBER = [FI].ROUTINGNUMBER,
                                @FINANCIALINSTITUTIONSORTCODE = [FI].SORTCODE,
                                @ACCOUNTNUMBER = coalesce(convert(nvarchar(50), DecryptByKey([CA].ACCOUNTNUMBER)),''),
                                @ACCOUNTTYPE = [CA].ACCOUNTTYPECODE,
                                @EFTSTATUSCODE = [CA].EFTSTATUSCODE,
                                @TSLONG = [CA].TSLONG
                            from
                                dbo.CONSTITUENTACCOUNT [CA]
                            left join
                                dbo.FINANCIALINSTITUTION [FI]
                            on
                                [FI].ID = [CA].FINANCIALINSTITUTIONID
                            where
                                [CA].ID = @ID;

                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                            return 1;
                        end catch

                        close symmetric key sym_BBInfinity;

                        return 0;