public ActionResult AddAwardAverage(GpcAwardAverage postModel)
        {
            var datastore = new GoogleCloudDatastore("Pogo");

            using (var session = datastore.OpenSession())
            {
                session.Store(postModel);
                session.SaveChanges();
            }

            return new EmptyResult();
        }
        public ActionResult AwardAverages(string id)
        {
            var datastore = new GoogleCloudDatastore("Pogo");

            using (var session = datastore.OpenSession())
            {
                var awards = session.Query<GpcAwardAverage>()
                    .Where(t => t.Company == id)
                    .ToList();

                return Json(awards, JsonRequestBehavior.AllowGet);
            }
        }
        public void WriteStockQuotes()
        {
            var target = new YahooFinance();
            string symbol = "KO";
            DateTime startDate = new DateTime(2014, 1, 1);
            DateTime endDate = new DateTime(2014, 3, 31);

            var results = target.GetHistoricalDailyStockQuotes(symbol, startDate, endDate);

            var datastore = new GoogleCloudDatastore("Pogo");

            using (var session = datastore.OpenSession())
            {
                foreach (var quote in results)
                {
                    session.Store(quote);
                }

                session.SaveChanges();
            }
        }
        public ActionResult StockPrices(string id)
        {
            var datastore = new GoogleCloudDatastore("Pogo");

            string symbol = _symbols[id];

            using (var session = datastore.OpenSession())
            {
                var prices = session.Query<DailyStockQuote>()
                    .Where(t => t.Symbol == symbol)
                    .ToList()
                    .OrderBy(t => t.Date); // GCD is throwing an error when trying to filter and order...

                return Json(prices, JsonRequestBehavior.AllowGet);
            }
        }