public GameInfoDTO getGameInfoDTO(Context context) {
GameInfoDTO gameInfo = new GameInfoDTO();
DatabaseHelper dbHelper = new DatabaseHelper(context);
dbHelper.open();
Cursor cursor = null;
cursor = dbHelper.fetchGameInfo();
cursor.moveToFirst();
while (cursor.isAfterLast() == false) {
gameInfo.setPlayerInfoStatus((cursor.getInt(cursor.getColumnIndex("playerInfoStatus"))));
gameInfo.setTime((cursor.getString(cursor.getColumnIndex("time"))));
gameInfo.setVenue((cursor.getString(cursor.getColumnIndex("venue"))));
gameInfo.setTeam1Id((cursor.getInt(cursor.getColumnIndex("team1Id"))));
gameInfo.setTeam1Name((cursor.getString(cursor.getColumnIndex("team1Name"))));
gameInfo.setTeam1Flag((cursor.getString(cursor.getColumnIndex("team1Flag"))));
gameInfo.setTeam1Group((cursor.getString(cursor.getColumnIndex("team1Group"))));
gameInfo.setTeam2Id((cursor.getInt(cursor.getColumnIndex("team2Id"))));
gameInfo.setTeam2Name((cursor.getString(cursor.getColumnIndex("team2Name"))));
gameInfo.setTeam2Group((cursor.getString(cursor.getColumnIndex("team2Group"))));
gameInfo.setTeam2Flag((cursor.getString(cursor.getColumnIndex("team2Flag"))));
cursor.moveToNext();
}
dbHelper.close();
return gameInfo;
}
public GameDTO getGame(Context context) {
DatabaseHelper dbHelper = new DatabaseHelper(context);
dbHelper.open();
Cursor cursor = null;
cursor = dbHelper.fetchGameDTO();
cursor.moveToFirst();
GameDTO currentGame = new GameDTO();
while (cursor.isAfterLast() == false) {
currentGame.setTeam1Id(cursor.getInt(cursor.getColumnIndex("team_1_id")));
currentGame.setTeam2Id(cursor.getInt(cursor.getColumnIndex("team_2_id")));
cursor.moveToNext();
}
dbHelper.close();
return currentGame;
}
public void updateGameFinal(Context context) {
DatabaseHelper dbHelper = new DatabaseHelper(context);
dbHelper.open();
dbHelper.updateTableGame();
dbHelper.close();
}
public void deleteTableGame(Context context) {
DatabaseHelper dbHelper = new DatabaseHelper(context);
dbHelper.open();
dbHelper.deleteTableGame();
dbHelper.close();
}
public void insertGameData(Context context, GameDTO gameDTO) {
DatabaseHelper dbHelper = new DatabaseHelper(context);
dbHelper.open();
dbHelper.addGameInfo(gameDTO);
dbHelper.close();
}