USP_FAF_DEFAULT_MARKETING_MESSAGES

Create default marketing messages for faf
Parameters

Parameter	Parameter Type	Mode
@EVENTID	uniqueidentifier	IN
@APPUSERID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@USERID	int	IN
@CLIENTSID	int	IN
Definition

Copy


CREATE procedure dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES
(
      @EVENTID uniqueidentifier,
      @APPUSERID uniqueidentifier,
      @CHANGEAGENTID uniqueidentifier = null,
      @USERID int = null,
      @CLIENTSID int = null
    )
as
begin

 SET NOCOUNT ON;

 DECLARE @PRIORYEAREVENTID uniqueidentifier

 SELECT @PRIORYEAREVENTID = PRIORYEAREVENTID FROM dbo.EVENTEXTENSION (NOLOCK) WHERE EVENTID = @EVENTID

  BEGIN TRAN    
    begin try   

      -- Create Adhoc Query and list - All participants


      EXEC dbo.USP_FAF_ADHOCQUERY_LIST_ALLPARTICIPANTS_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 1, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      -- All Leaders


      EXEC dbo.USP_FAF_ADHOCQUERY_LIST_ALLPARTICIPANTS_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 2, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      -- All Members


      EXEC dbo.USP_FAF_ADHOCQUERY_LIST_ALLPARTICIPANTS_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 3, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      -- Company & Team Leaders


      EXEC dbo.USP_FAF_ADHOCQUERY_LIST_ALLPARTICIPANTS_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 4, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      -- Company Leaders


      EXEC dbo.USP_FAF_ADHOCQUERY_LIST_ALLPARTICIPANTS_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 5, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      -- Team Leaders


      EXEC dbo.USP_FAF_ADHOCQUERY_LIST_ALLPARTICIPANTS_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 6, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      -- Household Leaders


      EXEC dbo.USP_FAF_ADHOCQUERY_LIST_ALLPARTICIPANTS_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 7, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      -- Team members & Individuals


      EXEC dbo.USP_FAF_ADHOCQUERY_LIST_ALLPARTICIPANTS_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 8, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      -- Household members


      EXEC dbo.USP_FAF_ADHOCQUERY_LIST_ALLPARTICIPANTS_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 9, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      -- Create Messages


      EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 1, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 2, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 3, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 4, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 5, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 6, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 7, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 8, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 9, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 10, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 11, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 12, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 13, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 14, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 15, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      -- Previous Participants


      IF EXISTS (SELECT 1 FROM dbo.EVENT (nolock) where ID = @PRIORYEAREVENTID)
      BEGIN

          EXEC dbo.USP_FAF_ADHOCQUERY_LIST_ALLPARTICIPANTS_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 10, @USERID = @USERID, @CLIENTSID = @CLIENTSID

          EXEC dbo.USP_FAF_ADHOCQUERY_LIST_ALLPARTICIPANTS_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 11, @USERID = @USERID, @CLIENTSID = @CLIENTSID

          EXEC dbo.USP_FAF_ADHOCQUERY_LIST_ALLPARTICIPANTS_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 12, @USERID = @USERID, @CLIENTSID = @CLIENTSID

          EXEC dbo.USP_FAF_ADHOCQUERY_LIST_ALLPARTICIPANTS_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 13, @USERID = @USERID, @CLIENTSID = @CLIENTSID

          EXEC dbo.USP_FAF_ADHOCQUERY_LIST_ALLPARTICIPANTS_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 14, @USERID = @USERID, @CLIENTSID = @CLIENTSID

          EXEC dbo.USP_FAF_ADHOCQUERY_LIST_ALLPARTICIPANTS_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 15, @USERID = @USERID, @CLIENTSID = @CLIENTSID


          EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 16, @USERID = @USERID, @CLIENTSID = @CLIENTSID

          EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 17, @USERID = @USERID, @CLIENTSID = @CLIENTSID

          EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 18, @USERID = @USERID, @CLIENTSID = @CLIENTSID

          EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 19, @USERID = @USERID, @CLIENTSID = @CLIENTSID

          EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 20, @USERID = @USERID, @CLIENTSID = @CLIENTSID

          EXEC dbo.USP_FAF_DEFAULT_MARKETING_MESSAGES_ADD @EVENTID = @EVENTID, @APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID, @TYPE = 21, @USERID = @USERID, @CLIENTSID = @CLIENTSID

      END

    end try
    begin catch
      exec dbo.USP_RAISE_ERROR;
      ROLLBACK TRAN
      return 1;
    end catch

    COMMIT TRAN

    return 0;
end