spAddEditDelCssClass

-- To add a new class: exec spAddEditDelCssClass '.newclass', 121, 'width: 465px;?

-- To modify a class: exec spAddEditDelCssClass '.existingclass', 121, 'width: 465px;?

-- To delete a class: exec spAddEditDelCssClass '.existingclass', 121 , @style=null, @toDelete = 1


CREATE procedure dbo.spAddEditDelCssClass(
    @className nvarchar(510),
    @contentTypeID int,
    @style nvarchar(4000),
    @inheritsClass nvarchar(510) = null,
    @toDelete bit = 0
) as
begin
    if Len(@className) = 0 or @contentTypeID is null
        raiserror('@className and @contentTypeID are required.', 13, 1);

    if @toDelete = 1
    begin
        delete from dbo.CSSClasses
        where ClassName = @className and ContentTypeID = @contentTypeID;

        return;
    end

    if not exists(select 1 from dbo.CSSClasses where ClassName = @className and ContentTypeID = @contentTypeID)
        insert CSSClasses (ClassName, ContentTypeID, BBDefaultCSS, InheritsClass)
        values (@className, @contentTypeID, @style, @inheritsClass);
    else
        update CSSClasses set
            BBDefaultCSS = @style,
            InheritsClass = isnull(@inheritsClass, InheritsClass)
        where ClassName = @className and ContentTypeID = @contentTypeID;

end