//Show one Team public ActionResult Show(int id) { // Retrieve data from a specific Team: string team_query = "SELECT * FROM teams WHERE teamID = @id"; var parameter = new SqlParameter("@id", id); Team team = db.Teams.SqlQuery(team_query, parameter).FirstOrDefault(); Debug.WriteLine("Query: " + team_query); // Find all Players that play on a specific Team string player_query = "SELECT * FROM players WHERE teamID=@id"; var fk_parameter = new SqlParameter("@id", id); List <Player> PlayerRoster = db.Players.SqlQuery(player_query, fk_parameter).ToList(); //ViewModels: // 1. Show team data // 2. Show all players on that team ShowTeam viewmodel = new ShowTeam(); viewmodel.Team = team; viewmodel.Players = PlayerRoster; return(View(viewmodel)); }
// GET: Team/Details/5 public ActionResult Details(int id) { ShowTeam ViewModel = new ShowTeam(); ViewModel.isadmin = User.IsInRole("Admin"); ViewModel.isfan = User.IsInRole("Fan"); ViewModel.userid = User.Identity.GetUserId(); string url = "teamdata/findteam/" + id; HttpResponseMessage response = client.GetAsync(url).Result; //Can catch the status code (200 OK, 301 REDIRECT), etc. //Debug.WriteLine(response.StatusCode); if (response.IsSuccessStatusCode) { //Put data into Team data transfer object TeamDto SelectedTeam = response.Content.ReadAsAsync <TeamDto>().Result; ViewModel.team = SelectedTeam; //Grab the sport associated with this team url = "TeamData/FindSportForTeam/" + id; response = client.GetAsync(url).Result; //Can catch the status code (200 OK, 301 REDIRECT), etc. //Debug.WriteLine(response.StatusCode); SportDto Sport = response.Content.ReadAsAsync <SportDto>().Result; ViewModel.sport = Sport; //We don't need to throw any errors if this is null //A team not having any players is not an issue. url = "teamdata/getplayersforteam/" + id; response = client.GetAsync(url).Result; //Can catch the status code (200 OK, 301 REDIRECT), etc. //Debug.WriteLine(response.StatusCode); IEnumerable <PlayerDto> SelectedPlayers = response.Content.ReadAsAsync <IEnumerable <PlayerDto> >().Result; ViewModel.teamplayers = SelectedPlayers; url = "teamdata/getsponsorsforteam/" + id; response = client.GetAsync(url).Result; //Can catch the status code (200 OK, 301 REDIRECT), etc. //Debug.WriteLine(response.StatusCode); //Put data into Team data transfer object IEnumerable <SponsorDto> SelectedSponsors = response.Content.ReadAsAsync <IEnumerable <SponsorDto> >().Result; ViewModel.teamsponsors = SelectedSponsors; //Grab the messages of support for this team url = "supportdata/getsupportsforteam/" + id; response = client.GetAsync(url).Result; IEnumerable <SupportDto> SupportMessages = response.Content.ReadAsAsync <IEnumerable <SupportDto> >().Result; ViewModel.supportmessages = SupportMessages; return(View(ViewModel)); } else { return(RedirectToAction("Error")); } }
// GET: Team/Details/5 public ActionResult Details(int id) { ShowTeam ViewModel = new ShowTeam(); string url = "teamdata/findteam/" + id; HttpResponseMessage response = client.GetAsync(url).Result; //Can catch the status code (200 OK, 301 REDIRECT), etc. //Debug.WriteLine(response.StatusCode); if (response.IsSuccessStatusCode) { //Put data into Team data transfer object TeamDto SelectedTeam = response.Content.ReadAsAsync <TeamDto>().Result; ViewModel.team = SelectedTeam; //We don't need to throw any errors if this is null //A team not having any players is not an issue. url = "teamdata/getplayersforteam/" + id; response = client.GetAsync(url).Result; //Can catch the status code (200 OK, 301 REDIRECT), etc. //Debug.WriteLine(response.StatusCode); IEnumerable <PlayerDto> SelectedPlayers = response.Content.ReadAsAsync <IEnumerable <PlayerDto> >().Result; ViewModel.teamplayers = SelectedPlayers; url = "teamdata/getsponsorsforteam/" + id; response = client.GetAsync(url).Result; //Can catch the status code (200 OK, 301 REDIRECT), etc. //Debug.WriteLine(response.StatusCode); //Put data into Team data transfer object IEnumerable <SponsorDto> SelectedSponsors = response.Content.ReadAsAsync <IEnumerable <SponsorDto> >().Result; ViewModel.teamsponsors = SelectedSponsors; return(View(ViewModel)); } else { return(RedirectToAction("Error")); } }
// GET: Team/Details/5 public ActionResult Details(int id) { ShowTeam ViewModel = new ShowTeam(); string url = "teamdata/findteam/" + id; HttpResponseMessage response = client.GetAsync(url).Result; if (response.IsSuccessStatusCode) { //Put data into Team data transfer object TeamDto SelectedTeam = response.Content.ReadAsAsync <TeamDto>().Result; ViewModel.team = SelectedTeam; url = "teamdata/getplayersforteam/" + id; response = client.GetAsync(url).Result; IEnumerable <PlayerDto> SelectedPlayers = response.Content.ReadAsAsync <IEnumerable <PlayerDto> >().Result; ViewModel.teamplayers = SelectedPlayers; return(View(ViewModel)); } else { return(RedirectToAction("Error")); } }