USP_CLONESITE_FAFACCOUNTSETTINGS

Handle the copy of FAF account settings 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_FAFACCOUNTSETTINGS]
(
     @SourceClientSitesID    as int 
    ,@TargetClientSitesID    as int 
    ,@CurrentUserID            as int
    ,@CopyBatchGUID            as uniqueidentifier 
)
as
begin

    set nocount on;

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

  insert into dbo.FAFACCOUNTSETTINGSCONTENT
      (ID, FORMID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
  select SC2.Guid, F.ID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE  from FAFACCOUNTSETTINGSCONTENT 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
      inner join APEXFORM F
          on F.COPYSOURCEID = FC.FORMID and F.COPYBATCHGUID = @CopyBatchGuid and F.SITEID = @TargetClientSitesID

    set nocount off;

end