public TDStatistics GetTDStats(ulong accID)
{
var stats = new TDStatistics();
using (var con = GetConnection())
{
using (var cmd = BuildQuery(con, "SELECT * FROM account_tdstats WHERE ID=@ID", "@ID", accID))
{
using (var r = cmd.ExecuteReader())
{
if (!r.Read())
{
return(stats);
}
stats.TotalTouchdowns = r.GetUInt32("TDs");
stats.TotalTouchdownAssists = r.GetUInt32("TDAssists");
stats.TotalKills = r.GetUInt32("Kills");
stats.TotalKillAssists = r.GetUInt32("KillAssists");
stats.TotalOffense = r.GetUInt32("Offense");
stats.TotalOffenseAssists = r.GetUInt32("OffenseAssists");
stats.TotalDefense = r.GetUInt32("Defense");
stats.TotalDefenseAssists = r.GetUInt32("DefenseAssists");
stats.TotalRecovery = r.GetUInt32("Recovery");
stats.TotalMatches = r.GetUInt32("Matches");
stats.Won = r.GetUInt32("Won");
stats.Lost = r.GetUInt32("Lost");
}
}
}
return(stats);
}
public void UpdateTDStats(ulong accID, TDStatistics stats)
{
using (var con = GetConnection())
{
using (var cmd = BuildQuery(con,
"UPDATE account_tdstats SET TDs=@TD, TDAssists=@TDA, Kills=@Kills, KillAssists=@KillA, Offense=@Offense, OffenseAssists=@OffenseA, Defense=@Defense, DefenseAssists=@DefenseA, Recovery=@Recovery, Matches=@Matches, Won=@Won, Lost=@Lost WHERE ID=@ID",
"@TD", stats.TotalTouchdowns, "@TDA", stats.TotalTouchdownAssists, "@Kills", stats.TotalKills, "@KillA",
stats.TotalKillAssists, "@Offense", stats.TotalOffense, "@OffenseA",
stats.TotalOffenseAssists, "@Defense", stats.TotalDefense, "@DefenseA",
stats.TotalDefenseAssists, "@Recovery", stats.TotalRecovery, "@Matches", stats.TotalMatches, "@Won", stats.Won, "@Lost", stats.Lost, "@ID", accID))
{
cmd.ExecuteNonQuery();
}
}
}
