USP_DATAFORMTEMPLATE_EDIT_ADDRESS_3

The save procedure used by the edit dataform template "Address Edit Form 3".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@ADDRESSTYPECODEID	uniqueidentifier	IN	Type
@PRIMARY	bit	IN	Set as primary address
@DONOTMAIL	bit	IN	Do not send mail to this address
@STARTDATE	UDT_MONTHDAY	IN	Start date
@ENDDATE	UDT_MONTHDAY	IN	End date
@COUNTRYID	uniqueidentifier	IN	Country
@STATEID	uniqueidentifier	IN	State
@ADDRESSBLOCK	nvarchar(150)	IN	Address
@CITY	nvarchar(50)	IN	City
@POSTCODE	nvarchar(12)	IN	ZIP
@CART	nvarchar(10)	IN	CART
@DPC	nvarchar(8)	IN	DPC
@LOT	nvarchar(5)	IN	LOT
@OMITFROMVALIDATION	bit	IN	Omit this address from validation
@COUNTYCODEID	uniqueidentifier	IN	County
@CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN	Congressional district
@STATEHOUSEDISTRICTCODEID	uniqueidentifier	IN	State house district
@STATESENATEDISTRICTCODEID	uniqueidentifier	IN	State senate district
@LOCALPRECINCTCODEID	uniqueidentifier	IN	Local precinct
@INFOSOURCECODEID	uniqueidentifier	IN	Info source
@REGIONCODEID	uniqueidentifier	IN	Region
@LASTVALIDATIONATTEMPTDATE	datetime	IN	Last attempt
@VALIDATIONMESSAGE	nvarchar(200)	IN	Validation message
@CERTIFICATIONDATA	int	IN
@UPDATECONTACTS	bit	IN	Update contacts that use this address
@DONOTMAILREASONCODEID	uniqueidentifier	IN	Reason
@UPDATEMATCHINGHOUSEHOLDADDRESSES	bit	IN	Update matching addresses in household

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ADDRESS_3
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @ADDRESSTYPECODEID uniqueidentifier,
                    @PRIMARY bit,
                    @DONOTMAIL bit,
                    @STARTDATE dbo.UDT_MONTHDAY,
                    @ENDDATE dbo.UDT_MONTHDAY,
                    @COUNTRYID uniqueidentifier,
                    @STATEID uniqueidentifier,
                    @ADDRESSBLOCK nvarchar(150),
                    @CITY nvarchar(50),
                    @POSTCODE nvarchar(12),
                    @CART nvarchar(10),
                    @DPC nvarchar(8),
                    @LOT nvarchar(5),
                    @OMITFROMVALIDATION bit,                    
                    @COUNTYCODEID uniqueidentifier,
                    @CONGRESSIONALDISTRICTCODEID uniqueidentifier,
                    @STATEHOUSEDISTRICTCODEID uniqueidentifier,
                    @STATESENATEDISTRICTCODEID uniqueidentifier,
                    @LOCALPRECINCTCODEID uniqueidentifier,
                    @INFOSOURCECODEID uniqueidentifier,
                    @REGIONCODEID uniqueidentifier,                    
                    @LASTVALIDATIONATTEMPTDATE datetime,
                    @VALIDATIONMESSAGE nvarchar(200),
                    @CERTIFICATIONDATA integer,
                    @UPDATECONTACTS bit,
                    @DONOTMAILREASONCODEID uniqueidentifier,
                    @UPDATEMATCHINGHOUSEHOLDADDRESSES bit
                )
                as
                    set nocount on;

                    if @CERTIFICATIONDATA is null
                        set @CERTIFICATIONDATA = 0;

                    if exists(select object_id from sys.objects where type = 'U' and name = 'GROUPMEMBER')
                    begin
                        begin try
                            if @UPDATEMATCHINGHOUSEHOLDADDRESSES = 1 begin
                                exec dbo.USP_ADDRESS_UPDATEMATCHINGADDRESSES @ADDRESSID = @ID,
                                    @CHANGEAGENTID = @CHANGEAGENTID,
                                    @ADDRESSTYPECODEID = @ADDRESSTYPECODEID,
                                    @PRIMARY = @PRIMARY,
                                    @DONOTMAIL = @DONOTMAIL,
                                    @STARTDATE = @STARTDATE,
                                    @ENDDATE = @ENDDATE,
                                    @COUNTRYID = @COUNTRYID,
                                    @STATEID = @STATEID,
                                    @ADDRESSBLOCK = @ADDRESSBLOCK,
                                    @CITY = @CITY,
                                    @POSTCODE = @POSTCODE,
                                    @CART = @CART,
                                    @DPC = @DPC,
                                    @LOT = @LOT,
                                    @OMITFROMVALIDATION = @OMITFROMVALIDATION,
                                    @COUNTYCODEID = @COUNTYCODEID,
                                    @CONGRESSIONALDISTRICTCODEID = @CONGRESSIONALDISTRICTCODEID,
                                    @STATEHOUSEDISTRICTCODEID = @STATEHOUSEDISTRICTCODEID,
                                    @STATESENATEDISTRICTCODEID = @STATESENATEDISTRICTCODEID,
                                    @LOCALPRECINCTCODEID = @LOCALPRECINCTCODEID,
                                    @INFOSOURCECODEID = @INFOSOURCECODEID,
                                    @REGIONCODEID = @REGIONCODEID,
                                    @LASTVALIDATIONATTEMPTDATE = @LASTVALIDATIONATTEMPTDATE,
                                    @VALIDATIONMESSAGE = @VALIDATIONMESSAGE,
                                    @CERTIFICATIONDATA = @CERTIFICATIONDATA,
                                    @DONOTMAILREASONCODEID = @DONOTMAILREASONCODEID
                            end

                            exec dbo.USP_ADDRESS_UPDATE @ID, @CHANGEAGENTID, @ADDRESSTYPECODEID, @PRIMARY, @DONOTMAIL, @STARTDATE, @ENDDATE,
                            @COUNTRYID, @STATEID, @ADDRESSBLOCK, @CITY, @POSTCODE, @CART, @DPC, @LOT, 0, -- Spouse addresses should be taken care of through the household address updates

                            @OMITFROMVALIDATION, @COUNTYCODEID, @CONGRESSIONALDISTRICTCODEID, @STATEHOUSEDISTRICTCODEID,
                            @STATESENATEDISTRICTCODEID, @LOCALPRECINCTCODEID, @INFOSOURCECODEID, @REGIONCODEID, @LASTVALIDATIONATTEMPTDATE,
                            @VALIDATIONMESSAGE, @CERTIFICATIONDATA, @UPDATECONTACTS, @DONOTMAILREASONCODEID

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

                    return 0;