USP_CLONESITE_PAYMENTSUMMARY

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


    --Insert new entries in teh ShoppingCartSummaryPart table

    insert into dbo.ShoppingCartSummaryPart (SiteContentID, ShoppingCartPartID)
    select
    SC.ID,
    ShoppingCartPartID
    from dbo.ShoppingCartSummaryPart SCSP
    inner join dbo.SiteContent SC on SC.CopySourceID = SCSP.SiteContentID and SC.CopyBatchGUID = @CopyBatchGuid    

    --Update the ShoppingCartPartID in the above entries if those parts were copied as well

    update SCSP
    set ShoppingCartPartID = CopiedCart.ID
    from dbo.ShoppingCartSummaryPart SCSP
    inner join dbo.SiteContent SC on SC.ID = SCSP.SiteContentID and SC.CopyBatchGUID = @CopyBatchGuid    
    inner join dbo.ShoppingCartPart SCP on SCP.ID = SCSP.ShoppingCartPartID
    inner join dbo.SiteContent CartSC on CartSC.CopySourceID = SCP.SiteContentID and CartSC.CopyBatchGUID = @CopyBatchGuid     
    inner join dbo.ShoppingCartPart CopiedCart on CopiedCart.SiteContentID = CartSC.ID

    --Update XML Data

    declare @Data xml
    set @Data = 
    (
        select P.SiteContentID, SCSP.ID as Value
        from dbo.UFN_GETXMLPROPERTYFORSITECOPY(@CopyBatchGuid,113, 'ShoppingCartSummaryPartID') P
        inner join dbo.ShoppingCartSummaryPart SCSP on SCSP.SiteContentID = P.SiteContentID
        FOR XML RAW, ELEMENTS
    )    
    exec USP_UPDATEXMLPROPERTYFORSITECOPY 'ShoppingCartSummaryPartID', @Data