public void Setup() { GamingInfo _gi = new GamingInfo() { GameId = 1, GameTitle = "Halo", GameDescription = "Good Game", ReleaseDate = DateTime.Today, GamePlatform = 1, GameCategory = 1, GamePrice = 10 }; _dbContext.GamingInfo.Add(_gi); _dbContext.SaveChanges(); BusinessGames _bg = new BusinessGames() { BusinessId = 1, GameId = 1 }; _dbContext.BusinessGames.Add(_bg); _dbContext.SaveChanges(); GamingPlatform _pl = new GamingPlatform() { PlatformId = 1, PlatformName = "SNES" }; _dbContext.GamingPlatform.Add(_pl); _dbContext.SaveChanges(); GamingCategory _ca = new GamingCategory() { CategoryId = 1, CategoryName = "Puzzle" }; _dbContext.GamingCategory.Add(_ca); _dbContext.SaveChanges(); }
private static async Task ListFinishedCompetitionsFirstWinner(GamingPlatform gamingPlatform, string zipCode) { // Retrieve the winner with the first position for all the finished competitions // that allowed the platform received as an argument // and located in the zipCode received as an argument. var winnersQuery = client.CreateDocumentQuery <Competition>(collectionUri, new FeedOptions() { MaxItemCount = 100, }) .Where(c => (c.Location.ZipCode == zipCode) && (c.Status == CompetitionStatus.Finished) && (c.Platforms.Contains(gamingPlatform))) .Select(c => c.Winners[0]) .AsDocumentQuery(); while (winnersQuery.HasMoreResults) { var winnersQueryResult = await winnersQuery.ExecuteNextAsync <Winner>(); foreach (var winner in winnersQueryResult) { Console.WriteLine($"Nickname: {winner.Player.NickName}, Score: {winner.Score}"); } } }
public void CheckPlatform_InsertId_ReturnName() { var controller = new GameController(_dbContext); string platform = "SNES"; GamingPlatform plat = new GamingPlatform(); plat.PlatformId = 1; string getName = controller.GetGamePlat(plat.PlatformId); Assert.AreEqual(getName, platform); }