public void updateFantasyTeam(FantasyTeam fantasyTeam) {
// Go through each team reg and update in db.
Map<Integer, Pair<Integer, Integer>> players = fantasyTeam.getPlayers();
for (Map.Entry<Integer, Pair<Integer, Integer>> entry : players.entrySet()) {
int numOfPlayer = entry.getKey();
int playerId = entry.getValue().getKey();
int playerPos = entry.getValue().getValue();
FantasyTeamReg ftr =
new FantasyTeamReg(fantasyTeam.getFantasyTeamId(), playerId, playerPos, numOfPlayer);
fantasyTeamRegServiceData.updateFantasyTeamReg(ftr);
}
}
public void addFantasyTeam(FantasyTeam fantasyTeam) {
JdbcTemplate queryFantasyTeams = new JdbcTemplate(this.getDataSource());
int userId = fantasyTeam.getUserId();
String sql1 = "SELECT * FROM fantasyteams WHERE userid = ?";
boolean hasTeam = true;
try {
queryFantasyTeams.queryForObject(sql1, new Object[] {userId}, new FantasyTeamRowMapper());
} catch (EmptyResultDataAccessException e) {
hasTeam = false;
}
if (!hasTeam) {
SimpleJdbcInsert insertToFantasyTeams =
(new SimpleJdbcInsert(this.getDataSource())).withTableName("fantasyteams");
String sql2 = "SELECT MAX(fantasyteamid) FROM fantasyteams";
int nextId = 1;
try {
nextId += queryFantasyTeams.queryForObject(sql2, Integer.class);
} catch (NullPointerException ignored) {
}
Map<String, Object> fantasyteamsParameters = new HashMap<String, Object>(2);
fantasyteamsParameters.put("fantasyteamid", nextId);
fantasyteamsParameters.put("userid", fantasyTeam.getUserId());
try {
insertToFantasyTeams.execute(fantasyteamsParameters);
} catch (DataIntegrityViolationException dive) {
this.log.warning(dive.getMessage());
}
for (int i = 1; i <= 11; ++i) {
FantasyTeamReg reg = new FantasyTeamReg(nextId, 0, 0, i);
fantasyTeamRegServiceData.addFantasyTeamReg(reg);
}
}
}