public PouleViewModel GetPouleById(int id) { PouleViewModel poule = new PouleViewModel(); poule.playerResults = Database.Instance.resultRepository.GetResultsByPoule(id); if (poule.playerResults.Count == 0) { return(null); } poule.teamResults = Database.Instance.teamRepository.GetTeamsByPoule(id); poule.teamResults = poule.teamResults.OrderByDescending(m => m.averageRating).ToList(); return(poule); }
public ActionResult Details(int id) { var s = new Service.PouleService(); PouleViewModel model = s.GetPouleById(id); if (model == null) return NotFound(); string sortField = Request.QueryString["SorteerOp"]; string sortDir = Request.QueryString["Richting"]; if (String.IsNullOrEmpty(sortField)) { sortField = "Percentage"; sortDir = "Aflopend"; } if (!String.IsNullOrEmpty(sortField)) { if (String.IsNullOrEmpty(sortDir)) sortDir = "Oplopend"; switch (sortField) { case "Bondsnummer": if (sortDir.Equals("Oplopend")) model.playerResults = model.playerResults.OrderBy(m => m.playerNr).ToList(); else model.playerResults = model.playerResults.OrderByDescending(m => m.playerNr).ToList(); break; case "Speler": if (sortDir.Equals("Oplopend")) model.playerResults = model.playerResults.OrderBy(m => m.playerName).ToList(); else model.playerResults = model.playerResults.OrderByDescending(m => m.playerName).ToList(); break; case "Team": if (sortDir.Equals("Oplopend")) model.playerResults = model.playerResults.OrderBy(m => m.clubName).ThenBy(m => m.teamNumber).ToList(); else model.playerResults = model.playerResults.OrderByDescending(m => m.clubName).ThenByDescending(m => m.teamNumber).ToList(); break; case "Gespeeld": if (sortDir.Equals("Oplopend")) model.playerResults = model.playerResults.OrderBy(m => m.setsPlayed).ToList(); else model.playerResults = model.playerResults.OrderByDescending(m => m.setsPlayed).ToList(); break; case "Gewonnen": if (sortDir.Equals("Oplopend")) model.playerResults = model.playerResults.OrderBy(m => m.setsWon).ToList(); else model.playerResults = model.playerResults.OrderByDescending(m => m.setsWon).ToList(); break; case "Percentage": if (sortDir.Equals("Oplopend")) model.playerResults = model.playerResults.OrderBy(m => m.sortPercentage).ThenBy(m => m.setsWon).ToList(); else model.playerResults = model.playerResults.OrderByDescending(m => m.sortPercentage).ThenByDescending(m => m.setsWon).ToList(); break; case "Basisrating": if (sortDir.Equals("Oplopend")) model.playerResults = model.playerResults.OrderBy(m => m.baseRating).ToList(); else model.playerResults = model.playerResults.OrderByDescending(m => m.baseRating).ToList(); break; case "Rating": if (sortDir.Equals("Oplopend")) model.playerResults = model.playerResults.OrderBy(m => m.rating).ToList(); else model.playerResults = model.playerResults.OrderByDescending(m => m.rating).ToList(); break; case "Licentie": if (sortDir.Equals("Oplopend")) model.playerResults = model.playerResults.OrderBy(m => m.license).ToList(); else model.playerResults = model.playerResults.OrderByDescending(m => m.license).ToList(); break; case "TeamNaam": if (sortDir.Equals("Oplopend")) model.teamResults = model.teamResults.OrderBy(m => m.clubName).ThenBy(m => m.teamNumber).ToList(); else model.teamResults = model.teamResults.OrderByDescending(m => m.clubName).ThenByDescending(m => m.teamNumber).ToList(); break; case "TeamRating": if (sortDir.Equals("Oplopend")) model.teamResults = model.teamResults.OrderBy(m => m.averageRating).ToList(); else model.teamResults = model.teamResults.OrderByDescending(m => m.averageRating).ToList(); break; default: break; } } return View(model); }