USP_DATAFORMTEMPLATE_EDIT_REVENUEBATCHADDRESSVALIDATION_2

Parameters

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

Copy


          CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEBATCHADDRESSVALIDATION_2
          (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @COUNTRYID uniqueidentifier,
            @ADDRESSBLOCK nvarchar(150),
            @CITY nvarchar(50),
            @STATEID uniqueidentifier,
            @POSTCODE nvarchar(12),
            @CART nvarchar(10),
            @DPC nvarchar(8),
            @LOT nvarchar(5),
            @CERTIFICATIONDATA int,
            @CONGRESSIONALDISTRICTCODEID uniqueidentifier,
            @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()

            if exists (select 1 from dbo.BATCHREVENUE
                        inner join dbo.BATCHREVENUECONSTITUENT on BATCHREVENUE.CONSTITUENTID = BATCHREVENUECONSTITUENT.ID
                        where BATCHREVENUE.ID = @ID)
            begin
              declare @BATCHREVENUECONSTITUENTID uniqueidentifier
              select @BATCHREVENUECONSTITUENTID = CONSTITUENTID
              from dbo.BATCHREVENUE
              where ID = @ID

              begin try
                update dbo.BATCHREVENUECONSTITUENT set
                  [COUNTRYID] = @COUNTRYID,
                  [ADDRESSBLOCK] = @ADDRESSBLOCK,
                  [CITY] = @CITY,
                  [STATEID] = @STATEID,
                  [POSTCODE] = @POSTCODE,
                  [CART] = @CART,
                  [DPC] = @DPC,
                  [LOT] = @LOT,
                  [CONGRESSIONALDISTRICTCODEID] = @CONGRESSIONALDISTRICTCODEID, 
                  [CERTIFICATIONDATA] = @CERTIFICATIONDATA,
                  [COUNTYCODEID] = @COUNTYCODEID,
                  [LASTVALIDATIONATTEMPTDATE] = @CURRENTDATE,
                  [VALIDATIONMESSAGE] = @VALIDATIONMESSAGE,
                  CHANGEDBYID = @CHANGEAGENTID,
                  DATECHANGED = @CURRENTDATE
                where ID = @BATCHREVENUECONSTITUENTID;
              end try
              begin catch
              exec dbo.USP_RAISE_ERROR
              return 1
              end catch
            end
            else
            begin
              declare @BATCHCONSTITUENTUPDATEADDRESSESID uniqueidentifier
              select @BATCHCONSTITUENTUPDATEADDRESSESID = BATCHCONSTITUENTUPDATEADDRESSES.ID
              from dbo.BATCHREVENUE
              inner join dbo.BATCHCONSTITUENTUPDATE on BATCHCONSTITUENTUPDATE.ID = BATCHREVENUE.ID
              inner join dbo.BATCHCONSTITUENTUPDATEADDRESSES on BATCHCONSTITUENTUPDATE.ID = BATCHCONSTITUENTUPDATEADDRESSES.BATCHCONSTITUENTUPDATEID
              where BATCHREVENUE.ID = @ID

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

          return 0;