public static IList <string> GetResultWithEngineNames(int raceNumber) { F1StatsDbContext db = new F1StatsDbContext("placeholder"); EredmenyLogic eredmenyRepo = new EredmenyLogic(new EredmenyRepository(db)); var query = from x in eredmenyRepo.GetAllEredmeny() where x.versenyhetvege_szam == raceNumber orderby x.helyezes select x.Versenyzo.Csapat.motor; return(query.ToList()); }
public static string GetTeamWithMostPoints() { F1StatsDbContext db = new F1StatsDbContext("placeholder"); VersenyzoLogic verLogic = new VersenyzoLogic(new VersenyzoRepository(db)); var query = from x in verLogic.GetAllVersenyzo() orderby x.ossz_pont descending group x by x.Csapat.csapat_nev into g select new { CsapatNev = g.Key, }; return(query.First().CsapatNev.ToString()); }
public static IList <ElertPont> GetDriversPoints() { F1StatsDbContext db = new F1StatsDbContext("placeholder"); EredmenyLogic eredmenyRepo = new EredmenyLogic(new EredmenyRepository(db)); VersenyzoLogic verRepo = new VersenyzoLogic(new VersenyzoRepository(db)); var query = from x in eredmenyRepo.GetAllEredmeny() group x by x.rajtszam into g join y in verRepo.GetAllVersenyzo() on g.Key equals y.rajtszam select new ElertPont { DriverName = y.nev, Points = g.Sum(z => z.pont), }; var res = query.ToList(); res.Sort(SortByPoints); return(res); }
public VersenyzoRepository(F1StatsDbContext db) { this.db = db; }
public VersenyzoRepository(string connectionPassword) { this.db = new F1StatsDbContext(connectionPassword); }
public EredmenyRepository(F1StatsDbContext db) { this.db = db; }
public EredmenyRepository(string connectionPassword) { this.db = new F1StatsDbContext(connectionPassword); }
public CsapatRepository(string connectionPassword) { this.db = new F1StatsDbContext(connectionPassword); }