private void FirstConnectionToDataBase()
{
using (var db = new PlayersContext())
{
db.Players.Load();
}
}
// GET: Sport
public ActionResult Index()
{
PlayersContext PlayersContext = new PlayersContext();
List <Sport> Sports = PlayersContext.Sports.ToList();
return(View(Sports));
}
public ActionResult Details(int SportID)
{
PlayersContext PlayersContext = new PlayersContext();
Players Players1 = PlayersContext.Players.Single(pl => pl.SportID == SportID);
return(View(Players1));
}
/// <summary>
/// Remove last player from DBSet
/// </summary>
/// <param name="db">PlayersContext object</param>
private static void RemoveLast(PlayersContext db)
{
var min = db.Players.Min(player => player.Score);
var lastPlayer = db.Players.Where(player => player.Score == min).OrderBy(player => player.Name).FirstOrDefault();
db.Players.Remove(lastPlayer);
}
public void ContextBuildsAViewModelWithAllPlayers()
{
var player = new Player {
Id = 1, FirstName = "First 1", LastName = "Last 1"
};
var playerViewModel = new PlayerViewModel {
Id = 1, FirstName = "First 1", LastName = "Last 1"
};
var players = new List <Player> {
player
};
var mockPlayerRepository = new MockPlayerRepository().StubGetAllToReturn(players);
var mockPlayerMapper = new MockPlayerMapper().StubMapToReturn(playerViewModel);
var playersContext = new PlayersContext(mockPlayerRepository, mockPlayerMapper);
var viewModel = playersContext.BuildViewModel();
Assert.NotNull(viewModel);
Assert.IsType <PlayersViewModel>(viewModel);
Assert.Equal(players.Count, viewModel.Players.Count());
var playerViewModels = viewModel.Players.ToList();
for (var i = 0; i < players.Count; i++)
{
Assert.Equal(players[i].Id, playerViewModels[i].Id);
Assert.Equal(players[i].FirstName, playerViewModels[i].FirstName);
Assert.Equal(players[i].LastName, playerViewModels[i].LastName);
}
mockPlayerRepository.VerifyGetAllCalled();
mockPlayerMapper.VerifyMapCalledWith(player);
}
// GET: Player
public ActionResult Index(int SportID)
{
PlayersContext PlayersContext = new PlayersContext();
List <Players> Players = PlayersContext.Players.Where(p => p.SportID == SportID).ToList();
return(View(Players));
}
public void CreatesAPlayersContext()
{
var mockPlayerRepository = new MockPlayerRepository();
var mockPlayerMapper = new MockPlayerMapper();
var playersContext = new PlayersContext(mockPlayerRepository, mockPlayerMapper);
Assert.NotNull(playersContext);
}
/// <summary>
/// Read players from database
/// </summary>
/// <returns>players</returns>
public static List <Player> GetPlayers()
{
using (var db = new PlayersContext())
{
db.Players.Load();
return(db.Players.ToList());
}
}
protected TestFixtureBase()
{
Context = PlayersContextFactory.Create();
var configProvider = new MapperConfiguration(cfg => { cfg.AddProfile <PlayersProfile>(); });
Mapper = configProvider.CreateMapper();
}
public void ContextBuildsAViewModel()
{
var mockPlayerRepository = new MockPlayerRepository();
var mockPlayerMapper = new MockPlayerMapper();
var playersContext = new PlayersContext(mockPlayerRepository, mockPlayerMapper);
var viewModel = playersContext.BuildViewModel();
Assert.NotNull(viewModel);
Assert.IsType <PlayersViewModel>(viewModel);
}
public static void Initialize(PlayersContext context)
{
context.Database.EnsureCreated();
if (!context.Players.Any())
{
context.Players.AddRange(GetPlayers());
context.SaveChanges();
}
}
public void ContextRemovesAPlayer()
{
var player = new Player {
Id = 1, FirstName = "First 2", LastName = "Last 2"
};
var mockPlayerRepository = new MockPlayerRepository().StubGetByToReturn(player);
var mockPlayerMapper = new MockPlayerMapper();
var playersContext = new PlayersContext(mockPlayerRepository, mockPlayerMapper);
playersContext.Remove(player.Id);
mockPlayerRepository.VerifyGetByCalledWith(player.Id);
mockPlayerRepository.VerifyRemoveCalledWith(player);
}
public List <Players> GetPlayers()
{
PlayersContext ctx = new PlayersContext();
List <Model.Players> players = ctx.Players.ToList();
List <Players> res = new List <Players>();
foreach (Model.Players pl in players)
{
Players player = new Players(pl.name, pl.sport, pl.country);
res.Add(player);
}
return(res);
}
public List <Players> GetPlayersByName(string name)
{
List <Players> res = new List <Players>();
using (PlayersContext db = new PlayersContext())
{
List <Model.Players> players = db.Players.Where(pl => pl.name.Contains(name)).ToList();
foreach (Model.Players pl in players)
{
Players player = new Players(pl.name, pl.sport, pl.country);
res.Add(player);
}
}
return(res);
}
public static PlayersContext Create()
{
var options = new DbContextOptionsBuilder <PlayersContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
var context = new PlayersContext(options);
context.Database.EnsureCreated();
context.Players.AddRange(new PlayersFactory().Players);
context.SaveChanges();
return(context);
}
/// <summary>
/// check if it need to add player into top-15
/// </summary>
/// <param name="currentScore">current score for check</param>
/// <returns>true if player enter in top-15</returns>
public static bool IsEntered(int currentScore)
{
using (var db = new PlayersContext())
{
//if count less then 15
db.Players.Load();
if (db.Players.Count() < Constants.MaxRecords)
{
return(true);
}
//if min score in db less then a current one
var min = db.Players.Min(player => player.Score);
return(min < currentScore ? true : false);
}
}
/// <summary>
/// Add new player into the database. Check for count of players and remove if needed
/// </summary>
/// <param name="player">player for add</param>
public static void AddPlayer(Player player)
{
using (var db = new PlayersContext())
{
//add player
db.Players.Load();
db.Players.Add(player);
//remove if needed
if (db.Players.Count() == Constants.MaxRecords)
{
RemoveLast(db);
}
db.SaveChanges();
}
}
public string InsertPlayer(Players player)
{
using (PlayersContext db = new PlayersContext())
{
Model.Players dbPlayer = db.Players.Where(pl => pl.name == player.Name && pl.sport == player.Sports && pl.country == player.Country).FirstOrDefault();
if (dbPlayer == null)
{
dbPlayer = new Model.Players();
dbPlayer.id = Guid.NewGuid();
dbPlayer.name = player.Name;
dbPlayer.country = player.Country;
dbPlayer.sport = player.Sports;
db.Players.Add(dbPlayer);
db.SaveChanges();
return(@"Игрок добавлен!");
}
else
{
return(@"Такой уже есть в базе!");
}
}
}
static void Main(string[] args)
{
var dbPlayers = new PlayersContext();
//var player1 = new Players
//{
// FullName = "Joe Jones",
// NickName = "JJ",
// PlayerNumber = "2",
// ThrowingArm = "Right",
//};
//var player2 = new Players
//{
// FullName = "Moe Money",
// NickName = "MM",
// PlayerNumber = "3",
// ThrowingArm = "Left",
//};
//var stpeteteam = new Teams
//{
// Mascot = "Seagulls",
// Colors = "Black and Yellow",
//};
//var tampateam = new Teams
//{
// Mascot = "Monkeys",
// Colors = "Mustard",
//};
//dbPlayers.Players.Add(player1);
//dbPlayers.Players.Add(player2);
//dbPlayers.Teams.Add(stpeteteam);
//dbPlayers.Teams.Add(tampateam);
// assign a existing team ID to a new Player
// query for team mascot
// update Teams ID
//var playerTeams = dbPlayers.Teams.First(team => team.Mascot == "Seagulls");
//var player3 = new Models.Players
//{
// FullName = "Kate Money",
// NickName = "KM",
// PlayerNumber = "13",
// ThrowingArm = "Left",
// TeamsID = playerTeams.Id
//};
//dbPlayers.Players.Add(player3);
//var game1 = new Models.Games
//{
// HomeTeamID = 1,
// AwayTeamID = 2,
// HomeScore = 20,
// AwayScore = 12,
// Date = new DateTime(2018, 04, 05),
// Notes = "Home Team advantage"
//};
//var game2 = new Models.Games
//{
// HomeTeamID = 2,
// AwayTeamID = 1,
// HomeScore = 15,
// AwayScore = 12,
// Date = new DateTime(2018, 04, 15),
// Notes = "Home Team was on point tonight"
//};
//var game3 = new Models.Games
//{
// HomeTeamID = 2,
// AwayTeamID = 1,
// HomeScore = 0,
// AwayScore = 0,
// Date = new DateTime(2018, 04, 28),
// Notes = ""
//};
//var game4 = new Models.Games
//{
// HomeTeamID = 1,
// AwayTeamID = 2,
// HomeScore = 0,
// AwayScore = 0,
// Date = new DateTime(2018, 05, 08),
// Notes = ""
//};
//dbPlayers.Games.Add(game1);
//dbPlayers.Games.Add(game2);
//dbPlayers.Games.Add(game3);
//dbPlayers.Games.Add(game4);
dbPlayers.SaveChanges();
//Update Player with Team ID
var player4 = dbPlayers.Players.First(f => f.PlayerNumber == "2");
player4.TeamsID = 2;
dbPlayers.SaveChanges();
var playerupdate = dbPlayers.Players.Where(p => p.FullName == "Moe Money");
foreach (var player in playerupdate)
{
player.TeamsID = 1;
}
dbPlayers.SaveChanges();
//Team Wins and Losses
var teamWins = dbPlayers.Teams.Select(games => new { games.Wins, games.Losses, games.Mascot });
foreach (var team in teamWins)
{
Console.WriteLine("Team Record for The " + team.Mascot + " is " + "Wins: " + team.Wins + " Losses, " + team.Losses);
}
//All Players and Team they are on
var playerTeamList = dbPlayers.Players.Include(i => i.Teams).Select(teams => new { teams.Teams, teams.FullName });
foreach (var player in playerTeamList)
{
Console.WriteLine("Player: " + player.FullName + " is on Team: " + player.Teams.Mascot);
}
//Upcoming Games
//this part is still not working ...
var futureGames = dbPlayers.Games.Include(i => i.Teams).Select(teams => new { teams.Teams, teams.Date });
//futureGames.Where(d => d.Date > DateTime.Today);
foreach (var futuregame in futureGames)
{
Console.WriteLine("Date of upcoming game: " + futuregame.Date);
//Console.WriteLine("Home Team: " + futuregame.HomeTeamsID + " Away Team: " + futuregame.AwayTeamsID);
}
}
public UnitOfWork(PlayersContext context)
{
_context = context;
}
public PlayersController(PlayersContext context, IWebHostEnvironment hostEnvironment)
{
_context = context;
this._hostEnvironment = hostEnvironment;
}
public PlayersContext GetInitiatedPlayersContext()
{
PlayersContext context = CreateContextAndMigrateDb();
MockedDataInstance = new MockedData
{
PlayerExternalIdForDelete = Guid.NewGuid().ToString(),
PlayerExternalIdForUpdate = Guid.NewGuid().ToString()
};
var playerForDelete = Player.Create("for delete", "for delete", externalId: MockedDataInstance.PlayerExternalIdForDelete);
var entityForDelete = context.Add(playerForDelete);
var playerForUpdate = Player.Create("for update", "for update", externalId: MockedDataInstance.PlayerExternalIdForUpdate);
var entityForUpdate = context.Add(playerForUpdate);
MockedDataInstance.ExistingPlayer = Guid.NewGuid().ToString();
MockedDataInstance.NotExistingPlayer = Guid.NewGuid().ToString();
var existingPlayer = Player.Create("exist", "d", externalId: MockedDataInstance.ExistingPlayer);
var entityOfExistingPlayer = context.Players.Add(existingPlayer);
Player p1 = Player.Create("p1", "p1");
Player p2 = Player.Create("p2", "p2");
Player p3 = Player.Create("p1", "p3");
Player p4 = Player.Create("p4", "p4");
Player p5 = Player.Create("p5", "p5");
Player p6 = Player.Create("p6", "p6");
Player p7 = Player.Create("p7", "p7");
Player p8 = Player.Create("p8", "p8");
Player p9 = Player.Create("p9", "p9");
Player p10 = Player.Create("p10", "p10");
var entityP1 = context.Add(p1);
var entityP2 = context.Add(p2);
var entityP3 = context.Add(p3);
var entityP4 = context.Add(p4);
var entityP5 = context.Add(p5);
var entityP6 = context.Add(p6);
var entityP7 = context.Add(p7);
var entityP8 = context.Add(p8);
var entityP9 = context.Add(p9);
var entityP10 = context.Add(p10);
context.SaveChanges();
int league1Id = 100;
int league2Id = 101;
var rates = new List <PlayerRate>
{
new PlayerRate(DateTime.UtcNow, "5.0", entityP1.Entity.Id, league1Id),
new PlayerRate(DateTime.UtcNow, "6.0", entityP1.Entity.Id, league2Id),
new PlayerRate(DateTime.UtcNow, "4.0", entityP2.Entity.Id, league1Id),
new PlayerRate(DateTime.UtcNow, "3.0", entityP2.Entity.Id, league2Id),
new PlayerRate(DateTime.UtcNow, "5.4", entityP3.Entity.Id, league1Id),
new PlayerRate(DateTime.UtcNow, "2.0", entityP3.Entity.Id, league2Id),
new PlayerRate(DateTime.UtcNow, "8.0", entityP4.Entity.Id, league1Id),
new PlayerRate(DateTime.UtcNow, "7.0", entityP4.Entity.Id, league2Id),
new PlayerRate(DateTime.UtcNow, "1.0", entityP5.Entity.Id, league1Id),
new PlayerRate(DateTime.UtcNow, "2.0", entityP5.Entity.Id, league2Id),
new PlayerRate(DateTime.UtcNow, "3.2", entityP6.Entity.Id, league1Id),
new PlayerRate(DateTime.UtcNow, "6.4", entityP6.Entity.Id, league2Id),
new PlayerRate(DateTime.UtcNow, "6.2", entityP7.Entity.Id, league1Id),
new PlayerRate(DateTime.UtcNow, "6.0", entityP7.Entity.Id, league2Id),
new PlayerRate(DateTime.UtcNow, "4.4", entityP8.Entity.Id, league1Id),
new PlayerRate(DateTime.UtcNow, "1.2", entityP8.Entity.Id, league2Id),
new PlayerRate(DateTime.UtcNow, "3.2", entityP9.Entity.Id, league1Id),
new PlayerRate(DateTime.UtcNow, "6.9", entityP9.Entity.Id, league2Id),
new PlayerRate(DateTime.UtcNow, "8.0", entityP10.Entity.Id, league1Id),
new PlayerRate(DateTime.UtcNow, "6.8", entityP10.Entity.Id, league2Id),
};
context.PlayerRates.AddRange(rates);
context.SaveChanges();
MockedDataInstance.PlayerInternalIdForDelete = entityForDelete.Entity.Id;
MockedDataInstance.PlayerInternalIdForUpdate = entityForUpdate.Entity.Id;
MockedDataInstance.ExistingPlayerInternalId = entityOfExistingPlayer.Entity.Id;
MockedDataInstance.LeagueForFilter1 = league1Id;
MockedDataInstance.PlayerForFilter1 = entityP1.Entity.Id;
MockedDataInstance.PlayerForFilter2 = entityP2.Entity.Id;
return(context);
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, PlayersContext playersContext)
{
loggerFactory.AddConsole(Configuration.Logging);
loggerFactory.AddDebug();
playersContext.Database.Migrate();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseBrowserLink();
}
else
{
app.UseExceptionHandler("/Home/Error");
}
app.UseStaticFiles();
app.UseSession();
app.UseMvc(routes =>
{
foreach (var item in Configuration.Routes)
{
routes.MapRoute(item);
}
routes.MapRoute("fallback", "{*whatever}", new { controller = "Home", action = "Index" });
});
}
public LigaRepository(PlayersContext context) : base(context)
{
}
public KlubRepository(PlayersContext context) : base(context)
{
}
public PlayerProvider(PlayersContext playersContext)
{
this.playersContext = playersContext;
}
public static void Destroy(PlayersContext context)
{
context.Database.EnsureDeleted();
context.Dispose();
}
public DrzavaRepository(PlayersContext context) : base(context)
{
}
public GenericRepository(PlayersContext context)
{
_context = context;
_dbSet = _context.Set <T>();
}
public IgracRepository(PlayersContext context) : base(context)
{
}
