public void NhlHtmlReport_ParseRosterFrenchRegSeason()
{
string path = @"C:\Users\jordanf\Google Drive\Coding\Sportsdata\TestData\FrenchRegSeasonRoster_formatted.htm";
string html = File.ReadAllText(path);
Nhl_Games_Rtss_Roster model = NhlGamesRtssRoster.ParseHtmlBlob(-1, html);
}
public void Script_NhlGamesRtssRoster()
{
NhlGamesRtssRoster.UpdateSeason(year: 2013, forceOverwrite: true);
//DateTime fromDate = DateTime.Now.AddDays(-2);
//NhlGamesRtssRoster.UpdateSeason(year: 2015, fromDate: fromDate, forceOverwrite: false);
}
public void NhlHtmlReport_ParseFrenchRegSeasonAndPersist()
{
string path = @"C:\Users\jordanf\Google Drive\Coding\Sportsdata\TestData\FrenchRegSeasonRoster_formatted.htm";
string html = File.ReadAllText(path);
Nhl_Games_Rtss_Roster model = NhlGamesRtssRoster.ParseHtmlBlob(-1, html);
using (SportsDataContext db = new SportsDataContext())
{
db.Nhl_Games_Rtss_Roster_DbSet.AddOrUpdate(
m => m.Id,
model);
db.SaveChanges();
model = db.Nhl_Games_Rtss_Roster_DbSet.FirstOrDefault(m => m.Id == model.Id);
model.VisitorRoster.Add(new Nhl_Games_Rtss_RosterParticipantItem {
Name = "visitor player 1"
});
model.VisitorRoster.Add(new Nhl_Games_Rtss_RosterParticipantItem {
Name = "visitor player 2"
});
model.VisitorScratches.Add(new Nhl_Games_Rtss_RosterParticipantItem {
Name = "visitor scratch 1"
});
model.VisitorScratches.Add(new Nhl_Games_Rtss_RosterParticipantItem {
Name = "visitor scratch 2"
});
model.VisitorHeadCoach.Add(new Nhl_Games_Rtss_RosterParticipantItem {
Name = "visitor head coach 1"
});
model.HomeRoster.Add(new Nhl_Games_Rtss_RosterParticipantItem {
Name = "home player 1"
});
model.HomeRoster.Add(new Nhl_Games_Rtss_RosterParticipantItem {
Name = "home player 2"
});
model.HomeScratches.Add(new Nhl_Games_Rtss_RosterParticipantItem {
Name = "home scratch 1"
});
model.HomeScratches.Add(new Nhl_Games_Rtss_RosterParticipantItem {
Name = "home scratch 2"
});
model.HomeHeadCoach.Add(new Nhl_Games_Rtss_RosterParticipantItem {
Name = "home head coach 1"
});
model.Referees.Add(new Nhl_Games_Rtss_RosterParticipantItem {
Name = "referee 1"
});
model.Referees.Add(new Nhl_Games_Rtss_RosterParticipantItem {
Name = "referee 2"
});
model.Linesman.Add(new Nhl_Games_Rtss_RosterParticipantItem {
Name = "linesman 1"
});
model.Linesman.Add(new Nhl_Games_Rtss_RosterParticipantItem {
Name = "linesman 2"
});
db.Nhl_Games_Rtss_Roster_DbSet.AddOrUpdate(
m => m.Id,
model);
db.SaveChanges();
}
List <Nhl_Games_Rtss_Roster> models;
using (SportsDataContext db = new SportsDataContext())
{
models = (from m in db.Nhl_Games_Rtss_Roster_DbSet
.Include(x => x.VisitorRoster)
.Include(x => x.VisitorScratches)
.Include(x => x.VisitorHeadCoach)
.Include(x => x.HomeRoster)
.Include(x => x.HomeScratches)
.Include(x => x.HomeHeadCoach)
.Include(x => x.Referees)
.Include(x => x.Linesman)
select m).ToList();
}
}
