USP_EVENTSPONSOR_EDITSAVE

Edits an event sponsor information.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NEWSPONSORCONSTITUENTID	uniqueidentifier	INOUT
@CONSTITUENTID	uniqueidentifier	IN
@EVENTSPONSORSHIPLOGO	varbinary	IN
@PICTURECHANGED	bit	IN
@EVENTSPONSORSHIPURL	nvarchar(4000)	IN
@SPONSORSHIPMESSAGE	nvarchar(2000)	IN
@ORGANIZATIONCONSTITUENTID	uniqueidentifier	IN
@ORGANIZATIONWEBADDRESS	nvarchar(4000)	IN
@EVENTSPONSORSHIPTYPEID	uniqueidentifier	IN
@FEESWAIVED	bit	IN
@BENEFITSWAIVED	bit	IN
@PASSWORD	nvarchar(255)	IN

Definition

Copy



    CREATE procedure dbo.USP_EVENTSPONSOR_EDITSAVE
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NEWSPONSORCONSTITUENTID uniqueidentifier = null output,
    @CONSTITUENTID uniqueidentifier,
    @EVENTSPONSORSHIPLOGO varbinary(max) = null,
    @PICTURECHANGED bit = 0,
    @EVENTSPONSORSHIPURL nvarchar(4000) = null,
    @SPONSORSHIPMESSAGE nvarchar(2000) = null,
    @ORGANIZATIONCONSTITUENTID uniqueidentifier = null,
    @ORGANIZATIONWEBADDRESS nvarchar(4000) = null,
    @EVENTSPONSORSHIPTYPEID uniqueidentifier,
    @FEESWAIVED bit = 0,
    @BENEFITSWAIVED bit = 0,
    @PASSWORD nvarchar(255)
)
as

/*
begin try
    -- Handle any custom "before-save" logic here 
end try
begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
end catch
*/

/* invoke the default implementation */
declare @r int
exec @r = dbo.USP_EVENTSPONSOR_EDITSAVE2
  @ID = @ID,
    @CURRENTAPPUSERID = @CURRENTAPPUSERID,
    @CHANGEAGENTID = @CHANGEAGENTID,
    @NEWSPONSORCONSTITUENTID = @NEWSPONSORCONSTITUENTID,
    @CONSTITUENTID = @CONSTITUENTID,
    @EVENTSPONSORSHIPLOGO = @EVENTSPONSORSHIPLOGO,
    @PICTURECHANGED = @PICTURECHANGED,
    @EVENTSPONSORSHIPURL = @EVENTSPONSORSHIPURL,
    @SPONSORSHIPMESSAGE = @SPONSORSHIPMESSAGE,
    @ORGANIZATIONCONSTITUENTID = @ORGANIZATIONCONSTITUENTID,
    @ORGANIZATIONWEBADDRESS = @ORGANIZATIONWEBADDRESS,
    @EVENTSPONSORSHIPTYPEID = @EVENTSPONSORSHIPTYPEID,
    @FEESWAIVED = @FEESWAIVED,
    @BENEFITSWAIVED = @BENEFITSWAIVED,
    @PASSWORD = @PASSWORD,
  @ALLOWADMINACCESSHQ = null

if @@error <> 0 
    begin
        if @r <> 0 return @r
        return 1;
    end

/*
begin try
    -- Handle any custom "after-save" logic here
end try
begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
end catch
 */

return @r;