public ActionResult Fixtures(Int32 id)
{
var dbAdapter = new SelectCommands();
var _fixtures = dbAdapter.GetHistoricFixByLeagueId(id);
var teams = dbAdapter.GetAllTeams();
if (!_fixtures.Any())
return HttpNotFound();
var fixtures = new List<FixtureViewModels>();
var leagues = dbAdapter.GetAllLeagues();
foreach (var _fixture in _fixtures.Where(f=>f.H_SHOTS ==null))
{
var tempFixture = new FixtureViewModels()
{
HomeTeam = teams.FirstOrDefault(team => team.API_TEAM_ID == Convert.ToInt32(_fixture.H_TEAM_ID))?.TEAM_NAME,
AwayTeam = teams.FirstOrDefault(team => team.API_TEAM_ID == Convert.ToInt32(_fixture.A_TEAM_ID))?.TEAM_NAME,
FixDate = _fixture.FIX_DATE.ToString()
};
fixtures.Add(tempFixture);
}
return View("_Fixtures",fixtures);
}
public ActionResult About()
{
//ViewBag.Message = "Your application description page.";
var dbAdapter = new SelectCommands();
var _leagues = dbAdapter.GetAllLeagues();
var _fixtures = dbAdapter.GetHistoricFixByLeagueId(3);
var teams = dbAdapter.GetAllTeams();
if (!_fixtures.Any())
return HttpNotFound();
var fixtures = _fixtures.Where(f => f.H_SHOTS == null).Select(fixture => new FixtureViewModels()
{
HomeTeam = teams.FirstOrDefault(team => team.API_TEAM_ID == Convert.ToInt32(fixture.H_TEAM_ID))?.TEAM_NAME, AwayTeam = teams.FirstOrDefault(team => team.API_TEAM_ID == Convert.ToInt32(fixture.A_TEAM_ID))?.TEAM_NAME, FixDate = fixture.FIX_DATE.ToString()
}).ToList();
if (!_leagues.Any())
return HttpNotFound();
var leagues = new LeaguesModel()
{
//SelectedLeagueId = "3",
Leagues = _leagues,
Fixtures = fixtures
};
return View(leagues);
}