USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTADDRESSUPDATEBATCHADDRESSVALIDATION_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@ADDRESSBLOCK	nvarchar(150)	IN
@CITY	nvarchar(50)	IN
@COUNTRYID	uniqueidentifier	IN
@POSTCODE	nvarchar(12)	IN
@STATEID	uniqueidentifier	IN
@DPC	nvarchar(8)	IN
@LOT	nvarchar(5)	IN
@CART	nvarchar(10)	IN
@CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN
@CERTIFICATIONDATA	int	IN
@COUNTYCODEID	uniqueidentifier	IN
@VALIDATIONMESSAGE	nvarchar(400)	IN

Definition

Copy


          create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTADDRESSUPDATEBATCHADDRESSVALIDATION_2
          (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @ADDRESSBLOCK nvarchar(150),
            @CITY nvarchar(50),
            @COUNTRYID uniqueidentifier,
            @POSTCODE nvarchar(12),
            @STATEID uniqueidentifier,
            @DPC nvarchar(8),
            @LOT nvarchar(5),
            @CART nvarchar(10),
            @CONGRESSIONALDISTRICTCODEID uniqueidentifier,
            @CERTIFICATIONDATA int,
            @COUNTYCODEID uniqueidentifier,
            @VALIDATIONMESSAGE nvarchar(400)
          )
          as

            set nocount on;

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

            declare @CURRENTDATE datetime
            set @CURRENTDATE = getdate()

            begin try
              -- handle updating the data
              update dbo.BATCHCONSTITUENTADDRESSUPDATE set
                [COUNTRYID] = @COUNTRYID,
                [ADDRESSBLOCK] = @ADDRESSBLOCK,
                [CITY] = @CITY,
                [STATEID] = @STATEID,
                [POSTCODE] = @POSTCODE,
                [CART] = @CART,
                [DPC] = @DPC,
                [LOT] = @LOT,
                [COUNTYCODEID] = @COUNTYCODEID,
                [CONGRESSIONALDISTRICTCODEID] = @CONGRESSIONALDISTRICTCODEID,
                [LASTVALIDATIONATTEMPTDATE] = @CURRENTDATE,
                [VALIDATIONMESSAGE] = @VALIDATIONMESSAGE,
                [CERTIFICATIONDATA] = @CERTIFICATIONDATA,
                CHANGEDBYID = @CHANGEAGENTID,
                DATECHANGED = @CURRENTDATE
              where ID = @ID
            end try
            begin catch
              exec dbo.USP_RAISE_ERROR
              return 1
            end catch

          return 0;