void GetMatches(PubgPlayer player) { var list = new List <PlayerMatch>(); using (var con = new PubgDbContext()) { foreach (var matchId in player.MatchIds) { var matchFound = con.Matches.Find(matchId); if (matchFound == null) { matchFound = PubgHelper.GetPubgMatch(matchId); } else { con.Matches.Attach(matchFound); } list.Add(new PlayerMatch() { Player = this, Match = matchFound }); } Matches = list; } }
public static List <Player> GetPlayersByName(string[] names) { var players = new List <Player>(); using (var con = new PubgDbContext()) { foreach (var name in names) { Player player; player = con.Players .Include(s => s.SoloStats) .Include(d => d.DuoStats) .Include(s => s.SquadStats) .Where(p => p.Name == name) .FirstOrDefault(); if (player == null) { player = new Player(name: name); } if (player.Id != null) { players.Add(player); } } } return(players); }
public static Player GetPlayerByName(string name) { Player player; using (var con = new PubgDbContext()) { player = con.Players .Include(s => s.SoloStats) .Include(d => d.DuoStats) .Include(s => s.SquadStats) .Where(p => p.Name == name) .FirstOrDefault(); } if (player == null) { player = new Player(name: name); } return(player); }
public void Save() { using (var con = new PubgDbContext()) { var player = con.Players.Find(Id); if (player == null) { con.Players.Add(this); con.SaveChanges(); } else { player.SoloStats = SoloStats; player.DuoStats = DuoStats; player.SquadStats = SquadStats; player.CurrentSeasionLastUpdate = CurrentSeasionLastUpdate; con.Players.Update(player); con.SaveChanges(); } } }