USP_CLONESITE_PAYMENTSUMMARY2

Handles the Payment Summary 2-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_PAYMENTSUMMARY2
    (
      @SourceClientSitesID int,
      @TargetClientSitesID int,
      @CurrentUserID int,
      @CopyBatchGuid uniqueidentifier
    )
    as

      declare @TEMP table(SiteContentID int, X xml, newID uniqueidentifier)

      insert into @TEMP
      select P.SiteContentID, Cast(P.Value as xml), NEWSC.Guid
      from dbo.UFN_GETXMLPROPERTYFORSITECOPY(@CopyBatchGuid,9107, 'BBNCCUSTOM') P
      inner join dbo.SiteContent OLDSC on OLDSC.Guid = Cast(P.Value as XML).value('(/CartSummaryPartSettings/ShoppingCartPartGUID/text())[1]', 'uniqueidentifier')
      inner join dbo.SiteContent NEWSC on NEWSC.CopySourceID = OLDSC.ID and NEWSC.CopyBatchGUID = @CopyBatchGuid

      update @TEMP
      set X.modify('replace value of (CartSummaryPartSettings[1]/ShoppingCartPartGUID[1]/text()[1]) with sql:column("newID")')

      --Update XML Data 

      declare @Data xml
      set @Data = 
      (
        select SiteContentID, '<?xml version="1.0" encoding="utf-16"?>' + cast(X as nvarchar(max)) as Value from @TEMP        
        FOR XML RAW, ELEMENTS
      )    
      exec USP_UPDATEXMLPROPERTYFORSITECOPY 'BBNCCUSTOM', @Data