spLoadRecord_ProfilePhotoImage

Parameters

Parameter	Parameter Type	Mode
@UserId	int	IN
@CategoryID	int	IN
@TAGCODEID	uniqueidentifier	IN

Definition

Copy


    CREATE  PROCEDURE [dbo].[spLoadRecord_ProfilePhotoImage]
(
  @UserId int,
  @CategoryID  int,
  @TAGCODEID uniqueidentifier = null
)
AS
    declare @Id as int

    if @CategoryID > 0 
    begin
        select @id = dbo.SiteImages.id
        from dbo.SiteImages
        inner join dbo.SiteImageFolders on dbo.SiteImages.Id = dbo.SiteImageFolders.SiteImageID
        where OwnerID = @UserId 
        and dbo.SiteImageFolders.SiteFolderID = @CategoryID 
        and type=2
        and dbo.SiteImages.deleted = 0
        order by dbo.SiteImages.id desc
    end
    else
    begin
        select @id = dbo.SiteImages.id
        from dbo.SiteImages
        inner join dbo.SITEIMAGETAG on dbo.SiteImages.Id = dbo.SITEIMAGETAG.SiteImageID
        where OwnerID = @UserId 
        and dbo.SITEIMAGETAG.TAGCODEID = @TAGCODEID 
        and dbo.SiteImages.deleted = 0
        order by dbo.SiteImages.id desc        
    end

    exec dbo.spLoadRecord_SiteImages @id