spHideShowContentType

Parameters

Parameter	Parameter Type	Mode
@ID	int	IN
@ClientSitesID	int	IN
@hidden	bit	IN

Definition

Copy



            CREATE procedure dbo.spHideShowContentType
            (
                @ID    int,
                @ClientSitesID int,
                @hidden    bit
            ) as
                set nocount on;
                if exists(select 1 from dbo.ClientContentTypes where ClientsID = @ClientSitesID and ContentTypesID = @ID) begin
                    if @hidden = 1
                        delete from dbo.ClientContentTypes where ClientsID = @ClientSitesID and ContentTypesID = @ID;
                end else begin
                    if (@hidden = 0)
                        insert into dbo.ClientContentTypes (ClientsID, ContentTypesID) values (@ClientSitesID, @ID);
                end