USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPPROGRAM

The load procedure used by the view dataform template "Sponsorship Program Edit Load View 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	TSLONG
@NAME	nvarchar(100)	INOUT	Name
@SPONSORSHIPOPPORTUNITYGROUPID	uniqueidentifier	INOUT	Opportunity group
@SPONSORSHIPGREATESTNEEDRULESETID	uniqueidentifier	INOUT	Greatest need rule set
@AMOUNT	money	INOUT	Default monthly amount
@FILTERLOCATIONCODE	tinyint	INOUT	Location
@FILTERLOCATIONS	xml	INOUT	FILTERLOCATIONS
@MATCHFUNCTIONID	uniqueidentifier	INOUT	MATCHFUNCTIONID
@ISAFFILIATEPROGRAM	bit	INOUT	Affiliate program
@AFFILIATEID	uniqueidentifier	INOUT	Affiliate constituent
@CONSTITUENCYCODEID	uniqueidentifier	INOUT	Sponsor constituency
@QUERYVIEWID	uniqueidentifier	INOUT	QUERYVIEWID
@BASECURRENCYID	uniqueidentifier	INOUT	BASECURRENCYID

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPPROGRAM
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = null output,
    @NAME nvarchar(100) = null output,
    @SPONSORSHIPOPPORTUNITYGROUPID uniqueidentifier = null output,
    @SPONSORSHIPGREATESTNEEDRULESETID uniqueidentifier = null output,
    @AMOUNT money = null output,
    @FILTERLOCATIONCODE tinyint = null output,
    @FILTERLOCATIONS xml = null output,
    @MATCHFUNCTIONID uniqueidentifier = null output,
    @ISAFFILIATEPROGRAM bit = null output,
    @AFFILIATEID  uniqueidentifier = null output,
    @CONSTITUENCYCODEID uniqueidentifier = null output,
    @QUERYVIEWID uniqueidentifier = null output,
  @BASECURRENCYID uniqueidentifier = null output
)
as
    set nocount on;

    set @DATALOADED = 0;
    set @TSLONG = 0

    select
        @DATALOADED = 1,
        @TSLONG = SPONSORSHIPPROGRAM.TSLONG,
        @NAME = SPONSORSHIPPROGRAM.NAME,
        @SPONSORSHIPOPPORTUNITYGROUPID = SPONSORSHIPPROGRAM.SPONSORSHIPOPPORTUNITYGROUPID,
        @SPONSORSHIPGREATESTNEEDRULESETID = SPONSORSHIPPROGRAM.SPONSORSHIPGREATESTNEEDRULESETID,
        @AMOUNT = SPONSORSHIPPROGRAM.AMOUNT,
        @FILTERLOCATIONCODE = SPONSORSHIPPROGRAM.FILTERLOCATIONCODE,
        @FILTERLOCATIONS = SPONSORSHIPPROGRAM.FILTERLOCATIONS,
        @MATCHFUNCTIONID = SPONSORSHIPPROGRAM.MATCHFUNCTIONID,
        @ISAFFILIATEPROGRAM = case when SPONSORSHIPAFFILIATEPROGRAM.ID is not null then 1 else 0 end,
        @AFFILIATEID = SPONSORSHIPAFFILIATEPROGRAM.AFFILIATEID,
        @CONSTITUENCYCODEID = SPONSORSHIPAFFILIATEPROGRAM.CONSTITUENCYCODEID,
        @QUERYVIEWID = SPONSORSHIPPROGRAM.QUERYVIEWID,
    @BASECURRENCYID = SPONSORSHIPPROGRAM.BASECURRENCYID
    from dbo.SPONSORSHIPPROGRAM
    left outer join dbo.SPONSORSHIPAFFILIATEPROGRAM on SPONSORSHIPAFFILIATEPROGRAM.ID = SPONSORSHIPPROGRAM.ID
    where SPONSORSHIPPROGRAM.ID = @ID;

    return 0;