USP_EVENTSPONSOR_EDITLOAD

Loads an event sponsor's data for editing.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@EVENTID	uniqueidentifier	INOUT
@EVENTSPONSORID	uniqueidentifier	INOUT
@CONSTITUENTID	uniqueidentifier	INOUT
@EVENTSPONSORSHIPLOGO	varbinary	INOUT
@EVENTSPONSORSHIPURL	nvarchar(4000)	INOUT
@SPONSORSHIPMESSAGE	nvarchar(2000)	INOUT
@ORGANIZATIONCONSTITUENTID	uniqueidentifier	INOUT
@ORGANIZATIONWEBADDRESS	nvarchar(4000)	INOUT
@EVENTSPONSORSHIPTYPEID	uniqueidentifier	INOUT
@FEESAMOUNT	money	INOUT
@FEESWAIVED	bit	INOUT
@BENEFITS	nvarchar(2048)	INOUT
@BENEFITSWAIVED	bit	INOUT
@ALLOWADMINACCESSHQ	bit	INOUT

Definition

Copy



CREATE procedure dbo.USP_EVENTSPONSOR_EDITLOAD
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @EVENTID uniqueidentifier = null output,
  @EVENTSPONSORID uniqueidentifier = null output,
  @CONSTITUENTID uniqueidentifier = null output,
  @EVENTSPONSORSHIPLOGO varbinary(max) = null output,
  @EVENTSPONSORSHIPURL nvarchar(4000) = null output,
    @SPONSORSHIPMESSAGE nvarchar(2000) = null output,
    @ORGANIZATIONCONSTITUENTID uniqueidentifier = null output,
  @ORGANIZATIONWEBADDRESS nvarchar(4000) = null output,
    @EVENTSPONSORSHIPTYPEID uniqueidentifier = null output,
    @FEESAMOUNT money = null output,
  @FEESWAIVED bit = null output,
    @BENEFITS nvarchar(2048) = null output,
  @BENEFITSWAIVED bit = null output,
  @ALLOWADMINACCESSHQ bit = null output
)
as
begin
    -- do work


    set nocount on;
    set @DATALOADED = 0;
    set @TSLONG = 0;

  select top 1
      @DATALOADED = 1,     
      @TSLONG = ES.TSLONG,
    @EVENTID = ES.EVENTID,
    @EVENTSPONSORID = ES.ID,
    @CONSTITUENTID = ES.CONSTITUENTID,
    @EVENTSPONSORSHIPLOGO = SI.ImageContent,
    @EVENTSPONSORSHIPURL = ES.EVENTSPONSORSHIPURL,
      @SPONSORSHIPMESSAGE = ES.SPONSORSHIPMESSAGE,
      @ORGANIZATIONCONSTITUENTID = ES.ORGANIZATIONCONSTITUENTID,
    @ORGANIZATIONWEBADDRESS = OC.WEBADDRESS,
      @EVENTSPONSORSHIPTYPEID = ES.EVENTSPONSORSHIPTYPEID,
      @FEESAMOUNT = ES.FEESAMOUNT,
    @FEESWAIVED = ES.FEESWAIVED,
      @BENEFITS = dbo.UFN_SPONSOR_GETBENEFITLIST_BYSPONSORID(ES.ID),
    @BENEFITSWAIVED = ES.BENEFITSWAIVED,
    @ALLOWADMINACCESSHQ = ES.ALLOWADMINACCESSHQ
  from
    dbo.EVENTSPONSOR ES(nolock)
    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;
end