USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTBATCHADDRESSVALIDATION_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@ADDRESS_COUNTRYID	uniqueidentifier	IN
@ADDRESS_ADDRESSBLOCK	nvarchar(150)	IN
@ADDRESS_CITY	nvarchar(50)	IN
@ADDRESS_STATEID	uniqueidentifier	IN
@ADDRESS_POSTCODE	nvarchar(12)	IN
@ADDRESS_CART	nvarchar(10)	IN
@ADDRESS_DPC	nvarchar(8)	IN
@ADDRESS_LOT	nvarchar(5)	IN
@ADDRESS_CERTIFICATIONDATA	int	IN
@ADDRESS_CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN
@ADDRESS_COUNTYCODEID	uniqueidentifier	IN
@ADDRESS_VALIDATIONMESSAGE	nvarchar(400)	IN

Definition

Copy


          create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTBATCHADDRESSVALIDATION_2
          (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @ADDRESS_COUNTRYID uniqueidentifier,
            @ADDRESS_ADDRESSBLOCK nvarchar(150),
            @ADDRESS_CITY nvarchar(50),
            @ADDRESS_STATEID uniqueidentifier,
            @ADDRESS_POSTCODE nvarchar(12),
            @ADDRESS_CART nvarchar(10),
            @ADDRESS_DPC nvarchar(8),
            @ADDRESS_LOT nvarchar(5),
            @ADDRESS_CERTIFICATIONDATA int,
            @ADDRESS_CONGRESSIONALDISTRICTCODEID uniqueidentifier,
            @ADDRESS_COUNTYCODEID uniqueidentifier,
            @ADDRESS_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
              update dbo.BATCHCONSTITUENT set
                [ADDRESS_COUNTRYID] = @ADDRESS_COUNTRYID,
                [ADDRESS_ADDRESSBLOCK] = @ADDRESS_ADDRESSBLOCK,
                [ADDRESS_CITY] = @ADDRESS_CITY,
                [ADDRESS_STATEID] = @ADDRESS_STATEID,
                [ADDRESS_POSTCODE] = @ADDRESS_POSTCODE,
                [ADDRESS_CART] = @ADDRESS_CART,
                [ADDRESS_DPC] = @ADDRESS_DPC,
                [ADDRESS_LOT] = @ADDRESS_LOT,
                [ADDRESS_CONGRESSIONALDISTRICTCODEID] = @ADDRESS_CONGRESSIONALDISTRICTCODEID, 
                [ADDRESS_CERTIFICATIONDATA] = @ADDRESS_CERTIFICATIONDATA,
                [ADDRESS_COUNTYCODEID] = @ADDRESS_COUNTYCODEID,
                [ADDRESS_LASTVALIDATIONATTEMPTDATE] = @CURRENTDATE,
                [ADDRESS_VALIDATIONMESSAGE] = @ADDRESS_VALIDATIONMESSAGE,
                CHANGEDBYID = @CHANGEAGENTID,
                DATECHANGED = @CURRENTDATE
              where ID = @ID
            end try
            begin catch
              exec dbo.USP_RAISE_ERROR
              return 1
            end catch

          return 0;