public JsonResult GetTitle(int id)
{
Title model = new Title();
using (var manager = new TitlesManager())
{
model = manager.Get(id);
}
return this.Json(model, JsonRequestBehavior.AllowGet);
}
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;
}
}
