USP_AUCTIONITEMBATCH_ADDGROUPMEMBER

Adds a group member through auction item batch.
Parameters

Parameter	Parameter Type	Mode
@BATCHAUCTIONMEMBERID	uniqueidentifier	INOUT
@BATCHAUCTIONGROUPID	uniqueidentifier	IN
@EXISTINGCONSTITUENTID	uniqueidentifier	IN
@KEYNAME	nvarchar(100)	IN
@FIRSTNAME	nvarchar(50)	IN
@MIDDLENAME	nvarchar(50)	IN
@TITLECODEID	uniqueidentifier	IN
@SUFFIXCODEID	uniqueidentifier	IN
@COPYHOUSEHOLDCONTACT	bit	IN
@ISPRIMARYMEMBER	bit	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
Definition

Copy


            CREATE procedure dbo.USP_AUCTIONITEMBATCH_ADDGROUPMEMBER
            (
                @BATCHAUCTIONMEMBERID uniqueidentifier = null output,
                @BATCHAUCTIONGROUPID uniqueidentifier,
                @EXISTINGCONSTITUENTID uniqueidentifier,
                @KEYNAME nvarchar(100),
                @FIRSTNAME nvarchar(50),
                @MIDDLENAME nvarchar(50),
                @TITLECODEID uniqueidentifier,
                @SUFFIXCODEID uniqueidentifier,
                @COPYHOUSEHOLDCONTACT bit,
                @ISPRIMARYMEMBER bit,
                @CHANGEAGENTID uniqueidentifier = null,
                @CURRENTAPPUSERID uniqueidentifier = null
            )
            as
            begin
                set nocount on;

                if @BATCHAUCTIONMEMBERID is null
                    set @BATCHAUCTIONMEMBERID = newid()

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

                declare @CURRENTDATE datetime
                set @CURRENTDATE = getdate()

                declare @COUNTRYID uniqueidentifier
                exec @COUNTRYID = dbo.UFN_COUNTRY_GETDEFAULT;

                -- If an existing constituent is being used, clear the name

                declare @ISORGANIZATION bit, @ISGROUP bit, @GROUPTYPECODE tinyint
                if @EXISTINGCONSTITUENTID is not null
                begin
                    set @KEYNAME = ''

                    select
                        @ISORGANIZATION = C.ISORGANIZATION,
                        @ISGROUP = C.ISGROUP,
                        @GROUPTYPECODE = GD.GROUPTYPECODE
                    from dbo.CONSTITUENT C
                    left join dbo.GROUPDATA GD on C.ID = GD.ID
                    where
                        C.ID = @EXISTINGCONSTITUENTID
                end
                else
                begin
                    set @ISORGANIZATION = 0
                    set @ISGROUP = 0
                    set @GROUPTYPECODE = 0
                end

                insert into dbo.BATCHAUCTIONITEMCONSTITUENT
                (
                    ID,
                    EXISTINGCONSTITUENTID,
                    KEYNAME,
                    FIRSTNAME,
                    MIDDLENAME,
                    TITLECODEID,
                    SUFFIXCODEID,
                    ISORGANIZATION,
                    ISGROUP,
                    GROUPTYPECODE,
                    COUNTRYID,
                    CURRENTAPPUSERID,
                    ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED
                )
                values
                (
                    @BATCHAUCTIONMEMBERID,
                    @EXISTINGCONSTITUENTID,
                    coalesce(@KEYNAME, ''),
                    @FIRSTNAME,
                    @MIDDLENAME,
                    @TITLECODEID,
                    @SUFFIXCODEID,
                    coalesce(@ISORGANIZATION, 0),
                    coalesce(@ISGROUP, 0),
                    coalesce(@GROUPTYPECODE, 0),
                    @COUNTRYID,
                    @CURRENTAPPUSERID,
                    @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE
                );

                insert into dbo.BATCHAUCTIONITEMCONSTITUENTGROUPMEMBER
                (
                    GROUPID,
                    MEMBERID,
                    ISPRIMARY,
                    COPYGROUPCONTACTINFOTOMEMBER,
                    ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED
                )
                values
                (
                    @BATCHAUCTIONGROUPID,
                    @BATCHAUCTIONMEMBERID,
                    @ISPRIMARYMEMBER,
                    @COPYHOUSEHOLDCONTACT,
                    @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE
                )
            end