public int InsertParticipantStat(ParticipantStat stat)
{
string query = "spInsertParticipantStat";
SqlParameter[] parameters = new SqlParameter[48];
parameters[0] = new SqlParameter("StatID", stat.StatID);
parameters[1] = new SqlParameter("Winner", stat.Winner);
parameters[2] = new SqlParameter("Kills", stat.Kills);
parameters[3] = new SqlParameter("Assists", stat.Assists);
parameters[4] = new SqlParameter("GoldSpent", stat.GoldSpent);
parameters[5] = new SqlParameter("GoldEarned", stat.GoldEarned);
parameters[6] = new SqlParameter("TotalDamageTaken", stat.TotalDamageTaken);
parameters[7] = new SqlParameter("TotalDamageDealtToChampions", stat.TotalDamageDealtToChampions);
parameters[8] = new SqlParameter("TotalDamageDealt", stat.TotalDamageDealt);
parameters[9] = new SqlParameter("PhysicalDamageTaken", stat.PhysicalDamageTaken);
parameters[10] = new SqlParameter("PhysicalDamageDealtToChampions", stat.PhysicalDamageDealtToChampions);
parameters[11] = new SqlParameter("PhysicalDamageDealt", stat.PhysicalDamageDealt);
parameters[12] = new SqlParameter("MagicDamageTaken", stat.MagicDamageTaken);
parameters[13] = new SqlParameter("MagicDamageDealtToChampions", stat.MagicDamageDealtToChampions);
parameters[14] = new SqlParameter("MagicDamageDealt", stat.MagicDamageDealt);
parameters[15] = new SqlParameter("TrueDamageTaken", stat.TrueDamageTaken);
parameters[16] = new SqlParameter("TrueDamageDealtToChampions", stat.TrueDamageDealtToChampions);
parameters[17] = new SqlParameter("TrueDamageDealt", stat.TrueDamageDealt);
parameters[18] = new SqlParameter("TotalUnitsHealed", stat.TotalUnitsHealed);
parameters[19] = new SqlParameter("TotalHeal", stat.TotalHeal);
parameters[20] = new SqlParameter("TotalTimeCrowdControlDealt", stat.TotalTimeCrowdControlDealt);
parameters[21] = new SqlParameter("WardsPlaced", stat.WardsPlaced);
parameters[22] = new SqlParameter("WardsKilled", stat.WardsKilled);
parameters[23] = new SqlParameter("VisionWardsBoughtInGame", stat.VisionWardsBoughtInGame);
parameters[24] = new SqlParameter("VisionScore", stat.VisionScore);
parameters[25] = new SqlParameter("SightWardsBoughtInGame", stat.SightWardsBoughtInGame);
parameters[26] = new SqlParameter("TowerKills", stat.TowerKills);
parameters[27] = new SqlParameter("InhibitorKills", stat.InhibitorKills);
parameters[28] = new SqlParameter("FirstTowerKill", stat.FirstTowerKill);
parameters[29] = new SqlParameter("FirstTowerAssist", stat.FirstTowerAssist);
parameters[30] = new SqlParameter("FirstInhibitorKill", stat.FirstInhibitorKill);
parameters[31] = new SqlParameter("FirstInhibitorAssist", stat.FirstInhibitorAssist);
parameters[32] = new SqlParameter("FirstBloodKill", stat.FirstBloodKill);
parameters[33] = new SqlParameter("FirstBloodAssist", stat.FirstBloodAssist);
parameters[34] = new SqlParameter("DoubleKills", stat.DoubleKills);
parameters[35] = new SqlParameter("TripleKills", stat.TripleKills);
parameters[36] = new SqlParameter("QuadraKills", stat.QuadraKills);
parameters[37] = new SqlParameter("PentaKills", stat.PentaKills);
parameters[38] = new SqlParameter("UnrealKills", stat.UnrealKills);
parameters[39] = new SqlParameter("KillingSprees", stat.KillingSprees);
parameters[40] = new SqlParameter("LargestKillingSpree", stat.LargestKillingSpree);
parameters[41] = new SqlParameter("LargestCriticalStrike", stat.LargestCriticalStrike);
parameters[42] = new SqlParameter("NeutralMinionsKilledEnemyJungle", stat.NeutralMinionsKilledEnemyJungle);
parameters[43] = new SqlParameter("NeutralMinionsKilledJungle", stat.NeutralMinionsKilledJungle);
parameters[44] = new SqlParameter("TotalMinionsKilled", stat.TotalMinionsKilled);
parameters[45] = new SqlParameter("ParticipantID", stat.ParticipantID);
parameters[46] = new SqlParameter("Deaths", stat.Deaths);
parameters[47] = new SqlParameter("ChampionLevel", stat.ChampionLevel);
int rows = dbIO.ExecuteNonQuery(query, parameters);
return(rows);
}
public ParticipantStat GetParticipantStatsByID()
{
ParticipantStat stats = new ParticipantStat();
return(stats);
}
