USP_FAFEVENTBATCH_EVENTLOCATION_ADD_EDIT

CREATE procedure dbo.USP_FAFEVENTBATCH_EVENTLOCATION_ADD_EDIT
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
  @NAME nvarchar(100) = ''
)
as

  set nocount on;

  declare @COUNTRYID uniqueidentifier
  exec @COUNTRYID = dbo.UFN_COUNTRY_GETDEFAULT

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

  begin try

    if @ID is null and @NAME = ''
      raiserror('LocationNameIsRequired', 13, 1)

    if @ID is not null and exists(select 1 from dbo.EVENTLOCATION where ID = @ID)
    begin
      if @NAME <> ''
        update dbo.EVENTLOCATION set NAME = @NAME where ID = @ID
    end
    else
    begin
      if @NAME <> ''
      begin
        set @ID = null
        select top 1 @ID=ID from dbo.EVENTLOCATION where name = @NAME order by DATEADDED desc

        if @ID is null
          exec dbo.USP_DATAFORMTEMPLATE_ADD_LOCATION
            @ID = @ID output,
            @CHANGEAGENTID = @CHANGEAGENTID,
            @NAME = @NAME,
            @COUNTRYID = @COUNTRYID
      end
      else
        raiserror('EventLocationIsNotExists', 13, 1)
    end
  end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;