Ejemplo n.º 1
0
        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));
        }
Ejemplo n.º 2
0
        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);
        }
Ejemplo n.º 3
0
        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);
        }
Ejemplo n.º 4
0
        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);
        }
Ejemplo n.º 7
0
        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
        }
Ejemplo n.º 8
0
        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);
        }
Ejemplo n.º 9
0
        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);
        }