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);
}
