USP_RECORDOPERATION_RESEARCHGROUPTOGGLEFAVORITE

CREATE procedure dbo.USP_RECORDOPERATION_RESEARCHGROUPTOGGLEFAVORITE
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @FAVORITE bit
)
as begin

if @FAVORITE = 1
begin
  Delete dbo.RESEARCHGROUPFAVORITE
  where
      @CURRENTAPPUSERID = APPUSERID and
      @ID = RESEARCHGROUPID
end else begin
  if @CHANGEAGENTID is null
      exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

  if not exists(select 1 from dbo.RESEARCHGROUPFAVORITE where @CURRENTAPPUSERID = APPUSERID and @ID = RESEARCHGROUPID)
    Insert into dbo.RESEARCHGROUPFAVORITE
      (APPUSERID, RESEARCHGROUPID, ADDEDBYID, CHANGEDBYID)
    values
      (@CURRENTAPPUSERID, @ID, @CHANGEAGENTID, @CHANGEAGENTID)
end

    return 0;

end