USP_CLONESITE_ECARDTEMPLATEFOLDERS
Used by CMS site copy to copy eCard templates into the correct folders.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CopyBatchGUID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_CLONESITE_ECARDTEMPLATEFOLDERS
(
@CopyBatchGUID uniqueidentifier
)
as
begin try
insert into dbo.[ECARDTEMPLATEFOLDER](ECARDTEMPLATEID, SITEFOLDERSID, COPYSOURCEID, COPYBATCHGUID)
select ET.ID, SF.FolderID, ETF.ID, @CopyBatchGUID
from dbo.[ECARDTEMPLATEFOLDER] ETF
inner join dbo.[ECARDTEMPLATE] ET on ET.COPYSOURCEID = ETF.[ECARDTEMPLATEID] and ET.[COPYBATCHGUID] = @CopyBatchGUID
inner join dbo.[SITEFOLDERS] SF on SF.[COPYSOURCEID] = ETF.[SITEFOLDERSID] and SF.[COPYBATCHGUID] = @CopyBatchGUID
end try
begin catch
UPDATE SiteCopy SET ErrorLog = ErrorLog + 'Error copying eCard template folders:' + ERROR_MESSAGE() + CHAR(13) WHERE ID = @CopyBatchGUID
end catch