USP_DATAFORMTEMPLATE_VIEW_EVENTSPONSORDETAIL

The load procedure used by the view dataform template "Event Sponsor Page Detail 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.
@CONSTITUENTNAME	nvarchar(256)	INOUT	Sponsorship contact name
@EVENTSPONSORSHIPLOGO	varbinary	INOUT	Logo
@EVENTSPONSORSHIPURL	nvarchar(2048)	INOUT	Sponsor website
@SPONSORSHIPMESSAGE	nvarchar(2000)	INOUT	Sponsor message
@ORGANIZATIONNAME	nvarchar(256)	INOUT	Organization name
@ORGANIZATIONWEBADDRESS	nvarchar(2048)	INOUT	Organization website
@SPONSORSHIPOPTION	nvarchar(256)	INOUT	Sponsorship option name
@FEESAMOUNT	nvarchar(100)	INOUT	Sponsorship fee
@FEESWAVIED	nvarchar(5)	INOUT	Sponsorship fee waived
@BENEFITS	nvarchar(2048)	INOUT	Benefits
@BENEFITSWAVIED	nvarchar(5)	INOUT	Benefits waived

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EVENTSPONSORDETAIL
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @CONSTITUENTNAME nvarchar(256) = null output,
  @EVENTSPONSORSHIPLOGO varbinary(max) = null output,
  @EVENTSPONSORSHIPURL nvarchar(2048) = null output,
  @SPONSORSHIPMESSAGE nvarchar(2000) = null output,
  @ORGANIZATIONNAME nvarchar(256) = null output,
  @ORGANIZATIONWEBADDRESS nvarchar(2048) = null output,
  @SPONSORSHIPOPTION nvarchar(256) = null output,
  @FEESAMOUNT nvarchar(100) = null output,
  @FEESWAVIED nvarchar(5) = null output,
  @BENEFITS nvarchar(2048) = null output,
  @BENEFITSWAVIED nvarchar(5) = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows
    set @DATALOADED = 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.
    select @DATALOADED = 1,
        @CONSTITUENTNAME = IC.NAME,
        @EVENTSPONSORSHIPLOGO = SI.ImageContent,
        @EVENTSPONSORSHIPURL = ES.EVENTSPONSORSHIPURL,
        @SPONSORSHIPMESSAGE = ES.SPONSORSHIPMESSAGE,
        @ORGANIZATIONNAME = OC.NAME,
        @ORGANIZATIONWEBADDRESS = OC.WEBADDRESS,
        @SPONSORSHIPOPTION = ST.NAME,
        @FEESAMOUNT = ES.FEESAMOUNT,
        @FEESWAVIED = case when ES.FEESWAIVED = 1 then 'Yes' else 'No' end,
        @BENEFITS = dbo.UFN_SPONSOR_GETBENEFITLIST_BYSPONSORID(ES.ID),
        @BENEFITSWAVIED = case when ES.BENEFITSWAIVED = 1 then 'Yes' else 'No' end
    from dbo.EVENTSPONSOR ES(nolock)
    left outer join dbo.EVENTSPONSORSHIPTYPE ST (nolock)
        on ST.ID = ES.EVENTSPONSORSHIPTYPEID
    left outer join dbo.CONSTITUENT IC(nolock)
        on IC.ID = ES.CONSTITUENTID
    left outer join dbo.CONSTITUENT OC(nolock)
        on OC.ID = ES.ORGANIZATIONCONSTITUENTID
    left outer join dbo.SiteImages SI(nolock)
        on SI.ID = ES.EVENTSPONSORSHIPLOGOID
    where ES.ID = @ID

    return 0;