spAddUpdate_QuickSearchPart

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@SiteContentID	int	IN
@CurrentUsersID	int	IN
@Name	nvarchar(100)	IN
@SearchCaption	nvarchar(100)	IN
@DestinationPageID	int	IN
@Guid	uniqueidentifier	IN

Definition

Copy



        CREATE     PROCEDURE dbo.spAddUpdate_QuickSearchPart
        (
            @PKID                int output,
            @SiteContentID        int,    
            @CurrentUsersID        int,
            @Name                nvarchar(100),
            @SearchCaption        nvarchar(100)    ,
            @DestinationPageID    int                ,
            @Guid                uniqueidentifier
        )
        AS

        begin transaction

        if (@PKID<=0)

        begin

            INSERT INTO QuickSearchPart
            (
            [Name],
            [SiteContentID],
            [SearchCaption],
            [DestinationPageID],
            [Guid]
            )
            VALUES
            (
            @Name,
            @SiteContentID,
            @SearchCaption,
            @DestinationPageID,
            @Guid
            )

            SELECT @PKID = @@Identity

            exec spAuditThis @CurrentUsersID, 1, @Guid, 20
        end 
        else 
        begin

            UPDATE QuickSearchPart SET
                [Name]                =@Name,
                [SearchCaption]        =@SearchCaption,
                [DestinationPageID] =@DestinationPageID,
                [Guid]                =@Guid
            WHERE ID=@PKID
            exec spAuditThis @CurrentUsersID, 2, @Guid, 20
        end

        commit transaction