USP_DATAFORMTEMPLATE_EDITLOAD_ACTION_ITEM

The load procedure used by the edit dataform template "Action Item Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@NAME	nvarchar(250)	INOUT	Name
@SYNOPSIS	nvarchar(4000)	INOUT	Synopsis
@DESCRIPTION	nvarchar(max)	INOUT	Description
@TYPECODE	tinyint	INOUT	Type
@STATUSCODE	tinyint	INOUT	Status
@TOPICCODE	tinyint	INOUT	Topic
@STARTDATE	datetime	INOUT	Startdate
@ENDDATE	datetime	INOUT	Enddate
@ISEMAILDELIVERY	bit	INOUT	Isemaildelivery
@ISFAXDELIVERY	bit	INOUT	Isfaxdelivery
@ISLETTERDELIVERY	bit	INOUT	Isletterdelivery
@ISDELIVERYNONE	bit	INOUT	Isdeliverynone
@ISFAXBACKUPFOREMAILSENABLED	bit	INOUT	Isfaxbackupforemailsenabled
@ISEMAILBACKUPFORFAXENABLED	bit	INOUT	Isemailbackupforfaxenabled
@TARGETOPTIONCODE	tinyint	INOUT	Targetoption
@TARGETDATABASE	nvarchar(100)	INOUT	Targetdatabase
@CONFIRMATIONTEXT	nvarchar(max)	INOUT	Confirmationtext
@RESULTTEXT	nvarchar(max)	INOUT	Resulttext
@FOLDERID	int	INOUT	Folderid
@SUBJECT	nvarchar(250)	INOUT	Subject
@MESSAGETEXT	nvarchar(max)	INOUT	Messagetext
@INSTRUCTIONS	nvarchar(1000)	INOUT	Instructions
@THANKYOUMESSAGETEXT	nvarchar(max)	INOUT	Thankyoumessagetext
@SENDCOPYTONPO	bit	INOUT	Sendcopytonpo
@OVERWRITECODE	tinyint	INOUT	Overwritetype
@ISTOPOSTALCODEDEPENDENT	bit	INOUT	IsToPostalcodeDependent
@ISCCPOSTALCODEDEPENDENT	bit	INOUT	IsCCPostalcodeDependent
@PERSONALIZATIONCODE	tinyint	INOUT	Persoanlizationtype
@SCHEDULEACTIVATION	bit	INOUT	ScheduleActivation
@ISTODMADEPENDENT	bit	INOUT	IsToDMADependent
@ISCCDMADEPENDENT	bit	INOUT	IsCCDMADependent
@EMAILTEMPLATEID	int	INOUT	EmailTemplateID

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_ACTION_ITEM
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @NAME nvarchar(250) = null output,
    @SYNOPSIS nvarchar(4000) = null output,
    @DESCRIPTION nvarchar(max) = null output,
    @TYPECODE tinyint = null output,
    @STATUSCODE tinyint = null output,
    @TOPICCODE tinyint = null output,
    @STARTDATE datetime = null output,
    @ENDDATE datetime = null output,
    @ISEMAILDELIVERY bit = null output,
    @ISFAXDELIVERY bit = null output,
    @ISLETTERDELIVERY bit = null output,
    @ISDELIVERYNONE bit = null output,
    @ISFAXBACKUPFOREMAILSENABLED bit = null output,
    @ISEMAILBACKUPFORFAXENABLED bit = null output,
    @TARGETOPTIONCODE tinyint = null output,
    @TARGETDATABASE nvarchar(100) = null output,
    @CONFIRMATIONTEXT nvarchar(max) = null output,
    @RESULTTEXT nvarchar(max) = null output,
    @FOLDERID int = null output,
    @SUBJECT nvarchar(250) = null output,
    @MESSAGETEXT nvarchar(max) = null output,
    @INSTRUCTIONS nvarchar(1000) = null output,
    @THANKYOUMESSAGETEXT nvarchar(max) = null output,
    @SENDCOPYTONPO bit = null output,
    @OVERWRITECODE tinyint = null output,
    @ISTOPOSTALCODEDEPENDENT bit = null output,
    @ISCCPOSTALCODEDEPENDENT bit = null output,
    --@THANKYOUEMAILSUBJECT nvarchar(250) =  null output,

    --@THANKYOUEMAILTEXT nvarchar(max) =  null output,

    @PERSONALIZATIONCODE tinyint = null output,
    @SCHEDULEACTIVATION bit = null output,
    @ISTODMADEPENDENT bit = null output,
    @ISCCDMADEPENDENT bit = null output,
  @EMAILTEMPLATEID int = null output
)
as

    set nocount on;

    -- be sure to set these, in case the select returns no rows

    set @DATALOADED = 0
    set @TSLONG = 0

    -- populate the output parameters, which correspond to fields on the form.  Note that

    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system

    -- will display a "no data loaded" message.  Also note that we fetch the TSLONG so that concurrency

    -- can be considered.

    select
        @DATALOADED = 1,
        @TSLONG = AI.TSLONG,
        @NAME = AI.NAME, 
        @SYNOPSIS = AI.SYNOPSIS, 
        @DESCRIPTION = AI.DESCRIPTION, 
        @TYPECODE = AI.TYPECODE, 
        @STATUSCODE = AI.STATUSCODE, 
        @TOPICCODE = AI.TOPICCODE, 
        @STARTDATE = AI.STARTDATE, 
        @ENDDATE = AI.ENDDATE, 
        @ISEMAILDELIVERY = AI.ISEMAILDELIVERY, 
        @ISFAXDELIVERY = AI.ISFAXDELIVERY, 
        @ISLETTERDELIVERY = AI.ISLETTERDELIVERY, 
        @ISDELIVERYNONE = AI.ISDELIVERYNONE, 
        @ISFAXBACKUPFOREMAILSENABLED = AI.ISFAXBACKUPFOREMAILSENABLED, 
        @ISEMAILBACKUPFORFAXENABLED = AI.ISEMAILBACKUPFORFAXENABLED, 
        @TARGETOPTIONCODE = AI.TARGETOPTIONCODE, 
        @TARGETDATABASE = AI.TARGETDATABASE, 
        @CONFIRMATIONTEXT = AI.CONFIRMATIONTEXT, 
        @RESULTTEXT = AI.RESULTTEXT,
        @FOLDERID = AF.FOLDERID,
        @SUBJECT = MT.SUBJECT, 
        @MESSAGETEXT = MT.MESSAGETEXT, 
        @INSTRUCTIONS = MT.INSTRUCTIONS, 
        @THANKYOUMESSAGETEXT = MT.THANKYOUMESSAGETEXT, 
        @SENDCOPYTONPO = MT.SENDCOPYTONPO,
        @OVERWRITECODE = MT.OVERWRITECODE,
        @ISTOPOSTALCODEDEPENDENT = AI.ISTOPOSTALCODEDEPENDENT,
        @ISCCPOSTALCODEDEPENDENT = AI.ISCCPOSTALCODEDEPENDENT,
    --    @THANKYOUEMAILSUBJECT = MT.THANKYOUEMAILSUBJECT,

    --    @THANKYOUEMAILTEXT = MT.THANKYOUEMAILTEXT,

        @PERSONALIZATIONCODE = MT.PERSONALIZATIONCODE,
        @SCHEDULEACTIVATION = AI.SCHEDULEACTIVATION,
        @ISTODMADEPENDENT = AI.ISTODMADEPENDENT,
        @ISCCDMADEPENDENT = AI.ISCCDMADEPENDENT,
    @EMAILTEMPLATEID = MT.EMAILTEMPLATEID
    from dbo.ACTION_ITEM AI
    LEFT OUTER JOIN dbo.ACTIONITEMFOLDER AF
    ON AI.ID = AF.ACTIONITEMID
    LEFT OUTER JOIN dbo.ACTIONITEMMESSAGETEXT MT
    ON MT.ACTIONITEMID = AI.ID
    where AI.ID = @ID

    return 0;