spAddUpdate_ContentTypes

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@Name	nvarchar(128)	IN
@DesktopSrc	nvarchar(256)	IN
@EditControl	nvarchar(256)	IN
@ClassName	nvarchar(256)	IN
@Static	bit	IN
@AutoInstall	bit	IN

Definition

Copy


                CREATE   PROCEDURE dbo.spAddUpdate_ContentTypes
(
        @PKID        int output,
        @CurrentUsersID    int,        
    @Name        nvarchar(128),
    @DesktopSrc    nvarchar(256),
    @EditControl    nvarchar(256),
    @ClassName    nvarchar(256),
    @Static        bit,
    @AutoInstall    bit
)
AS

if (@PKID<=0) begin

INSERT INTO ContentTypes
(
    Name        ,
    DesktopSrc    ,
    EditControl    ,
    ClassName    ,
    Static        ,
    AutoInstall    
)

VALUES
(
    @Name        ,
    @DesktopSrc    ,
    @EditControl    ,
    @ClassName    ,
    @Static        ,
    @AutoInstall    
)

SELECT
    @PKID = @@Identity

    /*exec spAuditThis @CurrentUsersID, 1, @Guid, 2*/

end else begin

    UPDATE ContentTypes SET
    Name=@Name        ,
    DesktopSrc=@DesktopSrc    ,

    EditControl=@EditControl    ,
    ClassName=@ClassName    ,
    Static=@Static        ,
    AutoInstall=@AutoInstall    
    WHERE ID=@PKID

    /*exec spAuditThis @CurrentUsersID, 2, @Guid, 2*/

end