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