USP_DATAFORMTEMPLATE_TAXDECLARATION_EDITLOAD_2

The load procedure used by the edit dataform template "Tax Declaration Edit Form 2"

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.
@CONSTITUENTID	uniqueidentifier	INOUT
@DECLARATIONMADE	datetime	INOUT	Made
@DECLARATIONSTARTS	datetime	INOUT	Start date
@DECLARATIONENDS	datetime	INOUT	End date
@DECLARATIONINDICATORCODE	tinyint	INOUT	Indicator
@DECLARATIONSOURCECODEID	uniqueidentifier	INOUT	Source
@CHARITYCLAIMREFERENCENUMBERID	uniqueidentifier	INOUT	Reference number
@SCANNEDDOCSEXIST	bit	INOUT	Scanned documents exist
@CONFIRMATIONSENT	datetime	INOUT	Sent
@CONFIRMATIONRETURNED	datetime	INOUT	Returned
@PAYSTAXCODE	tinyint	INOUT	Pays tax
@TAXSTATUSCODEID	uniqueidentifier	INOUT	Status
@COMMENTS	nvarchar(255)	INOUT	Comment
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@NAMEOPTIONCODE	tinyint	INOUT
@ALIASID	uniqueidentifier	INOUT
@ADDRESSOPTIONCODE	tinyint	INOUT
@ADDRESSID	uniqueidentifier	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_TAXDECLARATION_EDITLOAD_2
                    (
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
                        @CONSTITUENTID uniqueidentifier  = null output,
                        @DECLARATIONMADE datetime = null output,
                        @DECLARATIONSTARTS datetime = null output,
                        @DECLARATIONENDS datetime = null output,
                        @DECLARATIONINDICATORCODE tinyint = null output,
                        @DECLARATIONSOURCECODEID uniqueidentifier = null output,
                        @CHARITYCLAIMREFERENCENUMBERID uniqueidentifier = null output,                        
                        @SCANNEDDOCSEXIST bit = null output,
                        @CONFIRMATIONSENT datetime = null output,
                        @CONFIRMATIONRETURNED datetime = null output,
                        @PAYSTAXCODE tinyint = null output,
                        @TAXSTATUSCODEID uniqueidentifier = null output,
                        @COMMENTS nvarchar(255) = null output,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @NAMEOPTIONCODE tinyint = null output,
                        @ALIASID uniqueidentifier = null output,
                        @ADDRESSOPTIONCODE tinyint = null output,
                        @ADDRESSID uniqueidentifier = 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 = TSLONG,
                            @CONSTITUENTID = CONSTITUENTID,
                            @DECLARATIONMADE = DECLARATIONMADE,
                            @DECLARATIONSTARTS = DECLARATIONSTARTS,
                            @DECLARATIONENDS = DECLARATIONENDS,
                            @DECLARATIONINDICATORCODE = DECLARATIONINDICATORCODE,
                            @DECLARATIONSOURCECODEID = DECLARATIONSOURCECODEID,
                            @CHARITYCLAIMREFERENCENUMBERID = CHARITYCLAIMREFERENCENUMBERID,
                            @SCANNEDDOCSEXIST = SCANNEDDOCSEXIST,
                            @CONFIRMATIONSENT = CONFIRMATIONSENT,
                            @CONFIRMATIONRETURNED = CONFIRMATIONRETURNED,
                            @PAYSTAXCODE = PAYSTAXCODE,
                            @TAXSTATUSCODEID = TAXSTATUSCODEID,
                            @COMMENTS = COMMENTS,
                            @NAMEOPTIONCODE = case when ALIASID is null then 0 else 1 end,
                            @ALIASID = ALIASID,
                            @ADDRESSOPTIONCODE = case when ADDRESSID is null then 0 else 1 end,
                            @ADDRESSID = ADDRESSID
                        from dbo.TAXDECLARATION
                        where ID = @ID;

                        return 0;