USP_RECORDOPERATION_QUERYTOGGLEFAVORITE

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@FAVORITE	bit	IN
@QUERYTYPE	int	IN

Definition

Copy



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

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

  if @FAVORITE = 1 and @QUERYTYPE = 0  --Delete ad-hoc query favorite


    begin  
      exec dbo.[USP_APPUSERADHOCQUERYFAVORITE_DELETE] @ID, @CURRENTAPPUSERID, @CHANGEAGENTID
    end

  if @FAVORITE = 1 and @QUERYTYPE = 1  --Delete smart query favorite


    begin  
      exec dbo.[USP_APPUSERSMARTQUERYINSTANCEFAVORITE_DELETE] @ID, @CURRENTAPPUSERID, @CHANGEAGENTID
    end

  if @FAVORITE = 0 and @QUERYTYPE = 0  --Add ad-hoc query favorite


    begin  
      exec dbo.[USP_APPUSERADHOCQUERYFAVORITE_ADD] @ID, @CURRENTAPPUSERID, @CHANGEAGENTID
    end

  if @FAVORITE = 0 and @QUERYTYPE = 1  --Add smart query favorite


    begin  
      exec dbo.[USP_APPUSERSMARTQUERYINSTANCEFAVORITE_ADD] @ID, @CURRENTAPPUSERID, @CHANGEAGENTID
    end

    return 0;

end