public static int GetPlayerId(string name, int teamId, sakilaEntities4 db) { var p = db.player.FirstOrDefault( x => x.TeamID == teamId && x.PlayerName.EndsWith(name)); if (p != null) { return(p.PlayerID); } var newPlayer = new PremierLeagueMainProject.PlayerDetails(); newPlayer.PlayerName = name; newPlayer.PlayerPosition = "NA"; //NA var playerId = AddPlayerToDb(newPlayer, db, teamId); return(playerId); }
public static int AddPlayerToDb(PremierLeagueMainProject.PlayerDetails p, sakilaEntities4 db, int teamId) { var positionId = GetPositionId(p.PlayerPosition); var pl = new player(); if (IsPlayerAlreadyExists(p.PlayerName, teamId, db, out pl)) { pl.TeamID = teamId; pl.PositionID = positionId; db.SaveChanges(); return(pl.PlayerID); } var newPlayer = new player(); newPlayer.PlayerName = p.PlayerName; newPlayer.PositionID = positionId; newPlayer.TeamID = teamId; db.player.Add(newPlayer); db.SaveChanges(); return(newPlayer.PlayerID); }
public static List <PremierLeagueMainProject.PlayerDetails> ExtractAllPlayers(CQ dom) { var toReturn = new List <PremierLeagueMainProject.PlayerDetails>(); var names = dom[".player-squadno a"].Select(x => x.Cq().Text()).ToList(); var positions = dom[".player-position"].Select(x => x.Cq().Text()).ToList(); if (names.Count != positions.Count) { throw new Exception(); } for (var i = 0; i < names.Count; i++) { var name = names[i]; var position = positions[i]; var p = new PremierLeagueMainProject.PlayerDetails(); p.PlayerName = name; p.PlayerPosition = position; toReturn.Add(p); } return(toReturn); }