USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTSUMMARYADDRESSESTILE

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTSUMMARYADDRESSESTILE
(
    @ID uniqueidentifier,  
    @DATALOADED bit = 0 output,
    @ADDRESSES xml = null output,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @USER_GRANTED_ADDRESS_EDIT_FOR_CONSTIT bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select @ADDRESSES = dbo.UFN_CONSTITUENT_ADDRESSES_TOITEMLISTXML(@ID, 1);

    if exists(select 1 from dbo.CONSTITUENT where ID = @ID)
        set @DATALOADED = 1;

    if dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 
      set @USER_GRANTED_ADDRESS_EDIT_FOR_CONSTIT = 1;
    else    
        set @USER_GRANTED_ADDRESS_EDIT_FOR_CONSTIT = case
                            when
                                dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'9BEF22AB-496F-48FD-98FE-5BE72270EF30') = 1 and
                                dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_FORCONSTIT(@CURRENTAPPUSERID,'9BEF22AB-496F-48FD-98FE-5BE72270EF30',@ID) = 1 and
                                (select
                                    count(*)
                                from
                                    dbo.UFN_SITEID_MAPFROM_CONSTITUENTID(@ID) as SITES
                                where
                                    dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_FORSITE(@CURRENTAPPUSERID, '9BEF22AB-496F-48FD-98FE-5BE72270EF30', SITEID) = 1) > 0
                            then 1
                            else 0
                            end;


    return 0;