USP_CLONESITE_ECARDTEMPLATES

Used by CMS site copy to copy eCard templates.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_CLONESITE_ECARDTEMPLATES
(
@SourceClientSitesID int,
@TargetClientSitesID int,
@CurrentUserID int,
@CopyBatchGuid uniqueidentifier
)
as
begin try
    begin transaction

        insert into dbo.[ECARDTEMPLATE]
        (CLIENTSITESID, NAME, CAPTION, SUBJECTLINE, TYPE, PREVIEWIMAGE, PREVIEWIMAGETYPE, PREVIEWIMAGEMODIFIED, DELETED, HTMLCONTENT, ISSAMPLE, OWNERID, COPYSOURCEID, COPYBATCHGUID)
        select
        @TargetClientSitesID,
        ET.NAME,
        ET.CAPTION,
        ET.SUBJECTLINE,
        ET.TYPE,
        ET.PREVIEWIMAGE,
        ET.PREVIEWIMAGETYPE,
        ET.PREVIEWIMAGEMODIFIED,
        ET.DELETED,
        dbo.UFN_UPDATECOPYCONTENTHTML(ET.HTMLCONTENT,@CopyBatchGUID),
        ET.ISSAMPLE,
        ET.OwnerID,
        ET.ID,
        @CopyBatchGUID
        from ECARDTEMPLATE ET
        where ET.CLIENTSITESID = @SourceClientSitesID and ET.Deleted = 0 AND ET.ISSAMPLE = 0

    commit transaction
end try
begin catch
    rollback transaction
    update dbo.SITECOPY set ErrorLog = ErrorLog +  'Error copying eCard tempaltes:' + ERROR_MESSAGE() + CHAR(13) WHERE ID = @CopyBatchGUID
end catch