protected void SendToWeb(string league, DateTime koDate, string homeTeam, string awayTeam, Dictionary <string, int> hstats, Dictionary <string, int> astats, string time) { int leagueId = addLeague(league); int hTeamId = AddTeam.DoIt(dbStuff, homeTeam); int aTeamId = AddTeam.DoIt(dbStuff, awayTeam); int gameId = AddGame.DoIt(dbStuff, hTeamId, aTeamId, leagueId, koDate); List <int> allStats = new List <int>(); allStats.AddRange(hstats.Values); allStats.AddRange(astats.Values); int retries = 0; log.Debug("Adding " + homeTeam + " [" + hTeamId + "] v " + awayTeam + " [" + aTeamId + "] in league [" + leagueId + "] with game id: " + gameId + " at time: " + time); log.Debug("Goals Corners"); var line1 = hstats[statType[1]].ToString().PadRight(6) + hstats[statType[6]].ToString(); var line2 = astats[statType[1]].ToString().PadRight(6) + astats[statType[6]].ToString(); log.Debug(line1); log.Debug(line2); while (retries < keyClashRetries) { try { AddStatistics.DoIt(dbStuff, isBet365(), allStats, gameId, time, "", koDate); } catch (DbException) { log.Warn("Retrying...."); retries += 1; } break; } }
private void SendStats(IEnumerable <XElement> snaps, int gameId) { var lastSnap = snaps.Last(); bool firstSnap = true; foreach (var snap in snaps) { string time = snap.Attribute("Time").Value; //<Snap Time="Full Time" Seen="01/27/13 5:30:04"> //<Snap Time="Half Time" Seen="01/27/13 4:23:48"> //<Snap Time="90:19" Seen="01/27/13 5:23:57"> DateTime seenTime = GetSeenTime(snap); var hstats = snap.Descendants("Home").First(); var astats = snap.Descendants("Away").First(); Dictionary <string, int> statsStore = new Dictionary <string, int>(); List <int> values = new List <int>(); foreach (var hstat in hstats.Descendants()) { statsStore["Home" + hstat.Name.ToString()] = int.Parse(hstat.Value); values.Add(int.Parse(hstat.Value)); } foreach (var astat in astats.Descendants()) { statsStore["Away" + astat.Name.ToString()] = int.Parse(astat.Value); values.Add(int.Parse(astat.Value)); } if (firstSnap == true) { firstSnap = false; string lastTime = lastSnap.Attribute("Time").Value; int retries = 0; bool result = false; while (retries < keyClashRetries) { try { result = AddStatistics.DoIt(dbStuff, isBet365(), values, gameId, time, lastTime, seenTime); } catch (DbException) { retries += 1; } break; } if (result == false) { break; } } else { int retries = 0; while (retries < keyClashRetries) { try { AddStatistics.DoIt(dbStuff, isBet365(), values, gameId, time, "", seenTime); } catch (DbException) { retries += 1; } break; } } } }