USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTUPDATEBATCHADDRESSVALIDATION

The save procedure used by the edit dataform template "Constituent Update Batch Address Validation Edit Data Form".

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.
@ADDRESSES	xml	IN	Addresses

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTUPDATEBATCHADDRESSVALIDATION
          (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @ADDRESSES xml
          )
          as

            set nocount on;

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

            declare @CURRENTDATE datetime
            set @CURRENTDATE = getdate()

            begin try
              update dbo.BATCHCONSTITUENTUPDATEADDRESSES set
                COUNTRYID = NEWADDRESS.COUNTRYID,
                ADDRESSBLOCK = NEWADDRESS.ADDRESSBLOCK,
                CITY = NEWADDRESS.CITY,
                STATEID = NEWADDRESS.STATEID,
                POSTCODE = NEWADDRESS.POSTCODE,
                CART = NEWADDRESS.CART,
                DPC = NEWADDRESS.DPC,
                LOT = NEWADDRESS.LOT,
                CONGRESSIONALDISTRICTCODEID = NEWADDRESS.CONGRESSIONALDISTRICTCODEID,
                CERTIFICATIONDATA = NEWADDRESS.CERTIFICATIONDATA,
                COUNTYCODEID = NEWADDRESS.COUNTYCODEID,
                LASTVALIDATIONATTEMPTDATE = @CURRENTDATE,
                VALIDATIONMESSAGE = isnull(NEWADDRESS.VALIDATIONMESSAGE, ''),
                CHANGEDBYID = @CHANGEAGENTID,
                DATECHANGED = @CURRENTDATE
              from dbo.UFN_BATCHCONSTITUENTUPDATE_GETADDRESSES_FROMITEMLISTXML(@ADDRESSES) as NEWADDRESS
              where BATCHCONSTITUENTUPDATEADDRESSES.ID = NEWADDRESS.ID
            end try
            begin catch
              exec dbo.USP_RAISE_ERROR
              return 1
            end catch

          return 0;