USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS_1

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SEARCHRESULTHTML	nvarchar(max)	IN
@SEARCHCRITERIADESIGNCODE	tinyint	IN
@HTMLSEARCHRESULTCODE	tinyint	IN
@SHOWPAGINGCONTROLSCODE	tinyint	IN
@AUTOSEARCHENABLED	bit	IN
@SEARCHCOLUMNS	int	IN
@SIMPLEFIELDSLIST	xml	IN
@ADVANCEDFIELDSLIST	xml	IN
@OUTPUTFIELDSLIST	xml	IN
@RECORDSPERPAGE	int	IN
@COLUMNSPERPAGE	int	IN
@RESULTSPERSESSION	int	IN
@QUERYVIEWID	uniqueidentifier	IN
@QUERYID	uniqueidentifier	IN
@SPONSORSHIPFORMPAGEID	int	IN
@RESULTSFROMQUERY	int	IN

Definition

Copy


            create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS_1
            (
                  @ID uniqueidentifier,
                  @CHANGEAGENTID uniqueidentifier = null,
                @SEARCHRESULTHTML nvarchar(max),
                @SEARCHCRITERIADESIGNCODE tinyint,
                @HTMLSEARCHRESULTCODE tinyint,
                @SHOWPAGINGCONTROLSCODE tinyint,
                @AUTOSEARCHENABLED bit,
                @SEARCHCOLUMNS int,
                @SIMPLEFIELDSLIST xml,
                @ADVANCEDFIELDSLIST xml,
                @OUTPUTFIELDSLIST xml,
                @RECORDSPERPAGE int,
                @COLUMNSPERPAGE int,
                @RESULTSPERSESSION int,
                @QUERYVIEWID uniqueidentifier,
                @QUERYID uniqueidentifier,
                @SPONSORSHIPFORMPAGEID int,
                @RESULTSFROMQUERY int
            )
            as

                set nocount on;

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

                begin try
                    -- handle updating the data
                    update dbo.SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS set
                        SEARCHRESULTHTML = @SEARCHRESULTHTML,
                        SEARCHCRITERIADESIGNCODE = @SEARCHCRITERIADESIGNCODE,
                        HTMLSEARCHRESULTCODE = @HTMLSEARCHRESULTCODE,
                        SHOWPAGINGCONTROLSCODE = @SHOWPAGINGCONTROLSCODE,
                        AUTOSEARCHENABLED = @AUTOSEARCHENABLED,
                        SEARCHCOLUMNS = @SEARCHCOLUMNS,
                        SIMPLEFIELDSLIST = @SIMPLEFIELDSLIST,
                        ADVANCEDFIELDSLIST = @ADVANCEDFIELDSLIST,
                        OUTPUTFIELDSLIST = @OUTPUTFIELDSLIST,
                        RECORDSPERPAGE = @RECORDSPERPAGE,
                        COLUMNSPERPAGE = @COLUMNSPERPAGE,
                        RESULTSPERSESSION = @RESULTSPERSESSION,
                        QUERYVIEWID = @QUERYVIEWID,
                        QUERYID = @QUERYID,
                        SPONSORSHIPFORMPAGEID = @SPONSORSHIPFORMPAGEID,
                              CHANGEDBYID = @CHANGEAGENTID,
                              DATECHANGED = getdate(),
                        RESULTSFROMQUERY = @RESULTSFROMQUERY
                    where ID = @ID
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1
                end catch

            return 0;