USP_DATAFORMTEMPLATE_EDIT_R68ONLINESUBMISSIONGATEWAYSETTINGS

                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_R68ONLINESUBMISSIONGATEWAYSETTINGS 
                    (
                        @CHANGEAGENTID uniqueidentifier = null,
                        @GATEWAYSETTINGSID uniqueidentifier,
                        @GATEWAYCODE tinyint
                    )
                    as

                        set nocount on;

                        if @CHANGEAGENTID is null  
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                        declare @CURRENTDATE datetime
                        set @CURRENTDATE = getdate()

                        begin try
                            if @GATEWAYSETTINGSID is null
                            begin
                                insert into dbo.R68ONLINESUBMISSIONGATEWAYSETTINGS
                                    (ID, GATEWAYCODE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                                values
                                    (newid(), @GATEWAYCODE, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
                            end
                            else
                            begin
                                update dbo.R68ONLINESUBMISSIONGATEWAYSETTINGS 
                                set
                                    GATEWAYCODE = @GATEWAYCODE,
                                    CHANGEDBYID = @CHANGEAGENTID,
                                    DATECHANGED = @CURRENTDATE
                                where ID = @GATEWAYSETTINGSID
                            end
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR
                            return 1
                        end catch

                    return 0;