USP_DATAFORMTEMPLATE_EDIT_FAFTOPFUNDRAISERDISPLAYOPTION

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

    @DISPLAYCOMPANIES bit,
    @DISPLAYTEAMS bit,
    @DISPLAYHOUSEHOLDS bit,
    @DISPLAYPARTICIPANTS bit,

    @DISPLAYTEAMNAMEADDITIONFUNDRAISERNAME bit,
    @DISPLAYCOMPANYNAMEADDITIONFUNDRAISERNAME bit 
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        -- handle updating the data
        update dbo.FAFTOPFUNDRAISERDISPLAYOPTION 
    SET
            EVENTID = @EVENTID,
            NUMBERCOMPANIESTODISPLAY = @NUMBERCOMPANIESTODISPLAY,
            DISPLAYCOMPANYNAME = @DISPLAYCOMPANYNAME,
            DISPLAYCOMPANYPICTURE = @DISPLAYCOMPANYPICTURE,
            DISPLAYCOMPANYSTORY = @DISPLAYCOMPANYSTORY,
            DISPLAYCOMPANYTOTALRAISED = @DISPLAYCOMPANYTOTALRAISED,
            DISPLAYCOMPANYFUNDRAISINGGOAL = @DISPLAYCOMPANYFUNDRAISINGGOAL,
            NUMBERTEAMSTODISPLAY = @NUMBERTEAMSTODISPLAY,
            DISPLAYTEAMNAME = @DISPLAYTEAMNAME,
            DISPLAYTEAMPICTURE = @DISPLAYTEAMPICTURE,
            DISPLAYTEAMSTORY = @DISPLAYTEAMSTORY,
            DISPLAYTEAMTOTALRAISED = @DISPLAYTEAMTOTALRAISED,
            DISPLAYTEAMFUNDRAISINGGOAL = @DISPLAYTEAMFUNDRAISINGGOAL,
            NUMBERHOUSEHOLDSTODISPLAY = @NUMBERHOUSEHOLDSTODISPLAY,
            DISPLAYHOUSEHOLDNAME = @DISPLAYHOUSEHOLDNAME,
            DISPLAYHOUSEHOLDPICTURE = @DISPLAYHOUSEHOLDPICTURE,
            DISPLAYHOUSEHOLDSTORY = @DISPLAYHOUSEHOLDSTORY,
            DISPLAYHOUSEHOLDTOTALRAISED = @DISPLAYHOUSEHOLDTOTALRAISED,
            DISPLAYHOUSEHOLDFUNDRAISINGGOAL = @DISPLAYHOUSEHOLDFUNDRAISINGGOAL,
            NUMBERPARTICIPANTSTODISPLAY = @NUMBERPARTICIPANTSTODISPLAY,
            DISPLAYPARTICIPANTNAME = @DISPLAYPARTICIPANTNAME,
            DISPLAYPARTICIPANTPICTURE = @DISPLAYPARTICIPANTPICTURE,
            DISPLAYPARTICIPANTSTORY = @DISPLAYPARTICIPANTSTORY,
            DISPLAYPARTICIPANTTOTALRAISED = @DISPLAYPARTICIPANTTOTALRAISED,
            DISPLAYPARTICIPANTFUNDRAISINGGOAL = @DISPLAYPARTICIPANTFUNDRAISINGGOAL,
            PLAYEROPTIONSTITLE = @PLAYEROPTIONSTITLE,
            WIDTH = @WIDTH,
            HEIGHT = @HEIGHT,
            SCROLLINGDIRECTIONCODE = @SCROLLINGDIRECTIONCODE,
            SPEED = @SPEED,
            DISPLAYPLAYPAUSEOPTIONS = @DISPLAYPLAYPAUSEOPTIONS,
            DISPLAYCOMPANIES = @DISPLAYCOMPANIES, 
            DISPLAYTEAMS = @DISPLAYTEAMS, 
            DISPLAYHOUSEHOLDS = @DISPLAYHOUSEHOLDS,
            DISPLAYPARTICIPANTS = @DISPLAYPARTICIPANTS,

            DISPLAYTEAMNAMEADDITIONFUNDRAISERNAME= @DISPLAYTEAMNAMEADDITIONFUNDRAISERNAME,
            DISPLAYCOMPANYNAMEADDITIONFUNDRAISERNAME= @DISPLAYCOMPANYNAMEADDITIONFUNDRAISERNAME,

            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate()
        where ID = @ID

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

return 0;