public void MOCKFileHandlerDeletePlayer() { var testHandler = new MOCKFileHandler(); testHandler.LoadPlayers(); var testHandlerPlayers = testHandler.GetPlayers(); var testPlayers = TestPlayers(); var DeletePlayer = new Player("john", "smith", 24, "", "40404040", ""); var playerDeleted = 0; DeletePlayer.SetP_ID(playerDeleted); testPlayers.Remove(playerDeleted); testHandler.DeletePlayer(DeletePlayer.GetP_ID()); foreach (var item in testPlayers) { Assert.AreEqual(item.Value.Details(), testHandlerPlayers[item.Key].Details()); } }
public void UpdatePlayer(Player editPlayer) { players[editPlayer.GetP_ID()] = editPlayer; }
public void UpdatePlayer(Player editPlayer) { players[editPlayer.GetP_ID()] = editPlayer; var updatePlayer = SqlQueries.UpdatePlayer(editPlayer.GetP_ID(), editPlayer.GetFName(), editPlayer.GetLName(), editPlayer.GetAge(), editPlayer.GetGuardian(), editPlayer.GetContact(), editPlayer.GetMedical()); var updatePlayerCommand = new SQLiteCommand(updatePlayer, dbConnection); updatePlayerCommand.ExecuteNonQuery(); }
public void InsertPlayer(Player newPlayer) { newPlayer.SetP_ID(playerCounter); players.Add(playerCounter++, newPlayer); var insertPlayer = SqlQueries.InsertPlayer(newPlayer.GetP_ID(), newPlayer.GetFName(), newPlayer.GetLName(), newPlayer.GetAge(), newPlayer.GetGuardian(), newPlayer.GetContact(), newPlayer.GetMedical()); var insertPlayerCommand = new SQLiteCommand(insertPlayer, dbConnection); insertPlayerCommand.ExecuteNonQuery(); }