spAddUpdate_SearchPart

Parameters

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

Definition

Copy


        CREATE PROCEDURE [dbo].[spAddUpdate_SearchPart]
        (
            @PKID                int output,
            @SiteContentID        int,    
            @CurrentUsersID        int,
            @Name                nvarchar(100)    ,
            @Description        nvarchar(1024)    ,
            @SearchCaption        nvarchar(100)    ,
            @SiteSearchType        int,
            @Guid                uniqueidentifier
        )
        AS

        begin transaction

        if (@PKID<=0)

        begin

            INSERT INTO SearchPart
            (
            [SiteContentID],
            [Name],
            [Description],
            [SearchCaption],
            [SiteSearchType],
            [Guid]
            )
            VALUES
            (
            @SiteContentID,
            @Name,
            @Description,
            @SearchCaption,
            @SiteSearchType,
            @Guid
            )

            SELECT @PKID = @@Identity

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

            UPDATE SearchPart SET
                [Name]                =@Name,
                [Description]        =@Description,
                [SearchCaption]        =@SearchCaption,
                [Guid]                =@Guid,
                [SiteSearchType]    =@SiteSearchType
            WHERE ID=@PKID
            exec spAuditThis @CurrentUsersID, 2, @Guid, 20
        end

        commit transaction