private static League CreateLeagueIfNotExists(FootballContext context, XElement xLeague)
{
League league = null;
var xElementLeagueName = xLeague.Element("league-name");
if (xElementLeagueName != null)
{
string leagueName = xElementLeagueName.Value;
league = context.Leagues.FirstOrDefault(l => l.LeagueName == leagueName);
if (league != null)
{
Console.WriteLine("Existing league: {0}", leagueName);
}
else
{
// Create a new league in the DB
league = new League()
{
LeagueName = leagueName
};
context.Leagues.Add(league);
context.SaveChanges();
Console.WriteLine("Created league: {0}", leagueName);
}
}
return(league);
}
public void EditTeam()
{
string expected = "Changed";
string result;
Teams NewTeam;
using (var db = new FootballContext())
{
Teams newTeam = new Teams
{
TeamName = "Test"
};
db.Teams.Add(newTeam);
NewTeam = newTeam;
db.SaveChanges();
}
CRUDManager.Program.SaveTeam(NewTeam, NewTeam.TeamName, 0, 0, 0, 0, 0, 0, new List <Players>());
using (var db = new FootballContext())
{
var newTeam =
db.Teams.Where(o => o.TeamId == NewTeam.TeamId).FirstOrDefault();
var teamStats =
db.TeamStatistics.Where(o => o.TeamId == NewTeam.TeamId).FirstOrDefault();
result = newTeam.TeamName;
db.Remove(teamStats);
db.Remove(newTeam);
db.SaveChanges();
}
Assert.AreEqual(result, expected);
}
public IActionResult PlayerPage(int id)
{
using (FootballContext db = new FootballContext(connString)) {
Player player = db.Players.Find(id);
return(View(player));
}
}
public void Execute()
{
_contextOptions = new DbContextOptionsBuilder <FootballContext>()
.UseSqlServer(@"Server=tcp:qdijnzq4jx.database.windows.net,1433;Initial Catalog=Football;Persist Security Info=False;User ID=lordpiti@qdijnzq4jx;Password=Kidswast1;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;")
.Options;
var context = new FootballContext((DbContextOptions <FootballContext>)_contextOptions);
var b = context.Calendario;
foreach (var item in b)
{
var matchFound = context.Partido.FirstOrDefault(x => x.CodCompeticion == item.CodCompeticion &&
x.Jornada == item.Jornada && x.CodLocal == item.CodLocal && x.CodVisitante == item.CodVisitante);
if (matchFound != null)
{
item.MatchCodPartidoNavigation = matchFound;
}
}
try
{
context.SaveChanges();
}
catch (Exception ex)
{
}
}
public FootballUnitOfWork(FootballContext context)
{
_context = context;
this.CompetitionRepository = new CompetitionRepository(_context);
this.TeamRepository = new TeamRepository(_context);
this.GlobalMediaRepository = new GlobalMediaRepository(_context);
}
/// <summary>
/// The on load.
/// </summary>
/// <param name="e">
/// The e.
/// </param>
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
this.Context = new FootballContext();
this.Context.Commands.Load();
this.footballCommandBindingSource.DataSource = this.Context.Commands.Local.ToBindingList();
}
public IActionResult StadiumPage(int id)
{
using (FootballContext db = new FootballContext(connString)) {
Stadium stadium = db.Stadiums.Find(id);
return(View(stadium));
}
}
public IActionResult TeamPage(int id)
{
using (FootballContext db = new FootballContext(connString)) {
Team team = db.Teams.Find(id);
return(View(team));
}
}
public static void SubmitTeam(string teamName, List <Players> selectedPlayers)
{
using var db = new FootballContext();
Teams newTeam = new Teams
{
TeamName = teamName
};
db.Teams.Add(newTeam);
db.SaveChanges();
foreach (var selectedplayer in selectedPlayers)
{
PlayerTeams newEntry = new PlayerTeams
{
TeamId = newTeam.TeamId,
PlayerId = selectedplayer.PlayerId
};
db.PlayerTeams.Add(newEntry);
}
TeamStatistics newStatistics = new TeamStatistics
{
TeamId = newTeam.TeamId,
MatchesPlayed = 0,
Wins = 0,
Draws = 0,
Losses = 0,
GoalsScored = 0,
GoalsConceded = 0
};
db.TeamStatistics.Add(newStatistics);
db.SaveChanges();
}
public static List <Players> FilterPlayers(string filter, Positions pos)
{
using var db = new FootballContext();
if (filter == "")
{
if ((pos == null || pos.PositionId == 6))
{
return(db.Players.ToList <Players>());
}
else
{
var quary =
db.Players.Where(o => o.PositionId == pos.PositionId)
.OrderBy(o => o.FirstName);
return(quary.ToList <Players>());;
}
}
else if ((pos == null || pos.PositionId == 6))
{
var quary =
db.Players.Where(o => o.FirstName.Contains(filter))
.OrderBy(o => o.FirstName);
return(quary.ToList <Players>());
}
else
{
var quary =
db.Players.Where(o => o.FirstName.Contains(filter) && o.PositionId == pos.PositionId)
.OrderBy(o => o.FirstName);
return(quary.ToList <Players>());
}
}
public static void SaveTeam(Teams team, string teamName, int matchesPlayed, int wins, int draws, int losses, int goalsScored,
int goalsConceded, List <Players> players)
{
using var db = new FootballContext();
var findTeam =
db.Teams.Where(o => o.TeamId == team.TeamId).FirstOrDefault();
var findstats =
db.TeamStatistics.Where(o => o.TeamId == team.TeamId).FirstOrDefault();
findTeam.TeamName = teamName;
findstats.MatchesPlayed = matchesPlayed;
findstats.Wins = wins;
findstats.Draws = draws;
findstats.Losses = losses;
findstats.GoalsScored = goalsScored;
findstats.GoalsConceded = goalsConceded;
var removeEntries =
db.PlayerTeams.Where(o => o.TeamId == team.TeamId);
foreach (var rEntry in removeEntries)
{
db.PlayerTeams.Remove(rEntry);
}
foreach (var player in players)
{
PlayerTeams newEntry = new PlayerTeams
{
PlayerId = player.PlayerId,
TeamId = team.TeamId
};
db.PlayerTeams.Add(newEntry);
}
db.SaveChanges();
}
public static void SavePlayer(string firstName, string lastName, string nationality, DateTime dob,
Positions pos, Players selectedPlayer, List <Teams> teams)
{
using var db = new FootballContext();
var findPlayer =
db.Players.Where(o => o.PlayerId == selectedPlayer.PlayerId).First();
findPlayer.FirstName = firstName;
findPlayer.LastName = lastName;
findPlayer.Nationality = nationality;
findPlayer.DateOfBirth = dob;
findPlayer.PositionId = pos.PositionId;
var removeEntries =
db.PlayerTeams.Where(o => o.PlayerId == selectedPlayer.PlayerId);
foreach (var rEntry in removeEntries)
{
db.PlayerTeams.Remove(rEntry);
}
foreach (var team in teams)
{
PlayerTeams newEntry = new PlayerTeams
{
PlayerId = selectedPlayer.PlayerId,
TeamId = team.TeamId
};
db.PlayerTeams.Add(newEntry);
}
db.SaveChanges();
}
public static void SubmitPlayer(string firstName, string lastName, string nationality, DateTime dob,
List <Teams> selectedTeams, Positions pos)
{
using var db = new FootballContext();
Players newPlayer = new Players
{
FirstName = firstName,
LastName = lastName,
Nationality = nationality,
DateOfBirth = dob,
PositionId = pos.PositionId
};
db.Players.Add(newPlayer);
db.SaveChanges();
foreach (var team in selectedTeams)
{
PlayerTeams newEntry = new PlayerTeams
{
PlayerId = newPlayer.PlayerId,
TeamId = team.TeamId
};
db.PlayerTeams.Add(newEntry);
}
db.SaveChanges();
}
public AccountController(SignInManager <IdentityUser> signInManager,
FootballContext context, /*IdentityDbContext idcontext,*/ UserManager <IdentityUser> userManager)
{
this.signInManager = signInManager;
this.context = context;
this.userManager = userManager;
datamanager = new DataManager();
}
public AdminService(
ILogger <AdminService> logger,
FootballContext context
)
{
_logger = logger;
_context = context;
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
this.context = new FootballContext();
this.context.Teams.Load();
this.teamBindingSource.DataSource = this.context.Teams.Local.ToBindingList();
Team[] teams = this.context.Teams.Local.ToArray();
}
public static int GetTeamSize(Teams team)
{
using var db = new FootballContext();
var Numplayers =
db.PlayerTeams.Where(o => o.TeamId == team.TeamId).Count();
return(Numplayers);
}
public IActionResult GetAllTeams()
{
using (FootballContext db = new FootballContext(connString)) {
string path = "~/views/Teams/Teams.cshtml";
List <Team> teams = (from t in db.Teams select t).ToList();
return(View(path, teams));
}
}
public static List <PlayerTeams> GetSelectedPlayers(Teams selectedTeam)
{
using var db = new FootballContext();
var Playersquary =
db.PlayerTeams.Where(o => o.TeamId == selectedTeam.TeamId).Include(o => o.Player).ToList();
return(Playersquary);
}
public static TeamStatistics GetTeamStatistics(Teams team)
{
using var db = new FootballContext();
var stats =
db.TeamStatistics.Where(o => o.TeamId == team.TeamId).FirstOrDefault();
return(stats);
}
public static Players GetPlayer(PlayerTeams player)
{
using var db = new FootballContext();
var playerQuery =
db.Players.Where(o => o.PlayerId == player.PlayerId).FirstOrDefault();
return(playerQuery);
}
public IActionResult GetAllStadiums()
{
using (FootballContext db = new FootballContext(connString)) {
string path = "~/views/Stadiums/Stadiums.cshtml";
List <Stadium> stadiums = (from s in db.Stadiums select s).ToList();
return(View(path, stadiums));
}
}
public FixturesController(
FootballContext context,
IMapper mapper
)
{
_context = context;
_mapper = mapper;
}
public CompetitionController(
FootballContext context,
IMapper mapper
)
{
_context = context;
_mapper = mapper;
}
public TeamController(
FootballContext context,
IMapper mapper
)
{
_context = context;
_mapper = mapper;
}
static void Main(string[] args)
{
FootballContext ctx = new FootballContext();
var aarena = new Arena();
Console.WriteLine("Enter an Arnea name");
var name = Console.ReadLine();
aarena.Name = name;
Console.WriteLine("Enter an Arnea address name");
var address = Console.ReadLine();
aarena.Address = address;
ctx.Arenas.Add(aarena);
var ateam = new Team();
Console.WriteLine("Enter an Team name");
var teamname = Console.ReadLine();
ateam.Name = teamname;
Console.WriteLine("Enter an Team Email name");
ateam.Email = teamname + "di.com";
ctx.Teams.Add(ateam);
ctx.SaveChanges();
// list of Arena
Console.WriteLine("List of Arena name------");
foreach (var listarena in ctx.Arenas)
{
Console.WriteLine(listarena.Name);
}
// list of Team
Console.WriteLine("List of Team name------");
foreach (var alist in ctx.Teams)
{
Console.WriteLine(alist.Name);
}
Console.ReadKey();
}
public List <FootballTeam> GetTeams()
{
using (var context = new FootballContext())
{
var result = context.FootballTeams
.ToList();
return(result);
}
}
public PlayerUnitTest()
{
var context = new FootballContext(dbContextOptions);
TestDB db = new TestDB();
db.Seed(context);
players = new PlayersController(context);
}
public static List <Team> QueryAllTeams()
{
using (FootballContext db = new FootballContext())
{
// LINQ to entities
var query = db.Teams.OrderBy(team => team.Name).ToList();
return(query);
}
}
public void OneTimeSetup()
{
using (FootballContext context = new FootballContext())
{
context.Database.Migrate();
context.Database.EnsureCreated();
}
}
