USP_CLONESITE_DOCUMENTS

Handles the Documents-specific steps for cloning a CMS site.

Parameters

Parameter	Parameter Type	Mode
@SourceClientSitesID	int	IN
@TargetClientSitesID	int	IN
@CurrentUserID	int	IN
@CopyBatchGuid	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_CLONESITE_DOCUMENTS
(
@SourceClientSitesID int,
@TargetClientSitesID int,
@CurrentUserID int,
@CopyBatchGuid uniqueidentifier
)
as


    insert into dbo.DocUploadPart (SiteContentID,Name,Description,MaxSize,UploadCaption,RequiresApproval,Guid,SITEFOLDERID)
    select
    SC.ID,
    DUP.Name,
    DUP.Description,
    DUP.MaxSize,
    DUP.UploadCaption,
    DUP.RequiresApproval,
    NEWID(),
    SF.FOLDERID
    from dbo.DocUploadPart DUP
    inner join dbo.SiteContent SC on SC.CopySourceID = DUP.SiteContentID
    left outer join dbo.SITEFOLDERS SF on SF.COPYSOURCEID = DUP.SITEFOLDERID and SF.COPYBATCHGUID = @COPYBATCHGUID

    where SC.CopyBatchGUID = @CopyBatchGuid

    --Update XML Data

    declare @Data xml
    set @Data = 
    (
        select P.SiteContentID, DUP.ID as Value
        from dbo.UFN_GETXMLPROPERTYFORSITECOPY(@CopyBatchGuid,55, 'ClientDocUploadID') P
        inner join dbo.DocUploadPart DUP on DUP.SiteContentID = P.SiteContentID
        FOR XML RAW, ELEMENTS
    )    
    exec USP_UPDATEXMLPROPERTYFORSITECOPY 'ClientDocUploadID', @Data