USP_DATAFORMTEMPLATE_EDIT_RE7WEBINTEGRATIONCONFIGURATION2

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RE7WEBINTEGRATIONCONFIGURATION2
(
  @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @RE7DBID int,
    @RE7DBDESCRIPTION nvarchar(128),
  @RE7DBSERIALNUMBER nvarchar(100),
  @RE7WEBSERVER dbo.UDT_WEBADDRESS,
  @PROVISIONINGKEY nvarchar(12)
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    declare @ID uniqueidentifier;

    select
      @ID = ID
    from
        dbo.RE7INTEGRATIONCONFIGURATION;

  begin try

    if @ID is null begin
          insert into dbo.RE7INTEGRATIONCONFIGURATION (
                                    ID,
                                    RE7DBID,
                                    RE7DBDESCRIPTION,
                                    RE7DBSERIALNUMBER,
                                    DBSELECTIONLOCKED,
                  RERPWEBSERVICEURL,
                  RERPPROVISIONINGKEY,
                                    ADDEDBYID,
                                    CHANGEDBYID,
                                    DATEADDED,
                                    DATECHANGED
                                ) values (
                                    newid(),
                                    @RE7DBID,
                                    @RE7DBDESCRIPTION,
                                    @RE7DBSERIALNUMBER,
                                    1,
                  @RE7WEBSERVER,
                  @PROVISIONINGKEY,
                  @CHANGEAGENTID,
                                    @CHANGEAGENTID,
                                    @CURRENTDATE,
                                    @CURRENTDATE
          );
    end
        else begin

      declare @EXISTINGRE7SERIALNUMBER nvarchar(100);

      select @EXISTINGRE7SERIALNUMBER = RE7DBSERIALNUMBER from dbo.RE7INTEGRATIONCONFIGURATION;

      if @EXISTINGRE7SERIALNUMBER <> @RE7DBSERIALNUMBER
      begin
        raiserror('INVALIDRE7DBSERIALNUMBER',13,1);
        return 1;
      end
      else
              update dbo.RE7INTEGRATIONCONFIGURATION set
                                    RE7DBID = @RE7DBID,
                                    RE7DBDESCRIPTION = @RE7DBDESCRIPTION,       
                                    RE7DBSERIALNUMBER = @RE7DBSERIALNUMBER,     
                  RERPWEBSERVICEURL = @RE7WEBSERVER,
                  RERPPROVISIONINGKEY = @PROVISIONINGKEY,
                                    CHANGEDBYID = @CHANGEAGENTID,
                                    DATECHANGED = @CURRENTDATE
              where ID = @ID;
      end

  exec dbo.USP_CONDITIONSETTING_SETCONDITION N'RE7Integration', @CHANGEAGENTID, @CURRENTDATE;
  end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

  return 0;