public IndexModel(Models.CoreTaskManagerContext context, Data.ApplicationDbContext userContext)
{
_context = context;
_userContext = userContext;
// 一ページに表示する項目の量
_pageSize = 6;
}
public static IQueryable <string> GenerateGenreList(this Models.CoreTaskManagerContext context)
{
var genreQuery = from m in context.Progresses
orderby m.Genre
select m.Genre;
return(genreQuery.Distinct());
}
public static IQueryable <Progress> FilterUsingSearchStrings(this Models.CoreTaskManagerContext context,
string progressGenre, string searchString)
{
var progresses = from p in context.Progresses
select p;
progresses = progresses.OrderByDescending(p => p.RegisteredDateTime);
if (!String.IsNullOrEmpty(searchString))
{
progresses = progresses.Where(p => p.Title.Contains(searchString));
}
if (!String.IsNullOrEmpty(progressGenre))
{
progresses = progresses.Where(x => x.Genre == progressGenre);
}
return(progresses);
}
public IndexModel(Models.CoreTaskManagerContext context)
{
_context = context;
}
