USP_EVENTEMAILTEMPLATE_ADD

The save procedure used by the add dataform template "EVENTEMAILTEMPLATE Add Data Form".
Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@EVENTID	uniqueidentifier	IN	EVENTID
@EMAILTEMPLATEID	int	IN	EMAILTEMPLATEID
@CONFIRMATIONTYPECODE	tinyint	IN	CONFIRMATIONTYPECODE
Definition

Copy

CREATE procedure dbo.USP_EVENTEMAILTEMPLATE_ADD 
(  
  @ID uniqueidentifier = null output,  
  @EVENTID uniqueidentifier = null,  
  @EMAILTEMPLATEID int = null,  
  @CONFIRMATIONTYPECODE tinyint = null


)  
as  
 set nocount on;  

   declare @CHANGEAGENTID uniqueidentifier
   set @CHANGEAGENTID = null  

   declare @ISAVAILABLETOINDIVIDUAL bit 
   set @ISAVAILABLETOINDIVIDUAL  = 1 

   declare @ISAVAILABLETOHOUSEHOLD bit
   set @ISAVAILABLETOHOUSEHOLD  = 1  
   declare @ISAVAILABLETOHOUSEHOLDMEMBER bit
   set @ISAVAILABLETOHOUSEHOLDMEMBER  = 1  

   declare @ISAVAILABLETOTEAMMEMBER bit
   set @ISAVAILABLETOTEAMMEMBER  = 1  
   declare @ISAVAILABLETOTEAMLEADER bit 
   set @ISAVAILABLETOTEAMLEADER  = 1  
   declare @ISAVAILABLETOCOMPANYLEADER bit 
   set @ISAVAILABLETOCOMPANYLEADER  = 1
   declare @ISAVAILABLETOFUNDRAISINGCOACH bit 
   set  @ISAVAILABLETOFUNDRAISINGCOACH  = 1  

   declare @ISAVAILABLETOSPONSOR bit 
   set @ISAVAILABLETOSPONSOR  = 1 
   declare @ISACTIVE bit      
   set @ISACTIVE = 1  
   declare @RECIPIENTDONOR bit
   set @RECIPIENTDONOR = 0  
   declare @RECIPIENTPROSPECT bit  
   set @RECIPIENTPROSPECT = 0 
   declare @RECIPIENTINDIVIDUAL bit   
   set @RECIPIENTINDIVIDUAL = 0  
   declare @RECIPIENTHOUSEHOLDMEMBER bit  
   set @RECIPIENTHOUSEHOLDMEMBER = 0 
   declare @RECIPIENTHOUSEHOLDLEADER bit  
   set @RECIPIENTHOUSEHOLDLEADER = 0  
   declare @RECIPIENTTEAMMEMBER bit
   set @RECIPIENTTEAMMEMBER = 0  
   declare @RECIPIENTTEAMLEADER bit 
   set @RECIPIENTTEAMLEADER = 0  
   declare @RECIPIENTCOMPANYLEADER bit  
   set @RECIPIENTCOMPANYLEADER = 0  
   declare @RECIPIENTSTATUSPREVIOUS bit 
   set @RECIPIENTSTATUSPREVIOUS = 0  
   declare @RECIPIENTSTATUSCURRENT bit 
   set @RECIPIENTSTATUSCURRENT = 0  
   declare @NCNOTIFICATIONID int 
   set @NCNOTIFICATIONID  = null
   declare @AVAILABLEASLETTER bit  
   set @AVAILABLEASLETTER  = 0  

 if @ID is null  
  set @ID = newid()  

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

 declare @CURRENTDATE datetime      
 set @CURRENTDATE = getdate()      

 begin try  

   INSERT INTO dbo.EVENTEMAILTEMPLATE      
     ( ID, EVENTID, EMAILTEMPLATEID, CONFIRMATIONTYPECODE, ISAVAILABLETOINDIVIDUAL, ISAVAILABLETOHOUSEHOLD, ISAVAILABLETOTEAMMEMBER, ISAVAILABLETOTEAMLEADER,   
        ISAVAILABLETOCOMPANYLEADER,ISAVAILABLETOFUNDRAISINGCOACH,ISAVAILABLETOSPONSOR, ISACTIVE,  
        RECIPIENTDONOR, RECIPIENTPROSPECT, RECIPIENTINDIVIDUAL, RECIPIENTHOUSEHOLDMEMBER, RECIPIENTHOUSEHOLDLEADER, RECIPIENTTEAMMEMBER,   
        RECIPIENTTEAMLEADER, RECIPIENTCOMPANYLEADER, RECIPIENTSTATUSPREVIOUS, RECIPIENTSTATUSCURRENT, NCNOTIFICATIONID,  
        ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, AVAILABLEASLETTER, ISAVAILABLETOHOUSEHOLDMEMBER)      
   VALUES      
     ( @ID, @EVENTID, @EMAILTEMPLATEID, @CONFIRMATIONTYPECODE, @ISAVAILABLETOINDIVIDUAL, @ISAVAILABLETOHOUSEHOLD, @ISAVAILABLETOTEAMMEMBER, @ISAVAILABLETOTEAMLEADER,   
        @ISAVAILABLETOCOMPANYLEADER,@ISAVAILABLETOFUNDRAISINGCOACH,@ISAVAILABLETOSPONSOR, @ISACTIVE,   
        @RECIPIENTDONOR, @RECIPIENTPROSPECT,@RECIPIENTINDIVIDUAL, @RECIPIENTHOUSEHOLDMEMBER, @RECIPIENTHOUSEHOLDLEADER, @RECIPIENTTEAMMEMBER,   
        @RECIPIENTTEAMLEADER, @RECIPIENTCOMPANYLEADER, @RECIPIENTSTATUSPREVIOUS, @RECIPIENTSTATUSCURRENT, @NCNOTIFICATIONID,  
        @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE, @AVAILABLEASLETTER, @ISAVAILABLETOHOUSEHOLDMEMBER)      


 end try  
 begin catch  
  exec dbo.USP_RAISE_ERROR  
  return 1  
 end catch  

return 0;