USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTADDRESSUPDATEBATCHROW_3

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@ADDRESSID	uniqueidentifier	IN
@ADDRESSTYPECODEID	uniqueidentifier	IN
@COUNTRYID	uniqueidentifier	IN
@ADDRESSBLOCK	nvarchar(150)	IN
@CITY	nvarchar(50)	IN
@STATEID	uniqueidentifier	IN
@POSTCODE	nvarchar(12)	IN
@ISPRIMARY	bit	IN
@DONOTMAIL	bit	IN
@UPDATEMATCHINGSPOUSEADDRESSES	bit	IN
@SEQUENCE	int	IN
@CART	nvarchar(10)	IN
@DPC	nvarchar(8)	IN
@LOT	nvarchar(5)	IN
@COUNTYCODEID	uniqueidentifier	IN
@OMITFROMVALIDATION	bit	IN
@CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN
@STATEHOUSEDISTRICTCODEID	uniqueidentifier	IN
@STATESENATEDISTRICTCODEID	uniqueidentifier	IN
@LOCALPRECINCTCODEID	uniqueidentifier	IN
@INFOSOURCECODEID	uniqueidentifier	IN
@REGIONCODEID	uniqueidentifier	IN
@LASTVALIDATIONATTEMPTDATE	datetime	IN
@VALIDATIONMESSAGE	nvarchar(200)	IN
@CERTIFICATIONDATA	int	IN
@STARTDATE	UDT_MONTHDAY	IN
@ENDDATE	UDT_MONTHDAY	IN
@DONOTMAILREASONCODEID	uniqueidentifier	IN
@UPDATEMATCHINGHOUSEHOLDADDRESSES	bit	IN
@HASMATCHINGADDRESSES	bit	IN
@INFOSOURCECOMMENTS	nvarchar(256)	IN

Definition

Copy



                create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTADDRESSUPDATEBATCHROW_3
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier,
                    @ADDRESSID uniqueidentifier,
                    @ADDRESSTYPECODEID uniqueidentifier,
                    @COUNTRYID uniqueidentifier,
                    @ADDRESSBLOCK nvarchar(150),
                    @CITY nvarchar(50),
                    @STATEID uniqueidentifier,
                    @POSTCODE nvarchar(12),
                    @ISPRIMARY bit,
                    @DONOTMAIL bit,
                    @UPDATEMATCHINGSPOUSEADDRESSES bit,
                    @SEQUENCE int,
                    @CART nvarchar(10),
                    @DPC nvarchar(8),
                    @LOT nvarchar(5),
                    @COUNTYCODEID uniqueidentifier,
                    @OMITFROMVALIDATION bit,
                    @CONGRESSIONALDISTRICTCODEID uniqueidentifier,
                    @STATEHOUSEDISTRICTCODEID uniqueidentifier,
                    @STATESENATEDISTRICTCODEID uniqueidentifier,
                    @LOCALPRECINCTCODEID uniqueidentifier,
                    @INFOSOURCECODEID uniqueidentifier,
                    @REGIONCODEID uniqueidentifier,
                    @LASTVALIDATIONATTEMPTDATE datetime,
                    @VALIDATIONMESSAGE nvarchar(200),
                    @CERTIFICATIONDATA int,
                    @STARTDATE dbo.UDT_MONTHDAY,
                    @ENDDATE dbo.UDT_MONTHDAY,
                    @DONOTMAILREASONCODEID uniqueidentifier,
                    @UPDATEMATCHINGHOUSEHOLDADDRESSES bit,
                    @HASMATCHINGADDRESSES bit,
                    @INFOSOURCECOMMENTS nvarchar(256)
                ) as
                    set nocount on;

                    if @STARTDATE = '0000' and not @ENDDATE = '0000'
                        raiserror ('BBERR_STARTDATE_REQUIRED',13,1);
                    if @ENDDATE = '0000' and not @STARTDATE = '0000'
                        raiserror ('BBERR_ENDDATE_REQUIRED',13,1);

                    declare @CURRENTDATE datetime;

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

                    set @CURRENTDATE = getdate();

                    -- THM 03/07/2008 CR295315-030708 & CR295291-030608 set default values if null

                    if @CERTIFICATIONDATA is null
                        set @CERTIFICATIONDATA = 0

                    if @OMITFROMVALIDATION is null
                        set @OMITFROMVALIDATION = 0

                    if @DONOTMAIL = 0
                        set @DONOTMAILREASONCODEID = null

                    begin try                                
                        update
                            dbo.BATCHCONSTITUENTADDRESSUPDATE
                        set
                            [ADDRESSID] = @ADDRESSID,
                            [ADDRESSTYPECODEID] = @ADDRESSTYPECODEID,
                            [COUNTRYID] = @COUNTRYID,
                            [ADDRESSBLOCK] = @ADDRESSBLOCK,
                            [CITY] = @CITY,
                            [STATEID] = @STATEID,
                            [POSTCODE] = @POSTCODE,
                            [ISPRIMARY] = @ISPRIMARY,
                            [DONOTMAIL] = @DONOTMAIL,
                            [UPDATEMATCHINGSPOUSEADDRESSES] = @UPDATEMATCHINGSPOUSEADDRESSES,
                            [SEQUENCE] = @SEQUENCE,
                            [CHANGEDBYID] = @CHANGEAGENTID,
                            [DATECHANGED] = @CURRENTDATE,
                            [CART] = @CART,
                            [DPC] = @DPC,
                            [LOT] = @LOT,
                            [COUNTYCODEID] = @COUNTYCODEID,
                            [OMITFROMVALIDATION] = @OMITFROMVALIDATION,
                            [CONGRESSIONALDISTRICTCODEID] = @CONGRESSIONALDISTRICTCODEID,
                            [STATEHOUSEDISTRICTCODEID] = @STATEHOUSEDISTRICTCODEID,
                            [STATESENATEDISTRICTCODEID] = @STATESENATEDISTRICTCODEID,
                            [LOCALPRECINCTCODEID] = @LOCALPRECINCTCODEID,
                            [INFOSOURCECODEID] = @INFOSOURCECODEID,
                            [REGIONCODEID] = @REGIONCODEID,
                            [LASTVALIDATIONATTEMPTDATE] = @LASTVALIDATIONATTEMPTDATE,
                            [VALIDATIONMESSAGE] = @VALIDATIONMESSAGE,
                            [CERTIFICATIONDATA] = @CERTIFICATIONDATA,
                            STARTDATE = @STARTDATE,
                            ENDDATE = @ENDDATE,
                         DONOTMAILREASONCODEID = @DONOTMAILREASONCODEID,
                            UPDATEMATCHINGHOUSEHOLDADDRESSES = @UPDATEMATCHINGHOUSEHOLDADDRESSES,
                            [INFOSOURCECOMMENTS] = @INFOSOURCECOMMENTS
                        where ID = @ID;
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;