USP_PEOCLIENTUSERS_ADDEDIT

CREATE procedure dbo.USP_PEOCLIENTUSERS_ADDEDIT
(

  @CLIENTUSERSID integer = null,
    @PEOUSERID nvarchar(512)

)
as

set nocount on;

--updates or creates a mapping between PEO and NetCommunity users

begin try

  declare @MYCHANGEAGENTID uniqueidentifier
  exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @MYCHANGEAGENTID output

  declare @NOW datetime
  set @NOW = getdate()

  declare @EXISTINGID as uniqueidentifier
  select @EXISTINGID=ID from dbo.CLIENTUSERSEXTENSION where CLIENTUSERID=@CLIENTUSERSID

  if @EXISTINGID is null
    exec dbo.USP_DATAFORMTEMPLATE_ADD_CLIENTUSERSEXTENSION @ID=null, @CHANGEAGENTID=@MYCHANGEAGENTID, @CLIENTUSERID=@CLIENTUSERSID, @PROVIDERNAME = 'PatronEdgeOnline', @IDENTIFIER=@PEOUSERID, @DISPLAYNAME='', @PREFERREDUSERNAME='', @GIVENNAME='', @FAMILYNAME='', @FORMATTEDNAME=''
  else
    exec dbo.USP_DATAFORMTEMPLATE_EDIT_CLIENTUSERSEXTENSION @ID=@EXISTINGID, @CHANGEAGENTID=@MYCHANGEAGENTID, @CLIENTUSERID=@CLIENTUSERSID, @PROVIDERNAME = 'PatronEdgeOnline', @IDENTIFIER=@PEOUSERID, @DISPLAYNAME='', @PREFERREDUSERNAME='', @GIVENNAME='', @FAMILYNAME='', @FORMATTEDNAME=''
end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0