USP_DATAFORMTEMPLATE_EDIT_FINANCIALINSTITUTION

The save procedure used by the edit dataform template "Financial Institution Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@FINANCIALINSTITUTION	nvarchar(100)	IN	Institution name
@BRANCHNAME	nvarchar(100)	IN	Branch name
@ROUTINGNUMBER	nvarchar(9)	IN	Routing Number
@ISSPONSORINGINSTITUTION	bit	IN	Is sponsoring institution
@ACCOUNTNAME	nvarchar(50)	IN	Account name
@ACCOUNTNUMBER	nvarchar(17)	IN	Account number
@USERNUMBER	nvarchar(24)	IN	User number
@ADDRESSBLOCK	nvarchar(150)	IN	Address
@CITY	nvarchar(50)	IN	City
@STATEID	uniqueidentifier	IN	State
@POSTCODE	nvarchar(12)	IN	Postal code
@COUNTRYID	uniqueidentifier	IN	Country
@PHONENUMBER	nvarchar(100)	IN	Phone number

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_FINANCIALINSTITUTION
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @FINANCIALINSTITUTION nvarchar(100),
                        @BRANCHNAME nvarchar(100),
                        @ROUTINGNUMBER nvarchar(9),
                        @ISSPONSORINGINSTITUTION bit,
                        @ACCOUNTNAME nvarchar(50),
                        @ACCOUNTNUMBER nvarchar(17),
                        @USERNUMBER nvarchar(24),
                        @ADDRESSBLOCK nvarchar(150),
                        @CITY nvarchar(50),
                        @STATEID uniqueidentifier,
                        @POSTCODE nvarchar(12),
                        @COUNTRYID uniqueidentifier,
                        @PHONENUMBER nvarchar(100)
                    )
                    as
                        set nocount on;

                        declare @CURRENTDATE datetime;

                        begin try
                            if @CHANGEAGENTID is null  
                                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                            set @CURRENTDATE = getdate();

                            -- Sponsoring institution update (account number encryption)

                            if @ISSPONSORINGINSTITUTION = 1
                            begin
                                -- Open the symmetric key for encryption

                                exec dbo.USP_GET_KEY_ACCESS;
                                update dbo.FINANCIALINSTITUTION
                                    set FINANCIALINSTITUTION = @FINANCIALINSTITUTION,
                                    BRANCHNAME = @BRANCHNAME,
                                    ROUTINGNUMBER = @ROUTINGNUMBER,
                                    ISSPONSORINGINSTITUTION = @ISSPONSORINGINSTITUTION,
                                    ACCOUNTNAME = @ACCOUNTNAME,
                                    ACCOUNTNUMBER = EncryptByKey(Key_GUID('sym_BBInfinity'), @ACCOUNTNUMBER),
                                    USERNUMBER = @USERNUMBER,
                                    ADDRESSBLOCK = @ADDRESSBLOCK,
                                    CITY = @CITY ,
                                    STATEID = @STATEID,
                                    POSTCODE = @POSTCODE,
                                    COUNTRYID = @COUNTRYID,
                                    PHONENUMBER = @PHONENUMBER,
                                    DATECHANGED = @CURRENTDATE,
                                    CHANGEDBYID = @CHANGEAGENTID
                                where ID = @ID;
                                close symmetric key sym_BBInfinity;
                            end
                            else
                                update dbo.FINANCIALINSTITUTION
                                    set FINANCIALINSTITUTION = @FINANCIALINSTITUTION,
                                    BRANCHNAME = @BRANCHNAME,
                                    ROUTINGNUMBER = @ROUTINGNUMBER,
                                    ISSPONSORINGINSTITUTION = @ISSPONSORINGINSTITUTION,
                                    ACCOUNTNAME = '',
                                    ACCOUNTNUMBER = '',
                                    USERNUMBER = '',
                                    ADDRESSBLOCK = @ADDRESSBLOCK,
                                    CITY = @CITY ,
                                    STATEID = @STATEID,
                                    POSTCODE = @POSTCODE,
                                    COUNTRYID = @COUNTRYID,
                                    PHONENUMBER = @PHONENUMBER,
                                    DATECHANGED = @CURRENTDATE,
                                    CHANGEDBYID = @CHANGEAGENTID
                                where ID = @ID;

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

                        return 0;