UFN_CONSTITUENTSUMMARYSELECTEDTILE_VALIDTILE

CREATE function dbo.UFN_CONSTITUENTSUMMARYSELECTEDTILE_VALIDTILE
(
    @APPUSERID uniqueidentifier,
    @CONSTITUENTSUMMARYAVAILABLETILEID uniqueidentifier
)
returns bit
as begin
    declare @CONSTITUENTTYPECODE tinyint;

    select 
        @CONSTITUENTTYPECODE = CONSTITUENTTYPECODE 
    from
        dbo.CONSTITUENTSUMMARYAVAILABLETILE
    where
        ID = @CONSTITUENTSUMMARYAVAILABLETILEID;

    --Do not allow the user to select a tile with no dataforminstancecatalogid and a tile with a dataforminstancecatalogid.

    if exists 
    (
        select 1 
        from 
            dbo.CONSTITUENTSUMMARYSELECTEDTILE
            inner join dbo.CONSTITUENTSUMMARYAVAILABLETILE on CONSTITUENTSUMMARYSELECTEDTILE.CONSTITUENTSUMMARYAVAILABLETILEID = CONSTITUENTSUMMARYAVAILABLETILE.ID
        where
            CONSTITUENTSUMMARYAVAILABLETILE.DATAFORMINSTANCECATALOGID is null
            and CONSTITUENTSUMMARYSELECTEDTILE.APPUSERID = @APPUSERID
            and CONSTITUENTSUMMARYAVAILABLETILE.CONSTITUENTTYPECODE = @CONSTITUENTTYPECODE
    )
    begin
        if (
            select 
                count(*) 
            from 
                dbo.CONSTITUENTSUMMARYSELECTEDTILE 
                inner join dbo.CONSTITUENTSUMMARYAVAILABLETILE on CONSTITUENTSUMMARYSELECTEDTILE.CONSTITUENTSUMMARYAVAILABLETILEID = CONSTITUENTSUMMARYAVAILABLETILE.ID
            where 
                CONSTITUENTSUMMARYSELECTEDTILE.APPUSERID = @APPUSERID
                and CONSTITUENTSUMMARYAVAILABLETILE.CONSTITUENTTYPECODE = @CONSTITUENTTYPECODE
        ) > 1
            return 0;
        else
            return 1;
    end

    return 1;
end