USP_DATAFORMTEMPLATE_EDITLOAD_HOUSEHOLDRECOGNITIONDEFAULTSETTINGS

The load procedure used by the edit dataform template "Household Recognition Global Settings Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@HOUSEHOLDRECOGNIZEHOUSEHOLD	bit	INOUT	Household
@HOUSEHOLDRECOGNIZEMEMBERS	bit	INOUT	All members
@MEMBERRECOGNIZEHOUSEHOLD	bit	INOUT	Household
@MEMBERRECOGNIZEMEMBER	bit	INOUT	Member
@MEMBERRECOGNIZEOTHERMEMBERS	bit	INOUT	All other members
@HOUSEHOLDREVENUERECOGNITIONTYPECODEID	uniqueidentifier	INOUT	Default recognition credit type
@MEMBERREVENUERECOGNITIONTYPECODEID	uniqueidentifier	INOUT	Default recognition credit type
@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.
@MEMBERHOUSEHOLDREVENUERECOGNITIONTYPECODEID	uniqueidentifier	INOUT	Default recognition credit type
@DONORREVENUERECOGNITIONTYPE	nvarchar(100)	INOUT	Donor type

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_HOUSEHOLDRECOGNITIONDEFAULTSETTINGS
                    (
                        @DATALOADED bit = 0 output,
                        @HOUSEHOLDRECOGNIZEHOUSEHOLD bit = null output,
                        @HOUSEHOLDRECOGNIZEMEMBERS bit = null output,
                        @MEMBERRECOGNIZEHOUSEHOLD bit = null output,
                        @MEMBERRECOGNIZEMEMBER bit = null output,
                        @MEMBERRECOGNIZEOTHERMEMBERS bit = null output,
                        @HOUSEHOLDREVENUERECOGNITIONTYPECODEID uniqueidentifier = null output,
                        @MEMBERREVENUERECOGNITIONTYPECODEID uniqueidentifier = null output,
                        @TSLONG bigint = 0 output,
                        @MEMBERHOUSEHOLDREVENUERECOGNITIONTYPECODEID uniqueidentifier = null output,
                        @DONORREVENUERECOGNITIONTYPE nvarchar(100) = null output 
                    )
                    as
                        set nocount on;

                        select top 1
                            @HOUSEHOLDRECOGNIZEHOUSEHOLD = HOUSEHOLDRECOGNIZEHOUSEHOLD,
                            @HOUSEHOLDRECOGNIZEMEMBERS = HOUSEHOLDRECOGNIZEMEMBERS,
                            @MEMBERRECOGNIZEHOUSEHOLD = MEMBERRECOGNIZEHOUSEHOLD,
                            @MEMBERRECOGNIZEMEMBER = MEMBERRECOGNIZEMEMBER,
                            @MEMBERRECOGNIZEOTHERMEMBERS = MEMBERRECOGNIZEOTHERMEMBERS,
                            @HOUSEHOLDREVENUERECOGNITIONTYPECODEID = HOUSEHOLDREVENUERECOGNITIONTYPECODEID,
                            @MEMBERREVENUERECOGNITIONTYPECODEID = MEMBERREVENUERECOGNITIONTYPECODEID,
                            @MEMBERHOUSEHOLDREVENUERECOGNITIONTYPECODEID = MEMBERHOUSEHOLDREVENUERECOGNITIONTYPECODEID,
                            @DATALOADED = 1,
                            @TSLONG = TSLONG
                        from dbo.HOUSEHOLDINFO
                        order by DATEADDED

                        -- If the global settings don't exist yet, set everything to un-selected

                        if @DATALOADED = 0
                        begin
                            set @HOUSEHOLDRECOGNIZEHOUSEHOLD = 0
                            set @HOUSEHOLDRECOGNIZEMEMBERS = 0
                            set @MEMBERRECOGNIZEHOUSEHOLD = 0
                            set @MEMBERRECOGNIZEMEMBER = 0
                            set @MEMBERRECOGNIZEOTHERMEMBERS = 0
                            set @DATALOADED = 1                        
                        end

                        select @DONORREVENUERECOGNITIONTYPE = dbo.UFN_REVENUERECOGNITIONTYPECODE_GETDESCRIPTION(DONORREVENUERECOGNITIONTYPECODEID)
                        from dbo.RECOGNITIONDEFAULT;

                        return 0;