/// <summary>
/// Return an <see cref="System.Data.IDataReader"/> representing the hash keys for all media objects in the specified gallery.
/// </summary>
/// <param name="galleryId">The value that uniquely identifies the current gallery.</param>
/// <returns>
/// Returns an <see cref="System.Data.IDataReader"/> object with one field named "HashKey" containing the hash keys
/// for all media objects in the current gallery.
/// </returns>
public override System.Data.IDataReader MediaObject_GetAllHashKeys(int galleryId)
{
return(MediaObject.GetHashKeys(galleryId));
}
/// <summary>
/// Permanently delete the specified media object from the data store. This action cannot
/// be undone.
/// </summary>
/// <param name="mediaObject">The <see cref="IGalleryObject"/> to delete from the data store.</param>
public override void MediaObject_Delete(IGalleryObject mediaObject)
{
MediaObject.Delete(mediaObject);
}
/// <summary>
/// Persist the specified media object to the data store. Return the ID of the media object.
/// </summary>
/// <param name="mediaObject">An instance of <see cref="IGalleryObject"/> to persist to the data store.</param>
/// <returns>
/// Return the ID of the media object. If this is a new media object and a new ID has been
/// assigned, then this value has also been assigned to the ID property of the object.
/// </returns>
public override int MediaObject_Save(IGalleryObject mediaObject)
{
return(MediaObject.Save(mediaObject));
}
/// <summary>
/// Return an <see cref="System.Data.IDataReader"/> representing the metadata items for the specified mediaObjectId. If no matching object
/// is found in the data store, an empty <see cref="System.Data.IDataReader"/> is returned.
/// </summary>
/// <param name="mediaObjectId">The ID that uniquely identifies the desired media object.</param>
/// <returns>
/// Returns an <see cref="System.Data.IDataReader"/> object with all metadata items.
/// </returns>
public override System.Data.IDataReader MediaObject_GetDataReaderMetadataItemsByMediaObjectId(int mediaObjectId)
{
return(MediaObject.GetDataReaderMetadataItemsByMediaObjectId(mediaObjectId));
}
/// <summary>
/// Return a collection representing the child media objects contained within the album specified by
/// <paramref name="albumId"/> parameter, optionally including the metadata for each item. If no matching
/// objects are found in the data store, an empty collection is returned.
/// </summary>
/// <param name="albumId">The ID that uniquely identifies the desired album.</param>
/// <param name="includeMetadata">When <c>true</c> include metadata items on the
/// <see cref="MediaObjectDto.MediaObjectMetadata" /> property. When <c>false</c>, the property is null.</param>
/// <returns>
/// Returns a collection of all media objects directly within the album represented by <paramref name="albumId"/>.
/// </returns>
internal static IEnumerable <MediaObjectDto> GetChildGalleryObjectsById(int albumId, bool includeMetadata)
{
List <MediaObjectDto> mediaObjects = new List <MediaObjectDto>();
using (SqlConnection cn = SqlDataProvider.GetDbConnection())
{
using (IDataReader dr = GetCommandChildMediaObjectsById(albumId, cn).ExecuteReader())
{
while (dr.Read())
{
// SQL:
//SELECT
// MediaObjectId, FKAlbumId, Title, HashKey, ThumbnailFilename, ThumbnailWidth, ThumbnailHeight,
// ThumbnailSizeKB, OptimizedFilename, OptimizedWidth, OptimizedHeight, OptimizedSizeKB,
// OriginalFilename, OriginalWidth, OriginalHeight, OriginalSizeKB, ExternalHtmlSource, ExternalType, Seq,
// CreatedBy, DateAdded, LastModifiedBy, DateLastModified, IsPrivate
//FROM [gs_MediaObject]
//WHERE FKAlbumId = @AlbumId
mediaObjects.Add(new MediaObjectDto
{
MediaObjectId = dr.GetInt32(0),
FKAlbumId = dr.GetInt32(1),
Title = dr.GetString(2),
HashKey = dr.GetString(3),
ThumbnailFilename = dr.GetString(4),
ThumbnailWidth = dr.GetInt32(5),
ThumbnailHeight = dr.GetInt32(6),
ThumbnailSizeKB = dr.GetInt32(7),
OptimizedFilename = dr.GetString(8),
OptimizedWidth = dr.GetInt32(9),
OptimizedHeight = dr.GetInt32(10),
OptimizedSizeKB = dr.GetInt32(11),
OriginalFilename = dr.GetString(12),
OriginalWidth = dr.GetInt32(13),
OriginalHeight = dr.GetInt32(14),
OriginalSizeKB = dr.GetInt32(15),
ExternalHtmlSource = dr.GetString(16),
ExternalType = dr.GetString(17),
Seq = dr.GetInt32(18),
CreatedBy = dr.GetString(19),
DateAdded = dr.GetDateTime(20),
LastModifiedBy = dr.GetString(21),
DateLastModified = dr.GetDateTime(22),
IsPrivate = dr.GetBoolean(23)
});
}
}
if (includeMetadata)
{
foreach (MediaObjectDto moDto in mediaObjects)
{
moDto.MediaObjectMetadata = new HashSet <MediaObjectMetadataDto>(MediaObject.GetMetadataItemsByMediaObjectId(moDto.MediaObjectId, cn));
}
}
}
return(mediaObjects);
}
