public int CalculateScore() { using (var _gameStorage = new GameStorage("DefaultConnection")) { return(_gameStorage.Sessions.Sum(v => v.Score)); } }
public IEnumerable <GameSession> Find(Guid userId) { using (var _gameStorage = new GameStorage("DefaultConnection")) { return(_gameStorage.Sessions.Include(v => v.Character).Where(v => v.Character.OwnerUserId == userId)); } }
public void AddSession(GameSession session) { using (var _gameStorage = new GameStorage("DefaultConnection")) { _gameStorage.Sessions.Add(session); _gameStorage.SaveChanges(); } }
public IEnumerable <GameSession> FindLastGameSessions(Guid userId, int sessionsCount) { using (var _gameStorage = new GameStorage("DefaultConnection")) { return(_gameStorage.Sessions.Include(v => v.Character) .Where(v => v.Character.OwnerUserId == userId) .OrderByDescending(v => v.StartTime).Take(sessionsCount).ToList()); } }
public void CloseSession(Guid sessionId, int score) { using (var _gameStorage = new GameStorage("DefaultConnection")) { var session = _gameStorage.Sessions.FirstOrDefault(v => v.Id == sessionId); session.EndTime = DateTime.Now; session.Score = score; _gameStorage.SaveChanges(); } }
public CharacterRepositoryEF() { _gameStorage = new GameStorage("DefaultConnection"); }