public void AddCountries()
{
//var url = $"https://apifootball.com/api/?action=get_countries&APIkey={apikey}";
//var json = new WebClient().DownloadString(url);
//var result = JsonConvert.DeserializeObject<List<JsonCountry>>(json);
var url = $"https://allsportsapi.com/api/football/?met=Countries&APIkey={apikey}";
var json = new WebClient().DownloadString(url);
var result = JsonConvert.DeserializeObject <JsonCountry>(json);
//TODO
//List<Country> b = Mapper.Map<List<JsonCountry>, List<Country>>(a);
foreach (var jsonCountry in result.result)
{
Country country = Mapper.Map <Country>(jsonCountry);
_context.Countries.Add(country);
}
_context.SaveChanges();
}
public void AddFixture(DateTime date, string leagueId)
{
var parseDate = date.ToString("yyyy-MM-dd");
var url = $"https://allsportsapi.com/api/football/?met=Fixtures&leagueId={leagueId}&APIkey={apikey}&from={parseDate}&to={parseDate}";
var json = new WebClient().DownloadString(url);
var result = JsonConvert.DeserializeObject <JsonFixture>(json);
if (result.success == 1 && result.result != null)
{
foreach (var jsonFixture in result.result)
{
Fixture fixture = Mapper.Map <Fixture>(jsonFixture);
fixture.HomeTeam = context.Teams.FirstOrDefault(t => t.TeamKey.ToString() == jsonFixture.home_team_key);
fixture.AwayTeam = context.Teams.FirstOrDefault(t => t.TeamKey.ToString() == jsonFixture.away_team_key);
if (fixture.AwayTeam == null)
{
service.AddTeams(int.Parse(jsonFixture.league_key));
}
Fixture fixtureDB = context.Fixtures.FirstOrDefault(s => s.EventKey == jsonFixture.event_key);
if (fixtureDB == null)
{
context.Fixtures.Add(fixture);
}
else
{
if (!Equals(fixture, fixtureDB))
{
fixture.ID = fixtureDB.ID;
fixture.HomeTeamID = fixtureDB.HomeTeamID;
fixture.AwayTeamID = fixtureDB.AwayTeamID;
context.Entry(fixtureDB).CurrentValues.SetValues(fixture);
}
}
}
context.SaveChanges();
}
}
public void AddPost(Post post)
{
context.Posts.Add(post);
context.SaveChanges();
}
public void AddNews(News news)
{
context.News.Add(news);
context.SaveChanges();
}
public void AddTopic(Topic topic)
{
context.Add(topic);
context.SaveChanges();
}