public NhlStatsSet.goaliestatsDataTable GetGoaliesEx(String entry, long seasonId, bool top, String filter) { NhlStatsSet.goaliestatsDataTable table = new NhlStatsSet.goaliestatsDataTable(); SQLiteCommand command = new SQLiteCommand(); command.Connection = connection; command.CommandText = String.Format( "SELECT * FROM goaliestats " + "WHERE goaliestats.Season_ID = {0} {1} ORDER BY {2} {3}", seasonId, filter, entry, top ? "DESC" : "ASC"); SQLiteDataAdapter adapter = new SQLiteDataAdapter(command); adapter.Fill(table); return(table); }
public NhlStatsSet.goaliestatsDataTable GetEntireGoalies(String entry, bool top, bool playoffs) { NhlStatsSet.goaliestatsDataTable table = new NhlStatsSet.goaliestatsDataTable(); SQLiteCommand command = new SQLiteCommand(); command.Connection = connection; command.CommandText = String.Format( "SELECT * FROM goaliestats INNER JOIN seasons ON goaliestats.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.goaliestatsDataTable GetGoaliesEx() { this.Adapter.SelectCommand = this.CommandCollection[4]; NhlStatsSet.goaliestatsDataTable dataTable = new NhlStatsSet.goaliestatsDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual NhlStatsSet.goaliestatsDataTable GetGoalies(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.goaliestatsDataTable dataTable = new NhlStatsSet.goaliestatsDataTable(); this.Adapter.Fill(dataTable); return dataTable; }