partial void DeleteFIXTURE(FIXTURE instance);
partial void InsertFIXTURE(FIXTURE instance);
partial void UpdateFIXTURE(FIXTURE instance);
public List<FIXTURE> HistoricFixtures(string xml, int leagueId, bool isfinished)
{
var fixtures = new List<FIXTURE>();
var fixtureNodes = new List<XmlNode>();
var xmlfixtures = new XmlDocument();
xmlfixtures.LoadXml(xml);
var el = xmlfixtures.DocumentElement;
var nodelist = el.ChildNodes;
for (var i = 0; i < nodelist.Count; i++)
{
if (nodelist[i].Name == "Match") { fixtureNodes.Add(nodelist[i]); }
}
if (isfinished)
{
foreach (var node in fixtureNodes)
{
var nodeEl = XElement.Parse(node.OuterXml);
var tempFixture = new FIXTURE()
{
API_FIXTURE_ID = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='FixtureMatch_Id']").Value),
FIX_DATE = DateTime.Parse(nodeEl.XPathSelectElement("//*[local-name()='Date']").Value),
LEAGUE_ID = leagueId,
LEAGUE_ROUND = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='Round']").Value),
H_TEAM_ID = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='HomeTeam_Id']").Value),
H_CORNERS = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='HomeCorners']").Value),
H_GOALS = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='HomeGoals']").Value),
HALFTIME_H_GOALS = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='HalfTimeHomeGoals']").Value),
H_SHOTS = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='HomeShots']").Value),
H_SHOTS_ON_T = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='HomeShotsOnTarget']").Value),
H_FOULS = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='HomeFouls']").Value),
H_Y_CARDS = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='HomeYellowCards']").Value),
H_R_CARDS = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='HomeRedCards']").Value),
A_TEAM_ID = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='AwayTeam_Id']").Value),
A_CORNERS = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='AwayCorners']").Value),
A_GOALS = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='AwayGoals']").Value),
HALFTIME_A_GOALS = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='HalfTimeAwayGoals']").Value),
A_SHOTS = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='AwayShots']").Value),
A_SHOTS_ON_T = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='AwayShotsOnTarget']").Value),
A_FOULS = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='AwayFouls']").Value),
AWAY_Y_CARDS = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='AwayYellowCards']").Value),
AWAY_R_CARDS = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='AwayRedCards']").Value)
};
fixtures.Add(tempFixture);
}
}
else
{
foreach (var node in fixtureNodes)
{
var nodeEl = XElement.Parse(node.OuterXml);
var tempFixture = new FIXTURE()
{
API_FIXTURE_ID = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='Id']").Value),
FIX_DATE = DateTime.Parse(nodeEl.XPathSelectElement("//*[local-name()='Date']").Value),
LEAGUE_ID = leagueId,
LEAGUE_ROUND = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='Round']").Value),
H_TEAM_ID = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='HomeTeam_Id']").Value),
A_TEAM_ID = Convert.ToInt32(nodeEl.XPathSelectElement("//*[local-name()='AwayTeam_Id']").Value)
};
fixtures.Add(tempFixture);
}
}
return fixtures;
}
