public NhlStatsSet.playerstatsDataTable GetEntirePlayers(String entry, bool top, bool playoffs)
{
NhlStatsSet.playerstatsDataTable table = new NhlStatsSet.playerstatsDataTable();
SQLiteCommand command = new SQLiteCommand();
command.Connection = connection;
command.CommandText = String.Format(
"SELECT * FROM playerstats INNER JOIN seasons ON playerstats.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.playerstatsDataTable GetPlayers(global::System.Nullable<long> Season_ID) {
this.Adapter.SelectCommand = this.CommandCollection[3];
if ((Season_ID.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Season_ID.Value));
}
else {
this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
}
NhlStatsSet.playerstatsDataTable dataTable = new NhlStatsSet.playerstatsDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual NhlStatsSet.playerstatsDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
NhlStatsSet.playerstatsDataTable dataTable = new NhlStatsSet.playerstatsDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
