USP_DATAFORMTEMPLATE_EDIT_FAF_FUNDRAISING_ROLES_CONTENT

The save procedure used by the edit dataform template "FAF Fundraising Roles Content Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@REGISTRATIONPAGEID	int	IN	Registrationpage
@STARTACOMPANYTITLE	nvarchar(500)	IN	Startacompanytitle
@STARTACOMPANYDESCRIPTION	nvarchar(510)	IN	Startacompanydescription
@STARTACOMPANYIMAGEID	int	IN	Startacompanyimageid
@STARTATEAMTITLE	nvarchar(500)	IN	Startateamtitle
@STARTATEAMDESCRIPTION	nvarchar(510)	IN	Startateamdescription
@STARTATEAMTITLEIMAGEID	int	IN	Startateamtitleimageid
@STARTATEAMUNDERGROUPTITLE	nvarchar(500)	IN	Startateamundergrouptitle
@STARTATEAMUNDERGROUPDESCRIPTION	nvarchar(510)	IN	Startateamundergroupdescription
@STARTATEAMUNDERGROUPIMAGEID	int	IN	Startateamundergroupimageid
@STARTATEAMINDEPENDENTTITLE	nvarchar(500)	IN	Startateamindependenttitle
@STARTATEAMINDEPENDENTDESCRIPTION	nvarchar(510)	IN	Startateamindependentdescription
@STARTATEAMINDEPENDENTIMAGEID	int	IN	Startateamindependentimageid
@JOINATEAMTITLE	nvarchar(500)	IN	Joinateamtitle
@JOINATEAMDESCRIPTION	nvarchar(510)	IN	Joinateamdescription
@JOINATEAMTITLEIMAGEID	int	IN	Joinateamtitleimageid
@STARTAHOUSEHOLDTITLE	nvarchar(500)	IN	Startahouseholdtitle
@STARTAHOUSEHOLDDESCRIPTION	nvarchar(510)	IN	Startahouseholddescription
@STARTAHOUSEHOLDIMAGEID	int	IN	Startahouseholdimageid
@STARTAHOUSEHOLDUNDERCOMPANYTITLE	nvarchar(500)	IN	Startahouseholdundercompanytitle
@STARTAHOUSEHOLDUNDERCOMPANYDESCRIPTION	nvarchar(510)	IN	Startahouseholdundercompanydescription
@STARTAHOUSEHOLDUNDERCOMPANYIMAGEID	int	IN	Startahouseholdundercompanyimageid
@STARTAHOUSEHOLDUNDERTEAMTITLE	nvarchar(500)	IN	Startahouseholdunderteamtitle
@STARTAHOUSEHOLDUNDERTEAMDESCRIPTION	nvarchar(510)	IN	Startahouseholdunderteamdescription
@STARTAHOUSEHOLDUNDERTEAMIMAGEID	int	IN	Startahouseholdunderteamimageid
@STARTAHOUSEHOLDINDEPENDENTTITLE	nvarchar(500)	IN	Startahouseholdindependenttitle
@STARTAHOUSEHOLDINDEPENDENTDESCRIPTION	nvarchar(510)	IN	Startahouseholdindependentdescription
@STARTAHOUSEHOLDINDEPENDENTIMAGEID	int	IN	Startahouseholdindependentimageid
@JOINASINDIVIDUALTITLE	nvarchar(500)	IN	Joinasindividualtitle
@JOINASINDIVIDUALDESCRIPTION	nvarchar(510)	IN	Joinasindividualdescription
@JOINASINDIVIDUALIMAGEID	int	IN	Joinasindividualimageid
@JOINASINDIVIDUALUNDERCOMPANYTITLE	nvarchar(500)	IN	Joinasindividualundercompanytitle
@JOINASINDIVIDUALUNDERCOMPANYDESCRIPTION	nvarchar(510)	IN	Joinasindividualundercompanydescription
@JOINASINDIVIDUALUNDERCOMPANYIMAGEID	int	IN	Joinasindividualundercompanyimageid
@JOINASINDIVIDUALPARTICIPANTTITLE	nvarchar(500)	IN	Joinasindividualparticipanttitle
@JOINASINDIVIDUALPARTICIPANTDESCRIPTION	nvarchar(510)	IN	Joinasindividualparticipantdescription
@JOINASINDIVIDUALPARTICIPANTIMAGEID	int	IN	Joinasindividualparticipantimageid

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_FAF_FUNDRAISING_ROLES_CONTENT
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @REGISTRATIONPAGEID integer,
    @STARTACOMPANYTITLE nvarchar(500),
    @STARTACOMPANYDESCRIPTION nvarchar(510),
    @STARTACOMPANYIMAGEID int,
    @STARTATEAMTITLE nvarchar(500),
    @STARTATEAMDESCRIPTION nvarchar(510),
    @STARTATEAMTITLEIMAGEID int,
    @STARTATEAMUNDERGROUPTITLE nvarchar(500),
    @STARTATEAMUNDERGROUPDESCRIPTION nvarchar(510),
    @STARTATEAMUNDERGROUPIMAGEID int,
    @STARTATEAMINDEPENDENTTITLE nvarchar(500),
    @STARTATEAMINDEPENDENTDESCRIPTION nvarchar(510),
    @STARTATEAMINDEPENDENTIMAGEID int,
    @JOINATEAMTITLE nvarchar(500),
    @JOINATEAMDESCRIPTION nvarchar(510),
    @JOINATEAMTITLEIMAGEID int,
    @STARTAHOUSEHOLDTITLE nvarchar(500),
    @STARTAHOUSEHOLDDESCRIPTION nvarchar(510),
    @STARTAHOUSEHOLDIMAGEID int,
    @STARTAHOUSEHOLDUNDERCOMPANYTITLE nvarchar(500),
    @STARTAHOUSEHOLDUNDERCOMPANYDESCRIPTION nvarchar(510),
    @STARTAHOUSEHOLDUNDERCOMPANYIMAGEID int,
    @STARTAHOUSEHOLDUNDERTEAMTITLE nvarchar(500),
    @STARTAHOUSEHOLDUNDERTEAMDESCRIPTION nvarchar(510),
    @STARTAHOUSEHOLDUNDERTEAMIMAGEID int,
    @STARTAHOUSEHOLDINDEPENDENTTITLE nvarchar(500),
    @STARTAHOUSEHOLDINDEPENDENTDESCRIPTION nvarchar(510),
    @STARTAHOUSEHOLDINDEPENDENTIMAGEID int,
    @JOINASINDIVIDUALTITLE nvarchar(500),
    @JOINASINDIVIDUALDESCRIPTION nvarchar(510),
    @JOINASINDIVIDUALIMAGEID int,
    @JOINASINDIVIDUALUNDERCOMPANYTITLE nvarchar(500),
    @JOINASINDIVIDUALUNDERCOMPANYDESCRIPTION nvarchar(510),
    @JOINASINDIVIDUALUNDERCOMPANYIMAGEID int,
    @JOINASINDIVIDUALPARTICIPANTTITLE nvarchar(500),
    @JOINASINDIVIDUALPARTICIPANTDESCRIPTION nvarchar(510),
    @JOINASINDIVIDUALPARTICIPANTIMAGEID int
)
as

    set nocount on;

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

    begin try
        -- handle updating the data

        update dbo.FAFFUNDRAISINGROLESCONTENT set
            REGISTRATIONPAGEID = @REGISTRATIONPAGEID,
            STARTACOMPANYTITLE = @STARTACOMPANYTITLE,
            STARTACOMPANYDESCRIPTION = @STARTACOMPANYDESCRIPTION,
            STARTACOMPANYIMAGEID = @STARTACOMPANYIMAGEID,
            STARTATEAMTITLE = @STARTATEAMTITLE,
            STARTATEAMDESCRIPTION = @STARTATEAMDESCRIPTION,
            STARTATEAMTITLEIMAGEID = @STARTATEAMTITLEIMAGEID,
            STARTATEAMUNDERGROUPTITLE = @STARTATEAMUNDERGROUPTITLE,
            STARTATEAMUNDERGROUPDESCRIPTION = @STARTATEAMUNDERGROUPDESCRIPTION,
            STARTATEAMUNDERGROUPIMAGEID = @STARTATEAMUNDERGROUPIMAGEID,
            STARTATEAMINDEPENDENTTITLE = @STARTATEAMINDEPENDENTTITLE,
            STARTATEAMINDEPENDENTDESCRIPTION = @STARTATEAMINDEPENDENTDESCRIPTION,
            STARTATEAMINDEPENDENTIMAGEID = @STARTATEAMINDEPENDENTIMAGEID,
            JOINATEAMTITLE = @JOINATEAMTITLE,
            JOINATEAMDESCRIPTION = @JOINATEAMDESCRIPTION,
            JOINATEAMTITLEIMAGEID = @JOINATEAMTITLEIMAGEID,
            STARTAHOUSEHOLDTITLE = @STARTAHOUSEHOLDTITLE,
            STARTAHOUSEHOLDDESCRIPTION = @STARTAHOUSEHOLDDESCRIPTION,
            STARTAHOUSEHOLDIMAGEID = @STARTAHOUSEHOLDIMAGEID,
            STARTAHOUSEHOLDUNDERCOMPANYTITLE = @STARTAHOUSEHOLDUNDERCOMPANYTITLE,
            STARTAHOUSEHOLDUNDERCOMPANYDESCRIPTION = @STARTAHOUSEHOLDUNDERCOMPANYDESCRIPTION,
            STARTAHOUSEHOLDUNDERCOMPANYIMAGEID = @STARTAHOUSEHOLDUNDERCOMPANYIMAGEID,
            STARTAHOUSEHOLDUNDERTEAMTITLE = @STARTAHOUSEHOLDUNDERTEAMTITLE,
            STARTAHOUSEHOLDUNDERTEAMDESCRIPTION = @STARTAHOUSEHOLDUNDERTEAMDESCRIPTION,
            STARTAHOUSEHOLDUNDERTEAMIMAGEID = @STARTAHOUSEHOLDUNDERTEAMIMAGEID,
            STARTAHOUSEHOLDINDEPENDENTTITLE = @STARTAHOUSEHOLDINDEPENDENTTITLE,
            STARTAHOUSEHOLDINDEPENDENTDESCRIPTION = @STARTAHOUSEHOLDINDEPENDENTDESCRIPTION,
            STARTAHOUSEHOLDINDEPENDENTIMAGEID = @STARTAHOUSEHOLDINDEPENDENTIMAGEID,
            JOINASINDIVIDUALTITLE = @JOINASINDIVIDUALTITLE,
            JOINASINDIVIDUALDESCRIPTION = @JOINASINDIVIDUALDESCRIPTION,
            JOINASINDIVIDUALIMAGEID = @JOINASINDIVIDUALIMAGEID,
            JOINASINDIVIDUALUNDERCOMPANYTITLE = @JOINASINDIVIDUALUNDERCOMPANYTITLE,
            JOINASINDIVIDUALUNDERCOMPANYDESCRIPTION = @JOINASINDIVIDUALUNDERCOMPANYDESCRIPTION,
            JOINASINDIVIDUALUNDERCOMPANYIMAGEID = @JOINASINDIVIDUALUNDERCOMPANYIMAGEID,
            JOINASINDIVIDUALPARTICIPANTTITLE = @JOINASINDIVIDUALPARTICIPANTTITLE,
            JOINASINDIVIDUALPARTICIPANTDESCRIPTION = @JOINASINDIVIDUALPARTICIPANTDESCRIPTION,
            JOINASINDIVIDUALPARTICIPANTIMAGEID = @JOINASINDIVIDUALPARTICIPANTIMAGEID,

            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate()
        where ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;