public NhlStatsSet.teamsDataTable GetDivisionTeams(string division)
{
NhlStatsSet.teamsDataTable table = new NhlStatsSet.teamsDataTable();
SQLiteCommand command = new SQLiteCommand();
command.Connection = connection;
command.CommandText = String.Format("SELECT * FROM (SELECT TeamName, TeamID, Division FROM teams WHERE " +
"(Division = '{0}') GROUP BY TeamName) GROUP BY TeamID", division);
SQLiteDataAdapter adapter = new SQLiteDataAdapter(command);
adapter.Fill(table);
// System.Diagnostics.Debug.Assert(table.Rows.Count == 5); // meh
return(table);
}
public NhlStatsSet.teamsDataTable GetExistantTeam(string team)
{
NhlStatsSet.teamsDataTable table = new NhlStatsSet.teamsDataTable();
SQLiteCommand command = new SQLiteCommand();
command.Connection = connection;
command.CommandText = String.Format(
"SELECT TeamID, TeamName, TeamCity, Conference, Division " +
"FROM teams " +
"WHERE (TeamName LIKE '%{0}%') OR " +
"(TeamCity LIKE '%{0}%') AND (NOT (Conference = 'Nonexistent'))", team);
SQLiteDataAdapter adapter = new SQLiteDataAdapter(command);
adapter.Fill(table);
return(table);
}
public virtual NhlStatsSet.teamsDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
NhlStatsSet.teamsDataTable dataTable = new NhlStatsSet.teamsDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
