USP_RECORDOPERATION_KPIINSTANCEFAVORITETOGGLE

Parameters

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

Definition

Copy



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

  begin

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

    if @FAVORITE = 1 --Delete


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

    if @FAVORITE = 0  --Add


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

      return 0;

  end