public static List<RefereesMatch> GetAllRefereesInMatches(int id)
{
FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();
return db.RefereesMatches.Where(m => m.MatchID == id).ToList();
}
public static List<Owner> GetTeamOwner()
{
FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();
return db.Owners.ToList();
}
public static List<Stadium> GetAllStadiums()
{
FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();
return db.Stadiums.ToList();
}
public static List<Sponsor> GetTeamSponsor()
{
FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();
return db.Sponsors.ToList();
}
public static List<Coach> GetTeamCoach()
{
FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();
return db.Coaches.ToList();
}
public static List<PlayersTeam> GetAllPlayersInTeams(int id)
{
FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();
return db.PlayersTeams.Where(p => p.TeamID == id ).ToList();
}
public static List<FootballMatch> GetAllMatches()
{
FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();
return db.FootballMatches.ToList();
}
public static List<Player> GetAllPlayers()
{
FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();
return db.Players.ToList();
}
public static List<Tournament> GetAllTournaments()
{
FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();
return db.Tournaments.ToList();
}
public static List<OwnersTeam> GetAllOwnersInTeams(int id)
{
FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();
return db.OwnersTeams.Where(o => o.TeamID == id).ToList();
}
public static List<Country> GetAllCountries()
{
FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();
return db.Countries.ToList();
}
public static List<Referee> GetAllReferees()
{
FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();
return db.Referees.ToList();
}
public static List<FootballAssociation> GetAllAssociations()
{
FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();
return db.FootballAssociations.ToList();
}
public static List<StadiumsTeam> GetAllStadiumsInTeams(int id)
{
FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();
return db.StadiumsTeams.Where(s => s.TeamID == id).ToList();
}
public static List<CoachesTeam> GetAllCoachesInTeams(int id)
{
FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();
return db.CoachesTeams.Where(c => c.TeamID == id).ToList();
}
public ActionResult TeamDetails(int id)
{
FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();
Team team = db.Teams.SingleOrDefault(t => t.TeamID == id);
return View(team);
}
public static List<Team> GetAllTeams()
{
FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();
return db.Teams.ToList();
}