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);
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;
}
