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