USP_DATAFORMTEMPLATE_ADD_ACTION_ITEM

The save procedure used by the add dataform template "Action Item Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(250)	IN	Name
@SYNOPSIS	nvarchar(4000)	IN	Synopsis
@DESCRIPTION	nvarchar(max)	IN	Description
@TYPECODE	tinyint	IN	Type
@STATUSCODE	tinyint	IN	Status
@TOPICCODE	tinyint	IN	Topic
@STARTDATE	datetime	IN	Startdate
@ENDDATE	datetime	IN	Enddate
@ISEMAILDELIVERY	bit	IN	Isemaildelivery
@ISFAXDELIVERY	bit	IN	Isfaxdelivery
@ISLETTERDELIVERY	bit	IN	Isletterdelivery
@ISDELIVERYNONE	bit	IN	Isdeliverynone
@ISFAXBACKUPFOREMAILSENABLED	bit	IN	Isfaxbackupforemailsenabled
@ISEMAILBACKUPFORFAXENABLED	bit	IN	Isemailbackupforfaxenabled
@TARGETOPTIONCODE	tinyint	IN	Targetoption
@TARGETDATABASE	nvarchar(100)	IN	Targetdatabase
@CONFIRMATIONTEXT	nvarchar(max)	IN	Confirmationtext
@RESULTTEXT	nvarchar(max)	IN	Resulttext
@ISTOPOSTALCODEDEPENDENT	bit	IN	IsToPostalcodeDependent
@ISCCPOSTALCODEDEPENDENT	bit	IN	IsCCPostalcodeDependent
@SCHEDULEACTIVATION	bit	IN	ScheduleActivation
@ISTODMADEPENDENT	bit	IN	IsToDMADependent
@ISCCDMADEPENDENT	bit	IN	IsCCDMADependent
@OWNERID	int	IN	OwnerID

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ACTION_ITEM
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(250),
    @SYNOPSIS nvarchar(4000) = '',
    @DESCRIPTION nvarchar(max) = '',
    @TYPECODE tinyint = 0,
    @STATUSCODE tinyint = 0,
    @TOPICCODE tinyint = 11,
    @STARTDATE datetime = null,
    @ENDDATE datetime = null,
    @ISEMAILDELIVERY bit = 1,
    @ISFAXDELIVERY bit = 0,
    @ISLETTERDELIVERY bit = 0,
    @ISDELIVERYNONE bit = 0,
    @ISFAXBACKUPFOREMAILSENABLED bit = 1,
    @ISEMAILBACKUPFORFAXENABLED bit = 0,
    @TARGETOPTIONCODE tinyint = 0,
    @TARGETDATABASE nvarchar(100) = '',
    @CONFIRMATIONTEXT nvarchar(max) = '',
    @RESULTTEXT nvarchar(max) = '',
    @ISTOPOSTALCODEDEPENDENT bit = 1,
    @ISCCPOSTALCODEDEPENDENT bit = 1,
    @SCHEDULEACTIVATION bit = 1,
    @ISTODMADEPENDENT bit = 1,
    @ISCCDMADEPENDENT bit = 1,
    @OWNERID int = 0
)
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()

IF @STARTDATE = '9999-12-31 23:59:59'
    SET @STARTDATE = NULL

IF @ENDDATE = '9999-12-31 23:59:59'
    SET @ENDDATE = NULL

begin try
    -- handle inserting the data

    insert into dbo.ACTION_ITEM
        (ID, NAME, SYNOPSIS, DESCRIPTION, TYPECODE, STATUSCODE, TOPICCODE, STARTDATE, ENDDATE, ISEMAILDELIVERY, ISFAXDELIVERY, ISLETTERDELIVERY, ISDELIVERYNONE, ISFAXBACKUPFOREMAILSENABLED, ISEMAILBACKUPFORFAXENABLED, TARGETOPTIONCODE, TARGETDATABASE, CONFIRMATIONTEXT, RESULTTEXT, ISTOPOSTALCODEDEPENDENT, ISCCPOSTALCODEDEPENDENT, SCHEDULEACTIVATION, ISTODMADEPENDENT, ISCCDMADEPENDENT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, OWNERID)
    values
        (@ID, @NAME, @SYNOPSIS, @DESCRIPTION, @TYPECODE, @STATUSCODE, @TOPICCODE, @STARTDATE, @ENDDATE, @ISEMAILDELIVERY, @ISFAXDELIVERY, @ISLETTERDELIVERY, @ISDELIVERYNONE, @ISFAXBACKUPFOREMAILSENABLED, @ISEMAILBACKUPFORFAXENABLED, @TARGETOPTIONCODE, @TARGETDATABASE, @CONFIRMATIONTEXT, @RESULTTEXT, @ISTOPOSTALCODEDEPENDENT, @ISCCPOSTALCODEDEPENDENT, @SCHEDULEACTIVATION, @ISTODMADEPENDENT, @ISCCDMADEPENDENT, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE, @OWNERID)
end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0