USP_BBNC_COMMITEVENTREGISTRATIONGUESTADD_1_1

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@BBNCMAPID	int	INOUT
@FIRSTNAME	nvarchar(50)	IN
@MIDDLENAME	nvarchar(50)	IN
@KEYNAME	nvarchar(100)	IN
@CONSTITUENCYCODEID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN
@TITLECODEID	uniqueidentifier	IN
@SUFFIXCODEID	uniqueidentifier	IN
@MAIDENNAME	nvarchar(50)	IN
Definition

Copy


CREATE procedure dbo.USP_BBNC_COMMITEVENTREGISTRATIONGUESTADD_1_1
(
                @ID uniqueidentifier = null output,
                @BBNCMAPID int = null output,
                @FIRSTNAME nvarchar(50) = '',
                @MIDDLENAME nvarchar(50) = '',
                @KEYNAME nvarchar(100),
                @CONSTITUENCYCODEID uniqueidentifier = null,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null,
                @TITLECODEID uniqueidentifier =null,
        @SUFFIXCODEID uniqueidentifier = null,
        @MAIDENNAME nvarchar(50) = ''
            )
            as
                set nocount on;

                if @ID is null
                    set @ID = newid();

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

                if @CHANGEDATE is null
                    set @CHANGEDATE = getdate();

                --Used for adding constituency, not for DATEADDED/DATECHANGED

                declare @CURRENTDATE datetime;
                set @CURRENTDATE = getdate();

        declare @INFOSOURCECODEID uniqueidentifier;
                select top (1) 
        @INFOSOURCECODEID = [INFOSOURCECODEID]
        from dbo.NETCOMMUNITYDEFAULTCODEMAP;

                begin try
                    insert into dbo.CONSTITUENT
                    (
                        [ID],
                        [KEYNAME],
                        [FIRSTNAME],
                        [MIDDLENAME],
                        [ISORGANIZATION],
                        [ADDEDBYID],
                        [CHANGEDBYID],
                        [DATEADDED],
                        [DATECHANGED],
                        [TITLECODEID],
            [SUFFIXCODEID],
            [MAIDENNAME]
                    )
                    values
                    (
                        @ID,
                        @KEYNAME,
                        @FIRSTNAME,
                        @MIDDLENAME,
                        0,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @CHANGEDATE,
                        @CHANGEDATE,
                        @TITLECODEID,
            @SUFFIXCODEID,
            @MAIDENNAME
                    );

          if @INFOSOURCECODEID is not null
          begin
            exec dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTORIGIN @ID = @ID,
            @CHANGEAGENTID=@CHANGEAGENTID,
            @INFOSOURCECODEID = @INFOSOURCECODEID,
            @REVENUEID = null
          end 

                    insert into dbo.[NAMEFORMAT]
                        ([CONSTITUENTID]
                        ,[NAMEFORMATTYPECODEID]
                        ,[NAMEFORMATFUNCTIONID]
                        ,[ADDEDBYID]
                        ,[CHANGEDBYID]
                        ,[DATEADDED]
                        ,[DATECHANGED]
                        ,[PRIMARYADDRESSEE]
                        ,[PRIMARYSALUTATION])
                    select
                        @ID
                        ,NFD.NAMEFORMATTYPECODEID
                        ,NFD.NAMEFORMATFUNCTIONID
                        ,@CHANGEAGENTID
                        ,@CHANGEAGENTID
                        ,@CHANGEDATE
                        ,@CHANGEDATE
                        ,NFD.PRIMARYADDRESSEE
                        ,NFD.PRIMARYSALUTATION
                    from dbo.NAMEFORMATDEFAULT as NFD
                    where NFD.APPLYTOCODE = 0 

                    if @CONSTITUENCYCODEID is not null
                        insert into dbo.CONSTITUENCY
                        (
                            [CONSTITUENTID],
                            [CONSTITUENCYCODEID],
                            [DATEFROM],
                            [DATETO],
                            [ADDEDBYID],
                            [CHANGEDBYID],
                            [DATEADDED],
                            [DATECHANGED]
                        )
                        values
                        (
                            @ID,
                            @CONSTITUENCYCODEID,
                            dbo.UFN_DATE_GETEARLIESTTIME(@CURRENTDATE), -- TMV 04/10/2007 CR271993-040407 Added date from value. This is a new constituent so it cannot have any other constituencies that would cause CK_CONSTITUENCY_ISUNIQUE to fail.

                            null,
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CHANGEDATE,
                            @CHANGEDATE
                        );

                    select @BBNCMAPID = SEQUENCEID 
                    from 
                        dbo.CONSTITUENT
                    where 
                        ID = @ID;

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

                return 0;