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