public static IList <string> TestGetResultWithEngineNames(int raceNumber, IEredmenyRepository eRepo, ICsapatRepository csRepo, IVersenyzoRepository vRepo) { EredmenyLogic eredmenyRepo = new EredmenyLogic(eRepo); CsapatLogic csapatLogic = new CsapatLogic(csRepo); VersenyzoLogic vLogic = new VersenyzoLogic(vRepo); var query = from x in eredmenyRepo.GetAllEredmeny() where x.versenyhetvege_szam == raceNumber join y in vLogic.GetAllVersenyzo() on x.rajtszam equals y.rajtszam join z in csapatLogic.GetAllCsapat() on y.csapat_nev equals z.csapat_nev orderby x.helyezes select z.motor; return(query.ToList()); }
public static IList <ElertPont> TestGetDriversPoints(IEredmenyRepository eRepo, IVersenyzoRepository vRepo) { EredmenyLogic eredmenyRepo = new EredmenyLogic(eRepo); VersenyzoLogic verRepo = new VersenyzoLogic(vRepo); 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 EredmenyLogic(IEredmenyRepository repo) { this.eredmenyRepo = repo; }
public EredmenyLogic(string connectionPassword) { this.eredmenyRepo = new EredmenyRepository(connectionPassword); }
public EredmenyLogic() { this.eredmenyRepo = new EredmenyRepository(new F1StatsDatabaseEntities()); }