public NHLDatabaseOperator()
{
nhlStatsDatabase = new NhlStatsSet();
String dbPath = "nhlstatsdb";
connection = new SQLiteConnection("Data Source=" + dbPath);
connection.Open();
playerStatsAdapter = new NHLScoreBot.NhlStatsSetTableAdapters.playerstatsTableAdapter();
goalieStatsAdapter = new NHLScoreBot.NhlStatsSetTableAdapters.goaliestatsTableAdapter();
teamStatsAdapter = new NHLScoreBot.NhlStatsSetTableAdapters.teamstatsTableAdapter();
seasonsAdapter = new NHLScoreBot.NhlStatsSetTableAdapters.seasonsTableAdapter();
scheduleAdapter = new NHLScoreBot.NhlStatsSetTableAdapters.scheduleTableAdapter();
teamsAdapter = new NHLScoreBot.NhlStatsSetTableAdapters.teamsTableAdapter();
playerStatsAdapter.Connection = connection;
goalieStatsAdapter.Connection = connection;
teamStatsAdapter.Connection = connection;
scheduleAdapter.Connection = connection;
teamsAdapter.Connection = connection;
}
public NhlStatsSet.playerstatsDataTable QueryPlayerStats(String query)
{
NhlStatsSet result = new NhlStatsSet();
DataAdapter adapter = new SQLiteDataAdapter(query, connection);
adapter.Fill(result);
return result.playerstats;
}
