// GET: Players
public ActionResult Index()
{
using (var context = new NBAContext())
{
var Players = from c in context.Players
select c;
return(View(Players));
}
}
public static bool Login(string username, string password)
{
using (NBAContext db = new NBAContext())
{
// comparison will be case insensitive
return(db.Users.Any(user => user.Username.Equals(username,
StringComparison.OrdinalIgnoreCase) && user.Password == password));
}
}
public HttpResponseMessage Get()
{
// if user does not exist - 401 returned...
// can utilize linq for custom queries if needed
using (NBAContext db = new NBAContext())
{
return(Request.CreateResponse(HttpStatusCode.OK, db.Players.ToList()));
}
}
public static void PrepareContext()
{
var options = new DbContextOptionsBuilder <NBAContext>().UseInMemoryDatabase(databaseName: "nbaDB").Options;
_context = new NBAContext(options);
PreparePlayers();
_context.SaveChanges();
}
// GET: Players/Details/5
public ActionResult Details(int id)
{
using (var context = new NBAContext())
{
var Players = from c in context.Players
where c.playerId == id
select c;
return(View(Players));
}
}
private void LoadData()
{
var db = new NBAContext();
var teams = from t in db.Teams
select new Team
{
Coach = t.Coach,
Division = t.Division,
DivisionId = t.DivisionId,
Logo = t.Logo,
TeamId = t.TeamId,
TeamName = t.TeamName,
};
var conferences = from c in db.Conferences
select new ConferenceModel()
{
ConferenceId = c.ConferenceId,
ConferenceName = c.Name,
Divisions = c.Divisions.ToList()
};
foreach (var c in conferences)
{
var tabPage = new TabPage {
Text = c.ConferenceName
};
var flwLayoutPanel = new FlowLayoutPanel();
foreach (var division in c.Divisions)
{
var divisionUserControl = new DivisionUserControl {
DivisionName = division.Name, Teams = division.Teams
};
divisionUserControl.LoadData();
flwLayoutPanel.Controls.Add(divisionUserControl);
}
flwLayoutPanel.Dock = DockStyle.Fill;
flwLayoutPanel.Anchor =
(AnchorStyles.Top | AnchorStyles.Bottom | AnchorStyles.Left | AnchorStyles.Right);
tabPage.Controls.Add(flwLayoutPanel);
tabControlConferences.TabPages.Add(tabPage);
}
}
public DetailPatientDoctorRepository(NBAContext nBAContext)
{
db = nBAContext;
}
public PatientRepository(NBAContext nBAContext)
{
db = nBAContext;
}
public ValuesController(IPlayerService playerService, IMemoryCache memoryCache, NBAContext _context)
{
unitOfWork _unitOfWork = new unitOfWork(_context);
_playerService = playerService;
_memoryCache = memoryCache;
}
public TeamsController(NBAContext db)
{
_db = db;
}
public ClienteRepository(NBAContext context)
{
_context = context;
}
public DoctorRepository(NBAContext nBAContext)
{
db = nBAContext;
}
public PedidosRepository(NBAContext context)
{
_context = context;
}
static void Main(string[] args)
{
INBAContext db = new NBAContext();
IUnitOfWork uw = new UnitOfWork(db);
IGetStatMethods _getStatMethods = new GetStatMethods(db);
IStatScraper _statScraper = new Api.Entities.StatScraper(db, uw, _getStatMethods);
IStatCalculator _statCalculator = new StatCalculator(db, _getStatMethods);
ISimulator _simulator = new Simulator(_statCalculator, _getStatMethods);
IPredictor _predictor = new Predictor(db, uw, _getStatMethods, _simulator, _statScraper);
//for (int i = 200; i < 707; i++)
//{
// IPredictor predictor=new Predictor(_getStatMethods,_simulator,_statScraper);
// predictor.PredictQuarter(1,i);
//}
//for (int i = 708; i < 972; i++)
//{
// IPredictor predictor = new Predictor(_getStatMethods, _simulator, _statScraper);
// predictor.PredictQuarter(1, i);
//}
//QuarterPredictions quarter1 = _simulator.QuarterSimulator(Team.MemphisGrizzlies, Team.LosAngelesLakers, 1, 87);
//QuarterPredictions quarter2 = _simulator.QuarterSimulator(Team.MemphisGrizzlies, Team.LosAngelesLakers, 2, 87);
//QuarterPredictions quarter3 = _simulator.QuarterSimulator(Team.MemphisGrizzlies, Team.LosAngelesLakers, 3, 87);
//QuarterPredictions quarter4 = _simulator.QuarterSimulator(Team.MemphisGrizzlies, Team.LosAngelesLakers, 4, 87);
////FullStatScraper
//List<GameTime> gamesPlayed = _statScraper.GetListOfGamesPlayed();
//using (var driver = new ChromeDriver())
//{
// driver.Manage().Window.Maximize();
// driver.Navigate().GoToUrl("https://www.nba.com/schedule");
// Thread.Sleep(2000);
// driver.FindElementByXPath("/html/body/div[2]/div[3]/div/div/div[2]/div/div/button").Click();
// foreach (var game in gamesPlayed)
// {
// if (game.GameNo == 16 || game.GameNo == 145 || game.GameNo == 154 || game.GameNo == 160 || game.GameNo == 166 || game.GameNo == 167 || game.GameNo == 171 || game.GameNo == 179 || game.GameNo == 183 || game.GameNo == 185 || game.GameNo == 194 || game.GameNo == 197 || game.GameNo == 199 || game.GameNo == 204 || game.GameNo == 215 || game.GameNo == 225 || game.GameNo == 235 || game.GameNo == 240 || game.GameNo == 255 || game.GameNo == 263 || game.GameNo == 264 || game.GameNo == 278 || game.GameNo == 321 || game.GameNo == 362 || game.GameNo == 428 || game.GameNo == 434 || game.GameNo == 435 || game.GameNo == 442 || game.GameNo == 448)
// continue;
// if (_statScraper.DoesGameExist(game.GameNo))
// continue;
// try
// {
// driver.Navigate().GoToUrl("https://www.nba.com/game/002200" + (game.GameNo).ToString("0000"));
// FullSeason stat = _statScraper.GameScraper(driver, game.GameNo);
// List<PlayerStats> stats = _statScraper.PlayerStatScraper(driver, game.GameNo);
// List<FullSeasonQuarters> quarters = new List<FullSeasonQuarters>();
// for (int l = 1; l < 5; l++)
// {
// FullSeasonQuarters quarter = _statScraper.QuarterScraper(driver, game.GameNo, l);
// quarters.Add(quarter);
// }
// _statScraper.AddStatGame(stat);
// _statScraper.AddPlayerStatList(stats);
// foreach (var quarter in quarters)
// {
// if (quarter.HomePoints > 50 || quarter.HomePoints < 10 || quarter.AwayPoints > 50 ||
// quarter.AwayPoints < 10)
// {
// return;
// }
// _statScraper.AddStatQuarter(quarter);
// }
// }
// catch (Exception)
// {
// }
// }
//}
////Quarter Predictor
//List<GameTime> gamesToBePlayed = _statScraper.GetListOfGamesToBePlayed();
//foreach (var game in gamesToBePlayed)
//{
// if (_statScraper.DoesQuarterPredictionExist(game.GameNo) || game.GameNo == 428 || game.GameNo == 434 || game.GameNo == 435 || game.GameNo == 442 || game.GameNo == 448)
// {
// continue;
// }
// for (int j = 1; j < 5; j++)
// {
// try
// {
// QuarterPredictions quarter = _simulator.QuarterSimulator(game.HomeTeam, game.AwayTeam, j, game.GameNo);
// _statScraper.AddQuarterPrediction(quarter);
// }
// catch (Exception)
// {
// }
// }
//}
////Game Predictor
//foreach (var game in gamesToBePlayed)
//{
// if (_statScraper.DoesGamePredictionExist(game.GameNo) || game.GameNo == 428 || game.GameNo == 434 || game.GameNo == 435 || game.GameNo == 442 || game.GameNo == 448)
// {
// continue;
// }
// GamePredictions gamePrediction = _simulator.FullMatchSimulator(game.HomeTeam, game.AwayTeam, game.GameNo);
// _statScraper.AddGamePrediction(gamePrediction);
//}
////FullGame Date Scraper
//int i = 22;
//int k = 9;
//for (; i < 23; i++)
//{
// using (var driver = new ChromeDriver())
// {
// for (; k < 25; k++)
// {
// if (game.GameNo >= 563)
// return;
// try
// {
// GameTime time = _statScraper.DateScraper(driver, game.GameNo,
// "https://www.nba.com/game/002200" + (game.GameNo).ToString("0000"));
// _statScraper.AddGameTime(time);
// }
// catch (Exception)
// {
// k--;
// }
// }
// }
// k = 0;
//}
////Quarters
//List<GameTime> games = _statScraper.GetListOfGamesPlayed();
//using (var driver = new ChromeDriver())
//{
// driver.Manage().Window.Maximize();
// driver.Navigate().GoToUrl("https://www.nba.com/schedule");
// Thread.Sleep(2000);
// driver.FindElementByXPath("/html/body/div[2]/div[3]/div/div/div[2]/div/div/button").Click();
// Thread.Sleep(1000);
// foreach (var game in games)
// {
// if (_statScraper.DoesQuarterExist(game.GameNo))
// continue;
// if (game.GameNo == 16 || game.GameNo == 145 || game.GameNo == 154 || game.GameNo == 160 || game.GameNo == 166 || game.GameNo == 167 || game.GameNo == 171 || game.GameNo == 179 || game.GameNo == 183 || game.GameNo == 185 || game.GameNo == 194 || game.GameNo == 197 || game.GameNo == 199 || game.GameNo == 204 || game.GameNo == 215 || game.GameNo == 225 || game.GameNo == 235 || game.GameNo == 240 || game.GameNo == 255 || game.GameNo == 263 || game.GameNo == 264 || game.GameNo == 278 || game.GameNo == 321)
// continue;
// driver.Navigate().GoToUrl("https://www.nba.com/game/002200" + (game.GameNo).ToString("0000") + "/box-score");
// List<FullSeasonQuarters> season = new List<FullSeasonQuarters>();
// for (int l = 1; l < 5; l++)
// {
// try
// {
//
// }
// catch (Exception)
// {
// l--;
// }
// }
// }
//}
////PlayerInfoScraper
//using (var driver = new ChromeDriver())
//{
// driver.Manage().Window.Maximize();
// List<Players> players = _statScraper.PlayerInfoScraper(driver, 1, 508);
// _statScraper.AddPlayerInfoList(players);
//}
////GameTimeUpdate
//for (int j = 0; j < 6; j++)
//{
// using (var driver = new ChromeDriver())
// {
// for (int i = 1; i <= 100; i++)
// {
// if (j * 100 + i == 16)
// continue;
// if (j * 100 + i < 133)
// {
// GameTime game = db.GameTime.Find(j * 100 + i);
// if (game.GameDate < DateTime.Now.AddHours(-8))
// {
// continue;
// }
// driver.Navigate().GoToUrl("https://www.nba.com/game/002200" + (j * 100 + i).ToString("0000") + "/box-score");
// if (i == 1)
// {
// Thread.Sleep(1000);
// driver.FindElementByXPath("/html/body/div[3]/div[3]/div/div/div[2]/div/div/button").Click();
// }
// game.AwayTeam = _statScraper.GetTeamEnumByTeamName(driver
// .FindElementByXPath("/html/body/div[1]/div[2]/div[5]/section[2]/div[1]/h1/span").Text.Replace(" ", "").ToUpper().Replace('İ', 'I'));
// game.HomeTeam = _statScraper.GetTeamEnumByTeamName(driver
// .FindElementByXPath("/html/body/div[1]/div[2]/div[5]/section[3]/div[1]/h1/span").Text.Replace(" ", "").ToUpper().Replace('İ', 'I'));
// uw.Commit();
// }
// else
// {
// GameTime game = db.GameTime.Find(j * 100 + i);
// driver.Navigate().GoToUrl("https://www.nba.com/game/002200" + (j * 100 + i).ToString("0000"));
// if (i == 1)
// {
// Thread.Sleep(1000);
// driver.FindElementByXPath("/html/body/div[3]/div[3]/div/div/div[2]/div/div/button").Click();
// }
// string teams = null;
// while (teams==null)
// {
// try
// {
// teams = driver
// .FindElementByXPath("/html/body/div[1]/div[2]/section/div[1]/div[5]/div/div[2]/h1")
// .Text;
// }
// catch (Exception e)
// {
// driver.Navigate().Refresh();
// }
// }
// string away = teams.Substring(0, teams.IndexOf('@') - 1).ToUpper().Replace('İ', 'I').Replace(" ","");
// string home = teams.Substring(teams.IndexOf('@') + 2).ToUpper().Replace('İ', 'I').Replace(" ", "");
// game.AwayTeam = _statScraper.GetTeamEnumByTeamMascotName(away);
// game.HomeTeam = _statScraper.GetTeamEnumByTeamMascotName(home);
// uw.Commit();
// }
// }
// }
//}
////FullGame 19-20
//int i = 0;
//int k = 1;
//try
//{
// int gameNo = _getStatMethods.GetLatestGameNoFullSeason1920();
// i = gameNo / 25;
// k = gameNo % 25 + 1;
//}
//catch (Exception)
//{
//}
//for (; i < 39; i++)
//{
// using (var driver = new ChromeDriver())
// {
// driver.Manage().Window.Maximize();
// driver.Navigate().GoToUrl("https://www.nba.com/schedule");
// Thread.Sleep(2000);
// driver.FindElementByXPath("/html/body/div[2]/div[3]/div/div/div[2]/div/div/button").Click();
// if (game.GameNo >= 971)
// return;
// for (; k < 25; k++)
// {
// if (game.GameNo >= 971)
// return;
// if (game.GameNo == 707)
// continue;
// try
// {
// FullSeason19_20 stat = _statScraper.GameScraper1920(driver, game.GameNo,
// "https://www.nba.com/game/002190" + (game.GameNo).ToString("0000"));
// _statScraper.AddStatGame(stat);
// }
// catch (Exception)
// {
// k--;
// }
// }
// }
// k = 0;
//}
////FullSeasonQuarters 19-20
//int i = 0;
//int k = 1;
//int j = 1;
//try
//{
// int quarterNo = _getStatMethods.GetLatestQuarterNoFullSeasonQuarters1920();
// int gameNo = _getStatMethods.GetLatestGameNoFullSeasonQuarters1920();
// if (quarterNo == 4)
// {
// j = 0;
// gameNo += 1;
// quarterNo = 0;
// }
// i = gameNo / 25;
// k = gameNo % 25;
// j = quarterNo + 1;
//}
//catch (Exception)
//{
//}
//for (; i < 39; i++)
//{
// using (var driver = new ChromeDriver())
// {
// driver.Manage().Window.Maximize();
// driver.Navigate().GoToUrl("https://www.nba.com/schedule");
// Thread.Sleep(2000);
// driver.FindElementByXPath("/html/body/div[2]/div[3]/div/div/div[2]/div/div/button").Click();
// driver.Manage().Window.Minimize();
// if (game.GameNo >= 971)
// return;
// for (; k < 25; k++)
// {
// if (game.GameNo >= 971)
// return;
// if (game.GameNo == 707)
// continue;
// try
// {
// driver.Navigate().GoToUrl("https://www.nba.com/game/002190" + (game.GameNo).ToString("0000") + "/box-score");
// List<FullSeasonQuarters19_20> stats = new List<FullSeasonQuarters19_20>();
// for (; j < 5; j++)
// {
// FullSeasonQuarters19_20 stat = _statScraper.QuarterScraper1920(driver, game.GameNo, j);
// stats.Add(stat);
// }
// foreach (var stat in stats)
// {
// _statScraper.AddStatQuarter(stat);
// }
// j = 1;
// }
// catch (Exception)
// {
// k--;
// }
// }
// }
// k = 0;
//}
////FullSeasonQuarters 19-20 Add-ons
//List<int> games = new List<int>();
//List<int> quarters = new List<int>();
//for (int l = 1; l < 971; l++)
//{
// if (l == 707)
// {
// continue;
// }
// for (int m = 1; m < 5; m++)
// {
// if (!_getStatMethods.QuarterExist1920(l, m))
// {
// games.Add(l);
// quarters.Add(m);
// }
// }
//}
//using (var driver = new ChromeDriver())
//{
// driver.Manage().Window.Maximize();
// driver.Navigate().GoToUrl("https://www.nba.com/schedule");
// Thread.Sleep(2000);
// driver.FindElementByXPath("/html/body/div[2]/div[3]/div/div/div[2]/div/div/button").Click();
// for (int l = 0; l < games.Count; l++)
// {
// FullSeasonQuarters19_20 stat = _statScraper.QuarterScraper1920(driver, games[l], quarters[l]);
// _statScraper.AddStatQuarter(stat);
// }
//}
////CoEfficientOptimizerGame
//for (int i = 0; i < 6561; i++)
//{
// _predictor.CoefficientOptimizerGame(i);
//}
////CoEfficientOptimizerQuarter
//for (int i = 0; i < 6561; i++)
//{
// _predictor.CoefficientOptimizerQuarter(i);
//}
}
public PlayersController(NBAContext db)
{
_db = db;
}