spClone_SiteStyleSheets

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@NewName	nvarchar(50)	IN
@NewGuid	uniqueidentifier	IN
Definition

Copy

                 CREATE procedure [dbo].[spClone_SiteStyleSheets]
            (
            @PKID     int output,
            @CurrentUsersID int,
            @NewName  nvarchar(50),
            @NewGuid  uniqueidentifier
          )
          as  
            insert into dbo.SiteStyleSheets
              (
              Guid,
              ClientSitesID,
              Name,
              Description,
              CustomCSS,
              OwnerID,
              Deleted,
              CustomCssXml,
              MediaType,
              BrowserType
            )
            select
              @NewGuid,
              ClientSitesID,
              @NewName,
              Description,
              CustomCSS,
              @CurrentUsersID,
              Deleted,
              CustomCssXml,
              MediaType,
              BrowserType
            from
              dbo.SiteStyleSheets
            where
              ID = @PKID;

            declare @OldID int;
              select  @OldID = @PKID;
            select  @PKID  = @@Identity;

              insert into dbo.StyleSheetClasses
            (
                StyleSheetID,
                CSSClassID,
                CSS
              ) 
            select 
                @PKID,
                CSSClassID,
                CSS
              from
                dbo.StyleSheetClasses
              where 
              StyleSheetID = @OldID;

            DECLARE @OldGuid uniqueidentifier
            SELECT @OldGuid=Guid FROM SiteStyleSheets WHERE ID = @OldID

            exec spClone_RoleObjectPrivs @OldGuid, @NewGuid