public void CleanUpExistingRecords()
{
using (NemeStatsDbContext dbContext = new NemeStatsDbContext())
{
using (NemeStatsDataContext dataContext = new NemeStatsDataContext(dbContext, new SecuredEntityValidatorFactory()))
{
var games = dataContext.GetQueryable <GameDefinition>()
.Where(game => game.BoardGameGeekGameDefinitionId == null)
.ToList();
var bggSearcher = new BoardGameGeekClient(new ApiDownloaderService());
int updateCount = 0;
foreach (GameDefinition game in games)
{
var bggResults = bggSearcher.SearchBoardGames(game.Name.Trim(), true);
if (bggResults.Count() == 1)
{
game.BoardGameGeekGameDefinitionId = bggResults.First().BoardGameId;
ApplicationUser user = new ApplicationUser
{
CurrentGamingGroupId = game.GamingGroupId
};
dataContext.Save(game, user);
dataContext.CommitAllChanges();
Console.WriteLine(game.Name + " had exactly one match and was updated.");
updateCount++;
}
}
Console.WriteLine("Updated " + updateCount + " records.");
}
}
}
public void ItGetsResultsForExistingGameNames()
{
using (NemeStatsDbContext dbContext = new NemeStatsDbContext())
{
using (NemeStatsDataContext dataContext = new NemeStatsDataContext())
{
//gets a distinct list of all game names
//var gameNames2 = dataContext.GetQueryable<GameDefinition>()
// .GroupBy(game => game.Name)
// .Select(game => game.FirstOrDefault())
// .ToList();
var gameNames = new List <string>
{
"7 Wonders",
"Citadels",
"Cosmic encounter ",
"Coup",
"Dead of winter",
"Dominion",
"Five Tribes",
"Samurai Sword",
"Suburbia",
"Agricola",
"Arkham Horror",
"Bang!",
"Carcassonne",
"Castle Ravenloft",
"Race For The Galaxy",
"Settlers of Catan",
"Shadows of Brimstone",
"Sushi Go!",
"Twilight Imperium",
"Apples to Apples Kids",
"At the Gates of Loyang",
"Avalon",
"Boggle",
"Bohnanza",
"Carson City",
"Caverna",
"Chess",
"Cinque Terre",
"Clue",
"Coin Age",
"Cranium",
"Cranium Zigity",
"Cribbage",
"Cthulhu Gloom",
"Dominoes",
"Dungeon Fighter",
"Dungeon Petz",
"Dungeon Roll",
"Dutch Blitz",
"Eight Minute Empire",
"Famiglia",
"Fearsome Floors",
"Forbidden Island",
"Formula D",
"Freedom: The Underground Railroad",
"Galaxy Trucker",
"Game of thrones boardgame",
"Guillotine",
"Hive",
"Jaipur",
"Kaosball",
"Kemet",
"King of Tokyo",
"Legend of Drizzt",
"Legends of Andor",
"Lewis & Clark",
"Lords of Waterdeep",
"Love Letter",
"Machi Koro",
"Mage Knight Board Game",
"Mage Knight Dungeons",
"Magic the Gathering",
"Magic: The Gathering",
"Mascarade",
"Merchants & Marauders",
"Nations",
"Nuts",
"Once Upon a Time",
"Pairs (Calamity Variant)",
"Pandemic",
"Pathfinder ACG",
"Pirate Fluxx",
"Puerto Rico",
"Quantum",
"Quiddler",
"Quoridor",
"Race for the galaxy",
"Rampage",
"Risk: The Lord of the Rings Trilogy Edition",
"Risk: The Walking Dead",
"RoboRally",
"Rummikub",
"Saboteur",
"Saboteur 2",
"Samurai Swords",
"SanGuoSha: Legends of the Three Kingdoms",
"Scattergories",
"Scotland yard",
"Scrabble",
"Settlers of America: Trails to Rails",
"Settlers of the Stone Age",
"Seven Wonders",
"Small World",
"Spartacus",
"Splendor",
"Star Realms",
"Star Trek Battle Force",
"Star Trek: Fleet Captains",
"Star Wars: X-Wing Miniatures Game",
"Survive!",
"Taboo",
"Tales of the Arabian Nights",
"The Little Prince",
"The Princes of Florence",
"The Resistance",
"Thunderstone Advance: Towers of Ruin",
"Ticket to Ride",
"Ticket to Ride Europe",
"Tiny Epic Kingdoms",
"Troyes",
"tzolkin",
"Warhammer 40K",
"Wits & Wagers",
"Wrath of Ashardalon",
"Zombicide"
};
var bggSearcher = new BoardGameGeekClient(new ApiDownloaderService());
foreach (string gameName in gameNames)
{
var results = bggSearcher.SearchBoardGames(gameName, true);
if (results.Count() != 1)
{
Console.WriteLine(gameName + " has " + results.Count() + " results.");
}
}
}
}
}