public List <ITournamentEntry> saveTournamentEntry(IMatchup matchup) { ITournamentEntry entry1 = TournamentEntryTable.Get(matchup.MatchupEntries[0].TournamentEntryId, dbConn); ITournamentEntry entry2 = TournamentEntryTable.Get(matchup.MatchupEntries[1].TournamentEntryId, dbConn); if (entry1 == null || entry2 == null) { return(null); } entry1.Wins = matchup.MatchupEntries[0].TheTeam.Wins; entry1.Losses = matchup.MatchupEntries[0].TheTeam.Losses; entry2.Wins = matchup.MatchupEntries[1].TheTeam.Wins; entry2.Losses = matchup.MatchupEntries[1].TheTeam.Losses; List <ITournamentEntry> results = new List <ITournamentEntry>(); if (TournamentEntryTable.Update(entry1, dbConn) == null) { return(null); } if (TournamentEntryTable.Update(entry2, dbConn) == null) { return(null); } results.Add(entry1); results.Add(entry2); return(results); }
public static ITournamentEntry Create(ITournamentEntry entity, MySqlConnection dbConn) { string query = "INSERT INTO TournamentEntries (tournament_id, team_id, seed) VALUES (@tournament, @team, @seed)"; Dictionary <string, string> param = new Dictionary <string, string>(); param.Add("@tournament", entity.TournamentId.ToString()); param.Add("@team", entity.TeamId.ToString()); param.Add("@seed", entity.Seed.ToString()); var resultsPK = DatabaseHelper.GetNonQueryCount(query, dbConn, param); entity.TournamentEntryId = resultsPK; return(entity); }
public static ITournamentEntry Delete(ITournamentEntry entity, MySqlConnection dbConn) { string query = "DELETE FROM TournamentEntries WHERE tournament_entry_id = @id"; Dictionary <string, string> param = new Dictionary <string, string>(); param.Add("@id", entity.TournamentEntryId.ToString()); var result = DatabaseHelper.GetNonQueryCount(query, dbConn, param); if (result != 0) { return(entity); } return(null); }
public static ITournamentEntry Update(ITournamentEntry entity, MySqlConnection dbConn) { string query = "UPDATE TournamentEntries SET wins = @win, losses = @losses WHERE tournament_entry_id = @id"; Dictionary <string, string> param = new Dictionary <string, string>(); param.Add("@win", entity.Wins.ToString()); param.Add("@losses", entity.Losses.ToString()); param.Add("@id", entity.TournamentEntryId.ToString()); var result = DatabaseHelper.GetNonQueryCount(query, dbConn, param); if (result != 0) { return(entity); } return(null); }