USP_DATAFORMTEMPLATE_VIEW_SOCIALMEDIATEASER

create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_SOCIALMEDIATEASER
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @DATALOADED bit = 0 output,
  @SHOWTEASER bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

  select 
    @SHOWTEASER = SHOWTEASER,
    @DATALOADED = 1
  from 
    dbo.SOCIALMEDIATEASER 
  where 
    ID = @CURRENTAPPUSERID

  -- No user preference has been set yet, set preference and show teaser
  if @DATALOADED = 0
  begin
    set @SHOWTEASER = 1;

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

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

    insert into dbo.SOCIALMEDIATEASER
    (
      ID, 
      SHOWTEASER,
      ADDEDBYID,
      CHANGEDBYID,
      DATEADDED,
      DATECHANGED   
    )
    values
    (
      @CURRENTAPPUSERID,
      @SHOWTEASER,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE
    )

      set @DATALOADED = 1;
  end 

    return 0;