USP_DATAFORMTEMPLATE_ADD_EVENTSPONSOR

Add FAF Event Sponsor

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@EVENTID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
@EVENTSPONSORSHIPTYPEID	uniqueidentifier	IN
@EVENTSPONSORSHIPLOGOID	int	IN
@EVENTSPONSORSHIPURL	nvarchar(4000)	IN
@SPONSORSHIPMESSAGE	nvarchar(2000)	IN
@CREDITCARDTOKEN	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_ADD_EVENTSPONSOR
(
   @ID                        uniqueidentifier = null output
  ,@CHANGEAGENTID            uniqueidentifier = null  
  ,@EVENTID                    uniqueidentifier = null 
  ,@CONSTITUENTID            uniqueidentifier = null 
  ,@EVENTSPONSORSHIPTYPEID    uniqueidentifier = null 
  ,@EVENTSPONSORSHIPLOGOID  int                 = null
  ,@EVENTSPONSORSHIPURL        nvarchar(4000)   = null
  ,@SPONSORSHIPMESSAGE        nvarchar(2000)   = null
  ,@CREDITCARDTOKEN uniqueidentifier = null
)
as
begin

    set nocount on;

    if @ID is null set @ID = newid()

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    declare @CURRENTDATE datetime
    set    @CURRENTDATE = getdate()

    begin try    
        -- Event should be sponsored by the same sponsor once.

        if not exists(select 1 from dbo.EVENTSPONSOR where EVENTID=@EVENTID and CONSTITUENTID=@CONSTITUENTID)
        begin
            insert into dbo.EVENTSPONSOR(
                 ID
                ,EVENTID 
                ,CONSTITUENTID 
                ,EVENTSPONSORSHIPTYPEID 
                ,EVENTSPONSORSHIPLOGOID 
                ,EVENTSPONSORSHIPURL    
                ,SPONSORSHIPMESSAGE
        ,CREDITCARDTOKEN
                ,ADDEDBYID
                ,CHANGEDBYID
                ,DATEADDED
                ,DATECHANGED
            )  
            values (
                 @ID
                ,@EVENTID
                ,@CONSTITUENTID
                ,@EVENTSPONSORSHIPTYPEID
                ,@EVENTSPONSORSHIPLOGOID 
                ,@EVENTSPONSORSHIPURL    
                ,@SPONSORSHIPMESSAGE
        ,@CREDITCARDTOKEN
                ,@CHANGEAGENTID
                ,@CHANGEAGENTID
                ,@CURRENTDATE
                ,@CURRENTDATE
            );
        end    
    end try

    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;
end