USP_DATAFORMTEMPLATE_ADD_FAFTOPFUNDRAISERDISPLAYOPTION

CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FAFTOPFUNDRAISERDISPLAYOPTION
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @EVENTID uniqueidentifier,
    @NUMBERCOMPANIESTODISPLAY smallint = 5,
    @DISPLAYCOMPANYNAME bit = 1,
    @DISPLAYCOMPANYPICTURE bit = 1,
    @DISPLAYCOMPANYSTORY bit = 1,
    @DISPLAYCOMPANYTOTALRAISED bit = 1,
    @DISPLAYCOMPANYFUNDRAISINGGOAL bit = 1,
    @NUMBERTEAMSTODISPLAY smallint = 5,
    @DISPLAYTEAMNAME bit = 1,
    @DISPLAYTEAMPICTURE bit = 1,
    @DISPLAYTEAMSTORY bit = 1,
    @DISPLAYTEAMTOTALRAISED bit = 1,
    @DISPLAYTEAMFUNDRAISINGGOAL bit = 1,
    @NUMBERHOUSEHOLDSTODISPLAY smallint = 5,
    @DISPLAYHOUSEHOLDNAME bit = 1,
    @DISPLAYHOUSEHOLDPICTURE bit = 1,
    @DISPLAYHOUSEHOLDSTORY bit = 1,
    @DISPLAYHOUSEHOLDTOTALRAISED bit = 1,
    @DISPLAYHOUSEHOLDFUNDRAISINGGOAL bit = 1,
    @NUMBERPARTICIPANTSTODISPLAY smallint = 5,
    @DISPLAYPARTICIPANTNAME bit = 1,
    @DISPLAYPARTICIPANTPICTURE bit = 1,
    @DISPLAYPARTICIPANTSTORY bit = 1,
    @DISPLAYPARTICIPANTTOTALRAISED bit = 1,
    @DISPLAYPARTICIPANTFUNDRAISINGGOAL bit = 1,
    @PLAYEROPTIONSTITLE nvarchar(200) = '',
    @WIDTH smallint = 0,
    @HEIGHT smallint = 0,
    @SCROLLINGDIRECTIONCODE tinyint = 1,
    @SPEED smallint = 0,
    @DISPLAYPLAYPAUSEOPTIONS bit = 1,

    @DISPLAYCOMPANIES bit =1, 
    @DISPLAYTEAMS bit =1,
    @DISPLAYHOUSEHOLDS bit =1,
    @DISPLAYPARTICIPANTS bit =1,
    @DISPLAYTEAMNAMEADDITIONFUNDRAISERNAME bit =1,
    @DISPLAYCOMPANYNAMEADDITIONFUNDRAISERNAME bit =1 
)
as

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
    -- handle inserting the data
    insert into dbo.FAFTOPFUNDRAISERDISPLAYOPTION
        (ID, EVENTID, NUMBERCOMPANIESTODISPLAY, DISPLAYCOMPANYNAME, DISPLAYCOMPANYPICTURE, DISPLAYCOMPANYSTORY, DISPLAYCOMPANYTOTALRAISED, DISPLAYCOMPANYFUNDRAISINGGOAL, 
      NUMBERTEAMSTODISPLAY, DISPLAYTEAMNAME, DISPLAYTEAMPICTURE, DISPLAYTEAMSTORY, DISPLAYTEAMTOTALRAISED, DISPLAYTEAMFUNDRAISINGGOAL, NUMBERHOUSEHOLDSTODISPLAY, 
      DISPLAYHOUSEHOLDNAME, DISPLAYHOUSEHOLDPICTURE, DISPLAYHOUSEHOLDSTORY, DISPLAYHOUSEHOLDTOTALRAISED, DISPLAYHOUSEHOLDFUNDRAISINGGOAL, NUMBERPARTICIPANTSTODISPLAY, 
      DISPLAYPARTICIPANTNAME, DISPLAYPARTICIPANTPICTURE, DISPLAYPARTICIPANTSTORY, DISPLAYPARTICIPANTTOTALRAISED, DISPLAYPARTICIPANTFUNDRAISINGGOAL, PLAYEROPTIONSTITLE,
      DISPLAYCOMPANIES, DISPLAYTEAMS, DISPLAYHOUSEHOLDS, DISPLAYPARTICIPANTS, WIDTH, HEIGHT, SCROLLINGDIRECTIONCODE, SPEED, DISPLAYPLAYPAUSEOPTIONS, 
      DISPLAYTEAMNAMEADDITIONFUNDRAISERNAME, DISPLAYCOMPANYNAMEADDITIONFUNDRAISERNAME, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    values
        (@ID, @EVENTID, @NUMBERCOMPANIESTODISPLAY, @DISPLAYCOMPANYNAME, @DISPLAYCOMPANYPICTURE, @DISPLAYCOMPANYSTORY, @DISPLAYCOMPANYTOTALRAISED, @DISPLAYCOMPANYFUNDRAISINGGOAL, 
      @NUMBERTEAMSTODISPLAY, @DISPLAYTEAMNAME, @DISPLAYTEAMPICTURE, @DISPLAYTEAMSTORY, @DISPLAYTEAMTOTALRAISED, @DISPLAYTEAMFUNDRAISINGGOAL, @NUMBERHOUSEHOLDSTODISPLAY, 
      @DISPLAYHOUSEHOLDNAME, @DISPLAYHOUSEHOLDPICTURE, @DISPLAYHOUSEHOLDSTORY, @DISPLAYHOUSEHOLDTOTALRAISED, @DISPLAYHOUSEHOLDFUNDRAISINGGOAL, @NUMBERPARTICIPANTSTODISPLAY, 
      @DISPLAYPARTICIPANTNAME, @DISPLAYPARTICIPANTPICTURE, @DISPLAYPARTICIPANTSTORY, @DISPLAYPARTICIPANTTOTALRAISED, @DISPLAYPARTICIPANTFUNDRAISINGGOAL, @PLAYEROPTIONSTITLE, 
      @DISPLAYCOMPANIES, @DISPLAYTEAMS, @DISPLAYHOUSEHOLDS, @DISPLAYPARTICIPANTS, @WIDTH, @HEIGHT, @SCROLLINGDIRECTIONCODE, @SPEED, @DISPLAYPLAYPAUSEOPTIONS, 
      @DISPLAYTEAMNAMEADDITIONFUNDRAISERNAME, @DISPLAYCOMPANYNAMEADDITIONFUNDRAISERNAME, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0