USP_STYLESHEETCLASSES_ADD_EDIT

Add or update a css class of a stylesheet

Parameters

Parameter	Parameter Type	Mode
@SiteStyleSheetsID	int	IN
@ClassName	nvarchar(255)	IN
@Css	nvarchar(2046)	IN

Definition

Copy



create procedure dbo.USP_STYLESHEETCLASSES_ADD_EDIT(
    @SiteStyleSheetsID int,  
    @ClassName nvarchar(255),  
    @Css nvarchar(2046)  
)
as
    set nocount on; 

    declare @sheetClassID int
    set @sheetClassID = 0

    select top 1 @sheetClassID = sc.ID from dbo.StyleSheetClasses sc
        inner join dbo.CSSClasses c on sc.CSSClassID = c.ID
        where sc.StyleSheetID = @SiteStyleSheetsID and c.ClassName = @ClassName

      if @sheetClassID > 0
          update dbo.StyleSheetClasses set CSS = @Css where ID = @sheetClassID
      else
          insert into dbo.StyleSheetClasses (StyleSheetID, CSSClassID, CSS)  
          select @SiteStyleSheetsID, CssClasses.ID, @Css  
          from dbo.CssClasses  
          where CssClasses.ClassName = @ClassName;  
      return 0;