public static IList <string> GetResultWithEngineNames(int raceNumber) { F1StatsDatabaseEntities db = new F1StatsDatabaseEntities(); 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() { F1StatsDatabaseEntities db = new F1StatsDatabaseEntities(); VersenyzoLogic verRepo = new VersenyzoLogic(new VersenyzoRepository(db)); var query = from x in verRepo.GetAllVersenyzo() orderby x.ossz_pont descending group x by x.Csapat.csapat_nev into g select new { CsapatNev = g.Key, Osszpont = g.Sum(y => y.ossz_pont), }; return(query.First().CsapatNev.ToString() + " " + query.First().Osszpont.ToString()); }
public static IList <ElertPont> GetDriversPoints() { F1StatsDatabaseEntities db = new F1StatsDatabaseEntities(); 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.GetValueOrDefault()), // ez jó? :thinking: }; return(query.ToList()); }
public CsapatRepository(F1StatsDatabaseEntities db) { this.db = db; }
public VersenyHetvegeRepository(F1StatsDatabaseEntities db) { this.db = db; }
public EredmenyRepository(F1StatsDatabaseEntities db) { this.db = db; }