//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"));
}
}
