public async Task <IActionResult> Get() { var limit = 6; var moviesInThaters = await context.Movies .Where(x => x.InTheaters == true) .Take(limit) .OrderBy(x => x.ReleaseDate) .ToListAsync(); var today = DateTime.Today; var upcomingReleases = await context.Movies .Where(x => x.InTheaters == false) .Take(limit) .OrderBy(x => x.ReleaseDate) .ToListAsync(); var response = new IndexPageDTO { InTheaters = moviesInThaters, UpcomingReleases = upcomingReleases }; return(Ok(response)); }
public async Task <IndexPageDTO> GetIndexPageDTO() { var userId = await authenticationStateService.GetCurrentUserId(); var limit = 6; var moviesInTheaters = await context.Movies .Where(x => x.InTheater).Take(limit) .OrderByDescending(x => x.ReleaseDate) .ToListAsync(); var todaysDate = DateTime.Today; var upcomingReleases = await context.Movies .Where(x => x.ReleaseDate > todaysDate) .OrderBy(x => x.ReleaseDate).Take(limit) .ToListAsync(); var response = new IndexPageDTO(); response.Intheaters = moviesInTheaters; response.UpcomingReleases = upcomingReleases; return(response); }
public async Task <IndexPageDTO> GetIndexPageDTO(string userEmail) { if (userEmail == null) { return(null); } var personalQuestionnaires = await _context.Questionnaire .Where(x => x.AuthorEmail == userEmail) .Include(q => q.ReceiverQuestionnaires) .OrderByDescending(x => x.LatestUpdateDate) .AsNoTracking() .ToListAsync(); var receivedQuestionnaires = await _context.ReceiverQuestionnaire .Include(rq => rq.Questionnaire) .Where(x => x.ReceiverEmail == userEmail) .Where(x => x.Questionnaire.HasStarted == true) .AsNoTracking() .ToListAsync(); var response = new IndexPageDTO { PersonalQuestionnaires = personalQuestionnaires, ReceivedQuestionnaires = receivedQuestionnaires.Select(q => q.Questionnaire).OrderByDescending(q => q.LatestUpdateDate).ToList() }; return(response); }
public async Task <IndexPageDTO> GetIndexPageDTO() { var limit = 6; var moviesInTheaters = await context.Movies .Where(x => x.InTheaters).Take(limit) .OrderByDescending(x => x.ReleaseDate) .AsNoTracking() .ToListAsync(); var todaysDate = DateTime.Today; var upcomingReleases = await context.Movies .Where(x => x.ReleaseDate > todaysDate) .OrderBy(x => x.ReleaseDate).Take(limit) .AsNoTracking() .ToListAsync(); var response = new IndexPageDTO(); response.Intheaters = moviesInTheaters; response.UpcomingReleases = upcomingReleases; return(response); }
public async Task <ActionResult <IndexPageDTO> > Get() { var moviesInTheaters = await context.Movies.Where(x => x.InTheaters).OrderByDescending(x => x.ReleaseDate).ToListAsync(); var todayDate = DateTime.Today; var upcomingReleases = await context.Movies.Where(x => x.ReleaseDate > todayDate).OrderByDescending(x => x.ReleaseDate).ToListAsync(); var response = new IndexPageDTO(); response.InTheaters = moviesInTheaters; response.UpcomingReleases = upcomingReleases; return(response); }
public async Task <ActionResult <IndexPageDTO> > Get() { int limit = 6; var completeСlass = await _context.Rooms.Where(x => x.CompleteСlass) .Take(limit).OrderByDescending(x => x.EndOfTheSchoolYear).ToListAsync(); var upcomingClass = await _context.Rooms.Where(x => x.CompleteСlass != true) .OrderBy(x => x.StartOfTheSchoolYear).Take(limit).ToListAsync(); var response = new IndexPageDTO(); response.CompleteСlass = completeСlass; response.UpcomingClass = upcomingClass; return(response); }
public async Task <ActionResult <IndexPageDTO> > Get() { var limit = 5; //there are total 15 teams per conference = 3 pages var easternTeam = await _dbContext.Teams .Where(x => x.EasternConference).Take(limit) .OrderByDescending(x => x.TeamName).ToListAsync(); var westernTeam = await _dbContext.Teams .Where(x => x.WesternConference).Take(limit) .OrderByDescending(x => x.TeamName).ToListAsync(); var response = new IndexPageDTO(); response.EasternConference = easternTeam; response.WesternConference = westernTeam; return(response); //response is of type T = IndexPageDTO }
public async Task <ActionResult <IndexPageDTO> > Get() { int recordsLimit = 6; var moviesInTheater = await dbcontext.MoviesRecords .Where(x => x.InTheaters).Take(recordsLimit) .OrderByDescending(x => x.ReleaseDate) .ToListAsync(); var upcomingReleases = await dbcontext.MoviesRecords .Where(x => x.ReleaseDate > DateTime.Today) .OrderBy(x => x.ReleaseDate).Take(recordsLimit) .ToListAsync(); var responseObject = new IndexPageDTO(); responseObject.InTheathers = moviesInTheater; responseObject.UpcomingReleases = upcomingReleases; return(responseObject); }
public async Task <ActionResult <IndexPageDTO> > Get() { var limit = 400; var listelenecekKitaplar = await context.Kitaplar .Where(x => x.KitapListele).Take(limit) .OrderByDescending(x => x.YayinTarihi) .ToListAsync(); var todaysDate = DateTime.Today; var upcomingReleases = await context.Kitaplar .Where(x => x.YayinTarihi > todaysDate) .OrderBy(x => x.YayinTarihi).Take(limit) .ToListAsync(); var response = new IndexPageDTO(); response.Kitaplistele = listelenecekKitaplar; return(response); }
public async Task <ActionResult <IndexPageDTO> > Get() { int limit = 6; var moviesInTheaters = await _dbContext.Movies .Where(x => x.InTheaters).Take(limit) .OrderByDescending(x => x.ReleaseDate) .ToListAsync(); var todaysDate = DateTime.Today; var upcomingReleases = await _dbContext.Movies .Where(x => x.ReleaseDate > todaysDate) .OrderBy(x => x.ReleaseDate).Take(limit) .ToListAsync(); var response = new IndexPageDTO() { InTheaters = moviesInTheaters, UpcomingReleases = upcomingReleases }; return(response); }