public void UpdateLiteraryKinds(long projectId, BookData bookData)
{
if (bookData.LiteraryKinds == null)
{
return;
}
var dbKindList = m_catalogValueRepository.GetLiteraryKindList();
var project = m_metadataRepository.GetAdditionalProjectMetadata(projectId, false, false, true, false, false, false, false);
foreach (var newKindName in bookData.LiteraryKinds)
{
var dbKind = dbKindList.FirstOrDefault(x => x.Name == newKindName);
// Create new Literary Kind
if (dbKind == null)
{
dbKind = new LiteraryKind
{
Name = newKindName
};
m_catalogValueRepository.Create(dbKind);
dbKindList.Add(dbKind);
}
// Assign Literary Kind to project
if (project.LiteraryKinds.All(x => x.Id != dbKind.Id))
{
project.LiteraryKinds.Add(dbKind);
}
}
m_catalogValueRepository.Update(project);
}
public virtual BookVersion GetBookVersionDetailByBookId(long bookId)
{
using (var session = GetSession())
{
Book bookAlias = null;
BookVersion bookVersionAlias = null;
Responsible responsibleAlias = null;
ResponsibleType responsibleTypeAlias = null;
LiteraryOriginal literaryOriginalAlias = null;
LiteraryKind literaryKindAlias = null;
LiteraryGenre genreAlias = null;
var query = session.QueryOver(() => bookVersionAlias)
.JoinAlias(x => x.Book, () => bookAlias)
.Where(() => bookAlias.LastVersion.Id == bookVersionAlias.Id)
.And(x => bookAlias.Id == bookId);
var futureResult = query
.Fetch(x => x.Book).Eager
.Fetch(x => x.Publisher).Eager
.Fetch(x => x.DefaultBookType).Eager
.FutureValue <BookVersion>();
session.QueryOver(() => bookVersionAlias)
.JoinAlias(x => x.Book, () => bookAlias)
.Where(() => bookAlias.LastVersion.Id == bookVersionAlias.Id)
.And(x => bookAlias.Id == bookId)
.Fetch(x => x.ManuscriptDescriptions).Eager
.FutureValue <BookVersion>();
session.QueryOver(() => bookVersionAlias)
.JoinAlias(x => x.Book, () => bookAlias)
.Where(() => bookAlias.LastVersion.Id == bookVersionAlias.Id)
.And(x => bookAlias.Id == bookId)
.Fetch(x => x.Authors).Eager
.FutureValue <BookVersion>();
session.QueryOver(() => bookVersionAlias)
.JoinAlias(x => x.Book, () => bookAlias)
.Where(() => bookAlias.LastVersion.Id == bookVersionAlias.Id)
.And(x => bookAlias.Id == bookId)
.Fetch(x => x.Keywords).Eager
.FutureValue <BookVersion>();
session.QueryOver(() => bookVersionAlias)
.JoinAlias(x => x.Book, () => bookAlias)
.Where(() => bookAlias.LastVersion.Id == bookVersionAlias.Id)
.And(x => bookAlias.Id == bookId)
.Fetch(x => x.FullBookRecordings).Eager
.FutureValue <BookVersion>();
session.QueryOver(() => bookVersionAlias)
.JoinAlias(x => x.Book, () => bookAlias)
.Where(() => bookAlias.LastVersion.Id == bookVersionAlias.Id)
.And(x => bookAlias.Id == bookId)
.Left.JoinAlias(() => bookVersionAlias.Responsibles, () => responsibleAlias)
.Left.JoinAlias(() => responsibleAlias.ResponsibleType, () => responsibleTypeAlias)
.FutureValue <BookVersion>();
session.QueryOver(() => bookVersionAlias)
.JoinAlias(x => x.Book, () => bookAlias)
.Where(() => bookAlias.LastVersion.Id == bookVersionAlias.Id)
.And(x => bookAlias.Id == bookId)
.Left.JoinAlias(() => bookVersionAlias.LiteraryOriginals, () => literaryOriginalAlias)
.Fetch(x => x.LiteraryOriginals).Eager
.FutureValue <BookVersion>();
session.QueryOver(() => bookVersionAlias)
.JoinAlias(x => x.Book, () => bookAlias)
.Where(() => bookAlias.LastVersion.Id == bookVersionAlias.Id)
.And(x => bookAlias.Id == bookId)
.Left.JoinAlias(() => bookVersionAlias.LiteraryKinds, () => literaryKindAlias)
.Fetch(x => x.LiteraryKinds).Eager
.FutureValue <BookVersion>();
session.QueryOver(() => bookVersionAlias)
.JoinAlias(x => x.Book, () => bookAlias)
.Where(() => bookAlias.LastVersion.Id == bookVersionAlias.Id)
.And(x => bookAlias.Id == bookId)
.Left.JoinAlias(() => bookVersionAlias.LiteraryGenres, () => genreAlias)
.Fetch(x => x.LiteraryGenres).Eager
.FutureValue <BookVersion>();
var result = futureResult.Value;
return(result);
}
}
