public IEnumerable<GameEvent> Get(long gameId)
 {
     using (var repository = new GameEventRepository())
     {
         return (from evnt in repository.GetAll()
                 where evnt.GameId == gameId
                 select evnt).OrderBy(evnt => evnt.Timestamp).ToList();
     }
 }
        public void Update()
        {
            // Delete everything
            using (var repository = new TopEventRepository())
            {
                var evnts = (from evnt in repository.GetAll() select evnt).ToList();
                foreach(var evnt in evnts)
                {
                    repository.Delete(evnt);
                }
            }

            // update top points by count
            List<ActivityPoint> topPoints = new List<ActivityPoint>();
            List<GameEvent> topEvents = new List<GameEvent>();
            int skipPoints = 0;

            while (topEvents.Count < 10)
            {
                ActivityPoint point = null;
                GameEvent gameEvent = null;
                using (var repository = new ActivityRepository())
                {
                    point = (from p in repository.DataSet.Include("Game")
                             where p.Game.TweetCount > 0 &&
                             (p.Time < p.Game.HalftimeStart || p.Game.HalftimeEnd < p.Time)
                             select p).OrderByDescending(p => p.TweetCount).Skip(skipPoints).Take(1).First();
                }
                using (var repository = new GameEventRepository())
                {
                    gameEvent = (from evnt in repository.GetAll()
                                 where evnt.GameId == point.GameId
                                 && evnt.Timestamp < point.Time
                                 select evnt).OrderByDescending(evnt => evnt.Timestamp).Take(1).SingleOrDefault();
                }

                if (gameEvent == null
                    || gameEvent.Type == GameEventType.FIRST_HALF_START
                    || gameEvent.Type == GameEventType.FIRST_HALF_END
                    || gameEvent.Type == GameEventType.SECOND_HALF_START
                    || gameEvent.Type == GameEventType.SECOND_HALF_END
                    || topEvents.Where(evnt => evnt.Id == gameEvent.Id).Count() > 0)
                {
                    // this event is already in the list
                    skipPoints++;
                }
                else
                {
                    topEvents.Add(gameEvent);
                    topPoints.Add(point);
                }
            }

            using (var repository = new TopEventRepository())
            {
                for (int i = 0; i < topPoints.Count; i++)
                {
                    TopEvent evnt = new TopEvent()
                    {
                        IsRelativeTop = false,
                        Rank = i + 1,
                        GameId = topPoints[i].GameId,
                        ActivityId = topPoints[i].Id,
                        EventId = topEvents[i].Id
                    };
                    repository.Save(evnt);
                }
            }

            // update top points by percentage
            topPoints = new List<ActivityPoint>();
            topEvents = new List<GameEvent>();
            skipPoints = 0;

            while (topEvents.Count < 10)
            {
                ActivityPoint point = null;
                GameEvent gameEvent = null;
                using (var repository = new ActivityRepository())
                {
                    point = (from p in repository.DataSet.Include("Game")
                             where p.Game.TweetCount > 0 &&
                             (p.Time < p.Game.HalftimeStart || p.Game.HalftimeEnd < p.Time)
                             select p).OrderByDescending(p => (double)p.TweetCount / (double)p.Game.TweetCount).Skip(skipPoints).Take(1).First();
                }
                using (var repository = new GameEventRepository())
                {
                    gameEvent = (from evnt in repository.GetAll()
                                 where evnt.GameId == point.GameId
                                 && evnt.Timestamp < point.Time
                                 select evnt).OrderByDescending(evnt => evnt.Timestamp).Take(1).SingleOrDefault();
                }

                if (gameEvent == null
                    || gameEvent.Type == GameEventType.FIRST_HALF_START
                    || gameEvent.Type == GameEventType.FIRST_HALF_END
                    || gameEvent.Type == GameEventType.SECOND_HALF_START
                    || gameEvent.Type == GameEventType.SECOND_HALF_END
                    || topEvents.Where(evnt => evnt.Id == gameEvent.Id).Count() > 0)
                {
                    // this event is already in the list
                    skipPoints++;
                }
                else
                {
                    topEvents.Add(gameEvent);
                    topPoints.Add(point);
                }
            }

            using (var repository = new TopEventRepository())
            {
                for (int i = 0; i < topPoints.Count; i++)
                {
                    TopEvent evnt = new TopEvent()
                    {
                        IsRelativeTop = true,
                        Rank = i + 1,
                        GameId = topPoints[i].GameId,
                        ActivityId = topPoints[i].Id,
                        EventId = topEvents[i].Id
                    };
                    repository.Save(evnt);
                }
            }
        }