private async void Query6() { int selectedCountry = -1; ChoiceCountry form = new ChoiceCountry(db.Country.ToArray()); if (form.ShowDialog() == DialogResult.OK) { selectedCountry = form.selectedCountry; } var tmp = db.Results.Where(x => x.Persons.IdCountry == (selectedCountry + 1)).Select(x => new { OlimpiadNumber = x.Olympiads.Number, NamePerson = x.Persons.FullName }); dataGridView1.DataSource = await tmp.ToListAsync(); }
private async void Query7() { int selectedCountry = -1; ChoiceCountry form = new ChoiceCountry(db.Country.ToArray()); if (form.ShowDialog() == DialogResult.OK) { selectedCountry = form.selectedCountry; } var tmp = db.Results.Where(x => x.Persons.IdCountry == (selectedCountry + 1)).Select(x => new { OlimpiadNumber = x.Olympiads.Number, MedalsI = db.Results.Where(y => y.IdOlympiad == x.IdOlympiad && y.Persons.IdCountry == x.Persons.IdCountry).Where(y => y.Medal == 1).Count(), MedalsII = db.Results.Where(y => y.IdOlympiad == x.IdOlympiad && y.Persons.IdCountry == x.Persons.IdCountry).Where(y => y.Medal == 2).Count(), MedalsIII = db.Results.Where(y => y.IdOlympiad == x.IdOlympiad && y.Persons.IdCountry == x.Persons.IdCountry).Where(y => y.Medal == 3).Count() }).Distinct(); dataGridView1.DataSource = await tmp.ToListAsync(); }