USP_SPONSOR_EVENTSPONSOR_ADD

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
@CREDITCARDID	uniqueidentifier	IN
@BENEFITSWAIVED	bit	IN
@FEESAMOUNT	money	IN
@ORGANIZATIONCONSTITUENTID	uniqueidentifier	IN
@ISCANCELLED	bit	IN
Definition

Copy


CREATE procedure dbo.USP_SPONSOR_EVENTSPONSOR_ADD
(
   @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
  ,@CREDITCARDID uniqueidentifier = null
  ,@BENEFITSWAIVED bit = 0
  ,@FEESAMOUNT money = 0
  ,@ORGANIZATIONCONSTITUENTID    uniqueidentifier = null
  ,@ISCANCELLED bit = 0
)
as
begin

    set nocount on;

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

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

     if @SPONSORSHIPMESSAGE is null 
    set @SPONSORSHIPMESSAGE = '';

    declare @CURRENTDATE datetime;
    set    @CURRENTDATE = getdate();

  -- declare @SPONSORCONSTITUENTID uniqueidentifier;

  -- set @SPONSORCONSTITUENTID = @CONSTITUENTID;

  -- if @ORGANIZATIONCONSTITUENTID is not null 

    -- set @SPONSORCONSTITUENTID = @ORGANIZATIONCONSTITUENTID;


    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
                ,ORGANIZATIONCONSTITUENTID
                ,EVENTSPONSORSHIPTYPEID 
                ,EVENTSPONSORSHIPLOGOID 
                ,EVENTSPONSORSHIPURL    
                ,SPONSORSHIPMESSAGE
                ,CREDITCARDID
                ,FEESAMOUNT
                ,BENEFITSWAIVED
                ,ISCANCELLED
                ,ADDEDBYID
                ,CHANGEDBYID
                ,DATEADDED
                ,DATECHANGED
            )  
            values (
                 @ID
                ,@EVENTID
                ,@CONSTITUENTID
                ,@ORGANIZATIONCONSTITUENTID
                ,@EVENTSPONSORSHIPTYPEID
                ,@EVENTSPONSORSHIPLOGOID 
                ,@EVENTSPONSORSHIPURL    
                ,@SPONSORSHIPMESSAGE
                ,@CREDITCARDID
                ,@FEESAMOUNT
                ,@BENEFITSWAIVED
                ,@ISCANCELLED
                ,@CHANGEAGENTID
                ,@CHANGEAGENTID
                ,@CURRENTDATE
                ,@CURRENTDATE
            );
        end    

        -- Add Sponsor benefits

        if @BENEFITSWAIVED = 0
        begin
            insert into dbo.SPONSORBENEFITEXTENSION(
                [ID]
               ,[SPONSORID]
               ,[BENEFITID]
               ,[EVENTSPONSORSHIPTYPEID]
               ,[QUANTITY]
               ,[UNITVALUE]
               ,[TOTALVALUE]
               ,[BASECURRENCYID]
               ,[ADDEDBYID]
               ,[CHANGEDBYID]
               ,[DATEADDED]
               ,[DATECHANGED]
            )
            select
                 newid()
                ,@ID
                ,ESTB.[BENEFITID]
                ,ESTB.[EVENTSPONSORSHIPTYPEID]
                ,ESTB.[QUANTITY]
                ,B.VALUE
                ,B.VALUE * ESTB.QUANTITY
                ,B.[BASECURRENCYID]
                ,@CHANGEAGENTID
                ,@CHANGEAGENTID
                ,@CURRENTDATE
                ,@CURRENTDATE
            from dbo.EVENTSPONSORSHIPTYPEBENEFIT ESTB(nolock)
            inner join dbo.BENEFIT B(nolock)
                on B.ID = ESTB.BENEFITID
            where EVENTSPONSORSHIPTYPEID=@EVENTSPONSORSHIPTYPEID
        end

    end try

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

    return 0;
end