spAddUpdate_SiteLayouts

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@ClientSitesID	int	IN
@Name	nvarchar(255)	IN
@Description	nvarchar(255)	IN
@Content	ntext	IN
@StyleSheetID	int	IN
@DocType	int	IN
@Guid	uniqueidentifier	INOUT

Definition

Copy



CREATE        PROCEDURE dbo.spAddUpdate_SiteLayouts
(
       @PKID        int output,
       @CurrentUsersID    int,        
    @ClientSitesID    int,
    @Name    nvarchar(255),
    @Description    nvarchar(255),
    @Content    ntext,
    @StyleSheetID    int,
    @DocType    int,
    @Guid uniqueidentifier output
)
AS

if (@PKID<=0) begin

    INSERT INTO SiteLayouts
    (
        ClientSitesID    ,
        Name    ,
        Description    ,
        Content    ,
        StyleSheetID    ,
        OwnerID,
        DocType
    )

    VALUES
    (
        @ClientSitesID    ,
        @Name    ,
        @Description    ,
        @Content    ,
        @StyleSheetID    ,
        @CurrentUsersID ,
        @DocType

    )

    SELECT @PKID = @@Identity

    select @Guid = Guid from SiteLayouts where ID = @PKID

    exec spAuditThis @CurrentUsersID, 1, @Guid, 3

    end 
else 
    begin

    UPDATE SiteLayouts SET
        ClientSitesID=@ClientSitesID,
        Name=@Name    ,
        Description=@Description    ,
        Content=@Content    ,
        StyleSheetid=@StyleSheetid,
        DocType=@DocType
    WHERE ID=@PKID

    select @Guid = Guid from SiteLayouts where ID = @PKID

    exec spAuditThis @CurrentUsersID, 2, @Guid, 3

  end