USP_CLONESITE_NAVIGATIONBUTTONS

Handles the Navigation Button-specific steps for cloning a CMS site.

Parameters

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

Definition

Copy



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


    insert into dbo.NavBarItems(ContentID,Caption,URL,SitePageID,DefaultSiteImageID,ActiveSiteImageID,HoverSiteImageID,Sequence,PageTabId,Target,AddQS,DocumentID)
    select
    SC.ID,
    NBI.Caption,
    NBI.URL,
    ISNULL(SP.ID, NBI.SitePageID),
    ISNULL(DSI.ID, NBI.DefaultSiteImageID),
    ISNULL(ASI.ID, NBI.ActiveSiteImageID),
    ISNULL(HSI.ID, NBI.HoverSiteImageID),
    NBI.Sequence,
    NBI.PageTabId,
    NBI.[Target],
    NBI.AddQS,
  NBI.DocumentID
    from dbo.NavBarItems NBI
    inner join dbo.SiteContent SC on SC.CopySourceID = NBI.ContentID
    left outer join dbo.SitePages SP on SP.CopySourceID = NBI.SitePageID and SP.CopyBatchGUID = @CopyBatchGuid
    left outer join dbo.SiteImages DSI on DSI.CopySourceID = NBI.DefaultSiteImageID and DSI.CopyBatchGUID = @CopyBatchGuid
    left outer join dbo.SiteImages ASI on ASI.CopySourceID = NBI.ActiveSiteImageID and ASI.CopyBatchGUID = @CopyBatchGuid
    left outer join dbo.SiteImages HSI on HSI.CopySourceID = NBI.HoverSiteImageID and HSI.CopyBatchGUID = @CopyBatchGuid
    where SC.CopyBatchGUID = @CopyBatchGuid