public void SaveHighLevelStatsForPlayer(Models.PlayerStats PlayerModel) { using (var db = new Models.PlayerStats()) { db.Players.Add(new Models.Players { PlayerID = PlayerModel.tempPlayers.PlayerID, TeamID = PlayerModel.tempPlayers.TeamID, PlayerName = PlayerModel.tempPlayers.PlayerName }); db.SaveChanges(); } }
public void SavePlayerBasicInfo(Models.PlayerStats PlayerModel) { using (var db = new Models.PlayerStats()) { db.Players.Add(new Models.Players { PlayerID = PlayerModel.tempPlayers.PlayerID, TeamID = PlayerModel.tempPlayers.TeamID, PlayerName = PlayerModel.tempPlayers.PlayerName }); db.SaveChanges(); } }
public void ProcessPlayerHighLevelStats() { _driver.Navigate().GoToUrl(this.startURL); System.Threading.Thread.Sleep(1000); var teamList = _driver.FindElementsByClassName("division-standing"); //var rostersBtn = driver.FindElementByXPath("//*[contains(text(), 'Rosters')]"); //rostersBtn.Click(); for (int i = 0; i < teamList.Count - 1; i++) { var newTeamList = _driver.FindElementsByClassName("division-standing"); var newTeamID = newTeamList[i].GetAttribute("to"); //Enter into team details newTeamList[i].Click(); System.Threading.Thread.Sleep(2000); //Table of all names in the team var Players = _driver.FindElementByClassName("table-responsive"); var singlePlayers = Players.FindElements(By.TagName("tr")); for (int j = 0; j < singlePlayers.Count - 1; j++) { try { var player = singlePlayers[j].FindElements(By.TagName("td")); Models.PlayerStats PlayerModel = new Models.PlayerStats(); PlayerModel.tempPlayers = new Models.Players(); var playerdiv = player[0].FindElements(By.TagName("div")); PlayerModel.tempPlayers.PlayerName = playerdiv[0].Text; PlayerModel.tempPlayers.PlayerID = Convert.ToInt32(playerdiv[1].Text.Replace("#", "")); PlayerModel.tempPlayers.TeamID = Convert.ToInt32(newTeamID.ToString().Replace("/oc/team/", "")); //PlayerModel.SkillLevel = player[1].Text; //PlayerModel.MatchsWonPlayed = player[2].Text; //PlayerModel.WinPercentage = player[3].Text; //PlayerModel.PointPerMatch = player[4].Text; //PlayerModel.PointsAgainst = player[5].Text; _IPlayerRepo.SavePlayerBasicInfo(PlayerModel); } catch (Exception ex) { } } //Back to Team List _driver.Navigate().Back(); System.Threading.Thread.Sleep(2000); } }