public List <Player> GetPlayerPool()
        {
            PlayerFactory factory;

            using (var db = new FMDraftEntities1())
            {
                foreach (string division in divisions)
                {
                    var players = from p in db.Players
                                  where p.Clubs.Divisions.DivisionName.Equals(division)
                                  select p;
                    foreach (var player in players)
                    {
                        if (player.Position.Equals("GK"))
                        {
                            factory = GoalkeeperFactory.GetInstance();
                            playerPool.Add(factory.GetPlayer(player, valuta));
                        }
                        else
                        {
                            factory = OutfieldPlayerFactory.GetInstance();
                            playerPool.Add(factory.GetPlayer(player, valuta));
                        }
                    }
                }
            }
            return(playerPool);
        }
        public static Dictionary <string, Formation> GetFormations()
        {
            Dictionary <string, Formation> formations = new Dictionary <string, Formation>();

            using (FMDraftEntities1 db = new FMDraftEntities1())
            {
                var formationQuery = from c in db.Formations
                                     select c;
                foreach (var f in formationQuery)
                {
                    Formation formation = new Formation(f.ForTitle, f.For2, f.For3, f.For4, f.For5, f.For6, f.For7, f.For8, f.For9, f.For10, f.For11);


                    formations.Add(f.ForTitle, formation);
                }
            }
            return(formations);
        }
        public static List <Division> GetDivisionList()
        {
            List <Division> divisions = new List <Division>();

            using (FMDraftEntities1 db = new FMDraftEntities1())
            {
                var divisionQuery = from c in db.Divisions
                                    select c;
                foreach (var d in divisionQuery)
                {
                    Division division = new Division
                    {
                        Name   = d.DivisionName,
                        Nation = d.Based
                    };


                    divisions.Add(division);
                }
            }
            return(divisions);
        }