USP_DATAFORMTEMPLATE_VIEW_DATANETTEASER

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DATANETTEASER
(
    @ID nvarchar(100),
    @CURRENTAPPUSERID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @REMAININGCOUNT int = null output,
    @PREEXISTING bit = null output,
  @SHOWRESULTS bit = null output
)
as
    set nocount on;

    set @DATALOADED = 1;
  set @REMAININGCOUNT = 9;
  set @PREEXISTING = 0;
  set @SHOWRESULTS = 0;

  declare @CHANGEAGENTID uniqueidentifier;
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

  declare @CURRENTDATE datetime;
  set @CURRENTDATE = getdate();

  if exists(select top 1 1 from dbo.DATANETTEASERTRACKING where APPUSERID = @CURRENTAPPUSERID and ENTITYID = @ID)
    select @PREEXISTING = 1, @SHOWRESULTS = 1;

  set @REMAININGCOUNT = 10 - (select count(*) from dbo.DATANETTEASERTRACKING where APPUSERID = @CURRENTAPPUSERID);

  if (@REMAININGCOUNT > 0 and @PREEXISTING = 0)
  begin
    insert into dbo.DATANETTEASERTRACKING(APPUSERID, ENTITYID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    values(@CURRENTAPPUSERID, @ID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);

    set @REMAININGCOUNT = @REMAININGCOUNT - 1;
    set @SHOWRESULTS = 1;
  end

  if (@REMAININGCOUNT = 0)
    exec dbo.USP_DATANETTEASER_SENDEMAIL @CURRENTAPPUSERID, @CHANGEAGENTID, 0;

    return 0;