USP_DATAFORMTEMPLATE_ADD_AUCTIONITEMBATCHHOUSEHOLD

The save procedure used by the add dataform template "Auction Item Batch Household Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(300)	IN	Description
@GIVESANONYMOUSLY	bit	IN	Household gives anonymously
@ADDRESS_ADDRESSTYPECODEID	uniqueidentifier	IN	Address type
@ADDRESS_COUNTRYID	uniqueidentifier	IN	Country
@ADDRESS_ADDRESSBLOCK	nvarchar(150)	IN	Address
@ADDRESS_CITY	nvarchar(50)	IN	City
@ADDRESS_STATEID	uniqueidentifier	IN	State
@ADDRESS_POSTCODE	nvarchar(12)	IN	ZIP/Postal code
@PHONE_PHONETYPECODEID	uniqueidentifier	IN	Phone type
@PHONE_NUMBER	nvarchar(100)	IN	Phone number
@EMAIL_EMAILADDRESSTYPECODEID	uniqueidentifier	IN	Email type
@EMAIL_EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@WEBADDRESS	UDT_WEBADDRESS	IN	Website
@PRIMARYCONTACTID	uniqueidentifier	IN	Full name
@PRIMARYCONTACT_KEYNAME	nvarchar(100)	IN	Last name
@PRIMARYCONTACT_FIRSTNAME	nvarchar(50)	IN	First name
@PRIMARYCONTACT_MIDDLENAME	nvarchar(50)	IN	Middle name
@PRIMARYCONTACT_TITLECODEID	uniqueidentifier	IN	Title
@PRIMARYCONTACT_SUFFIXCODEID	uniqueidentifier	IN	Suffix
@PRIMARYCONTACT_COPYHOUSEHOLDCONTACT	bit	IN	Copy household contact information
@SECONDMEMBERID	uniqueidentifier	IN	Full name
@SECONDMEMBER_KEYNAME	nvarchar(100)	IN	Last name
@SECONDMEMBER_FIRSTNAME	nvarchar(50)	IN	First name
@SECONDMEMBER_MIDDLENAME	nvarchar(50)	IN	Middle name
@SECONDMEMBER_TITLECODEID	uniqueidentifier	IN	Title
@SECONDMEMBER_SUFFIXCODEID	uniqueidentifier	IN	Suffix
@SECONDMEMBER_COPYHOUSEHOLDCONTACT	bit	IN	Copy household contact information
@SECONDMEMBER_RELATIONSHIP_RECIPROCALTYPECODEID	uniqueidentifier	IN	Reciprocal relationship type
@SECONDMEMBER_RELATIONSHIP_RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relationship type
@SECONDMEMBER_RELATIONSHIP_STARTDATE	datetime	IN	Start date
@SECONDMEMBER_RELATIONSHIP_ISSPOUSE	bit	IN	This is the spouse relationship
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DONOTMAIL	bit	IN	Do not send mail to this address
@DONOTMAILREASONCODEID	uniqueidentifier	IN	Reason
@OMITFROMVALIDATION	bit	IN	Omit this address from validation
@CART	nvarchar(10)	IN
@DPC	nvarchar(8)	IN
@LOT	nvarchar(5)	IN
@COUNTYCODEID	uniqueidentifier	IN
@CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN
@LASTVALIDATIONATTEMPTDATE	datetime	IN
@VALIDATIONMESSAGE	nvarchar(100)	IN
@CERTIFICATIONDATA	int	IN
@DONOTCALL	bit	IN	Do not call this phone number
@DONOTEMAIL	bit	IN	Do not send email to this address

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_AUCTIONITEMBATCHHOUSEHOLD
                    (
                        @ID uniqueidentifier output,
                        @NAME nvarchar(100) = null,
                        @DESCRIPTION nvarchar(300) = '',
                        @GIVESANONYMOUSLY bit = 0,
                        @ADDRESS_ADDRESSTYPECODEID uniqueidentifier = null,
                        @ADDRESS_COUNTRYID uniqueidentifier = null,
                        @ADDRESS_ADDRESSBLOCK nvarchar(150) = '',
                        @ADDRESS_CITY nvarchar(50) = '',
                        @ADDRESS_STATEID uniqueidentifier = null,
                        @ADDRESS_POSTCODE nvarchar(12) = '',
                        @PHONE_PHONETYPECODEID uniqueidentifier = null,
                        @PHONE_NUMBER nvarchar(100) = '',
                        @EMAIL_EMAILADDRESSTYPECODEID uniqueidentifier = null,
                        @EMAIL_EMAILADDRESS dbo.UDT_EMAILADDRESS = '',
                        @WEBADDRESS dbo.UDT_WEBADDRESS = '',

                        -- Primary member fields

                        @PRIMARYCONTACTID uniqueidentifier = null,
                        @PRIMARYCONTACT_KEYNAME nvarchar(100) = '',
                        @PRIMARYCONTACT_FIRSTNAME nvarchar(50) = '',
                        @PRIMARYCONTACT_MIDDLENAME nvarchar(50) = '',
                        @PRIMARYCONTACT_TITLECODEID uniqueidentifier = null,
                        @PRIMARYCONTACT_SUFFIXCODEID uniqueidentifier = null,
                        @PRIMARYCONTACT_COPYHOUSEHOLDCONTACT bit = 0,

                        -- Secondary member fields

                        @SECONDMEMBERID uniqueidentifier = null,
                        @SECONDMEMBER_KEYNAME nvarchar(100) = '',
                        @SECONDMEMBER_FIRSTNAME nvarchar(50) = '',
                        @SECONDMEMBER_MIDDLENAME nvarchar(50) = '',
                        @SECONDMEMBER_TITLECODEID uniqueidentifier = null,
                        @SECONDMEMBER_SUFFIXCODEID uniqueidentifier = null,
                        @SECONDMEMBER_COPYHOUSEHOLDCONTACT bit = 0,
                        @SECONDMEMBER_RELATIONSHIP_RECIPROCALTYPECODEID uniqueidentifier = null,
                        @SECONDMEMBER_RELATIONSHIP_RELATIONSHIPTYPECODEID uniqueidentifier = null,
                        @SECONDMEMBER_RELATIONSHIP_STARTDATE datetime = null,
                        @SECONDMEMBER_RELATIONSHIP_ISSPOUSE bit = 0,

                        @CHANGEAGENTID uniqueidentifier = null,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @DONOTMAIL bit = 0,
                        @DONOTMAILREASONCODEID uniqueidentifier = null,
                        @OMITFROMVALIDATION bit = 0,
                        @CART nvarchar(10) = '',
                        @DPC nvarchar(8) = '',
                        @LOT nvarchar(5) = '',
                        @COUNTYCODEID uniqueidentifier = null,
                        @CONGRESSIONALDISTRICTCODEID uniqueidentifier = null,
                        @LASTVALIDATIONATTEMPTDATE datetime = null,
                        @VALIDATIONMESSAGE nvarchar(100) = '',
                        @CERTIFICATIONDATA integer = 0,
                        @DONOTCALL bit = 0,
                        @DONOTEMAIL bit = 0
                    ) 
                    as
                        set nocount on;

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

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

                        if @DONOTMAIL = 0 
                          set @DONOTMAILREASONCODEID = null

                        begin try
                            exec dbo.USP_AUCTIONITEMBATCH_ADDHOUSEHOLD @ID output, @NAME, @DESCRIPTION, @GIVESANONYMOUSLY, @ADDRESS_ADDRESSTYPECODEID, @ADDRESS_COUNTRYID, @ADDRESS_ADDRESSBLOCK, 
                                @ADDRESS_CITY, @ADDRESS_STATEID, @ADDRESS_POSTCODE, @PHONE_PHONETYPECODEID, @PHONE_NUMBER, 
                                @EMAIL_EMAILADDRESSTYPECODEID, @EMAIL_EMAILADDRESS, @WEBADDRESS, @PRIMARYCONTACTID, @PRIMARYCONTACT_KEYNAME, 
                                @PRIMARYCONTACT_FIRSTNAME, @PRIMARYCONTACT_MIDDLENAME, @PRIMARYCONTACT_TITLECODEID, @PRIMARYCONTACT_SUFFIXCODEID, 
                                @PRIMARYCONTACT_COPYHOUSEHOLDCONTACT, @SECONDMEMBERID, @SECONDMEMBER_KEYNAME, @SECONDMEMBER_FIRSTNAME, 
                                @SECONDMEMBER_MIDDLENAME, @SECONDMEMBER_TITLECODEID, @SECONDMEMBER_SUFFIXCODEID, @SECONDMEMBER_COPYHOUSEHOLDCONTACT, 
                                @SECONDMEMBER_RELATIONSHIP_RECIPROCALTYPECODEID, @SECONDMEMBER_RELATIONSHIP_RELATIONSHIPTYPECODEID, @SECONDMEMBER_RELATIONSHIP_STARTDATE, 
                                @SECONDMEMBER_RELATIONSHIP_ISSPOUSE, @CHANGEAGENTID, @CURRENTAPPUSERID, @DONOTMAIL, @DONOTMAILREASONCODEID,
                                @OMITFROMVALIDATION, @CART, @DPC, @LOT, @COUNTYCODEID, @CONGRESSIONALDISTRICTCODEID,
                                @LASTVALIDATIONATTEMPTDATE, @VALIDATIONMESSAGE, @CERTIFICATIONDATA, @DONOTCALL, @DONOTEMAIL

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

                        return 0;