USP_BBNC_COMMITDONORINFORMATIONBIOADD_1_2

Parameters

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

Copy


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

                declare @CURRENTDATE datetime;

                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();

                set @CURRENTDATE = getdate();

                begin try

                        -- ADD CONSTITUENT

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

                    -- ADD SYSTEM DEFAULT NAME FORMAT SETTINGS (before we deal with WI 132800)

                 if @ISORGANIZATION=0
                    begin
                                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 

                    -- WI 132800 PROCESS NAME FORMAT VALUES COMING FROM BBNC TRANSACTIONS

                                exec dbo.USP_BBNC_NAMEFORMATS_ADDUPDATE @ID, @XMLITEMS, @CHANGEAGENTID, @CHANGEDATE;
                        end

                    -- Add origin information

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

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

                    -- ADD CONSTITUENCY

                    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;