public PlayerStatDTO GetByID(int?id)
{
try
{
PlayerStatDTO playerStat = new PlayerStatDTO();
using (MySqlConnection conn = _con.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SELECT PlayerStatID,PlayerID,MatchID,TeamID,GodPlayedID,PlayerLevel,PlayerKills," +
"PlayerDeaths,PlayerAssists,PlayerDamage,PlayerDamageTaken,PlayerDamageMitigated," +
"PlayerHealing,PlayerGoldEarned,PlayerGoldPerMinute,PlayerItem1ID,PlayerItem2ID," +
"PlayerItem3ID,PlayerItem4ID,PlayerItem5ID,PlayerItem6ID,PlayerRelic1ID,PlayerRelic2ID," +
"PlayerWon,PlayerRoleID,PlayerPickOrder FROM playerstat WHERE PlayerStatID = ?id", conn);
cmd.Parameters.AddWithValue("id", id);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
playerStat.PlayerStatID = reader[0] as int? ?? default;
playerStat.PlayerID = reader[1] as int? ?? default;
playerStat.MatchID = reader[2] as int? ?? default;
playerStat.TeamID = reader[3] as int? ?? default;
playerStat.GodPlayedID = reader[4] as int? ?? default;
playerStat.PlayerLevel = reader[5] as int? ?? default;
playerStat.PlayerKills = reader[6] as int? ?? default;
playerStat.PlayerDeaths = reader[7] as int? ?? default;
playerStat.PlayerAssists = reader[8] as int? ?? default;
playerStat.PlayerDamage = reader[9] as int? ?? default;
playerStat.PlayerDamageTaken = reader[10] as int? ?? default;
playerStat.PlayerDamageMitigated = reader[11] as int? ?? default;
playerStat.PlayerHealing = reader[12] as int? ?? default;
playerStat.PlayerGoldEarned = reader[13] as int? ?? default;
playerStat.PlayerGoldPerMinute = reader[14] as int? ?? default;
playerStat.PlayerItem1ID = reader[15] as int? ?? default;
playerStat.PlayerItem2ID = reader[16] as int? ?? default;
playerStat.PlayerItem3ID = reader[17] as int? ?? default;
playerStat.PlayerItem4ID = reader[18] as int? ?? default;
playerStat.PlayerItem5ID = reader[19] as int? ?? default;
playerStat.PlayerItem6ID = reader[20] as int? ?? default;
playerStat.PlayerRelic1ID = reader[21] as int? ?? default;
playerStat.PlayerRelic2ID = reader[22] as int? ?? default;
playerStat.PlayerWon = reader[23] as bool? ?? default;
playerStat.PlayerRoleID = reader[24] as int? ?? default;
playerStat.PlayerPickOrder = reader[25] as int? ?? default;
}
}
}
return(playerStat);
}
catch (Exception ex)
{
throw new ContextErrorException(ex);
}
}
//Update
public int?Update(PlayerStatDTO entity)
{
try
{
using (MySqlConnection conn = _con.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("UPDATE playerstat SET PlayerID = ?PlayerID,MatchID = ?MatchID," +
"TeamID = ?TeamID, GodPlayedID = ?GodPlayedID,PlayerLevel = ?PlayerLevel,PlayerKills = ?PlayerKills," +
"PlayerDeaths = ?PlayerDeaths,PlayerAssists = ?PlayerAssists,PlayerDamage = ?PlayerDamage,PlayerDamageTaken = ?PlayerDamageTaken," +
"PlayerDamageMitigated = ?PlayerDamageMitigated,PlayerHealing = ?PlayerHealing,PlayerGoldEarned = ?PlayerGoldEarned," +
"PlayerGoldPerMinute = ?PlayerGoldPerMinute,PlayerItem1ID = ?PlayerItem1ID,PlayerItem2ID = ?PlayerItem2ID," +
"PlayerItem3ID = ?PlayerItem3ID,PlayerItem4ID = ?PlayerItem4ID,PlayerItem5ID = ?PlayerItem5ID,PlayerItem6ID = ?PlayerItem6ID," +
"PlayerRelic1ID = ?PlayerRelic1ID,PlayerRelic2ID = ?PlayerRelic2ID,PlayerWon = ?PlayerWon, PlayerRoleID = ?PlayerRoleID, PlayerPickOrder = ?PlayerPickOrder WHERE PlayerStatID = ?id", conn);
//where id is
cmd.Parameters.AddWithValue("id", entity.PlayerStatID);
//values
cmd.Parameters.AddWithValue("PlayerID", entity.PlayerID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("MatchID", entity.MatchID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("TeamID", entity.TeamID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodPlayedID", entity.GodPlayedID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerLevel", entity.PlayerLevel);
cmd.Parameters.AddWithValue("PlayerKills", entity.PlayerKills);
cmd.Parameters.AddWithValue("PlayerDeaths", entity.PlayerDeaths);
cmd.Parameters.AddWithValue("PlayerAssists", entity.PlayerAssists);
cmd.Parameters.AddWithValue("PlayerDamage", entity.PlayerDamage);
cmd.Parameters.AddWithValue("PlayerDamageTaken", entity.PlayerDamageTaken);
cmd.Parameters.AddWithValue("PlayerDamageMitigated", entity.PlayerDamageMitigated);
cmd.Parameters.AddWithValue("PlayerHealing", entity.PlayerHealing);
cmd.Parameters.AddWithValue("PlayerGoldEarned", entity.PlayerGoldEarned);
cmd.Parameters.AddWithValue("PlayerGoldPerMinute", entity.PlayerGoldPerMinute);
cmd.Parameters.AddWithValue("PlayerItem1ID", entity.PlayerItem1ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerItem2ID", entity.PlayerItem2ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerItem3ID", entity.PlayerItem3ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerItem4ID", entity.PlayerItem4ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerItem5ID", entity.PlayerItem5ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerItem6ID", entity.PlayerItem6ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerRelic1ID", entity.PlayerRelic1ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerRelic2ID", entity.PlayerRelic2ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerWon", entity.PlayerWon);
cmd.Parameters.AddWithValue("PlayerRoleID", entity.PlayerRoleID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerPickOrder", entity.PlayerPickOrder);
//execute command
int rowsAffected = cmd.ExecuteNonQuery();
//should return if a row is affected or not
return(rowsAffected);
}
}
catch (Exception ex)
{
throw new ContextErrorException(ex);
}
}
//Create
public int?Add(PlayerStatDTO entity)
{
try
{
using (MySqlConnection conn = _con.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO god (PlayerID,MatchID,TeamID,GodPlayedID,PlayerLevel," +
"PlayerKills,PlayerDeaths,PlayerAssists,PlayerDamage,PlayerDamageTaken,PlayerDamageMitigated," +
"PlayerHealing,PlayerGoldEarned,PlayerGoldPerMinute,PlayerItem1ID,PlayerItem2ID," +
"PlayerItem3ID,PlayerItem4ID,PlayerItem5ID,PlayerItem6ID," +
"PlayerRelic1ID,PlayerRelic2ID,PlayerWon,PlayerRoleID,PlayerPickOrder) VALUES(?PlayerID,?MatchID,?TeamID,?GodPlayedID,?PlayerLevel," +
"?PlayerKills,?PlayerDeaths,?PlayerAssists,?PlayerDamage,?PlayerDamageTaken,?PlayerDamageMitigated," +
"?PlayerHealing,?PlayerGoldEarned,?PlayerGoldPerMinute,?PlayerItem1ID,?PlayerItem2ID," +
"?PlayerItem3ID,?PlayerItem4ID,?PlayerItem5ID,?PlayerItem6ID," +
"?PlayerRelic1ID,?PlayerRelic2ID,?PlayerWon,?PlayerRoleID,?PlayerPickOrder)", conn);
//values
//values
cmd.Parameters.AddWithValue("PlayerID", entity.PlayerID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("MatchID", entity.MatchID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("TeamID", entity.TeamID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodPlayedID", entity.GodPlayedID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerLevel", entity.PlayerLevel);
cmd.Parameters.AddWithValue("PlayerKills", entity.PlayerKills);
cmd.Parameters.AddWithValue("PlayerDeaths", entity.PlayerDeaths);
cmd.Parameters.AddWithValue("PlayerAssists", entity.PlayerAssists);
cmd.Parameters.AddWithValue("PlayerDamage", entity.PlayerDamage);
cmd.Parameters.AddWithValue("PlayerDamageTaken", entity.PlayerDamageTaken);
cmd.Parameters.AddWithValue("PlayerDamageMitigated", entity.PlayerDamageMitigated);
cmd.Parameters.AddWithValue("PlayerHealing", entity.PlayerHealing);
cmd.Parameters.AddWithValue("PlayerGoldEarned", entity.PlayerGoldEarned);
cmd.Parameters.AddWithValue("PlayerGoldPerMinute", entity.PlayerGoldPerMinute);
cmd.Parameters.AddWithValue("PlayerItem1ID", entity.PlayerItem1ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerItem2ID", entity.PlayerItem2ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerItem3ID", entity.PlayerItem3ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerItem4ID", entity.PlayerItem4ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerItem5ID", entity.PlayerItem5ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerItem6ID", entity.PlayerItem6ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerRelic1ID", entity.PlayerRelic1ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerRelic2ID", entity.PlayerRelic2ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerWon", entity.PlayerWon);
cmd.Parameters.AddWithValue("PlayerRoleID", entity.PlayerRoleID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerPickOrder", entity.PlayerPickOrder);
//execute command
int rowsAffected = cmd.ExecuteNonQuery();
//should return if a row is affected or not
return(rowsAffected);
}
}
catch (Exception ex)
{
throw new ContextErrorException(ex);
}
}
//Delete
public int?Remove(PlayerStatDTO entity)
{
try
{
using (MySqlConnection conn = _con.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("DELETE FROM playerstat WHERE PlayerStatID = ?id", conn);
//where id =
cmd.Parameters.AddWithValue("id", entity.PlayerStatID);
//execute command
int rowsAffected = cmd.ExecuteNonQuery();
//should return if a row is affected or not
return(rowsAffected);
}
}
catch (Exception ex)
{
throw new ContextErrorException(ex);
}
}
