示例#1
0
        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);
        }
示例#2
0
        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;
 }