public async Task <IEnumerable <Title> > GetTitlesAsync() { using (var db = new TitlesContext()) { return(await db.Title.ToListAsync()); } }
public async Task <IEnumerable <TitleGenreDetails> > GetGenresByTitleIdAsync(int titleId) { using (var db = new TitlesContext()) { var query = from tg in db.TitleGenres join g in db.Genres on tg.GenreId equals g.Id where tg.TitleId == titleId select new TitleGenreDetails { Id = tg.Id, Name = tg.Genre.Name }; return(await query.ToListAsync()); } }
public async Task <IEnumerable <StoryLine> > GetStoryLineByTitleIdAsync(int titleId) { using (var db = new TitlesContext()) { var results = await db.StoryLines.Where(s => s.TitleId == titleId).Select(s => new StoryLine { Id = s.Id, TitleId = s.TitleId, Type = s.Type, Language = s.Language, Description = s.Description }).ToListAsync(); return(results); } }
public async Task <IEnumerable <Participant> > GetPatricipantByTitleIdAsync(int titleId) { using (var db = new TitlesContext()) { var query = from tp in db.TitleParticipants join p in db.Participants on tp.Id equals p.Id where tp.TitleId == titleId select new Participant { Id = p.Id, Name = p.Name, ParticipantType = p.ParticipantType }; return(await query.ToListAsync()); } }
public async Task <IEnumerable <Award> > GetAwardsByTitleIdAsync(int titleId) { using (var db = new TitlesContext()) { var results = await db.Awards.Where(a => a.TitleId == titleId).Select(a => new Award { Id = a.Id, TitleId = a.TitleId, Award1 = a.Award1, AwardWon = a.AwardWon, AwardYear = a.AwardYear, AwardCompany = a.AwardCompany }).ToListAsync(); return(results); } }
public async Task <IEnumerable <OtherName> > GetOtherTitleByTitleIdAsync(int titleId) { using (var db = new TitlesContext()) { var results = await db.OtherNames.Where(o => o.TitleId == titleId).Select(o => new OtherName { TitleId = o.TitleId, TitleNameLanguage = o.TitleNameLanguage, TitleNameType = o.TitleNameType, TitleNameSortable = o.TitleNameSortable, TitleName = o.TitleName, Id = o.Id }).OrderBy(o => o.TitleNameSortable).ToListAsync(); return(results); } }
public Handler(TitlesContext context) { _context = context; }
public TitlesController(TitlesContext context) { _context = context; }
public async Task <IEnumerable <Title> > SearchByNameAsyc(string searchString) { using (var db = new TitlesContext()) { var titles = await db.Title.Where(t => EF.Functions.Like(t.TitleName, "%" + searchString + "%")).Select(t => new Title { TitleId = t.TitleId, TitleName = t.TitleName, TitleNameSortable = t.TitleNameSortable, TitleTypeId = t.TitleTypeId, ReleaseYear = t.ReleaseYear, ProcessedDateTimeUtc = t.ProcessedDateTimeUtc }).OrderBy(t => t.TitleNameSortable).ToListAsync(); var ids = titles.Select(t => t.TitleId).ToList(); if (ids.Any()) { foreach (var id in ids) { var participants = from tp in db.TitleParticipants join p in db.Participants on tp.Id equals p.Id where tp.TitleId == id select new TitleParticipant { Id = tp.Id, TitleId = tp.TitleId, ParticipantId = tp.ParticipantId, IsKey = tp.IsKey, RoleType = tp.RoleType, IsOnScreen = tp.IsOnScreen, Name = tp.Participant.Name }; var title = titles.Where(x => x.TitleId == id).FirstOrDefault(); foreach (var participant in participants) { title.TitleParticipants.Add(participant); } var titleGenres = from tg in db.TitleGenres join g in db.Genres on tg.GenreId equals g.Id where tg.TitleId == id select new TitleGenre { Id = tg.Id, Name = g.Name, GenreId = tg.GenreId }; foreach (var titleGenre in titleGenres) { title.TitleGenres.Add(titleGenre); } var storyLines = await db.StoryLines.Where(s => s.TitleId == id).Select(s => new StoryLine { TitleId = s.TitleId, Type = s.Type, Language = s.Language, Description = s.Description }).ToListAsync(); foreach (var storyLine in storyLines) { title.StoryLines.Add(storyLine); } var awards = await db.Awards.Where(a => a.TitleId == id).Select(a => new Award { TitleId = a.TitleId, AwardWon = a.AwardWon, AwardYear = a.AwardYear, AwardCompany = a.AwardCompany, Award1 = a.Award1 }).ToListAsync(); foreach (var award in awards) { title.Awards.Add(award); } } } return(titles); } }