USP_DATAFORMTEMPLATE_EDIT_PARTIALINFORMATIONSEARCHURL

The save procedure used by the edit dataform template "Prospect Quick Search URL Edit Form".
Parameters

Parameter	Parameter Type	Mode	Description
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@PARTIALINFORMATIONSEARCHURL	UDT_WEBADDRESS	IN	Prospect Quick Search URL
Definition

Copy

                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PARTIALINFORMATIONSEARCHURL (
                        @CHANGEAGENTID uniqueidentifier = null,
                        @PARTIALINFORMATIONSEARCHURL dbo.UDT_WEBADDRESS
                    ) as
                        set nocount on;

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

                        declare @CURRENTDATE datetime;
                        set @CURRENTDATE = getdate();

                        begin try
                            declare @ID uniqueidentifier;
                            select top 1
                                @ID = PISC.[ID]
                            from
                                dbo.[PARTIALINFORMATIONSEARCHCONFIGURATION] PISC;

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

                    return 0;