spDelete_SiteFolders

Parameters

Parameter	Parameter Type	Mode	Description
@PKID	int	IN
@CurrentUsersID	int	IN

Definition

Copy


CREATE     PROCEDURE [dbo].[spDelete_SiteFolders]
(
        @PKID        int,
        @CurrentUsersID    int
)
AS
    declare @Guid uniqueidentifier

    begin transaction
        Update SiteFolders set Deleted = 1 where FolderID = @PKID

        update dbo.sitepages set FolderID = 0 where FolderID = @PKID

        update dbo.EmailList set SITEFOLDERSID = 0 where SITEFOLDERSID = @PKID

        delete dbo.sitecontentfolders where SiteFoldersID = @PKID

        delete dbo.SiteImageFolders where SiteFolderID = @PKID

        select @Guid = Guid from SiteFolders where FolderID = @PKID

        exec spAuditThis @CurrentUsersID, 3, @Guid, 32
    commit