spAddUpdate_DiscussionPosts

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@TopicID	int	IN
@ReplyToID	int	IN
@Message	ntext	IN
@Approved	bit	IN
@PostedByID	int	IN
Definition

Copy


        CREATE   PROCEDURE [dbo].[spAddUpdate_DiscussionPosts]
            (
                @PKID        int output,
                @TopicID    int,
                @ReplyToID    int,
                @Message    ntext,
                @Approved    bit,
                @PostedByID    int
            )
            AS
          BEGIN
                  set nocount on

                  begin transaction

                  if @ReplyToID <= 0
                      set @ReplyToID = null

                  declare @ApprovedDate datetime
                  declare @ApprovedID int
                  if @Approved=1
                      begin
                          set @ApprovedDate = getutcdate()
                          set @ApprovedID = @PostedByID
                      end
                  else
                      begin
                          set @ApprovedDate = null
                          set @ApprovedID = null
                      end

                  if (@PKID<=0)
                  begin

                      INSERT INTO DiscussionPosts
                      (
                      TopicID        ,
                      ReplyToID    ,
                      [Message]    ,
                      Approved    ,
                      ApprovedID    ,
                      ApprovedDate,
                      PostedByID
                      )

                      VALUES
                      (
                      @TopicID    ,
                      @ReplyToID    ,
                      @Message    ,
                      @Approved    ,
                      @ApprovedID    ,
                      @ApprovedDate,
                      @PostedByID
                      )

                      SELECT @PKID = @@Identity
                  end 
                  else 
                  begin
                      UPDATE DiscussionPosts set
                      [Message]    =@Message,
                      Approved = @Approved,
                      ApprovedDate = @ApprovedDate,
                      UpdateDate        =getutcdate()        
                      WHERE ID=@PKID
                  end
                  commit transaction
          END