public void Run() { var games = new GameAccessor().GetAll(); var db = new PlayAccessor(); var csv = File.ReadAllLines("GameList.tsv"); for (int i = 1; i < csv.Length; i++) { var line = csv[i]; var cells = line.Split('\t'); var play = new PlayEntity(); play.Date = new DateTime(2014, 12, 31); play.Duration = TimeSpan.FromHours(double.Parse(cells[3], CultureInfo.InvariantCulture)); play.GameId = games.First(p => p.Name == cells[0]).Id; play.PlayerCount = 2; var numberOfOldPlays = int.Parse(cells[2]); for (int x = 0; x < numberOfOldPlays; x++) { db.Create(play); play.Id = Guid.Empty; } } }
public void Run() { var games = new GameAccessor().GetAll(); var db = new PlayAccessor(); var tsv = File.ReadAllLines($"{_year}.tsv"); for (int i = 1; i < tsv.Length; i++) { var line = tsv[i]; var cells = line.Split('\t'); var play = new PlayEntity(); play.Date = DateTime.Parse(cells[0]); play.Duration = TimeSpan.FromHours(double.Parse(cells[2], CultureInfo.InvariantCulture)); var game = games.FirstOrDefault(p => p.Name == cells[1]); if (game == null) { Console.WriteLine($"Couldn't find game {cells[1]}."); continue; } play.GameId = game.Id; play.Comment = cells.Length == 4 ? cells[3] : null; play.PlayerCount = game.SoloMode == SoloMode.None ? 2 : 1; db.Create(play); } }