public List <Hrac> Kanada()
{
HraciTable hraciTable = new HraciTable();
GolyTable golyTable = new GolyTable();
AsistenceTable asistenceTable = new AsistenceTable();
List <Hrac> hraci = hraciTable.Select();
List <Gol> goly = golyTable.Select();
List <Asistence> asistence = asistenceTable.Select();
for (int i = 0; i < hraci.Count; i++)
{
int countG = 0;
int countA = 0;
for (int j = 0; j < goly.Count; j++)
{
if (goly[j].Hrac.HracId == hraci[i].HracId)
{
countG++;
}
}
for (int j = 0; j < asistence.Count; j++)
{
if (asistence[j].Hrac.HracId == hraci[i].HracId)
{
countA++;
}
}
hraci[i].Body = countG + countA;
hraci[i].Goly = countG;
hraci[i].Asistence = countA;
}
return(hraci.OrderByDescending(x => x.Body).ThenByDescending(x => x.Goly).ToList());
}
public void ZapisAsistenci(Asistence a)
{
AsistenceTable asistenceTable = new AsistenceTable();
asistenceTable.Insert(a);
}
