/// <summary>
/// Fill the <paramref name="emptyCollection"/> with all the galleries in the current application. The return value is the same reference
/// as the parameter. The template gallery is not included (that is, the one where the gallery ID = <see cref="Int32.MinValue" />.
/// </summary>
/// <param name="emptyCollection">An empty <see cref="IGalleryCollection"/> object to populate with the list of galleries in the current
/// application. This parameter is required because the library that implements this interface does not have
/// the ability to directly instantiate any object that implements <see cref="IGalleryCollection"/>.</param>
/// <returns>
/// Returns an <see cref="IGalleryCollection" /> representing the galleries in the current application. The returned object is the
/// same object in memory as the <paramref name="emptyCollection"/> parameter.
/// </returns>
/// <exception cref="ArgumentNullException">Thrown when <paramref name="emptyCollection" /> is null.</exception>
internal static IGalleryCollection GetGalleries(IGalleryCollection emptyCollection)
{
if (emptyCollection == null)
{
throw new ArgumentNullException("emptyCollection");
}
if (emptyCollection.Count > 0)
{
emptyCollection.Clear();
}
using (IDataReader dr = GetDataReaderGalleries())
{
// SQL:
//SELECT
// GalleryId, Description, DateAdded
//FROM [gs_Gallery];
while (dr.Read())
{
IGallery g = emptyCollection.CreateEmptyGalleryInstance();
g.GalleryId = Convert.ToInt32(dr["GalleryId"].ToString().Trim(), CultureInfo.InvariantCulture);
g.Description = Convert.ToString(dr["Description"].ToString().Trim(), CultureInfo.InvariantCulture);
g.CreationDate = Convert.ToDateTime(dr["DateAdded"].ToString(), CultureInfo.CurrentCulture);
g.Albums = FlattenGallery(g.GalleryId);
emptyCollection.Add(g);
}
}
return(emptyCollection);
}
/// <summary>
/// Fill the <paramref name="emptyCollection"/> with all the galleries in the current application. The return value is the same reference
/// as the parameter. The template gallery is not included (that is, the one where the gallery ID = <see cref="Int32.MinValue"/>.
/// </summary>
/// <param name="emptyCollection">An empty <see cref="IGalleryCollection"/> object to populate with the list of galleries in the current
/// application. This parameter is required because the library that implements this interface does not have
/// the ability to directly instantiate any object that implements <see cref="IGalleryCollection"/>.</param>
/// <returns>
/// Returns an <see cref="IGalleryCollection"/> representing the galleries in the current application. The returned object is the
/// same object in memory as the <paramref name="emptyCollection"/> parameter.
/// </returns>
/// <exception cref="ArgumentNullException">Thrown when <paramref name="emptyCollection" /> is null.</exception> ///
public override IGalleryCollection Gallery_GetGalleries(IGalleryCollection emptyCollection)
{
if (emptyCollection == null)
throw new ArgumentNullException("emptyCollection");
if (emptyCollection.Count > 0)
{
emptyCollection.Clear();
}
using (GspContext ctx = new GspContext())
{
var galleries = from i in ctx.Galleries where i.GalleryId > int.MinValue select i;
foreach (GalleryDto gallery in galleries)
{
IGallery g = emptyCollection.CreateEmptyGalleryInstance();
g.GalleryId = gallery.GalleryId;
g.Description = gallery.Description;
g.CreationDate = gallery.DateAdded;
g.Albums = FlattenGallery(gallery.GalleryId);
emptyCollection.Add(g);
}
}
return emptyCollection;
}
/// <summary>
/// Fill the <paramref name="emptyCollection"/> with all the galleries in the current application. The return value is the same reference
/// as the parameter. The template gallery is not included (that is, the one where the gallery ID = <see cref="Int32.MinValue" />.
/// </summary>
/// <param name="emptyCollection">An empty <see cref="IGalleryCollection"/> object to populate with the list of galleries in the current
/// application. This parameter is required because the library that implements this interface does not have
/// the ability to directly instantiate any object that implements <see cref="IGalleryCollection"/>.</param>
/// <returns>
/// Returns an <see cref="IGalleryCollection" /> representing the galleries in the current application. The returned object is the
/// same object in memory as the <paramref name="emptyCollection"/> parameter.
/// </returns>
/// <exception cref="ArgumentNullException">Thrown when <paramref name="emptyCollection" /> is null.</exception>
internal static IGalleryCollection GetGalleries(IGalleryCollection emptyCollection)
{
if (emptyCollection == null)
throw new ArgumentNullException("emptyCollection");
if (emptyCollection.Count > 0)
{
emptyCollection.Clear();
}
using (IDataReader dr = GetDataReaderGalleries())
{
// SQL:
//SELECT
// GalleryId, Description, DateAdded
//FROM [gs_Gallery];
while (dr.Read())
{
IGallery g = emptyCollection.CreateEmptyGalleryInstance();
g.GalleryId = Convert.ToInt32(dr["GalleryId"].ToString().Trim(), CultureInfo.InvariantCulture);
g.Description = Convert.ToString(dr["Description"].ToString().Trim(), CultureInfo.InvariantCulture);
g.CreationDate = Convert.ToDateTime(dr["DateAdded"].ToString(), CultureInfo.CurrentCulture);
g.Albums = FlattenGallery(g.GalleryId);
emptyCollection.Add(g);
}
}
return emptyCollection;
}
/// <summary>
/// Fill the <paramref name="emptyCollection"/> with all the galleries in the current application. The return value is the same reference
/// as the parameter. The template gallery is not included (that is, the one where <see cref="GalleryDto.IsTemplate" /> = <c>true</c>).
/// </summary>
/// <param name="emptyCollection">An empty <see cref="IGalleryCollection"/> object to populate with the list of galleries in the current
/// application. This parameter is required because the library that implements this interface does not have
/// the ability to directly instantiate any object that implements <see cref="IGalleryCollection"/>.</param>
/// <returns>
/// Returns an <see cref="IGalleryCollection"/> representing the galleries in the current application. The returned object is the
/// same object in memory as the <paramref name="emptyCollection"/> parameter.
/// </returns>
/// <exception cref="ArgumentNullException">Thrown when <paramref name="emptyCollection" /> is null.</exception> ///
private static IGalleryCollection LoadGalleries(IGalleryCollection emptyCollection)
{
if (emptyCollection == null)
throw new ArgumentNullException("emptyCollection");
if (emptyCollection.Count > 0)
{
emptyCollection.Clear();
}
using (var repo = new GalleryRepository())
{
//var galleries = from i in ctx.Galleries where i.GalleryId > int.MinValue select i;
var galleries = repo.Where(g => !g.IsTemplate);
foreach (GalleryDto gallery in galleries)
{
IGallery g = emptyCollection.CreateEmptyGalleryInstance();
g.GalleryId = gallery.GalleryId;
g.Description = gallery.Description;
g.CreationDate = gallery.DateAdded;
g.Albums = FlattenGallery(gallery.GalleryId);
emptyCollection.Add(g);
}
}
return emptyCollection;
}
