USP_CLONESITE_FAFOFFLINEFORM

Handle the copy of FAF offline form part in cloning CMS website

Parameters

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

Definition

Copy



create procedure dbo.USP_CLONESITE_FAFOFFLINEFORM
(
     @SourceClientSitesID    as int 
    ,@TargetClientSitesID    as int 
    ,@CurrentUserID            as int
    ,@CopyBatchGUID            as uniqueidentifier 
)
as
begin

  declare @CHANGEAGENTID uniqueidentifier
  exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output
  declare @CURRENTDATE datetime
  set @CURRENTDATE = getdate()
  insert into dbo.FAFOFFLINEFORMCONTENT
      (ID, 
      NAME,
      DESCRIPTION,
      TYPECODE,
      IMAGEID,
      HTML,
      ADDEDBYID, 
      CHANGEDBYID, 
      DATEADDED, 
      DATECHANGED)
  select 
      SC2.Guid, 
      FC.NAME,
      FC.DESCRIPTION,
      FC.TYPECODE,
      COALESCE(IMG.ID, 0),
      dbo.UFN_UPDATECOPYCONTENTHTML(FC.HTML,@CopyBatchGUID),
      @CHANGEAGENTID, 
      @CHANGEAGENTID, 
      @CURRENTDATE, 
      @CURRENTDATE  
      from FAFOFFLINEFORMCONTENT FC 
      inner join SiteContent SC 
          on FC.ID = SC.Guid and SC.ClientSitesID = @SourceClientSitesID
      inner join SiteContent SC2 
          on SC2.CopyBatchGUID = @CopyBatchGUID
          and SC.ID = SC2.CopySourceID  and SC2.ClientSitesID = @TargetClientSitesID
      left outer join SiteImages IMG
          on IMG.CopySourceID = FC.IMAGEID  and IMG.COPYBATCHGUID = @CopyBatchGUID and IMG.ClientSitesID = @TargetClientSitesID


end