private static List <SeasonData> GetOneShlSeason(int seasonNumber)
{
List <SeasonData> seasons = new List <SeasonData>();
string leagueAcronym = "SHL";
bool isPlayoffs = false;
string seasonType = isPlayoffs ? "Playoffs" : "Regular Season";
Console.WriteLine($"### {leagueAcronym} - {seasonType}");
string seasonValue = seasonNumber.ToString();
if (seasonNumber < 10)
{
seasonValue = " " + seasonValue;
}
Console.Write(" - Season " + seasonValue);
var sourceSeason = SeasonStatsExtractor.ExtractSeason(seasonNumber, isPlayoffs, leagueAcronym);
if (sourceSeason != null)
{
seasons.Add(new SeasonData(sourceSeason));
Console.Write(" [DONE]");
}
else
{
Console.Write(" [Not Found]");
}
Console.WriteLine();
return(seasons);
}
public static void GetOneShlSeason(int seasonNumber, string url, string leagueAcronym)
{
SeasonData season;
bool isPlayoffs = url.Contains("-PLF-");
var extractedSeason = SeasonStatsExtractor.ExtractSeason(url, seasonNumber, isPlayoffs, leagueAcronym);
if (extractedSeason != null && extractedSeason.Teams.Count > 0)
{
season = new SeasonData(extractedSeason);
Console.Write(" [DONE]");
Console.WriteLine();
Console.WriteLine("----");
Console.WriteLine("Uploading Data to DB");
Console.Write(" - Season " + season.SourceSeason.Number);
season.SaveDataToDB();
Console.Write(" [DONE]");
Console.WriteLine();
}
else
{
Console.Write(" [Not Found]");
}
Console.WriteLine("----");
Console.WriteLine("Extraction Complete");
Console.WriteLine();
Console.ReadKey();
}
private static List <SeasonData> GetAllSeasons()
{
List <SeasonData> seasons = new List <SeasonData>();
string[] leagueOptions = { "SHL", "SMJHL" };
bool[] isPlayoffsOptions = { false, true };
foreach (var isPlayoffs in isPlayoffsOptions)
{
foreach (var leagueAcronym in leagueOptions)
{
string seasonType = isPlayoffs ? "Playoffs" : "Regular Season";
Console.WriteLine($"### {leagueAcronym} - {seasonType}");
for (int seasonNumber = 1; seasonNumber <= 28; seasonNumber++)
{
string seasonValue = seasonNumber.ToString();
if (seasonNumber < 10)
{
seasonValue = " " + seasonValue;
}
Console.Write(" - Season " + seasonValue);
var sourceSeason = SeasonStatsExtractor.ExtractSeason(seasonNumber, isPlayoffs, leagueAcronym);
if (sourceSeason != null)
{
seasons.Add(new SeasonData(sourceSeason));
Console.Write(" [DONE]");
}
else
{
Console.Write(" [Not Found]");
}
Console.WriteLine();
}
}
}
return(seasons);
}
public static void GetEverything()
{
List <SeasonData> seasons = new List <SeasonData>();
List <SeasonPage> seasonPages = new List <SeasonPage>
{
new SeasonPage()
{
Url = "http://www.shlstuff.wtgbear.com/RegSeason/S{0}/SHL-ProTeamScoring.html",
StartIndex = 29,
LeagueAcronym = "SHL",
IsPlayoffs = false,
},
new SeasonPage()
{
Url = "http://www.shlstuff.wtgbear.com/Playoffs/S{0}/SHL-PLF-ProTeamScoring.html",
StartIndex = 30,
LeagueAcronym = "SHL",
IsPlayoffs = true,
},
new SeasonPage()
{
Url = "http://www.smjhlstuff.wtgbear.com/S{0}Reg/SMJHL-ProTeamScoring.html",
StartIndex = 23,
LeagueAcronym = "SMJHL",
IsPlayoffs = false,
},
new SeasonPage()
{
Url = "http://www.smjhlstuff.wtgbear.com/S{0}PO/SMJHL-PLF-ProTeamScoring.html",
StartIndex = 22,
LeagueAcronym = "SMJHL",
IsPlayoffs = true,
}
};
int endIndex = 40;
Console.WriteLine("Starting Modern Extractions");
foreach (var page in seasonPages)
{
Console.WriteLine($"### {page.LeagueAcronym} - {(page.IsPlayoffs ? "Playoffs" : "Regular Season")}");
for (int seasonNumber = page.StartIndex; seasonNumber <= endIndex; seasonNumber++)
{
Console.Write(" - Season " + (seasonNumber < 10 ? " " : "") + seasonNumber);
var season = SeasonStatsExtractor.ExtractSeason(page.Url, seasonNumber, page.IsPlayoffs, page.LeagueAcronym);
if (season != null && season.Teams.Count > 0)
{
seasons.Add(new SeasonData(season));
Console.Write(" [DONE]");
}
else
{
Console.Write(" [Not Found]");
}
Console.WriteLine();
}
}
Console.WriteLine("----");
Console.WriteLine("Uploading Data to DB");
DatabaseHelpers.AddLeagues();
DatabaseHelpers.AddRequestTypes();
foreach (var season in seasons)
{
Console.Write(" - Season " + season.SourceSeason.Number);
season.SaveDataToDB();
Console.Write(" [DONE]");
Console.WriteLine();
}
DatabaseHelpers.AddFranchises();
DatabaseHelpers.RemoveExtraPlayers();
Console.WriteLine("----");
Console.WriteLine("Extraction Complete");
Console.WriteLine();
}
