USP_FAF_AddOrganizationIndividual_Relationship

Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@EVENTID	uniqueidentifier	IN
@INDIVIDUALCONSTITUENTID	uniqueidentifier	IN
@ORGANIZATIONCONSTITUENTID	uniqueidentifier	IN
@TYPECODE	smallint	IN
Definition

Copy


CREATE procedure dbo.USP_FAF_AddOrganizationIndividual_Relationship
(
     @REVENUEID    uniqueidentifier,  
     @EVENTID      uniqueidentifier,  
     @INDIVIDUALCONSTITUENTID     uniqueidentifier, 
     @ORGANIZATIONCONSTITUENTID   uniqueidentifier, 
     @TYPECODE    smallint

)
as
begin
    set nocount on; 

  declare @CHANGEAGENTID  uniqueidentifier
  declare @CHANGEDATE     datetime


  if @CHANGEAGENTID is null  
      exec USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output  

  if @CHANGEDATE is null  
   set @CHANGEDATE = getdate()  

  -- donation

  if @REVENUEID != CAST(CAST(0 AS BINARY) AS UNIQUEIDENTIFIER) 
     begin
        insert into dbo.FAFORGANIZATIONINDIVIDUALRELATION      
          (
             ID,
             REVENUEID,  
             EVENTID,  
             INDIVIDUALCONSTITUENTID, 
             ORGANIZATIONCONSTITUENTID, 
             TYPECODE, 
             ADDEDBYID,   
             CHANGEDBYID,   
             DATEADDED,   
             DATECHANGED
          )
        values
          (
              newID(),
              @REVENUEID,  
              @EVENTID,  
              @INDIVIDUALCONSTITUENTID, 
              @ORGANIZATIONCONSTITUENTID, 
              @TYPECODE,
              @CHANGEAGENTID,   
              @CHANGEAGENTID,   
              @CHANGEDATE,   
              @CHANGEDATE  
           )

     end 
  -- registration and sponsor without donation

   else
     -- check if the constituent is a team

     if exists(select ID from dbo.TeamExtension where TEAMFUNDRAISINGTEAMID = @INDIVIDUALCONSTITUENTID)
       begin
           Set @INDIVIDUALCONSTITUENTID = (select TEAMCONSTITUENTID from dbo.TeamExtension where TEAMFUNDRAISINGTEAMID = @INDIVIDUALCONSTITUENTID)
       end

     if not exists(Select ID from dbo.FAFORGANIZATIONINDIVIDUALRELATION 
                      where EventID = @EVENTID and INDIVIDUALCONSTITUENTID = @INDIVIDUALCONSTITUENTID 
                            and ORGANIZATIONCONSTITUENTID = @ORGANIZATIONCONSTITUENTID
                            and TYPECODE = @TYPECODE)

        begin
          -- pass null

          set @REVENUEID = null

          insert into dbo.FAFORGANIZATIONINDIVIDUALRELATION      
            (
               ID,
               REVENUEID,  
               EVENTID,  
               INDIVIDUALCONSTITUENTID, 
               ORGANIZATIONCONSTITUENTID, 
               TYPECODE, 
               ADDEDBYID,   
               CHANGEDBYID,   
               DATEADDED,   
               DATECHANGED
            )
          values
            (
                newID(),
                @REVENUEID,  
                @EVENTID,  
                @INDIVIDUALCONSTITUENTID, 
                @ORGANIZATIONCONSTITUENTID, 
                @TYPECODE,
                @CHANGEAGENTID,   
                @CHANGEAGENTID,   
                @CHANGEDATE,   
                @CHANGEDATE  
             )

     end 

end