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