USP_FAFDEFAULTSOCIALNETWORK

CREATE procedure dbo.USP_FAFDEFAULTSOCIALNETWORK
(
  @EVENTID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null
)
as
begin

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

  declare @isEventExist bit

  begin try

    select @isEventExist= count(*) from FAFEVENTSOCIALNETWORKPROPERTY where EVENTID= @EVENTID
    if @isEventExist = 0
      begin
        insert into FAFEVENTSOCIALNETWORKPROPERTY (EVENTID, TRANSACTIONTYPECODE, ISEMPTY, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED) 
        values 
        (@EVENTID, 0, 1, @CHANGEAGENTID, @CHANGEAGENTID, getdate(), getdate()),
        (@EVENTID, 1, 1, @CHANGEAGENTID, @CHANGEAGENTID, getdate(), getdate()),
        (@EVENTID, 2, 1, @CHANGEAGENTID, @CHANGEAGENTID, getdate(), getdate()),
        (@EVENTID, 3, 1, @CHANGEAGENTID, @CHANGEAGENTID, getdate(), getdate()),
        (@EVENTID, 4, 1, @CHANGEAGENTID, @CHANGEAGENTID, getdate(), getdate()),
        (@EVENTID, 5, 1, @CHANGEAGENTID, @CHANGEAGENTID, getdate(), getdate()),
        (@EVENTID, 6, 1, @CHANGEAGENTID, @CHANGEAGENTID, getdate(), getdate())
      end

    update EVENTEXTENSION set ISNEWSOCIALNETWORK = 1 where EVENTID = @EVENTID
  end try
begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0    
end