public IActionResult Index() { List <Competition> allCompetitions = _competitionRepository.GetAll(); List <SportsComplex> allSportsComplexes = _sportsComplexRepository.GetAll(); Dictionary <int, int> numberOfParticipants = ( from athlete in _athletePerformanceRepository.GetAll() group athlete by athlete.CompetitionId into athleteGroup select new { CompetitionId = athleteGroup.Key, NumberOfParticipants = athleteGroup.Count() }).ToDictionary( pair => pair.CompetitionId, pair => pair.NumberOfParticipants); List <CompetitionDto> result = (from competition in allCompetitions join sportsComplex in allSportsComplexes on competition.SportsComplexId equals sportsComplex.Id select new CompetitionDto { Id = competition.Id, Name = competition.Name, StartDate = competition.StartDate, EndDate = competition.EndDate, SportsComplexName = sportsComplex.Name, NumberOfParticipants = numberOfParticipants.ContainsKey(competition.Id) ? numberOfParticipants[competition.Id] : 0 }).ToList(); return(View(result)); }
public IActionResult Index() { List <Athlete> allAthletes = _athleteRepository.GetAll(); List <AthletePerformance> allPerformances = _athletePerformanceRepository.GetAll(); List <Competition> allCompetitions = _competitionRepository.GetAll(); List <AthletePerformanceDto> result = (from performance in allPerformances join competition in allCompetitions on performance.CompetitionId equals competition.Id join athlete in allAthletes on performance.AthleteId equals athlete.Id select new AthletePerformanceDto { Id = performance.Id, AthleteName = athlete.Name, AthleteSurname = athlete.Surname, AthletePatronymicName = athlete.PatronymicName, CompetitionName = competition.Name, PerformanceDate = performance.PerformanceDate, Score = performance.Score }).ToList(); return(View(result)); }
/// <summary> /// get competition /// </summary> /// <param name="size"></param> /// <param name="page"></param> /// <param name="searchString"></param> /// <returns></returns> // GET: Competition public ActionResult Index(int?size, int?page, string searchString) { var lst = _competitionRepository.GetAll(); if (!String.IsNullOrEmpty(searchString)) { ViewBag.CurrentFilter = searchString; lst = lst.Where(s => s.Name.Contains(searchString)); } ViewBag.stt = 1; ViewBag.currentSize = size; // tạo biến kích thước trang hiện tại ViewBag.total = lst.ToList().Count; page = page ?? 1; int pageSize = (size ?? 2); int pageNumber = (page ?? 1); return(View(lst.ToPagedList(pageNumber, pageSize))); }
// GET: Admin/Competitions public ActionResult Index() { var lstCompetition = _competitionRepository.GetAll().ToList(); return(View(lstCompetition)); }
public void ShouldExerciseCompetitionRepositoryNHibernate() { var league1 = new League("NHL", 1, null); var league2 = new League("NHL 2", 1, null); var leagueRepo = new LeagueRepository(new RepositoryNHibernate <League>()); var repo = new CompetitionRepository(new RepositoryNHibernate <Competition>()); var configRepo = new CompetitionConfigRepository(new RepositoryNHibernate <CompetitionConfig>()); var cc0 = new SeasonCompetitionConfig("Test B", league1, 1, 1, null, 1, null, null, null, null, null, null); var cc1 = new SeasonCompetitionConfig("Test 1", league1, 1, 1, null, 1, null, null, null, null, null, null); var c1 = new Season(cc1, "Test 1", 5, null, null, null, null, true, false, 5, 55); var cc2 = new PlayoffCompetitionConfig("P3", league1, 2, 25, null, 1, null, null, null, new List <CompetitionConfig> { cc1, cc0 }, null); var c8 = new Playoff(cc2, "P3", 5, 5, null, null, null, null, false, false, 5, 12); var c2 = new Season(null, "Test 2", 6, null, null, null, null, true, true, 5, 55); var c3 = new Season(null, "Test 3", 7, null, null, null, null, true, false, 5, 55); var c4 = new Season(cc1, "Test 4", 8, null, null, null, null, true, false, 5, 55); var c5 = new Season(null, "Test 5", 9, null, null, null, null, true, false, 5, 55); var c6 = new Playoff(null, "P1", 8, 5, null, null, null, null, true, false, 5, 12); var c7 = new Playoff(null, "P2", 8, 5, null, null, null, null, false, false, 5, 12); var c9 = new Playoff(cc2, "P9", 15, 5, null, null, null, null, false, false, 5, 12); var c10 = new Playoff(cc2, "P10", 15, 5, null, null, null, null, false, true, 5, 12); var c11 = new Playoff(cc2, "P11", 15, 5, null, null, null, null, true, false, 5, 12); var c12 = new Playoff(cc2, "P12", 15, 5, null, null, null, null, true, true, 5, 12); configRepo.Update(cc2); repo.Update(c1); repo.Update(c2); repo.Update(c3); repo.Update(c4); repo.Update(c5); repo.Update(c6); repo.Update(c7); repo.Update(c8); repo.Update(c9); repo.Update(c10); repo.Update(c11); repo.Update(c12); var c10Id = c10.Id; //getall StrictEqual(12, repo.GetAll().Count()); //GetByNameAndYear Equal("P3", repo.GetByNameAndYear("P3", 5).Name); //GetByYear StrictEqual(3, repo.GetByYear(8).Count()); //GetStartedAndUnfinishedCompetitionsByYear StrictEqual(2, repo.GetStartedAndUnfinishedCompetitionsByYear(8).Count()); StrictEqual(0, repo.GetStartedAndUnfinishedCompetitionsByYear(6).Count()); //IsCompetitionCompleteForYear False(repo.IsCompetitionCompleteForYear(5, cc1)); False(repo.IsCompetitionCompleteForYear(12, cc1)); //hasn't even been created yet! //GetParentCompetitionsForCompetitionConfig var parents = repo.GetParentCompetitionsForCompetitionConfig(cc2, 5).ToList(); StrictEqual(1, parents.Count()); Equal("Test 1", parents[0].Name); Equal(5, parents[0].Year); //GetCompetitionsForCompetitionConfig var competitionForConfig = repo.GetCompetitionForCompetitionConfig(cc2, 5); Equal("P3", competitionForConfig.Name); Equal(5, competitionForConfig.Year); var shouldBeNull = repo.GetCompetitionForCompetitionConfig(cc0, 5); Null(shouldBeNull); //IEnumerable<Competition> GetByLeagueAndYear(int leagueId, int year) StrictEqual(2, repo.GetByLeagueAndYear(league1.Id, 5).Count()); StrictEqual(1, repo.GetByLeagueAndYear(league1.Id, 8).Count()); StrictEqual(0, repo.GetByLeagueAndYear(league2.Id, 15).Count()); //IEnumerable<Competition> GetByLeagueAndYear(int leagueId, int year, bool started, bool finished) Equal("P9", repo.GetByLeagueAndYear(league1.Id, 15, false, false).First().Name); Equal("P10", repo.GetByLeagueAndYear(league1.Id, 15, false, true).First().Name); Equal("P11", repo.GetByLeagueAndYear(league1.Id, 15, true, false).First().Name); Equal("P12", repo.GetByLeagueAndYear(league1.Id, 15, true, true).First().Name); //IEnumerable<CompetitionSimpleViewModel> GetCompetitionsByYear(int year); Single(repo.GetByYear(9)); StrictEqual(2, repo.GetByYear(5).Count()); //Competition GetCompetition(long id); Equal("P10", repo.Get(c10Id).Name); }