USP_DATAFORMTEMPLATE_ADD_FAF_FUNDRAISING_ROLES_CONTENT
The save procedure used by the add dataform template "FAF Fundraising Roles Content Add Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | The output parameter indicating the ID of the record added. |
| @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_ADD_FAF_FUNDRAISING_ROLES_CONTENT
(
@ID uniqueidentifier = null output,
@CHANGEAGENTID uniqueidentifier = null,
@REGISTRATIONPAGEID integer = null,
@STARTACOMPANYTITLE nvarchar(500) = '',
@STARTACOMPANYDESCRIPTION nvarchar(510) = '',
@STARTACOMPANYIMAGEID int = 0,
@STARTATEAMTITLE nvarchar(500) = '',
@STARTATEAMDESCRIPTION nvarchar(510) = '',
@STARTATEAMTITLEIMAGEID int = 0,
@STARTATEAMUNDERGROUPTITLE nvarchar(500) = '',
@STARTATEAMUNDERGROUPDESCRIPTION nvarchar(510) = '',
@STARTATEAMUNDERGROUPIMAGEID int = 0,
@STARTATEAMINDEPENDENTTITLE nvarchar(500) = '',
@STARTATEAMINDEPENDENTDESCRIPTION nvarchar(510) = '',
@STARTATEAMINDEPENDENTIMAGEID int = 0,
@JOINATEAMTITLE nvarchar(500) = '',
@JOINATEAMDESCRIPTION nvarchar(510) = '',
@JOINATEAMTITLEIMAGEID int = 0,
@STARTAHOUSEHOLDTITLE nvarchar(500) = '',
@STARTAHOUSEHOLDDESCRIPTION nvarchar(510) = '',
@STARTAHOUSEHOLDIMAGEID int = 0,
@STARTAHOUSEHOLDUNDERCOMPANYTITLE nvarchar(500) = '',
@STARTAHOUSEHOLDUNDERCOMPANYDESCRIPTION nvarchar(510) = '',
@STARTAHOUSEHOLDUNDERCOMPANYIMAGEID int = 0,
@STARTAHOUSEHOLDUNDERTEAMTITLE nvarchar(500) = '',
@STARTAHOUSEHOLDUNDERTEAMDESCRIPTION nvarchar(510) = '',
@STARTAHOUSEHOLDUNDERTEAMIMAGEID int = 0,
@STARTAHOUSEHOLDINDEPENDENTTITLE nvarchar(500) = '',
@STARTAHOUSEHOLDINDEPENDENTDESCRIPTION nvarchar(510) = '',
@STARTAHOUSEHOLDINDEPENDENTIMAGEID int = 0,
@JOINASINDIVIDUALTITLE nvarchar(500) = '',
@JOINASINDIVIDUALDESCRIPTION nvarchar(510) = '',
@JOINASINDIVIDUALIMAGEID int = 0,
@JOINASINDIVIDUALUNDERCOMPANYTITLE nvarchar(500) = '',
@JOINASINDIVIDUALUNDERCOMPANYDESCRIPTION nvarchar(510) = '',
@JOINASINDIVIDUALUNDERCOMPANYIMAGEID int = 0,
@JOINASINDIVIDUALPARTICIPANTTITLE nvarchar(500) = '',
@JOINASINDIVIDUALPARTICIPANTDESCRIPTION nvarchar(510) = '',
@JOINASINDIVIDUALPARTICIPANTIMAGEID int = 0
)
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.FAFFUNDRAISINGROLESCONTENT
(ID, REGISTRATIONPAGEID, STARTACOMPANYTITLE, STARTACOMPANYDESCRIPTION, STARTACOMPANYIMAGEID, STARTATEAMTITLE, STARTATEAMDESCRIPTION, STARTATEAMTITLEIMAGEID, STARTATEAMUNDERGROUPTITLE, STARTATEAMUNDERGROUPDESCRIPTION, STARTATEAMUNDERGROUPIMAGEID, STARTATEAMINDEPENDENTTITLE, STARTATEAMINDEPENDENTDESCRIPTION, STARTATEAMINDEPENDENTIMAGEID, JOINATEAMTITLE, JOINATEAMDESCRIPTION, JOINATEAMTITLEIMAGEID, STARTAHOUSEHOLDTITLE, STARTAHOUSEHOLDDESCRIPTION, STARTAHOUSEHOLDIMAGEID, STARTAHOUSEHOLDUNDERCOMPANYTITLE, STARTAHOUSEHOLDUNDERCOMPANYDESCRIPTION, STARTAHOUSEHOLDUNDERCOMPANYIMAGEID, STARTAHOUSEHOLDUNDERTEAMTITLE, STARTAHOUSEHOLDUNDERTEAMDESCRIPTION, STARTAHOUSEHOLDUNDERTEAMIMAGEID, STARTAHOUSEHOLDINDEPENDENTTITLE, STARTAHOUSEHOLDINDEPENDENTDESCRIPTION, STARTAHOUSEHOLDINDEPENDENTIMAGEID, JOINASINDIVIDUALTITLE, JOINASINDIVIDUALDESCRIPTION, JOINASINDIVIDUALIMAGEID, JOINASINDIVIDUALUNDERCOMPANYTITLE, JOINASINDIVIDUALUNDERCOMPANYDESCRIPTION, JOINASINDIVIDUALUNDERCOMPANYIMAGEID, JOINASINDIVIDUALPARTICIPANTTITLE, JOINASINDIVIDUALPARTICIPANTDESCRIPTION, JOINASINDIVIDUALPARTICIPANTIMAGEID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
values
(@ID, @REGISTRATIONPAGEID, @STARTACOMPANYTITLE, @STARTACOMPANYDESCRIPTION, @STARTACOMPANYIMAGEID, @STARTATEAMTITLE, @STARTATEAMDESCRIPTION, @STARTATEAMTITLEIMAGEID, @STARTATEAMUNDERGROUPTITLE, @STARTATEAMUNDERGROUPDESCRIPTION, @STARTATEAMUNDERGROUPIMAGEID, @STARTATEAMINDEPENDENTTITLE, @STARTATEAMINDEPENDENTDESCRIPTION, @STARTATEAMINDEPENDENTIMAGEID, @JOINATEAMTITLE, @JOINATEAMDESCRIPTION, @JOINATEAMTITLEIMAGEID, @STARTAHOUSEHOLDTITLE, @STARTAHOUSEHOLDDESCRIPTION, @STARTAHOUSEHOLDIMAGEID, @STARTAHOUSEHOLDUNDERCOMPANYTITLE, @STARTAHOUSEHOLDUNDERCOMPANYDESCRIPTION, @STARTAHOUSEHOLDUNDERCOMPANYIMAGEID, @STARTAHOUSEHOLDUNDERTEAMTITLE, @STARTAHOUSEHOLDUNDERTEAMDESCRIPTION, @STARTAHOUSEHOLDUNDERTEAMIMAGEID, @STARTAHOUSEHOLDINDEPENDENTTITLE, @STARTAHOUSEHOLDINDEPENDENTDESCRIPTION, @STARTAHOUSEHOLDINDEPENDENTIMAGEID, @JOINASINDIVIDUALTITLE, @JOINASINDIVIDUALDESCRIPTION, @JOINASINDIVIDUALIMAGEID, @JOINASINDIVIDUALUNDERCOMPANYTITLE, @JOINASINDIVIDUALUNDERCOMPANYDESCRIPTION, @JOINASINDIVIDUALUNDERCOMPANYIMAGEID, @JOINASINDIVIDUALPARTICIPANTTITLE, @JOINASINDIVIDUALPARTICIPANTDESCRIPTION, @JOINASINDIVIDUALPARTICIPANTIMAGEID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
end try
begin catch
exec dbo.USP_RAISE_ERROR
return 1
end catch
return 0