public TvSeries Get(int season)
{
try
{
Logger.Trace("Begin -> Get");
Logger.DebugFormat("Parameters [season={0}]", season);
using (IGraphClient client = DatabaseFactory.CreateReader())
{
TvSeries result = client.Cypher
.Match(
"(series:TvSeries {name: {name} })")
.WithParams(new Dictionary <string, object>
{
{ "name", string.Format("Season {0}", season) }
})
.Return(series => series.As <TvSeries>())
.OrderBy(new[] { "series.name" })
.Results.FirstOrDefault();
Logger.Trace("End -> Get");
return(result);
}
}
catch (Exception err)
{
Logger.Error("Error in Get", err);
throw;
}
}
public IEnumerable <Character> ListCharactersInSeason(int season)
{
try
{
Logger.Trace("Begin -> ListCharactersInSeries");
Logger.DebugFormat("Parameters [season={0}]", season);
using (IGraphClient client = DatabaseFactory.CreateReader())
{
IEnumerable <Character> results = client.Cypher
.Match("(series:TvSeries {name: {name} })-[APPEAREDIN]-(character:Character)")
.WithParams(new Dictionary <string, object>
{
{ "name", string.Format("Season {0}", season) }
})
.Return(character => character.As <Character>())
.OrderBy(new[] { "character.name" })
.Results;
Logger.Trace("End -> ListCharactersInSeries");
return(results);
}
}
catch (Exception err)
{
Logger.Error("Error in ListCharactersInSeries", err);
throw;
}
}
public IEnumerable <Character> ListCharactersInCulture(string name)
{
try
{
Logger.Trace("Begin -> ListCharactersInCulture");
Logger.DebugFormat("Parameters [name={0}]", name);
using (IGraphClient client = DatabaseFactory.CreateReader())
{
IEnumerable <Character> results = client.Cypher
.Match("(culture:Culture {name: {name} })-[MEMBER]-(character:Character)")
.WithParams(new Dictionary <string, object>
{
{ "name", name }
})
.Return(character => character.As <Character>())
.OrderBy(new[] { "character.name" })
.Results;
Logger.Trace("End -> ListCharactersInCulture");
return(results);
}
}
catch (Exception err)
{
Logger.Error("Error in ListCharactersInCulture", err);
throw;
}
}
public IEnumerable <Character> ListCharactersInBook(int bookId)
{
try
{
Logger.Trace("Begin -> ListCharactersInBook");
Logger.DebugFormat("Parameters [bookId={0}]", bookId);
using (IGraphClient client = DatabaseFactory.CreateReader())
{
IEnumerable <Character> results = client.Cypher
.Match("(book:Book {id: {id} })-[APPEARS]-(character:Character)")
.WithParams(new Dictionary <string, object>
{
{ "id", bookId }
})
.Return(character => character.As <Character>())
.OrderBy(new[] { "character.name" })
.Results;
Logger.Trace("End -> ListCharactersInBook");
return(results);
}
}
catch (Exception err)
{
Logger.Error("Error in ListCharactersInBook", err);
throw;
}
}
public Book Get(int bookId)
{
try
{
Logger.Trace("Begin -> Get");
Logger.DebugFormat("Parameters [bookId={0}]", bookId);
using (IGraphClient client = DatabaseFactory.CreateReader())
{
Book result = client.Cypher
.Match(
"(book:Book {id: {id} })")
.WithParams(new Dictionary <string, object>
{
{ "id", bookId }
})
.Return(book => book.As <Book>())
.OrderBy(new[] { "book.id" })
.Results.FirstOrDefault();
Logger.Trace("End -> Get");
return(result);
}
}
catch (Exception err)
{
Logger.Error("Error in Get", err);
throw;
}
}
public IEnumerable <TvSeries> List()
{
try
{
Logger.Trace("Begin -> List");
using (IGraphClient client = DatabaseFactory.CreateReader())
{
IEnumerable <TvSeries> results = client.Cypher
.Match("(series:TvSeries)")
.Return(series => series.As <TvSeries>())
.OrderBy(new[] { "series.name" })
.Results;
Logger.Trace("End -> List");
return(results);
}
}
catch (Exception err)
{
Logger.Error("Error in List", err);
throw;
}
}
public IEnumerable <Culture> List()
{
try
{
Logger.Trace("Begin -> List");
using (IGraphClient client = DatabaseFactory.CreateReader())
{
IEnumerable <Culture> results = client.Cypher
.Match("(culture:Culture)")
.Return(culture => culture.As <Culture>())
.OrderBy(new[] { "culture.name" })
.Results;
Logger.Trace("End -> List");
return(results);
}
}
catch (Exception err)
{
Logger.Error("Error in List", err);
throw;
}
}