USP_DATAFORMTEMPLATE_EDIT_EVENTSITEPERMISSION

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EVENTSITEPERMISSION (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,    
  @CURRENTAPPUSERID uniqueidentifier,
    @SITES xml
)
as
    set nocount on;

  declare @DEFAULTSITEID uniqueidentifier,
          @dSite nvarchar(75)

  if dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID) = 1 
  begin
    if @SITES is null
      raiserror('Site is required.',13,1)  
    else
    begin
      select @DEFAULTSITEID = SITEID from dbo.UFN_SITE_MYSITE_GET(@CURRENTAPPUSERID)
      if @DEFAULTSITEID is null
        raiserror('You are not assigned to a default site. To continue, contact your administrator and verify your default site setup.', 13,1);
      else
        begin      
          set @dSite = '<SITEID>'+ cast(@DEFAULTSITEID as nvarchar(40)) +'</SITEID>';
          if CAST(@SITES AS NVARCHAR(MAX)) NOT LIKE '%'+@dSite+'%'
            raiserror('You did not assign your default site to the event.  To continue, edit site security and add your default site.', 13,1)

        end
    end
  end

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        exec dbo.USP_EVENT_GETSITES_UPDATEFROMXML @ID, @SITES, @CHANGEAGENTID, @CURRENTDATE
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;