USP_CLONESITE_TRANSACTIONMANAGER

Handles the Transaction Manager-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_TRANSACTIONMANAGER
(
@SourceClientSitesID int,
@TargetClientSitesID int,
@CurrentUserID int,
@CopyBatchGuid uniqueidentifier
)
as


    insert into dbo.GivingHistory2 (SiteContentID, GiftTypes, Campaigns, Funds, Appeals, GiftQueryID, IncludeSoftCredit, ResultsPerPage, UseCustomFilter, UseCustomColumn, IncludePending, IncludeSummary, IncludeGiftTotal, IncludeGiftAidTotal, IncludePendingTotal, IncludePledgeTotal, IncludeBalanceTotal, IncludeTotalsCurrency, PledgePaymentPageID)
    select 
    SC.ID,
    GiftTypes,
    Campaigns,
    Funds,
    Appeals,
    GiftQueryID,
    IncludeSoftCredit,
    ResultsPerPage,
    UseCustomFilter,
    UseCustomColumn,
    IncludePending,
    IncludeSummary,
    IncludeGiftTotal,
    IncludeGiftAidTotal,
    IncludePendingTotal,
    IncludePledgeTotal,
    IncludeBalanceTotal,
    IncludeTotalsCurrency,
    PledgePaymentPageID
    from dbo.GivingHistory2 GH
    inner join dbo.SiteContent SC on SC.CopySourceID = GH.SiteContentID    
    where SC.CopyBatchGuid = @CopyBatchGuid


    --Update XML Data

    declare @Data xml
    set @Data = 
    (
        select P.SiteContentID, GH.ID as Value
        from dbo.UFN_GETXMLPROPERTYFORSITECOPY(@CopyBatchGuid,118, 'ClientGivingHistory2ID') P
        inner join dbo.GivingHistory2 GH on GH.SiteContentID = P.SiteContentID
        FOR XML RAW, ELEMENTS
    )    
    exec USP_UPDATEXMLPROPERTYFORSITECOPY 'ClientGivingHistory2ID', @Data