public static RosterEntry Add(RosterEntry entry)
{
using (var db = new FFStatsDbContext())
{
db.RosterEntries.Add(entry);
db.SaveChanges();
}
return(entry);
}
public void Setup()
{
entry = new RosterEntry()
{
Id = 1,
PlayerId = 3,
TeamId = 4
};
ctx = new SqlContext();
engine = new RosterEntryEngine(ctx);
}
public void TestInsertRosterEntry()
{
RosterEntry entry = new RosterEntry()
{
Id = 1,
PlayerId = 3,
TeamId = 4
};
repo.Insert(entry);
Assert.IsTrue(ctx.RosterEntries.Any(c => c.Id == 1));
}
public void TestExists()
{
engine.Save(entry);
RosterEntry entry2 = new RosterEntry()
{
Id = 1,
PlayerId = 3,
TeamId = 5
};
Assert.IsTrue(engine.Exists(entry2));
}
public void TestRosterEntyExists()
{
RosterEntry entry = new RosterEntry()
{
Id = 1,
PlayerId = 3,
TeamId = 4
};
repo.Insert(entry);
Assert.IsTrue(repo.Exists(entry));
}
public void TestDeleteRosterEntry()
{
RosterEntry entry = new RosterEntry()
{
Id = 1,
PlayerId = 3,
TeamId = 4
};
repo.Insert(entry);
repo.Delete(entry);
Assert.AreEqual(0, ctx.RosterEntries.Count());
}
public void TestSaveUpdateNoId()
{
engine.Save(entry);
RosterEntry entry2 = new RosterEntry()
{
Id = 0,
PlayerId = 3,
TeamId = 5
};
engine.Save(entry2);
Assert.AreEqual(1, ctx.RosterEntries.Count());
Assert.IsNotNull(ctx.RosterEntries.Where(c => c.Id == 1 && c.TeamId == 5).FirstOrDefault());
Assert.IsNotNull(ctx.Transactions.Where(c => c.NewTeamId == 5 && c.PlayerId == 3 && c.OldTeamId == 4).FirstOrDefault());
}
public void TestRosterEntryNotExists()
{
RosterEntry entry = new RosterEntry()
{
Id = 1,
PlayerId = 3,
TeamId = 4
};
repo.Insert(entry);
RosterEntry entry2 = new RosterEntry()
{
Id = 1,
PlayerId = 4,
TeamId = 5
};
Assert.IsFalse(repo.Exists(entry2));
}
public void TestGetRosterEntries()
{
RosterEntry entry = new RosterEntry()
{
Id = 1,
PlayerId = 3,
TeamId = 4
};
repo.Insert(entry);
RosterEntry entry2 = new RosterEntry()
{
Id = 2,
PlayerId = 4,
TeamId = 5
};
repo.Insert(entry2);
Assert.AreEqual(2, repo.GetRosterEntries().Count());
}
public void TestGetRosterEntry()
{
RosterEntry entry = new RosterEntry()
{
Id = 1,
PlayerId = 3,
TeamId = 4
};
repo.Insert(entry);
RosterEntry entry2 = new RosterEntry()
{
Id = 2,
PlayerId = 4,
TeamId = 5
};
repo.Insert(entry2);
Assert.IsNotNull(repo.GetRosterEntry(2));
}
public void TestUpdateRosterEntry()
{
RosterEntry entry = new RosterEntry()
{
Id = 1,
PlayerId = 3,
TeamId = 4
};
repo.Insert(entry);
RosterEntry entry2 = new RosterEntry()
{
Id = 1,
PlayerId = 3,
TeamId = 5
};
repo.Update(entry2);
Assert.IsTrue(ctx.RosterEntries.Any(c => c.Id == 1 && c.TeamId == 5));
Assert.AreEqual(1, ctx.RosterEntries.Count());
}
static WeekRosters ParseFile(string path)
{
Console.WriteLine($"Parsing: {path}");
// extract year and week from file name
var fileName = Path.GetFileNameWithoutExtension(path);
var fileNameMatch = Regex.Match(fileName, @"(\d{4})-w(\d{1,2})");
var year = int.Parse(fileNameMatch.Groups[1].Value);
var week = int.Parse(fileNameMatch.Groups[2].Value);
var weekRosters = new WeekRosters
{
Year = year,
Week = week,
Rosters = new List <Roster>()
};
var reader = new StreamReader(path);
while (!reader.EndOfStream)
{
var line = reader.ReadLine();
if (TeamNames.Contains(line))
{
var dbTeamName = line;
// renamed teams
if (line == "Hooked on a Thielen")
{
dbTeamName = "Retro Hawks";
}
else if (line == "ImJustHereSoIWontGetHigh")
{
dbTeamName = "Nangijala IF";
}
else if (line == "Wentz Upon A Time")
{
dbTeamName = "Kings of the North";
}
weekRosters.Rosters.Add(new Roster
{
Team = dbTeamName,
Entries = new List <RosterEntry>()
});
}
else if (RosterPositions.Contains(line))
{
var rosterPosStr = (line == "W/R" ? "FLX" : line);
var entry = new RosterEntry
{
RosterPosition = Enum.Parse <Position>(rosterPosStr)
};
var playerLine = reader.ReadLine();
if (playerLine.Contains("--empty--"))
{
continue;
}
if (playerLine.EndsWith("View Videos"))
{
var nextLine = reader.ReadLine();
if (nextLine.Contains("Bye"))
{
entry.IsByeWeek = true;
// status and stat line is on 'next' line
}
else
{
// skip status and stat lines
reader.ReadLine();
reader.ReadLine();
}
}
else if (playerLine.Contains("Bye"))
{
entry.IsByeWeek = true;
// status and stat line is on player line
}
else
{
// skip status and stat lines
reader.ReadLine();
reader.ReadLine();
}
// extract player name and position from player line
// (assume that player name ends with lowercase character)
var playerMatch = Regex.Match(playerLine, @"([A-Za-z0-9' \.-]+[a-z])([A-Z]{1,3})(\s|View)");
entry.PlayerName = playerMatch.Groups[1].Value;
entry.PlayerPosition = Enum.Parse <Position>(playerMatch.Groups[2].Value);
// fix names for relocated teams
if (entry.PlayerName == "Los Angeles Rams" && year < 2016)
{
entry.PlayerName = "St. Louis Rams";
}
else if (entry.PlayerName == "Los Angeles Chargers" && year < 2017)
{
entry.PlayerName = "San Diego Chargers";
}
// parse points line
var pointsLine = reader.ReadLine();
entry.Points = double.Parse(pointsLine, CultureInfo.InvariantCulture);
weekRosters.Rosters.Last().Entries.Add(entry);
}
}
return(weekRosters);
}
public void Delete(RosterEntry rosterEntry)
{
base.Delete(rosterEntry);
}
public RosterEntry Update(RosterEntry rosterEntry)
{
return(base.Update(rosterEntry));
}
public RosterEntry Insert(RosterEntry rosterEntry)
{
return(Add(rosterEntry));
}
public bool Exists(RosterEntry rosterEntry)
{
Expression <Func <RosterEntry, bool> > doesExist = c => c.PlayerId == rosterEntry.PlayerId;
return(Query(doesExist).Count() > 0);
}
