public IList <UserJournal> FindAll(UserJournalFilter filter)
{
var query = DbContext.UserJournals.Include(x => x.UserProfile);
if (filter.JournalId.HasValue)
{
query = query.Where(x => x.JournalId == filter.JournalId.Value);
}
query = query.Where(x => x.UserProfileId == filter.UserProfileId);
return(query.OrderByDescending(x => x.DateAdded).ToList());
}
public IPagedList <Journal> Search(UserJournalFilter filter)
{
var query = DbContext.UserJournals
.Include(uj => uj.Journal)
.Include(uj => uj.Journal.Publisher)
.Include(uj => uj.Journal.Languages)
.Include(uj => uj.Journal.Subjects)
.Include(uj => uj.UserProfile)
.AsExpandable()
.Where(x => x.UserProfileId == filter.UserProfileId);
return(query.Select(uj => uj.Journal).Search(filter));
}
