public static ITournamentPrize Create(ITournamentPrize entity, MySqlConnection dbConn) { string query = "INSERT INTO TournamentPrizes (tournament_id, prize_id, place_id) VALUES (@tournament, @prize, @place)"; Dictionary <string, string> param = new Dictionary <string, string>(); param.Add("@tournament", entity.TournamentId.ToString()); param.Add("@prize", entity.PrizeId.ToString()); param.Add("@place", entity.PlaceId.ToString()); var resultsPK = DatabaseHelper.GetNonQueryCount(query, dbConn, param); entity.TournamentPrizeId = resultsPK; return(entity); }
public static ITournamentPrize Delete(ITournamentPrize entity, MySqlConnection dbConn) { string query = "DELETE FROM TournamentPrizes WHERE tournament_prize_id = @id"; Dictionary <string, string> param = new Dictionary <string, string>(); param.Add("@id", entity.TournamentPrizeId.ToString()); var result = DatabaseHelper.GetNonQueryCount(query, dbConn, param); if (result != 0) { return(entity); } return(null); }
public static ITournamentPrize Update(ITournamentPrize entity, MySqlConnection dbConn) { string query = "UPDATE TournamentPrizes SET prize_id = @prize, tournament_id = @tourney, place_id = @place WHERE tournament_prize_id = @id"; Dictionary <string, string> param = new Dictionary <string, string>(); param.Add("@id", entity.TournamentPrizeId.ToString()); param.Add("@prize", entity.PrizeId.ToString()); param.Add("@tourney", entity.TournamentId.ToString()); param.Add("@place", entity.PlaceId.ToString()); var result = DatabaseHelper.GetNonQueryCount(query, dbConn, param); if (result != 0) { return(entity); } return(null); }