public async Task <IEnumerable <WatchALotFilmViewModel> > GetFilmsInTag(string slug)
{
var tagId = (await _context.Tag.SingleAsync(p => p.Slug == slug)).ID;
var listFilmInTag = await _context.FilmTag
.Where(p => p.TagID == tagId)
.ToListAsync();
List <WatchALotFilmViewModel> model = new List <WatchALotFilmViewModel>(listFilmInTag.Capacity - 1);
foreach (var item in listFilmInTag)
{
var film = await _context.Film
.Include(p => p.Image)
.SingleOrDefaultAsync(p => p.ID == item.FilmID);
if (film != null)
{
WatchALotFilmViewModel tempItem = new WatchALotFilmViewModel(film.Image);
tempItem.Title = film.Title;
tempItem.OrtherTitle = film.Title;
tempItem.Watch = film.Watch;
tempItem.Slug = film.Slug;
tempItem.Info = film.Info;
model.Add(tempItem);
}
}
return(model);
}
public async Task <IEnumerable <WatchALotFilmViewModel> > GetSearchFilms(string search)
{
try
{
var listFilmDB = await _context.Film.Include(f => f.Image)
.Where(p => p.Approved == "A" && !p.IsProposed && p.Title.Contains(search))
.OrderByDescending(post => post.Watch).ToListAsync();
if (listFilmDB == null)
{
listFilmDB = await _context.Film.Include(f => f.Image)
.Where(p => p.Approved == "A" && !p.IsProposed && p.OrtherTitle.Contains(search))
.OrderByDescending(post => post.Watch).ToListAsync();
}
int leng = listFilmDB.Capacity;
List <WatchALotFilmViewModel> model = new List <WatchALotFilmViewModel>(leng);
foreach (var item in listFilmDB)
{
WatchALotFilmViewModel tempItem = new WatchALotFilmViewModel(item.Image);
tempItem.Title = item.Title;
tempItem.OrtherTitle = item.Title;
tempItem.Watch = item.Watch;
tempItem.Slug = item.Slug;
tempItem.Info = item.Info;
model.Add(tempItem);
}
return(model);
}
catch (Exception e)
{
_logger.LogError(e.StackTrace, null);
return(null);
}
}
public async Task <IEnumerable <WatchALotFilmViewModel> > GetWatchALotFilm()
{
var listFilmDB = await _context.Film.Include(f => f.Image)
.Where(p => p.Approved == "A" && !p.IsProposed)
.OrderByDescending(post => post.Watch).ToListAsync();
int leng = listFilmDB.Capacity;
List <WatchALotFilmViewModel> model = new List <WatchALotFilmViewModel>(leng);
foreach (var item in listFilmDB)
{
WatchALotFilmViewModel tempItem = new WatchALotFilmViewModel(item.Image);
tempItem.Title = item.Title;
tempItem.OrtherTitle = item.Title;
tempItem.Watch = item.Watch;
tempItem.Slug = item.Slug;
tempItem.Info = item.Info;
model.Add(tempItem);
}
return(model);
}
