public PlayerWindow(HockeyContext dbContext, MainWindow mainWindow, Player player) { // Predana instancia db kontextu _dbContext = dbContext; _mainWindow = mainWindow; InitializeComponent(); // Naplnim si hodnoty vekovej kategorie do combobox DataAgeCategories = Enum.GetValues(typeof(AgeCategory)); ComboBoxAgeCategories.ItemsSource = DataAgeCategories; // Naplnim si hodnoty nazvov klubov do combobox DataClubs = _dbContext.GetClubsName().ToList(); ComboBoxClubs.ItemsSource = DataClubs; // Ak je nastaveny player, je to editaca if (player != null) { TextBoxKrp.Text = player.KrpId.ToString(); TextBoxTitleBefore.Text = player.TitleBefore; TextBoxFirstName.Text = player.FirstName; TextBoxLastName.Text = player.LastName; TextBoxYearOfBirth.Text = player.YearOfBirth.ToString(); ComboBoxAgeCategories.SelectedItem = player.AgeCategory; ComboBoxClubs.SelectedItem = player.Club.Name; } }
private List <Player> getPlayers(HockeyContext context) { List <Player> players = new List <Player>() { new Player() { JerseyNumber = 70, FirstName = "Kevin", Position = "Goalie", Country = "Canada", TeamId = context.Teams.FirstOrDefault(t => t.Name == "Canucks").TeamId }, new Player() { JerseyNumber = 45, FirstName = "Keanu", Position = "Right Wing", Country = "Africa", TeamId = context.Teams.FirstOrDefault(t => t.Name == "Canucks").TeamId }, new Player() { JerseyNumber = 23, FirstName = "Bill", Position = "Center", Country = "Argentina", TeamId = context.Teams.FirstOrDefault(t => t.Name == "Canucks").TeamId }, new Player() { JerseyNumber = 33, FirstName = "John", Position = "Goalie", Country = "France", TeamId = context.Teams.FirstOrDefault(t => t.Name == "Sharks").TeamId }, new Player() { JerseyNumber = 103, FirstName = "Will", Position = "Right Wing", Country = "Jumbilaya", TeamId = context.Teams.FirstOrDefault(t => t.Name == "Sharks").TeamId }, new Player() { JerseyNumber = 72, FirstName = "Johnny", Position = "Center", Country = "France", TeamId = context.Teams.FirstOrDefault(t => t.Name == "Sharks").TeamId } }; return(players); }
public MainWindow() { InitializeComponent(); // Zalozim si db kontext _dbContext = new HockeyContext(); // Ako prve si selektnem vsetkych hracov (nefiltrovanych) RefreshListPlayers(); }
static void Main(string[] args) { var clubFlag = false; var playersFlag = false; var clearDatabase = false; var clubsPath = ""; var playersPath = ""; CheckArgs(args, ref clubFlag, ref playersFlag, ref clubsPath, ref playersPath, ref clearDatabase); var clubs = new List <Club>(); var players = new List <Player>(); if (clubFlag && !string.IsNullOrWhiteSpace(clubsPath)) { ReadClubs(ref clubs, clubsPath); } if (playersFlag && !string.IsNullOrWhiteSpace(playersPath)) { ReadPlayers(ref players, playersPath, ref clubs); } #region InicializationDB using (var db_context = new HockeyContext()) { if (clearDatabase) { db_context.Database.ExecuteSqlCommand("DELETE FROM Player"); db_context.Database.ExecuteSqlCommand("DELETE FROM Club"); } foreach (var club in clubs) { db_context.Clubs.Add(club); } foreach (var player in players) { db_context.Players.Add(player); } db_context.SaveChanges(); foreach (var club in db_context.GetClubs()) { Console.WriteLine(club); } foreach (var player in db_context.GetPlayers()) { Console.WriteLine(player); } } Console.WriteLine("DB Loaded!"); Console.ReadLine(); #endregion }
static void Main(string[] args) { Console.WriteLine("HockeyPlayerDatabase - import dat"); dbContext = new HockeyContext(); try { // nacitanie argumentov, na poradi nezalezi var order = 0; foreach (var arg in args) { if (arg == "-clubs") { clubsCsvPath = args[order + 1]; } else if (arg == "-players") { playersCsvPath = args[order + 1]; } order++; } // zmazat data ak je nastaveny argument if (args.Contains("-clearDatabase")) { dbContext.ClearDatabase(); } FileHelperEngine <ClubsHeader> engineClubs = new FileHelperEngine <ClubsHeader>(); ImportClubs(engineClubs, clubsCsvPath); FileHelperEngine <PlayersHeader> enginePlayers = new FileHelperEngine <PlayersHeader>(); ImportPlayers(enginePlayers, playersCsvPath); } catch (Exception e) { Console.WriteLine($"Neocakavana chyba pri spracovani importu: {e}"); } Console.WriteLine("Import bol uspesne dokonceny."); Console.ReadLine(); }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, HockeyContext context, IBackgroundJobClient backgroundJobs, IHostingEnvironment env) { context.Database.EnsureCreated(); DbInitializer dbInitializer = new DbInitializer(context); dbInitializer.FetchApiData().Wait(); dbInitializer.ConfigurePlayerRanks().Wait(); app.UseHangfireDashboard(); RecurringJob.AddOrUpdate(() => dbInitializer.FetchUpdatedStats(), "0 23 * * *", TimeZoneInfo.Local); RecurringJob.AddOrUpdate(() => dbInitializer.FetchUpdatedOveralls(), "0 23 * * 3", TimeZoneInfo.Local); if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } else { app.UseExceptionHandler("/Home/Error"); // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts. app.UseHsts(); } app.UseHttpsRedirection(); app.UseStaticFiles(); app.UseCookiePolicy(); app.UseAuthentication(); app.UseMvc(routes => { routes.MapRoute( name: "default", template: "{controller=Home}/{action=Index}/{id?}"); }); }
private List <Player> getPlayers(HockeyContext context) { List <Player> players = new List <Player>() { new Player() { JerseyNumber = 70, FirstName = "Bob", LastName = "Smith", Position = "Goalie", Country = "Canada", TeamId = context.Teams.FirstOrDefault(t => t.Name == "Canucks").TeamId }, new Player() { JerseyNumber = 45, FirstName = "Tom", LastName = "Jones", Position = "Right Wing", Country = "Sweeden", TeamId = context.Teams.FirstOrDefault(t => t.Name == "Canucks").TeamId }, new Player() { JerseyNumber = 23, FirstName = "Bill", LastName = "Stevens", Position = "Center", Country = "Finland", TeamId = context.Teams.FirstOrDefault(t => t.Name == "Canucks").TeamId }, new Player() { JerseyNumber = 33, FirstName = "Joe", LastName = "Barker", Position = "Goalie", Country = "USA", TeamId = context.Teams.FirstOrDefault(t => t.Name == "Oilers").TeamId }, new Player() { JerseyNumber = 103, FirstName = "Tim", LastName = "Stewart", Position = "Defense", Country = "Switzerland", TeamId = context.Teams.FirstOrDefault(t => t.Name == "Oilers").TeamId }, new Player() { JerseyNumber = 73, FirstName = "Jason", LastName = "Gregory", Position = "Left Wing", Country = "France", TeamId = context.Teams.FirstOrDefault(t => t.Name == "Oilers").TeamId }, }; return(players); }
public HomeController(HockeyContext context) { _context = context; }
public SeasonController(HockeyContext context, UserManager <User> userManager) { _context = context; _userManager = userManager; }
public MainController(HockeyContext context) { _context = context; }
public DbInitializer(HockeyContext context) { _context = context; }