fnGetImageCategoryID

Return

Return Type
int
Parameters

Parameter	Parameter Type	Mode	Description
@ClientSitesID	int	IN
@Category	nvarchar(255)	IN
Definition

Copy


            CREATE FUNCTION dbo.fnGetImageCategoryID
            (
                @ClientSitesID int,
                @Category nvarchar(255)
            )
            RETURNS int
            AS
            BEGIN
                DECLARE @CategoryID int
                SET @CategoryID = 0

                IF EXISTS (SELECT TOP 1 FolderID
                              FROM dbo.SiteFolders
                             WHERE ClientSitesID = @ClientSitesID
                               AND FolderName = LTRIM(RTRIM(@Category))
                               AND Type = 2
                               AND Deleted = 0)
                    SELECT TOP 1 @CategoryID = FolderID
                      FROM dbo.SiteFolders
                     WHERE ClientSitesID = @ClientSitesID
                       AND FolderName = LTRIM(RTRIM(@Category))
                       AND Type = 2
                       AND Deleted = 0

                RETURN @CategoryID
            END