HomeController.cs

using System;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using CommunityWeb.Models;
using Microsoft.Extensions.Options;
using CommunityWeb.Util;
using Microsoft.Azure.Documents.Client;
using System.Collections.Generic;
using Microsoft.Azure.Documents.Linq;

namespace CommunityWeb.Controllers
{
    public class HomeController : Controller
    {
        private readonly AppSettings _appSettings;

        public HomeController(IOptions<AppSettings> appSettings)
        {
            _appSettings = appSettings.Value;
        }

        public async Task<IActionResult> Index()
        {
            var meetupEvents = (await JsonParser<MeetupEvent>.RetrieveJsonDataFromUrlAsync(
                "https://api.meetup.com/NET-Developers-SG/events?key=" + _appSettings.MeetupWebApiKey + "&scroll=future_or_past"))
		.OrderByDescending(m => m.HappensAt)
		.Take(2);

	    bool isNoUpcomingEvent = true;
	    
            foreach (var meetupEvent in meetupEvents)
            {
                long unixDate = meetupEvent.HappensAt;
                DateTime start = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc);
                meetupEvent.HappensAtDateTime = start.AddMilliseconds(unixDate).ToLocalTime();
		
		isNoUpcomingEvent = isNoUpcomingEvent && meetupEvent.HappensAtDateTime < DateTime.Now;
            }
	    
	    if (isNoUpcomingEvent && meetupEvents.Count() > 1) 
	    {
	        meetupEvents = meetupEvents.Take(1);
	    }

            ViewBag.MeetupEvents = meetupEvents;

            var newDocumentDbConnector = new DocumentDbConnector(_appSettings.DotnetsgDocumentDbEndpoint, _appSettings.DotnetsgDocumentDbPrimaryKey,
                _appSettings.DocumentDbDatabaseFeeds, _appSettings.DocumentDbCollectionFacebookGroupFeeds);

            var query = newDocumentDbConnector.DocumentClient.CreateDocumentQuery<FacebookGroupFeed>
		        (UriFactory.CreateDocumentCollectionUri(_appSettings.DocumentDbDatabaseFeeds, _appSettings.DocumentDbCollectionFacebookGroupFeeds)).AsDocumentQuery();
            var results = new List<FacebookGroupFeed>();
            while (query.HasMoreResults)
            {
                results.AddRange(await query.ExecuteNextAsync<FacebookGroupFeed>());
            }
            ViewBag.FacebookGroupFeeds = results.Count() > 0 ? results.ToList()[0].Feeds.OrderByDescending(x => x.UpdatedTime).ToList() : null;

            return View();
        }

        public IActionResult Error()
        {
            return View();
        }
    }
}