/// <summary>
/// Verify there is a UI template/album mapping for the root album in the current gallery, creating them
/// if necessary.
/// </summary>
/// <param name="rootAlbum">The root album.</param>
private static void ConfigureUiTemplateAlbumTable(AlbumDto rootAlbum)
{
using (var repoUiTmpl = new UiTemplateRepository())
{
using (var repoUiTmplA = new UiTemplateAlbumRepository(repoUiTmpl.Context))
{
// Make sure each template category has at least one template assigned to the root album.
// We do this with a union of two queries:
// 1. For categories where there is at least one album assignment, determine if at least one of
// those assignments is the root album.
// 2. Find categories without any albums at all (this is necessary because the SelectMany() in the first
// query won't return any categories that don't have related records in the template/album table).
var dtos = repoUiTmpl.Where(t => t.FKGalleryId == rootAlbum.FKGalleryId)
.SelectMany(t => t.TemplateAlbums, (t, tt) => new { t.TemplateType, tt.FKAlbumId })
.GroupBy(t => t.TemplateType)
.Where(t => t.All(ta => ta.FKAlbumId != rootAlbum.AlbumId))
.Select(t => t.Key)
.Union(repoUiTmpl.Where(t => t.FKGalleryId == rootAlbum.FKGalleryId).GroupBy(t => t.TemplateType).Where(t => t.All(t2 => !t2.TemplateAlbums.Any())).Select(t => t.Key))
;
foreach (var dto in dtos)
{
// We have a template type without a root album. Find the default template and assign that one.
var dto1 = dto;
repoUiTmplA.Add(new UiTemplateAlbumDto()
{
FKUiTemplateId = repoUiTmpl.Where(t => t.FKGalleryId == rootAlbum.FKGalleryId && t.TemplateType == dto1 && t.Name.Equals("default", StringComparison.OrdinalIgnoreCase)).First().UiTemplateId,
FKAlbumId = rootAlbum.AlbumId
});
}
repoUiTmplA.Save();
}
}
}
/// <summary>
/// Gets a collection of all UI templates from the data store. Returns an empty collection if no
/// items exist.
/// </summary>
/// <returns>Returns a collection of all UI templates from the data store.</returns>
public static IUiTemplateCollection GetUiTemplates()
{
IUiTemplateCollection tmpl = new UiTemplateCollection();
using (var repo = new UiTemplateRepository())
{
foreach (var jDto in repo.GetAll(j => j.TemplateAlbums))
{
IUiTemplate t = new UiTemplate
{
UiTemplateId = jDto.UiTemplateId,
TemplateType = jDto.TemplateType,
GalleryId = jDto.FKGalleryId,
Name = jDto.Name,
Description = jDto.Description,
HtmlTemplate = jDto.HtmlTemplate,
ScriptTemplate = jDto.ScriptTemplate
};
t.RootAlbumIds.AddRange(from r in jDto.TemplateAlbums select r.FKAlbumId);
tmpl.Add(t);
}
}
return(tmpl);
}
/// <summary>
/// Verify there are UI templates for the current gallery that match every UI template associated with
/// the template gallery, creating any if necessary.
/// </summary>
private void ConfigureUiTemplateTable()
{
using (var repoUiTmpl = new UiTemplateRepository())
{
var ctx = repoUiTmpl.Context;
repoUiTmpl.Load();
// Get the UI templates belonging to the template gallery. We have to do a join here because the data
// model doesn't have a relationship. (Doing so would conflict with the relationship between
// the UITemplateAlbum and Album tables.)
var tmplForTmplGallery = from uiTmpl in ctx.UiTemplates join g in ctx.Galleries on uiTmpl.FKGalleryId equals g.GalleryId where g.IsTemplate select uiTmpl;
// For each UI template, make sure one exists in the gallery
foreach (var uiTmpl in tmplForTmplGallery)
{
if (!repoUiTmpl.Local.Any(ui => ui.TemplateType == uiTmpl.TemplateType && ui.FKGalleryId == GalleryId && ui.Name == uiTmpl.Name))
{
// We need to add a UI template
repoUiTmpl.Add(new UiTemplateDto()
{
TemplateType = uiTmpl.TemplateType,
FKGalleryId = GalleryId,
Name = uiTmpl.Name,
Description = uiTmpl.Description,
HtmlTemplate = uiTmpl.HtmlTemplate,
ScriptTemplate = uiTmpl.ScriptTemplate
});
}
}
repoUiTmpl.Save();
}
}
/// <summary>
/// Persist this UI template object to the data store.
/// </summary>
public void Save()
{
using (var repo = new UiTemplateRepository())
{
repo.Save(this);
}
CacheController.RemoveCache(CacheItem.UiTemplates);
}
/// <summary>
/// Persist this UI template object to the data store.
/// </summary>
public void Save()
{
using (var repo = new UiTemplateRepository())
{
repo.Save(this);
}
Factory.ClearAllCaches();
}
/// <summary>
/// Deletes the UI templates associated with the current gallery.
/// </summary>
private void DeleteUiTemplates()
{
using (var repo = new UiTemplateRepository())
{
foreach (var dto in repo.Where(m => m.FKGalleryId == GalleryId))
{
repo.Delete(dto);
}
repo.Save();
}
}
/// <summary>
/// Permanently delete the current UI template from the data store. This action cannot be undone.
/// </summary>
public void Delete()
{
using (var repo = new UiTemplateRepository())
{
var uiTmplDto = repo.Find(UiTemplateId);
if (uiTmplDto != null)
{
repo.Delete(uiTmplDto);
repo.Save();
}
}
CacheController.RemoveCache(CacheItem.UiTemplates);
}
/// <summary>
/// Permanently delete the current UI template from the data store. This action cannot be undone.
/// </summary>
public void Delete()
{
using (var repo = new UiTemplateRepository())
{
var uiTmplDto = repo.Find(UiTemplateId);
if (uiTmplDto != null)
{
repo.Delete(uiTmplDto);
repo.Save();
}
}
Factory.ClearAllCaches();
}
/// <summary>
/// Update the UITemplate table to work with the new data. We don't have any templates from a previous version, but we have the current ones for 3 in
/// the database, so what we do is find the UI templates that map to the template gallery and update the FKGalleryId value to the template gallery ID
/// in the data we are importing, then we'll delete any UI templates not belonging to the template gallery.
/// </summary>
/// <param name="ds">The DataSet.</param>
/// <param name="dataStore">The data store currently being used for gallery data.</param>
/// <param name="cn">The connection.</param>
/// <param name="tran">The transaction.</param>
private static void MigrateUiTemplates(DataSet ds, ProviderDataStore dataStore, IDbConnection cn, IDbTransaction tran)
{
// Get the template gallery ID for the gallery we'll be importing. At this moment this info is in the dataset because we haven't yet
// imported it into the table.
var tmplGalleryId = Convert.ToInt32(ds.Tables["Gallery"].Select("IsTemplate = true").First()["GalleryId"]);
using (var cmd = cn.CreateCommand())
{
// Get the UI templates belonging to the template gallery. We have to do a join here because the data
// model doesn't have a relationship. (Doing so would conflict with the relationship between
// the UITemplateAlbum and Album tables.)
var uiTmplTableName = Utils.GetSqlName("UiTemplate", dataStore);
using (var repo = new UiTemplateRepository())
{
var ctx = repo.Context;
var tmplForTmplGallery = from uiTmpl in ctx.UiTemplates join g in ctx.Galleries on uiTmpl.FKGalleryId equals g.GalleryId where g.IsTemplate select uiTmpl;
// For each UI template, make sure one exists in the gallery
cmd.Transaction = tran;
foreach (var uiTmpl in tmplForTmplGallery)
{
var sql = String.Format(CultureInfo.InvariantCulture, "UPDATE {0} SET FKGalleryId = {1} WHERE UiTemplateId = {2};", uiTmplTableName, tmplGalleryId, uiTmpl.UiTemplateId);
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
}
using (var cmdDr = cn.CreateCommand())
{
cmdDr.Transaction = tran;
cmdDr.CommandText = String.Format(CultureInfo.InvariantCulture, "SELECT UiTemplateId FROM {0} WHERE FKGalleryId <> {1};", uiTmplTableName, tmplGalleryId);
using (var dr = cmdDr.ExecuteReader())
{
while (dr != null && dr.Read())
{
var sql = String.Format(CultureInfo.InvariantCulture, "DELETE FROM {0} WHERE UiTemplateId = {1};", uiTmplTableName, dr[0]);
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
}
}
}
}
/// <summary>
/// Persist this UI template object to the data store.
/// </summary>
public void Save()
{
using (var repo = new UiTemplateRepository())
{
repo.Save(this);
}
Factory.ClearAllCaches();
}
/// <summary>
/// Permanently delete the current UI template from the data store. This action cannot be undone.
/// </summary>
public void Delete()
{
using (var repo = new UiTemplateRepository())
{
var uiTmplDto = repo.Find(UiTemplateId);
if (uiTmplDto != null)
{
repo.Delete(uiTmplDto);
repo.Save();
}
}
Factory.ClearAllCaches();
}
/// <summary>
/// Gets a collection of all UI templates from the data store. Returns an empty collection if no
/// items exist.
/// </summary>
/// <returns>Returns a collection of all UI templates from the data store.</returns>
public static IUiTemplateCollection GetUiTemplates()
{
IUiTemplateCollection tmpl = new UiTemplateCollection();
using (var repo = new UiTemplateRepository())
{
foreach (var jDto in repo.GetAll(j => j.TemplateAlbums))
{
IUiTemplate t = new UiTemplate
{
UiTemplateId = jDto.UiTemplateId,
TemplateType = jDto.TemplateType,
GalleryId = jDto.FKGalleryId,
Name = jDto.Name,
Description = jDto.Description,
HtmlTemplate = jDto.HtmlTemplate,
ScriptTemplate = jDto.ScriptTemplate
};
t.RootAlbumIds.AddRange(from r in jDto.TemplateAlbums select r.FKAlbumId);
tmpl.Add(t);
}
}
return tmpl;
}
/// <summary>
/// Deletes the UI templates associated with the current gallery.
/// </summary>
private void DeleteUiTemplates()
{
using (var repo = new UiTemplateRepository())
{
foreach (var dto in repo.Where(m => m.FKGalleryId == GalleryId))
{
repo.Delete(dto);
}
repo.Save();
}
}
/// <summary>
/// Verify there are UI templates for the current gallery that match every UI template associated with
/// the template gallery, creating any if necessary.
/// </summary>
private void ConfigureUiTemplateTable()
{
using (var repoUiTmpl = new UiTemplateRepository())
{
var ctx = repoUiTmpl.Context;
repoUiTmpl.Load();
// Get the UI templates belonging to the template gallery. We have to do a join here because the data
// model doesn't have a relationship. (Doing so would conflict with the relationship between
// the UITemplateAlbum and Album tables.)
var tmplForTmplGallery = from uiTmpl in ctx.UiTemplates join g in ctx.Galleries on uiTmpl.FKGalleryId equals g.GalleryId where g.IsTemplate select uiTmpl;
// For each UI template, make sure one exists in the gallery
foreach (var uiTmpl in tmplForTmplGallery)
{
if (!repoUiTmpl.Local.Any(ui => ui.TemplateType == uiTmpl.TemplateType && ui.FKGalleryId == GalleryId && ui.Name == uiTmpl.Name))
{
// We need to add a UI template
repoUiTmpl.Add(new UiTemplateDto()
{
TemplateType = uiTmpl.TemplateType,
FKGalleryId = GalleryId,
Name = uiTmpl.Name,
Description = uiTmpl.Description,
HtmlTemplate = uiTmpl.HtmlTemplate,
ScriptTemplate = uiTmpl.ScriptTemplate
});
}
}
repoUiTmpl.Save();
}
}
/// <summary>
/// Verify there is a UI template/album mapping for the root album in the current gallery, creating them
/// if necessary.
/// </summary>
/// <param name="rootAlbum">The root album.</param>
private static void ConfigureUiTemplateAlbumTable(AlbumDto rootAlbum)
{
using (var repoUiTmpl = new UiTemplateRepository())
{
using (var repoUiTmplA = new UiTemplateAlbumRepository(repoUiTmpl.Context))
{
// Make sure each template category has at least one template assigned to the root album.
// We do this with a union of two queries:
// 1. For categories where there is at least one album assignment, determine if at least one of
// those assignments is the root album.
// 2. Find categories without any albums at all (this is necessary because the SelectMany() in the first
// query won't return any categories that don't have related records in the template/album table).
var dtos = repoUiTmpl.Where(t => t.FKGalleryId == rootAlbum.FKGalleryId)
.SelectMany(t => t.TemplateAlbums, (t, tt) => new { t.TemplateType, tt.FKAlbumId })
.GroupBy(t => t.TemplateType)
.Where(t => t.All(ta => ta.FKAlbumId != rootAlbum.AlbumId))
.Select(t => t.Key)
.Union(repoUiTmpl.Where(t => t.FKGalleryId == rootAlbum.FKGalleryId).GroupBy(t => t.TemplateType).Where(t => t.All(t2 => !t2.TemplateAlbums.Any())).Select(t => t.Key))
;
foreach (var dto in dtos)
{
// We have a template type without a root album. Find the default template and assign that one.
var dto1 = dto;
repoUiTmplA.Add(new UiTemplateAlbumDto()
{
FKUiTemplateId = repoUiTmpl.Where(t => t.FKGalleryId == rootAlbum.FKGalleryId && t.TemplateType == dto1 && t.Name.Equals("default", StringComparison.OrdinalIgnoreCase)).First().UiTemplateId,
FKAlbumId = rootAlbum.AlbumId
});
}
repoUiTmplA.Save();
}
}
}
