public List<Models.Title> GetAll()
{
using (var db = new TitlesEntities())
{
List<Models.Title> titles = (from t in db.Titles
select new Models.Title
{
TitleID = t.TitleId,
TitleName = t.TitleName,
ReleaseYear = t.ReleaseYear,
Genre = t.TitleGenres.FirstOrDefault().Genre.Name
}
).ToList();
return titles;
}
}
public Models.Title Get(int id)
{
using (var db = new TitlesEntities())
{
var dbTitle = db.Titles.FirstOrDefault(t => t.TitleId == id);
Models.Title title = new Models.Title
{
TitleName = dbTitle.TitleName,
ReleaseYear = dbTitle.ReleaseYear,
Genre = dbTitle.TitleGenres.FirstOrDefault().Genre.Name,
StoryLine = dbTitle.StoryLines.FirstOrDefault().Description,
Participants = dbTitle.TitleParticipants.Select(p => p.Participant.Name).ToList(),
Awards = dbTitle.Awards.Select(a => a.Award1 + " (" + a.AwardYear + ")").ToList()
};
return title;
}
}