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; } }