spAddUpdate_SiteFolders

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@ClientSitesID	int	IN
@FolderName	nvarchar(256)	IN
@ParentFolderID	int	IN
@Sequence	int	IN
@Type	int	IN
@Guid	uniqueidentifier	INOUT

Definition

Copy



CREATE  PROCEDURE dbo.spAddUpdate_SiteFolders
  (
  @PKID        int output,
  @CurrentUsersID    int,
  @ClientSitesID  int,
  @FolderName     nvarchar(256),
  @ParentFolderID int,
  @Sequence        int,
  @Type        int,
  @Guid uniqueidentifier output
  )
  AS

  if (@PKID<=0) begin

      INSERT INTO SiteFolders
      (
      FolderName,
      ParentFolderID,
      Sequence,
      ClientSitesID,
      Type,
      OwnerID
      )
      VALUES
      (
      @FolderName,
      @ParentFolderID,
      @Sequence,
      @ClientSitesID,
      @Type,
      @CurrentUsersID
      )

      SELECT @PKID = @@Identity

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

      exec spAuditThis @CurrentUsersID, 1, @Guid, 32

      end

  else

    begin


      update SiteFolders
      set
      FolderName   = @FolderName,
      ParentFolderID = @ParentFolderID,
      [Sequence]     = @Sequence
      where FolderID = @PKID

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

      exec spAuditThis @CurrentUsersID, 2, @Guid, 32

  end