USP_REGISTRANTREGISTRATION_CHANGEORGANIZATION

CREATE procedure dbo.USP_REGISTRANTREGISTRATION_CHANGEORGANIZATION
(
  @EVENTID uniqueidentifier,
  @CONSTITUENTID uniqueidentifier,
  @ORGANIZATIONCONSTITUENTID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
    @ROLECODE tinyint,
  @GROUPID uniqueidentifier = null
)
as
begin try

  declare @RELATIONSHIPTYPECODEID uniqueidentifier = null;  
    declare @RECIPROCALTYPECODEID uniqueidentifier = null;

  if @ROLECODE in (0,1)
  begin

      select top 1 
          @RELATIONSHIPTYPECODEID = PRIMARYBUSINESSRELATIONSHIPTYPECODEID, 
          @RECIPROCALTYPECODEID = PRIMARYBUSINESSRECIPROCALTYPECODEID
      from dbo.NETCOMMUNITYDEFAULTCODEMAP

      if @RELATIONSHIPTYPECODEID is not null and @RECIPROCALTYPECODEID is not null and @ORGANIZATIONCONSTITUENTID is not null
              exec dbo.USP_DATAFORMTEMPLATE_ADD_INDTOGROUP_RELATIONSHIP
                  @CONSTITUENTID = @ORGANIZATIONCONSTITUENTID,  
                  @RECIPROCALCONSTITUENTID = @CONSTITUENTID,  
                  @RELATIONSHIPTYPECODEID = @RELATIONSHIPTYPECODEID ,
                  @RECIPROCALTYPECODEID = @RECIPROCALTYPECODEID,
                  @COMMENTS = '';        

    update dbo.REGISTRANTEXTENSION
    set ORGANIZATIONCONSTITUENTID = @ORGANIZATIONCONSTITUENTID
    where REGISTRANTID in (select ID from dbo.REGISTRANT where CONSTITUENTID = @CONSTITUENTID and EVENTID = @EVENTID) 


  end


end try
begin catch
  exec USP_RAISE_ERROR
  return 1;
end catch

return 0;