spAddUpdate_SiteStylesheets

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@ClientSitesID	int	IN
@Name	nvarchar(255)	IN
@Description	nvarchar(255)	IN
@Guid	uniqueidentifier	INOUT
@MediaType	nvarchar(max)	IN
@BrowserType	uniqueidentifier	IN

Definition

Copy



CREATE      PROCEDURE [dbo].[spAddUpdate_SiteStylesheets]
(
       @PKID        int output,
       @CurrentUsersID    int,        
    @ClientSitesID    int,
    @Name    nvarchar(255),
    @Description    nvarchar(255),
    @Guid uniqueidentifier output,
    @MediaType    nvarchar(max) = NULL,
    @BrowserType uniqueidentifier = NULL

)
AS

if (@PKID<=0) begin

    INSERT INTO SiteStyleSheets
    (
        ClientSitesID    ,
        Name    ,
        Description    ,
        OwnerID,
        MediaType,
        BrowserType
    )

    VALUES
    (
        @ClientSitesID    ,
        @Name    ,
        @Description    ,
        @CurrentUsersID ,
        @MediaType,
        @BrowserType
    )

    SELECT @PKID = @@Identity

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

    exec spAuditThis @CurrentUsersID, 1, @Guid, 30

    end 
else 
    begin

    UPDATE SiteStylesheets SET
        ClientSitesID=@ClientSitesID,
        Name=@Name    ,
        Description=@Description,
        MediaType = @MediaType,
        BrowserType = @BrowserType,
        UpdateDate = getutcdate()
    WHERE ID=@PKID

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

    exec spAuditThis @CurrentUsersID, 2, @Guid, 30

end