USP_SIMPLEDATALIST_DONATIONBATCHRECIPIENTROLE

CREATE procedure dbo.USP_SIMPLEDATALIST_DONATIONBATCHRECIPIENTROLE
(
  @EVENTID uniqueidentifier
) as

  declare @ISALLOWCOMPANYDONATIONS bit;
  declare @ISALLOWEVENTDONATIONS bit;
  declare @ISALLOWTEAMDONATIONS bit;

  select
    @ISALLOWCOMPANYDONATIONS = ISALLOWCOMPANYDONATIONS,
    @ISALLOWEVENTDONATIONS = ISALLOWEVENTDONATIONS,
    @ISALLOWTEAMDONATIONS = ISALLOWTEAMDONATIONS
  from FAFEVENTDONATIONOPTIONSCONFIG
  where EVENTID=@EVENTID;

  create table #TEMP_CONFIG
  (
      value nvarchar(50),
      label nvarchar(50)
  );

  if @ISALLOWEVENTDONATIONS is not null and @ISALLOWEVENTDONATIONS = 1
    insert into #TEMP_CONFIG values ('0','The hosting event');

  insert into #TEMP_CONFIG values ('4','An individual');

  if @ISALLOWTEAMDONATIONS is not null and @ISALLOWTEAMDONATIONS = 1
    insert into #TEMP_CONFIG values ('1','A team');

  if @ISALLOWCOMPANYDONATIONS is not null and @ISALLOWCOMPANYDONATIONS = 1
    insert into #TEMP_CONFIG values ('2','A company');

  insert into #TEMP_CONFIG values ('3','A household');

    select value, label from #TEMP_CONFIG

  drop table #TEMP_CONFIG;