USP_SIMPLEDATALIST_DONATIONBATCHGIFTFREQUENCIES

create procedure dbo.USP_SIMPLEDATALIST_DONATIONBATCHGIFTFREQUENCIES
(
  @EVENTID uniqueidentifier,
  @GIFTTYPE nvarchar(50)
) as
  declare @MONTHLYGIFT bit;
  declare @ANNUALLYGIFT bit;
  declare @SEMIANNUALLYGIFT bit;
  declare @QUARTERLYGIFT bit;
  declare @BIMONTHLYGIFT bit;
  declare @SEMIMONTHLYGIFT bit;
  declare @BIWEEKLYGIFT bit;
  declare @WEEKLYGIFT bit;

  declare @MONTHLYPLEDGE bit;
  declare @ANNUALLYPLEDGE bit;
  declare @SEMIANNUALLYPLEDGE bit;
  declare @QUARTERLYPLEDGE bit;
  declare @SEMIMONTHLYPLEDGE bit;
  declare @BIWEEKLYPLEDGE bit;
  declare @SINGLEPLEDGE bit;

  select
    @MONTHLYGIFT = [ISFREQUENCYAVAILONLINEMONTHLYGIFT],  
    @ANNUALLYGIFT = [ISFREQUENCYAVAILONLINEANNUALLYGIFT],  
    @SEMIANNUALLYGIFT = [ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT],  
    @QUARTERLYGIFT = [ISFREQUENCYAVAILONLINEQUARTERLYGIFT],  
    @BIMONTHLYGIFT = [ISFREQUENCYAVAILONLINEBIMONTHLYGIFT],  
    @SEMIMONTHLYGIFT = [ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT],  
    @BIWEEKLYGIFT = [ISFREQUENCYAVAILONLINEBIWEEKLYGIFT],  
    @WEEKLYGIFT = [ISFREQUENCYAVAILONLINEWEEKLYGIFT],  

    @MONTHLYPLEDGE = [ISFREQUENCYAVAILONLINEMONTHLYPLEDGE],  
    @ANNUALLYPLEDGE = [ISFREQUENCYAVAILONLINEANNUALLYPLEDGE],  
    @SEMIANNUALLYPLEDGE = [ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE],  
    @QUARTERLYPLEDGE = [ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE],   
    @SEMIMONTHLYPLEDGE = [ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE],  
    @BIWEEKLYPLEDGE = [ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE],
    @SINGLEPLEDGE = [ISFREQUENCYAVAILONLINESINGLEPLEDGE]
  from
      FAFEVENTDONATIONOPTIONSCONFIG
  where EVENTID=@EVENTID;

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

  if lower(@GIFTTYPE)='recurring_gift'
  begin
    if @MONTHLYGIFT is not null and @MONTHLYGIFT = 1
      insert into #TEMP_CONFIG values ('monthly', 'Monthly')
    if @ANNUALLYGIFT is not null and @ANNUALLYGIFT = 1
      insert into #TEMP_CONFIG values ('annually', 'Annually')
    if @SEMIANNUALLYGIFT is not null and @SEMIANNUALLYGIFT = 1
      insert into #TEMP_CONFIG values ('semi_annually', 'Semi-annually')
    if @QUARTERLYGIFT is not null and @QUARTERLYGIFT = 1
      insert into #TEMP_CONFIG values ('quarterly', 'Quarterly')
    if @BIMONTHLYGIFT is not null and @BIMONTHLYGIFT = 1
      insert into #TEMP_CONFIG values ('bimonthly', 'Bimonthly')
    if @SEMIMONTHLYGIFT is not null and @SEMIMONTHLYGIFT = 1
      insert into #TEMP_CONFIG values ('semi_monthly', 'Semi-monthly')
    if @BIWEEKLYGIFT is not null and @BIWEEKLYGIFT = 1
      insert into #TEMP_CONFIG values ('biweekly', 'Biweekly')
    if @WEEKLYGIFT is not null and @WEEKLYGIFT = 1
      insert into #TEMP_CONFIG values ('weekly', 'Weekly')
  end
  else
  begin
    if @MONTHLYPLEDGE is not null and @MONTHLYPLEDGE = 1
      insert into #TEMP_CONFIG values ('monthly', 'Monthly')
    if @ANNUALLYPLEDGE is not null and @ANNUALLYPLEDGE = 1
      insert into #TEMP_CONFIG values ('annually', 'Annually')
    if @SEMIANNUALLYPLEDGE is not null and @SEMIANNUALLYPLEDGE = 1
      insert into #TEMP_CONFIG values ('semi_annually', 'Semi-annually')
    if @QUARTERLYPLEDGE is not null and @QUARTERLYPLEDGE = 1
      insert into #TEMP_CONFIG values ('quarterly', 'Quarterly')
    if @SEMIMONTHLYPLEDGE is not null and @SEMIMONTHLYPLEDGE = 1
      insert into #TEMP_CONFIG values ('semi_monthly', 'Semi-monthly')
    if @BIWEEKLYPLEDGE is not null and @BIWEEKLYPLEDGE = 1
      insert into #TEMP_CONFIG values ('biweekly', 'Biweekly')
    if @SINGLEPLEDGE is not null and @SINGLEPLEDGE = 1
      insert into #TEMP_CONFIG values ('single_payment', 'Single-Payment')
  end

    select
        value, label
    from #TEMP_CONFIG

  drop table #TEMP_CONFIG