USP_INVITEE_TOGGLECONSTITUENTDECLINEDSTATUS

create procedure dbo.USP_INVITEE_TOGGLECONSTITUENTDECLINEDSTATUS
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier
)
as
  set nocount on;

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

  update
    INVITEE
  set
    INVITEE.DECLINED = ABS(CONTEXT.DECLINED - 1),
    CHANGEDBYID = @CHANGEAGENTID, DATECHANGED = getdate()
  from
    dbo.INVITEE
  inner join
    dbo.INVITEE CONTEXT on CONTEXT.EVENTID = INVITEE.EVENTID and CONTEXT.CONSTITUENTID = INVITEE.CONSTITUENTID
  where
    CONTEXT.ID = @ID;

  return 0;