USP_CLONESITE_SPONSORSHIPFORM

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

    declare @CHANGEAGENTID uniqueidentifier
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output                
    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    insert into dbo.SPONSORSHIPFORMCMSSETTINGS
    (
    ID,
    CHILDDISPLAYHTML,
    PROJECTDISPLAYHTML,
    ATTRIBUTEITEMSLIST,
    DESIGNATIONLIST,
    DEFAULTDESIGNATIONID,
    DEFAULTDESIGNATION,
    APPEALSLIST,
    REQUIREAPPEAL,
    SOLESPONSORSHIPENABLED,
    GIFTSPONSORSHIPENABLED,
    ECARDSENABLED,
    ADDITIONALGIFTENABLED,
    MULTIPLEGIFTSENABLED,
    MINIMUMGIFTAMOUNT,
    CONSTITUENCYID,
    GENERALRECURRENCEENABLED,
    SCHEDULEDENDDATEENABLED,
    RECURRENCEDATAIDLIST,
    ITEMEXPIRATION,
    PAYMENTPARTPAGE,
    DIRECTDEBITENABLED,
    ADDEDBYID,
    CHANGEDBYID,
    DATEADDED,
    DATECHANGED,
    CHECKENABLED,
    FORMITEMEXPIRATION,
    ACKNOWLEDGEMENTHTML
    )
    select
    NSC.Guid,
    dbo.UFN_UPDATECOPYCONTENTHTML(CHILDDISPLAYHTML, @CopyBatchGuid),
    dbo.UFN_UPDATECOPYCONTENTHTML(PROJECTDISPLAYHTML, @CopyBatchGuid),
    ATTRIBUTEITEMSLIST,
    DESIGNATIONLIST,
    DEFAULTDESIGNATIONID,
    DEFAULTDESIGNATION,
    APPEALSLIST,
    REQUIREAPPEAL,
    SOLESPONSORSHIPENABLED,
    GIFTSPONSORSHIPENABLED,
    ECARDSENABLED,
    ADDITIONALGIFTENABLED,
    MULTIPLEGIFTSENABLED,
    MINIMUMGIFTAMOUNT,
    CONSTITUENCYID,
    GENERALRECURRENCEENABLED,
    SCHEDULEDENDDATEENABLED,
    RECURRENCEDATAIDLIST,
    ITEMEXPIRATION,
    ISNULL(SP.ID, PAYMENTPARTPAGE) as PAYMENTPARTPAGE,
    DIRECTDEBITENABLED,
    @CHANGEAGENTID,
    @CHANGEAGENTID,
    @CURRENTDATE,
    @CURRENTDATE,
    CHECKENABLED,
    FORMITEMEXPIRATION,
    dbo.UFN_UPDATECOPYCONTENTHTML(ACKNOWLEDGEMENTHTML, @CopyBatchGuid)
    from dbo.SPONSORSHIPFORMCMSSETTINGS SF
    inner join dbo.SiteContent OSC on OSC.Guid = SF.ID
    inner join dbo.SiteContent NSC on NSC.CopySourceID = OSC.ID
    left outer join dbo.SitePages SP on SP.CopySourceID = SF.PAYMENTPARTPAGE AND SP.CopyBatchGUID = @CopyBatchGuid
    where NSC.CopyBatchGUID = @CopyBatchGuid

    --Update XML Data

    declare @Data xml

    set @Data = 
    (
        select P.SiteContentID, ECP.ID as Value
        from dbo.UFN_GETXMLPROPERTYFORSITECOPY(@CopyBatchGuid,9103, 'ECardPartID') P
        inner join dbo.EcardPart ECP on ECP.SiteContentID = P.SiteContentID
        FOR XML RAW, ELEMENTS
    )    
    exec USP_UPDATEXMLPROPERTYFORSITECOPY 'ECardPartID', @Data