public IEnumerable <object> GetRaces(int page, int pageSize)
{
using (var data = new Formula1Context())
{
if (_lastpageSearched == page)
{
return(_cache);
}
_lastpageSearched = page;
var q = (from r in data.Races
from rr in r.RaceResults
orderby r.Date ascending
select new
{
Year = r.Date.Year,
Country = r.Circuit.Country,
Position = rr.Position,
Racer = rr.Racer.FirstName + " " + rr.Racer.LastName,
Car = rr.Team.Name,
Points = rr.Points
}).Skip(page * pageSize).Take(pageSize);
_cache = q.ToList();
return(_cache);
}
}
private List <Championship> GetYears()
{
using (var data = new Formula1Context())
{
return(data.Races.Select(r => new Championship
{
Year = r.Date.Year
}).Distinct().OrderBy(c => c.Year).ToList());
}
}
private IEnumerable <F1RaceResult> GetResults()
{
using (var context = new Formula1Context())
{
return((from rr in context.RaceResults
where rr.Race.Date == this.Date
select new F1RaceResult
{
Position = rr.Position,
Racer = rr.Racer.FirstName + " " + rr.Racer.LastName,
Car = rr.Team.Name
}).ToList());
}
}
private IEnumerable <F1Race> GetRaces()
{
using (var context = new Formula1Context())
{
return((from r in context.Races
where r.Date.Year == Year
orderby r.Date
select new F1Race
{
Date = r.Date,
Country = r.Circuit.Country
}).ToList());
}
}
public PilotosController(Formula1Context context)
{
_context = context;
if (_context.Pilotos.Count() == 0)
{
List <Piloto> pilotos = this.CrearPilotos();
foreach (Piloto p in pilotos)
{
_context.Pilotos.Add(p);
}
_context.SaveChanges();
}
}
public Formula1Controller(Formula1Context context)
{
_context = context;
if (_context.Monoplazas.Count() == 0)
{
List <Monoplaza> monolazas = this.CrearMonoplazas();
foreach (Monoplaza m in monolazas)
{
_context.Monoplazas.Add(m);
}
_context.SaveChanges();
}
}
private IEnumerable <object> GetRaces()
{
using (var data = new Formula1Context())
{
return((from r in data.Races
from rr in r.RaceResults
orderby r.Date ascending
select new
{
r.Date.Year,
r.Circuit.Country,
rr.Position,
Racer = rr.Racer.FirstName + " " + rr.Racer.LastName,
Car = rr.Team.Name
}).Skip(_currentPage * _pageSize).Take(_pageSize).ToList());
}
}
public PosicaoController(Formula1Context context)
{
_context = context;
}
