USP_DATAFORMTEMPLATE_ADD_REGISTRANT_EXTENSION

The save procedure used by the add dataform template "Registrant Extension 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.
@REGISTRANTID	uniqueidentifier	IN	Registrant
@FUNDRAISINGGOAL	money	IN	Fundraisinggoal
@ADVOCACYACTIONGOAL	int	IN	Advocacyactiongoal
@MEMBERECRUITMENTGOAL	int	IN	Memberecruitmentgoal
@COMMUNICATIONGOAL	int	IN	Communicationgoal
@VOLUNTEERRECRUITMENTGOAL	int	IN	Volunteerrecruitmentgoal
@TARGETFUNDRAISINGGOAL	money	IN	TargetFundraisingGoal
@DONORRETENTIONGOAL	decimal(5, 2)	IN	DonorRetentionGoal
@OTHERUNITGOAL	int	IN	OtherUnitGoal
@CREDITCARDID	uniqueidentifier	IN	CreditcardID
@WAIVERACCEPTED	bit	IN	Waiver Accepted
@ALLOWADMINACCESSHQ	bit	IN	AllowAdminAccessHQ
@ORGANIZATIONCONSTITUENTID	uniqueidentifier	IN	OrganizationConstituentID
@ISDASHBOARDHELPERVISIBLE	bit	IN	IsDashboardHelperVisible
@LOCALCORPPOSTCODE	nvarchar(12)	IN	ZIP
@ISPRIVATE	bit	IN	IsPrivate
@ALLOWOTHERPARTICIPANTSCONTACTME	bit	IN	AllowOtherParticipantsContactMe

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_REGISTRANT_EXTENSION
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
  @REGISTRANTID uniqueidentifier,
  @FUNDRAISINGGOAL money = 0,
  @ADVOCACYACTIONGOAL int = 0,
  @MEMBERECRUITMENTGOAL int = 0,
  @COMMUNICATIONGOAL int = 0,
  @VOLUNTEERRECRUITMENTGOAL int = 0,
  @TARGETFUNDRAISINGGOAL money = 0,
  @DONORRETENTIONGOAL decimal(5,2) = 0,
  @OTHERUNITGOAL int = 0,
  @CREDITCARDID uniqueidentifier = null,
  @WAIVERACCEPTED bit = 1,
  @ALLOWADMINACCESSHQ bit = 1,
  @ORGANIZATIONCONSTITUENTID uniqueidentifier = null,
  @ISDASHBOARDHELPERVISIBLE bit = 1,
  @LOCALCORPPOSTCODE nvarchar(12) = '',
  @ISPRIVATE bit = 0,
  @ALLOWOTHERPARTICIPANTSCONTACTME 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()

declare @EVENTID uniqueidentifier
SELECT @EVENTID = EVENTID FROM REGISTRANT WHERE ID = @REGISTRANTID

declare @WAIVERID uniqueidentifier
if @WAIVERACCEPTED = 1
   SELECT @WAIVERID = ID FROM REGISTRATIONWAIVER WHERE EVENTID = @EVENTID AND ISCURRENT = 1
else
   set @WAIVERID = null

declare @ZIPCODE nvarchar(5);
if len(@LOCALCORPPOSTCODE) > 5
  set @ZIPCODE = substring(@LOCALCORPPOSTCODE, 1, 5);
else
  set @ZIPCODE = @LOCALCORPPOSTCODE;

declare @LOCALCORPID uniqueidentifier;
select @LOCALCORPID = ID from dbo.LOCALCORP(nolock) where ZIPCODE = @ZIPCODE and ISACTIVE=1;
if @LOCALCORPID is null
  select @LOCALCORPID = ID from dbo.LOCALCORP(nolock) where TERRITORYABBREV = '' and DIVISIONABBREV = '' and LOCALCORP = '' and MERCHANTACCT > '' and ISACTIVE=1;

begin try
    --handle inserting the data
    insert into dbo.REGISTRANTEXTENSION
        (ID, REGISTRANTID, FUNDRAISINGGOAL, ADVOCACYACTIONGOAL, MEMBERECRUITMENTGOAL, COMMUNICATIONGOAL, VOLUNTEERRECRUITMENTGOAL, WAIVERID, TARGETFUNDRAISINGGOAL, DONORRETENTIONGOAL, OTHERUNITGOAL, CREDITCARDID, ISPRIVATE, ALLOWADMINACCESSHQ, ORGANIZATIONCONSTITUENTID, ISDASHBOARDHELPERVISIBLE, LOCALCORPPOSTCODE, LOCALCORPID, ALLOWOTHERPARTICIPANTSCONTACTME, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    values
        (@ID, @REGISTRANTID, @FUNDRAISINGGOAL, @ADVOCACYACTIONGOAL, @MEMBERECRUITMENTGOAL, @COMMUNICATIONGOAL, @VOLUNTEERRECRUITMENTGOAL, @WAIVERID, @TARGETFUNDRAISINGGOAL, @DONORRETENTIONGOAL, @OTHERUNITGOAL, @CREDITCARDID, @ISPRIVATE, @ALLOWADMINACCESSHQ, @ORGANIZATIONCONSTITUENTID, @ISDASHBOARDHELPERVISIBLE, @LOCALCORPPOSTCODE, @LOCALCORPID, @ALLOWOTHERPARTICIPANTSCONTACTME, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0