USP_EVENTEMAILTEMPLATE_EDIT

CREATE procedure dbo.USP_EVENTEMAILTEMPLATE_EDIT  
(  
  @ID uniqueidentifier ,  
  @EVENTID uniqueidentifier ,  
  @EMAILTEMPLATEID int ,  
  @CONFIRMATIONTYPECODE tinyint 


)  
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  


   UPDATE dbo.EVENTEMAILTEMPLATE  
    SET   
    EVENTID = isnull(@EVENTID, EVENTID),  
    EMAILTEMPLATEID = isnull(@EMAILTEMPLATEID,EMAILTEMPLATEID),  
    CONFIRMATIONTYPECODE = isnull(@CONFIRMATIONTYPECODE,CONFIRMATIONTYPECODE),  
      ISAVAILABLETOINDIVIDUAL = isnull(@ISAVAILABLETOINDIVIDUAL,ISAVAILABLETOINDIVIDUAL),   
      ISAVAILABLETOHOUSEHOLD = isnull(@ISAVAILABLETOHOUSEHOLD, ISAVAILABLETOHOUSEHOLD),  
      ISAVAILABLETOTEAMMEMBER = isnull(@ISAVAILABLETOTEAMMEMBER, ISAVAILABLETOTEAMMEMBER),  
      ISAVAILABLETOTEAMLEADER = isnull(@ISAVAILABLETOTEAMLEADER, ISAVAILABLETOTEAMLEADER),  
      ISAVAILABLETOCOMPANYLEADER = isnull(@ISAVAILABLETOCOMPANYLEADER, ISAVAILABLETOCOMPANYLEADER),  
      ISAVAILABLETOFUNDRAISINGCOACH = isnull(@ISAVAILABLETOFUNDRAISINGCOACH, ISAVAILABLETOFUNDRAISINGCOACH),  
      ISAVAILABLETOSPONSOR = isnull(@ISAVAILABLETOSPONSOR, ISAVAILABLETOSPONSOR),  
      ISACTIVE = @ISACTIVE,  

      RECIPIENTDONOR =            isnull(@RECIPIENTDONOR,RECIPIENTDONOR),   
      RECIPIENTPROSPECT =         isnull(@RECIPIENTPROSPECT, RECIPIENTPROSPECT),  
      RECIPIENTINDIVIDUAL =       isnull(@RECIPIENTINDIVIDUAL, RECIPIENTINDIVIDUAL),  
      RECIPIENTHOUSEHOLDMEMBER =  isnull(@RECIPIENTHOUSEHOLDMEMBER, RECIPIENTHOUSEHOLDMEMBER),  
      RECIPIENTHOUSEHOLDLEADER =  isnull(@RECIPIENTHOUSEHOLDLEADER, RECIPIENTHOUSEHOLDLEADER),  
      RECIPIENTTEAMMEMBER =       isnull(@RECIPIENTTEAMMEMBER, RECIPIENTTEAMMEMBER),  
      RECIPIENTTEAMLEADER =       isnull(@RECIPIENTTEAMLEADER, RECIPIENTTEAMLEADER),  
      RECIPIENTCOMPANYLEADER =    isnull(@RECIPIENTCOMPANYLEADER, RECIPIENTCOMPANYLEADER),  
      RECIPIENTSTATUSPREVIOUS =   isnull(@RECIPIENTSTATUSPREVIOUS, RECIPIENTSTATUSPREVIOUS),  
      RECIPIENTSTATUSCURRENT =    isnull(@RECIPIENTSTATUSCURRENT, RECIPIENTSTATUSCURRENT),  
      NCNOTIFICATIONID = isnull(@NCNOTIFICATIONID, NCNOTIFICATIONID),  
      AVAILABLEASLETTER =         isnull(@AVAILABLEASLETTER, AVAILABLEASLETTER),
      ISAVAILABLETOHOUSEHOLDMEMBER = isnull(@ISAVAILABLETOHOUSEHOLDMEMBER, ISAVAILABLETOHOUSEHOLDMEMBER)  

   WHERE ID= @ID  

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

return 0;