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();

        }
示例#3
0
        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();
        
        }
示例#8
0
       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();
        
        }
示例#11
0
        public static List<Country> GetAllCountries()
        {
            FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();

            return db.Countries.ToList();
        
        }
示例#12
0
        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();
        
        }
示例#16
0
 public ActionResult TeamDetails(int id)
 {
     FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();
     Team team = db.Teams.SingleOrDefault(t => t.TeamID == id);
     return View(team);
 }
示例#17
0
        public static List<Team> GetAllTeams()
        {
            FootballZoneMVC4Entities db = new FootballZoneMVC4Entities();

            return db.Teams.ToList();
        }