public IEnumerable <Entity.detail> GetDetail(int id)
{
IEnumerable <Entity.detail> records = null;
using (Access.TitlesEntities db = new Access.TitlesEntities())
{
records = db.Titles.Where(w => w.TitleId == id).ToList().Select(record => new Entity.detail
{
movie = new Entity.title
{
id = record.TitleId,
name = record.TitleName,
processedDateTime = record.ProcessedDateTimeUTC,
releaseYear = record.ReleaseYear,
sortable = record.TitleNameSortable,
typeId = record.TitleTypeId
},
awards = getAwards(record.Awards),
genre = getGenre(record.TitleGenres),
description = getDescription(record.StoryLines),
otherNames = getOtherNames(record.OtherNames),
participiants = getParticipiants(record.TitleParticipants)
}).ToList();
}
return(records);
}
public IEnumerable <Entity.title> GetList(string keyword)
{
IEnumerable <Entity.title> records = null;
using (Access.TitlesEntities db = new Access.TitlesEntities())
{
IEnumerable <Access.Title> result = db.Titles.AsEnumerable();
if (!string.IsNullOrEmpty(keyword))
{
result = result.Where(w => w.TitleName.ToLower().Contains(keyword.ToLower()));
}
records = result.OrderBy(o => o.TitleName).Select(record => new Entity.title
{
id = record.TitleId,
name = record.TitleName,
processedDateTime = record.ProcessedDateTimeUTC,
releaseYear = record.ReleaseYear,
sortable = record.TitleNameSortable,
typeId = record.TitleTypeId
}).ToList();
}
return(records);
}