public NhlStatsSet.teamstatsDataTable GetEntireTeams(String entry, bool top, bool playoffs)
{
NhlStatsSet.teamstatsDataTable table = new NhlStatsSet.teamstatsDataTable();
SQLiteCommand command = new SQLiteCommand();
command.Connection = connection;
command.CommandText = String.Format(
"SELECT * FROM teamstats INNER JOIN seasons ON teamstats.Season_ID = seasons.Season_ID " +
"WHERE seasons.Playoffs = '{2}' ORDER BY [{0}] {1} LIMIT 5", entry,
top ? "DESC" : "ASC", playoffs ? "1" : "0");
SQLiteDataAdapter adapter = new SQLiteDataAdapter(command);
adapter.Fill(table);
return(table);
}
public virtual NhlStatsSet.teamstatsDataTable GetTeams(global::System.Nullable<long> Season) {
this.Adapter.SelectCommand = this.CommandCollection[3];
if ((Season.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Season.Value));
}
else {
this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
}
NhlStatsSet.teamstatsDataTable dataTable = new NhlStatsSet.teamstatsDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual NhlStatsSet.teamstatsDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
NhlStatsSet.teamstatsDataTable dataTable = new NhlStatsSet.teamstatsDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
