public void savePlayer(int playerId, string playerName, string playerPositionCode, string playerHW) { using (var context = new ModelTrophy()) { context.Players.Add(new Player { Id = playerId, Name = playerName, PositionCode = playerPositionCode, TrophyCode = playerHW }); context.SaveChanges(); } }
public IEnumerable <Player> getPlayers() { using (var context = new ModelTrophy()) { var player = from playerDict in context.Players orderby playerDict.PositionCode select playerDict; if (player.Any()) { return(player.ToList()); } } return(null); }
public Player getPlayerById(string playerId) { using (var context = new ModelTrophy()) { var player = from playerDict in context.Players where playerDict.TrophyCode == playerId select playerDict; if (player.Any()) { return(player.First()); } } return(null); }
private void button1_Click(object sender, EventArgs e) { var connectionString = ConfigurationManager.ConnectionStrings["ModelTrophy"].ConnectionString; using (var context = new ModelTrophy(connectionString)) { // Age new ContextBroker().saveSkillInDictionary(1, "age", "Age", "Wiek"); // ASI new ContextBroker().saveSkillInDictionary(2, "asi", "ASI", "ASI"); // Routine new ContextBroker().saveSkillInDictionary(3, "routine", "Routine", "Doświadczenie"); // Strength new ContextBroker().saveSkillInDictionary(4, "str", "Strength", "Siła"); // Stamina new ContextBroker().saveSkillInDictionary(5, "sta", "Stamina", "Wytrzymałość"); // Pace new ContextBroker().saveSkillInDictionary(6, "pac", "Pace", "Szybkość"); // Marking new ContextBroker().saveSkillInDictionary(7, "mar", "Marking", "Krycie"); // Tacking new ContextBroker().saveSkillInDictionary(8, "tac", "Tacking", "Odbiór"); // Workrate new ContextBroker().saveSkillInDictionary(9, "wor", "Workrate", "Pracowitość"); // Positioning new ContextBroker().saveSkillInDictionary(10, "pos", "Positioning", "Ustawianie się"); // Passing new ContextBroker().saveSkillInDictionary(11, "pas", "Passing", "Podania"); // Crossing new ContextBroker().saveSkillInDictionary(12, "cro", "Crossing", "Dośrodkowania"); // Technique new ContextBroker().saveSkillInDictionary(13, "tec", "Technique", "Technika"); // Heading new ContextBroker().saveSkillInDictionary(14, "hea", "Heading", "Główkowanie"); // Finishing new ContextBroker().saveSkillInDictionary(15, "fin", "Finishing", "Wykańczanie"); // Longshots new ContextBroker().saveSkillInDictionary(16, "log", "Longshots", "Strzały z dystansu"); // Set Pieces new ContextBroker().saveSkillInDictionary(17, "set", "Set Pieces", "Stałe fragmenty"); // Handing new ContextBroker().saveSkillInDictionary(18, "han", "Handing", "Łapanie"); // One-on-ones new ContextBroker().saveSkillInDictionary(19, "one", "One-on-ones", "Jeden na jednego"); // Reflexes new ContextBroker().saveSkillInDictionary(20, "ref", "Reflexes", "Refleks"); // Aerial Ability new ContextBroker().saveSkillInDictionary(21, "ari", "Aerial Ability", "Gra w powietrzu"); // Jumping new ContextBroker().saveSkillInDictionary(22, "jum", "Jumping", "Skoczność"); // Communication new ContextBroker().saveSkillInDictionary(23, "com", "Communication", "Komunikacja"); // Kicking new ContextBroker().saveSkillInDictionary(24, "kic", "Kicking", "Wykop"); // Throwing new ContextBroker().saveSkillInDictionary(25, "thr", "Throwing", "Rzucanie"); } }