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