public List <MyLibraryViewModel> getListMyLibrary()
{
var db = new eReaderNoLoginContext();
try
{
var list = (from l in db.Level
where l.Deleted == 0
orderby l.Priority ascending
select new MyLibraryViewModel
{
Name = l.Name,
ListTheme = (List <ThemeLevelViewModel>)l.Theme.Where(m => m.Deleted == 0).Select(m => new ThemeLevelViewModel {
Id = m.Id,
Name = m.Name,
Image = Convert.ToBase64String(m.ImageFile)
}).ToList()
}).ToList();
return(list);
}
catch (Exception e)
{
//LogBasic.Error("MyLibraryQuery.GetListMyLibrary", e);
return(null);
}
finally
{
db.Dispose();
}
}
public List <PageViewModel> getPageInTheme(int idTheme)
{
var db = new eReaderNoLoginContext();
try
{
var list = (from p in db.Page
join t in db.Theme on p.IdTheme equals t.Id
where p.Deleted == 0 && p.IdTheme == idTheme
orderby p.PageIndex ascending
select new PageViewModel
{
Id = p.Id,
Image = Convert.ToBase64String(p.ImageFile),
PageIndex = p.PageIndex,
ListSentence = (List <SentenceViewModel>)p.SentenceInPage.Select(m => new SentenceViewModel()
{
IdSentence = m.Id,
SoundFile = Convert.ToBase64String(m.SoundFile)
}).ToList()
}).ToList();
return(list);
}
catch (Exception e)
{
//LogBasic.Error("PageQuery.GetPageInTheme", e);
return(null);
}
finally
{
db.Dispose();
}
}