USP_DATAFORMTEMPLATE_EDITLOAD_SALESORDERITEMSPONSORSHIP

The load procedure used by the edit dataform template "Sales Order Item Sponsorship Edit Data 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.
@SPONSORSHIPID	uniqueidentifier	INOUT	Sponsorship Id
@SPONSORSHIPPROGRAMID	uniqueidentifier	INOUT	Sponsorship Program Id
@SPONSORSHIPOPPORTUNITYID	uniqueidentifier	INOUT	Sponsorship Opportunity Id
@STARTDATE	date	INOUT	Start date
@GIFTRECIPIENTID	uniqueidentifier	INOUT	Gift Recipient Id
@SPONSORSHIPLOCATIONID	uniqueidentifier	INOUT	Sponsorship Location Id
@GENDERCODE	tinyint	INOUT	Gender Code
@SPONSORSHIPOPPORTUNITYAGERANGEID	uniqueidentifier	INOUT	Sponsorship age range Id
@ISHIVPOSITIVECODE	tinyint	INOUT	Is Hiv positive
@HASCONDITIONCODE	tinyint	INOUT	Has condition code
@ISORPHANEDCODE	tinyint	INOUT	Is orphaned code
@SPROPPPROJECTCATEGORYCODEID	uniqueidentifier	INOUT	Project category code
@ISSOLESPONSORSHIP	bit	INOUT	Is sole sponsorship
@EXPIRATIONDATE	date	INOUT	Expiration date
@EXPIRATIONREASONID	uniqueidentifier	INOUT	Expiration reason Id
@ORDERPAYMENTAMOUNT	money	INOUT	Order payment amount
@FREQUENCYCODE	tinyint	INOUT	Frequency
@SCHEDULESTARTDATE	date	INOUT	Schedule start date
@AMOUNT	money	INOUT	Amount
@GROUPID	uniqueidentifier	INOUT	Group Id
@CALLBACKURL	nvarchar(255)	INOUT	Call back url
@DATA	xml	INOUT	Data
@ACKNOWLEDGEMENTHTML	nvarchar(max)	INOUT	Acknowledgement Html
@ATTRIBUTES	xml	INOUT	Attributes
@OPTIONS	xml	INOUT	Options
@MASKIMAGEID	int	INOUT	Mask Image ID
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT
@CURRENCYISO	nvarchar(3)	INOUT
@APPEALID	uniqueidentifier	INOUT

Definition

Copy


        CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SALESORDERITEMSPONSORSHIP(
            @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
            @TSLONG bigint = 0 output,
              @SPONSORSHIPID uniqueidentifier = null output,
              @SPONSORSHIPPROGRAMID uniqueidentifier = null output,
              @SPONSORSHIPOPPORTUNITYID uniqueidentifier = null output,
              @STARTDATE date = null output,
              @GIFTRECIPIENTID uniqueidentifier = null output,
              @SPONSORSHIPLOCATIONID uniqueidentifier = null output,
              @GENDERCODE tinyint = null output,
              @SPONSORSHIPOPPORTUNITYAGERANGEID uniqueidentifier = null output,
              @ISHIVPOSITIVECODE tinyint = null output,
              @HASCONDITIONCODE tinyint = null output,
              @ISORPHANEDCODE tinyint = null output,
              @SPROPPPROJECTCATEGORYCODEID uniqueidentifier = null output,
              @ISSOLESPONSORSHIP bit = null output,
              @EXPIRATIONDATE date = null output,
              @EXPIRATIONREASONID uniqueidentifier = null output,
              @ORDERPAYMENTAMOUNT money = null output,
              @FREQUENCYCODE tinyint = null output,
              @SCHEDULESTARTDATE date = null output,
              @AMOUNT money = null output,
              @GROUPID uniqueidentifier = null output,
              @CALLBACKURL nvarchar(255) = null output,
              @DATA xml = null output,
              @ACKNOWLEDGEMENTHTML nvarchar(max) = null output,
              @ATTRIBUTES xml = null output,
              @OPTIONS xml = null output,
              @MASKIMAGEID int = null output,
              @PDACCOUNTSYSTEMID uniqueidentifier = null output,
              @CURRENCYISO nvarchar(3) = null output,
              @APPEALID 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 = S.TSLONG,
                @SPONSORSHIPID = S.SPONSORSHIPID,
                @SPONSORSHIPPROGRAMID = S.SPONSORSHIPPROGRAMID,
                @SPONSORSHIPOPPORTUNITYID = S.SPONSORSHIPOPPORTUNITYID,
                @STARTDATE = S.STARTDATE,
                @GIFTRECIPIENTID = S.GIFTRECIPIENTID,
                @SPONSORSHIPLOCATIONID = S.SPONSORSHIPLOCATIONID,
                @GENDERCODE = S.GENDERCODE,
                @SPONSORSHIPOPPORTUNITYAGERANGEID = S.SPONSORSHIPOPPORTUNITYAGERANGEID,
                @ISHIVPOSITIVECODE = S.ISHIVPOSITIVECODE,
                @HASCONDITIONCODE = S.HASCONDITIONCODE,
                @ISORPHANEDCODE = S.ISORPHANEDCODE,
                @SPROPPPROJECTCATEGORYCODEID = S.SPROPPPROJECTCATEGORYCODEID,
                @ISSOLESPONSORSHIP = S.ISSOLESPONSORSHIP,
                @EXPIRATIONDATE = S.EXPIRATIONDATE,
                @EXPIRATIONREASONID = S.EXPIRATIONREASONID,
                @AMOUNT = RS.AMOUNT,
                @FREQUENCYCODE = RS.FREQUENCYCODE,
                @SCHEDULESTARTDATE = RS.SCHEDULESTARTDATE,
                @MASKIMAGEID = S.MASKIMAGEID,
                @PDACCOUNTSYSTEMID = S.PDACCOUNTSYSTEMID,
                @CURRENCYISO = S.CURRENCYISO,
                @APPEALID = S.APPEALID
            from dbo.SALESORDERITEMSPONSORSHIP as S
            inner join dbo.SALESORDERITEMREVENUESCHEDULE as RS on RS.ID = S.ID
            where S.ID = @ID

            select 
            @ORDERPAYMENTAMOUNT = PRICE, 
            @CALLBACKURL = CALLBACKURL, 
            @DATA = DATA, 
   @ACKNOWLEDGEMENTHTML = ACKNOWLEDGEMENT, 
            @ATTRIBUTES = ATTRIBUTES,
            @OPTIONS = OPTIONS
          from dbo.SALESORDERITEM where ID = @ID

          select @GROUPID = GROUPID from dbo.SALESORDERITEMGROUP where ID = @ID
            return 0;