USP_FAF_DEFAULT_MARKETING_TEMPLATE_ADD

    CREATE PROCEDURE dbo.USP_FAF_DEFAULT_MARKETING_TEMPLATE_ADD
    (
      @EVENTID uniqueidentifier,
      @APPUSERID uniqueidentifier = null,
      @CHANGEAGENTID uniqueidentifier = null,
      @USERID int = null,
      @CLIENTSID int = null      
    )
    as

    SET NOCOUNT ON;

    DECLARE @EVENTNAME varchar(200)
    DECLARE @TEMPLATENAME varchar(255)
--    DECLARE @UserID int

--    DECLARE @ClientsID int

    DECLARE @DATEADDED datetime
    DECLARE @EMAILTEMPLATEID int
    DECLARE @EMAILTEMPLATEGUID uniqueidentifier
    DECLARE @FromDisplayName nvarchar(255)
    DECLARE @FromAddress nvarchar(255)
    DECLARE @ClientSitesID int
    DECLARE @NCNotificationTypeID int
    DECLARE @NCNotificationID int

    SET @DATEADDED = GETDATE()

--    SELECT @UserID = C.ID, @ClientsID = C.ClientsID

--    FROM BBNCUSERMAP B

--      INNER JOIN dbo.[ClientUsers] C (NOLOCK) 

--      ON C.[UserName] = B.BBNCUSERNAME

--      WHERE B.ID = @APPUSERID


--    IF @UserID IS NULL

--    SELECT top 1 @USERID = ID, @CLIENTSID = ClientsID

--    FROM dbo.ClientUsers (NOLOCK)

--    WHERE Deleted = 0 and Active = 1 and IsSupervisor = 1

--    ORDER BY CreateDate 


    SELECT @EVENTNAME = E.NAME, @FromDisplayName = C.NAME, @FromAddress = EA.EMAILADDRESS
    FROM dbo.EVENT E (NOLOCK) 
    LEFT OUTER JOIN dbo.CONSTITUENT C (NOLOCK)
    ON E.EVENTLOCATIONCONTACTID = C.ID
    LEFT OUTER JOIN dbo.EMAILADDRESS EA (NOLOCK)
    ON C.ID = EA.CONSTITUENTID AND EA.ISPRIMARY = 1
    WHERE E.ID = @EVENTID;

    SELECT @ClientSitesID = CLIENTSITESID
    from dbo.EVENTEXTENSION (NOLOCK)
    where EVENTID = @EVENTID

    IF ISNULL(@FromDisplayName,'') = ''
    SET @FromDisplayName = 'Sender Name'

    IF ISNULL(@FromAddress,'') = ''
    SET @FromAddress = 'Sender@Contact.com'

    IF LEN(@EVENTNAME) > 80
    SET @EVENTNAME = SUBSTRING(@EVENTNAME,0,80)

    IF @CHANGEAGENTID is null  
            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    IF @EMAILTEMPLATEGUID IS NULL
        SET @EMAILTEMPLATEGUID = NEWID();

    SET @TEMPLATENAME = @EVENTNAME+' - Event Information Emails'

    SELECT @NCNotificationTypeID = ID from dbo.NotificationType where SystemName = 'FAF Notification'

    SET @NCNotificationID = 0

    BEGIN TRAN

    begin try    

     EXEC dbo.spAddUpdate_Notification @PKID = @NCNotificationID output,  
                @NotificationTypeID = @NCNotificationTypeID,  
                @DisplayName = @TEMPLATENAME,  
                @Description = @TEMPLATENAME,  
                @EmailTemplateID = null,  
                @Enabled = 1;  

    EXEC dbo.USP_FAFEVENTEMAILTEMPLATE_ADDUPDATE @ID = @EMAILTEMPLATEGUID, @EVENTID = @EVENTID, @CLIENTSITEID = @ClientSitesID,@EMAILTEMPLATEID = 0, @USERID = @UserID,
        @ClientsId = @ClientsID, @Name = @TEMPLATENAME, @Description = '', @ContentHTML=N'', @FromAddress=@FromAddress,    @FROMNAME=@FromDisplayName,
        @Subject=N'Please change subject',@FAFEMAILTYPECODE = 33

        UPDATE EmailTemplate
            SET Type = 13,DataSourceID = 320
            WHERE ClientSitesID = @ClientSitesID and Name = @TEMPLATENAME    

      UPDATE EVENTEMAILTEMPLATE
        SET NCNOTIFICATIONID = @NCNotificationID
        WHERE ID = @EMAILTEMPLATEGUID

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

    COMMIT TRAN
    return 0;