USP_FAFDEFAULTOPTIONS_CREATE

CREATE procedure dbo.USP_FAFDEFAULTOPTIONS_CREATE
(
  @EVENTID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null
)
as
begin

  declare @EVENTREGISTRATIONTYPEID uniqueidentifier = null,
          @CURRENTDATE datetime;

  set @CURRENTDATE = getdate();

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

  select @EVENTREGISTRATIONTYPEID = ID from dbo.EVENTREGISTRATIONTYPE where [DESCRIPTION] = 'General'
  if @EVENTREGISTRATIONTYPEID is null
    begin
      set @EVENTREGISTRATIONTYPEID = newid()
      insert into dbo.EVENTREGISTRATIONTYPE
            (ID, DESCRIPTION, REGISTRATIONCOUNT, ISACTIVE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
          values
              (@EVENTREGISTRATIONTYPEID, 'General', 1, 1, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);
    end

  exec dbo.USP_DATAFORMTEMPLATE_FAF_REGISTRATION_TYPE_ADD @NAME=N'General',@REGISTRATIONCOUNT=1,
    @BENEFITS=N'<?xml version="1.0" encoding="utf-16"?><BENEFITS />',
    @EVENTREGISTRATIONTYPEID=@EVENTREGISTRATIONTYPEID,
    @DESCRIPTION=N'',
    @ISNOTAVAILABLEONLINEREG=0,@ISREGTYPEAVAILABLEINDIVIDUAL=1,@ISREGTYPEAVAILABLEFAMILYMEMBER=1,@ISREGTYPEAVAILABLEHEADHOUSEHOLD=1,
    @ISREGTYPEAVAILABLETEAMMEMBER=1,@ISREGTYPEAVAILABLETEAMLEADER=1,@ISREGTYPEAVAILABLECOMPANYLEADER=1,@AMOUNT=0,@RECEIPTAMOUNT=0,
    @EARLYREGISTRATIONDATE=NULL,@LATEFEEDATE=NULL,@EARLYREGISTRATIONDISCOUNT=0,@LATEFEE=0,@ALLOWPARTICIPANTSWAIVEBENEFITS=1,
    @MINFUNDRAISING=100,@ISNOTLOWERFUNDRAISING=0,@PARTICIPANTMUSTPAYBALANCE=0,@PARTICIPANTPAYSBALANCEMESSAGE=N'If you do not meet the minimum fundraising goal by the event end date, we will charge the balance to the credit card you submit during registration.',
    @RECRUITEMENT=0,@ISNOTLOWERRECRUITEMENT=0,@VOLUNTEERRECRUITEMENT=0,@ISNOTLOWERVOLUNTEERRECRUITEMENT=0,@DONORRETENTION=0,
    @ISNOTLOWERDONORRETENTION=0,@UNIT=0,@ISNOTLOWERUNIT=0,@COMMUNICATIONS=0,@ISNOTLOWERCOMMUNICATION=0,@LABELFORUNIT=N'',@TARGETFUNDRAISING=100,
    @ISNOTLOWERTARGETFUNDRAISING=0,@TEAMMINFUNDRAISING=0,@TEAMISNOTLOWERFUNDRAISING=0,@TEAMRECRUITEMENT=0,@TEAMISNOTLOWERRECRUITEMENT=0,
    @TEAMMEMBERS=0,@ISNOTLOWERTEAMMEMBERS=0,@TEAMVOLUNTEERRECRUITEMENT=0,@ISNOTLOWERVOLUNTEERRECRUITEMENTTEAMGOAL=0,@TEAMMEMBERRETENTION=0,
    @ISNOTLOWERTEAMMEMBERRETENTION=0,@TEAMUNIT=0,@TEAMISNOTLOWERUNIT=0,@TEAMCOMMUNICATIONS=0,@TEAMSNOTLOWERCOMMUNICATION=0,@TEAMLABELFORUNIT=N'',
    @COMPANYMINFUNDRAISING=0,@COMPANYISNOTLOWERFUNDRAISING=0,@COMPANYRECRUITEMENT=0,@COMPANYISNOTLOWERRECRUITEMENT=0,@TEAMS=0,@ISNOTLOWERTEAMS=0,
    @COMPANYCOMMUNICATIONS=0,@COMPANYISNOTLOWERCOMMUNICATION=0,@TEAMRETENTION=0,@ISNOTLOWERTEAMRETENTION=0,@COMPANYVOLUNTEERRECRUITEMENT=0,
    @COMPANYISNOTLOWERVOLUNTEERRECRUITEMENT=0,@COMPANYTEAMMEMBERS=0,@COMPANYISNOTLOWERTEAMMEMBERS=0,@COMPANYUNIT=0,@COMPANYISNOTLOWERUNIT=0,
    @COMPANYTEAMMEMBERRETENTION=0,@COMPANYISNOTLOWERTEAMMEMBERRETENTION=0,@COMPANYLABELFORUNIT=N'',@MAXQUANTITY=0,@TURNONWAITLIST=0,
    @DISPLAYSPOTSAVAILABLE=0,@SENDEVENTCONTACTALERTMAXREACHED=0,@WAITLISTMESSAGE=N'',@MINIMUMAGE=N'',@MAXIMUMAGE=N'',@HOUSEHOLDMINFUNDRAISING=100,
    @HOUSEHOLDISNOTLOWERFUNDRAISING=0,@HOUSEHOLDPARTICIPANTMUSTPAYBALANCE=0,@HOUSEHOLDPARTICIPANTPAYSBALANCEMESSAGE=N'',@HOUSEHOLDRECRUITEMENT=0,
    @HOUSEHOLDISNOTLOWERRECRUITEMENT=0,@HOUSEHOLDVOLUNTEERRECRUITEMENT=0,@HOUSEHOLDISNOTLOWERVOLUNTEERRECRUITEMENT=0,@HOUSEHOLDDONORRETENTION=0,
    @HOUSEHOLDISNOTLOWERDONORRETENTION=0,@HOUSEHOLDUNIT=0,@HOUSEHOLDISNOTLOWERUNIT=0,@HOUSEHOLDCOMMUNICATIONS=0,@HOUSEHOLDISNOTLOWERCOMMUNICATION=0,
    @HOUSEHOLDLABELFORUNIT=N'',@HOUSEHOLDTARGETFUNDRAISING=100,@HOUSEHOLDISNOTLOWERTARGETFUNDRAISING=0,
    @CHANGEAGENTID=@CHANGEAGENTID,@EVENTID=@EVENTID

  exec USP_DATAFORMTEMPLATE_ADD_SPONSORSHIPTYPE @NAME=N'General',@DESCRIPTION=N'',@BENEFITS=N'<?xml version="1.0" encoding="utf-16"?><BENEFITS />',
    @ISNOTAVAILABLEONLINEREG=0,@FEESAMOUNT=0,@TAXDEDUCTIBLEAMOUNT=0,@EARLYREGISTRATIONDATE=NULL,@EARLYREGISTRATIONDISCOUNT=0,@LATEFEEDATE=NULL,
    @LATEFEE=0,@MINFUNDRAISINGGOAL=0,@ISNOTLOWERFUNDRAISINGGOAL=0,@SPONSORMUSTPAYBALANCE=0,@SPONSORPAYSBALANCEMESSAGE=N'',@RECRUITEMENT=0,
    @ISNOTLOWERRECRUITEMENT=0,@VOLUNTEERRECRUITEMENT=0,@ISNOTLOWERVOLUNTEERRECRUITEMENT=0,@DONORRETENTION=0,@ISNOTLOWERDONORRETENTION=0,@UNIT=0,
    @ISNOTLOWERUNIT=0,@COMMUNICATIONS=0,@ISNOTLOWERCOMMUNICATION=0,@LABELFORUNITGOAL=N'',@NUMBERAVAILABLE=0,@TURNONWAITLIST=0,@DISPLAYSPOTSAVAILABLE=0,
    @SENDEVENTCONTACTALERTMAXREACHED=0,@WAITLISTMESSAGE=N'',@ALLOWSPONSORWAIVEBENEFITS=1,
    @CHANGEAGENTID=@CHANGEAGENTID,@EVENTID=@EVENTID

end