USP_DATAFORMTEMPLATE_ADD_CONSTITUENTNOTE_BBIS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@DATEENTERED	datetime	IN
@TITLE	nvarchar(50)	IN
@AUTHORID	uniqueidentifier	IN
@TEXTNOTE	nvarchar(max)	IN
@NOTETYPECODEID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
@HTMLNOTE	nvarchar(max)	IN
@BBISPAGENAME	nvarchar(1000)	IN
@BBISPAGEID	int	IN

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_CONSTITUENTNOTE_BBIS
(
  @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,    
    @DATEENTERED datetime,
    @TITLE nvarchar(50) = '',
    @AUTHORID uniqueidentifier = null,
    @TEXTNOTE nvarchar(max) = '',
    @NOTETYPECODEID uniqueidentifier,
    @CONSTITUENTID uniqueidentifier,
    @HTMLNOTE nvarchar(max) = '',
  @BBISPAGENAME nvarchar(1000) = '',
  @BBISPAGEID int = null
)
as

set nocount on;

if @ID is null
    set @ID = newid()

if @CHANGEAGENTID is null  
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()

begin try
    exec dbo.USP_DATAFORMTEMPLATE_ADD_CONSTITUENTNOTE 
    @ID,
    @CHANGEAGENTID,
    @DATEENTERED,
    @TITLE,
    @AUTHORID,
    @TEXTNOTE,
    @NOTETYPECODEID,
    @CONSTITUENTID,
    @HTMLNOTE

  insert into dbo.CONSTITUENTNOTEBBIS (
  ID,
  BBISPAGENAME,
  BBISPAGEID,
  ADDEDBYID,
  CHANGEDBYID,
  DATEADDED,
  DATECHANGED
) values (
  @ID,
  @BBISPAGENAME,
  @BBISPAGEID,
  @CHANGEAGENTID,
  @CHANGEAGENTID,
  @CURRENTDATE,
  @CURRENTDATE
);
end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0