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);
}
}
public PerfomanceBuilder WithPlayEntity(PlayEntity play)
{
Play = new Play(play.Name, play.Type);
return(this);
}
