USP_DATAFORMTEMPLATE_EDIT_ADDRESSVALIDATIONBATCHROW

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@SEQUENCE	int	IN	Sequence
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@ADDRESSVALIDATIONID	uniqueidentifier	IN	Address validation ID
@COUNTRYID	uniqueidentifier	IN	Address ID
@ADDRESSID	uniqueidentifier	IN	Address ID
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@ADDRESSBLOCK	nvarchar(150)	IN	Address
@CITY	nvarchar(150)	IN	City
@STATEID	uniqueidentifier	IN	State
@POSTCODE	nvarchar(10)	IN	Zip
@NEWADDRESSBLOCK	nvarchar(150)	IN	Validated address
@NEWCITY	nvarchar(150)	IN	Validated city
@NEWSTATEID	uniqueidentifier	IN	Validated state
@NEWPOSTCODE	nvarchar(10)	IN	Validated zip
@NEWCOUNTYID	uniqueidentifier	IN	Validated county
@NEWCONGRESSIONALDISTRICTID	uniqueidentifier	IN	Validated congressional district
@NEWDPC	nvarchar(8)	IN	Validated DPC
@NEWCART	nvarchar(10)	IN	Validated CART
@NEWLOT	nvarchar(5)	IN	Validated LOT
@VALIDATIONMESSAGE	nvarchar(200)	IN	Validation message
@ADDRESSCHANGED	bit	IN	Address changed
@CERTIFICATIONDATA	int	IN	Certification data

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ADDRESSVALIDATIONBATCHROW
(
    @ID uniqueidentifier,
    @SEQUENCE int,
    @CHANGEAGENTID uniqueidentifier,
    @ADDRESSVALIDATIONID uniqueidentifier,
    @COUNTRYID uniqueidentifier,
    @ADDRESSID uniqueidentifier,
    @CONSTITUENTID uniqueidentifier,
    @ADDRESSBLOCK nvarchar(150),
    @CITY nvarchar(150),
    @STATEID uniqueidentifier,
    @POSTCODE nvarchar(10),
    @NEWADDRESSBLOCK nvarchar(150),
    @NEWCITY nvarchar(150),
    @NEWSTATEID uniqueidentifier,
    @NEWPOSTCODE nvarchar(10),
    @NEWCOUNTYID uniqueidentifier,
    @NEWCONGRESSIONALDISTRICTID uniqueidentifier,
    @NEWDPC nvarchar(8),
    @NEWCART nvarchar(10),
    @NEWLOT nvarchar(5),
    @VALIDATIONMESSAGE nvarchar(200),
    @ADDRESSCHANGED bit,
    @CERTIFICATIONDATA integer
)
as
    set nocount on;

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getdate();

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

    update dbo.BATCHADDRESSVALIDATION set
        ADDRESSVALIDATIONID = @ADDRESSVALIDATIONID,
        COUNTRYID = @COUNTRYID,
        ADDRESSID = @ADDRESSID,
        CONSTITUENTID = @CONSTITUENTID,
        ADDRESSBLOCK = @ADDRESSBLOCK,
        CITY = @CITY,
        STATEID = @STATEID,
        POSTCODE = @POSTCODE,
        NEWADDRESSBLOCK = @NEWADDRESSBLOCK,
        NEWCITY = @NEWCITY,
        NEWSTATEID = @NEWSTATEID,
        NEWPOSTCODE = @NEWPOSTCODE,
        NEWCOUNTYID = @NEWCOUNTYID,
        NEWCONGRESSIONALDISTRICTID = @NEWCONGRESSIONALDISTRICTID,
        NEWDPC = @NEWDPC,
        NEWCART = @NEWCART,
        NEWLOT = @NEWLOT,
        VALIDATIONMESSAGE = @VALIDATIONMESSAGE,
        ADDRESSCHANGED = @ADDRESSCHANGED,
        CERTIFICATIONDATA = @CERTIFICATIONDATA,
        SEQUENCE = @SEQUENCE,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
    where ID = @ID;

    return 0;