public async Task CreateDb()
{
using (var ctx = new FootballContext())
{
await ctx.Players.ToListAsync();
await ctx.SaveChangesAsync();
}
}
/// <summary>
/// Fill the matches with data taken from XML file
/// </summary>
/// <param name="matches">Gets a collection of matches</param>
public void FillMatchesFromXml(ICollection<Match> matches)
{
var ctx = new FootballContext();
using (ctx)
{
foreach (var match in matches)
{
ctx.Matches.Add(match);
}
ctx.SaveChanges();
}
}
/// <summary>
/// Gets report for all stadiums - Id, Name, Capacity and Town
/// </summary>
/// <returns>Returns a collection of DtoStadiumReport</returns>
public ICollection<DtoStadiumReport> GetStadiumReport()
{
var ctx = new FootballContext();
using (ctx)
{
var stadiumReport = ctx.Stadiums.Select(s => new DtoStadiumReport
{
Id = s.Id,
Name = s.Name,
Capacity = s.Capacity,
TownName = s.Town.Name
}).ToList();
return stadiumReport;
}
}
private async void GetMongoData_Click(object sender, EventArgs e)
{
try
{
var repo = new MongoDbRepository();
var teams = (await repo.GetTeamsData()).ToList();
var stadiums = (await repo.GetStadiumsData()).ToList();
var ctx = new FootballContext();
using (ctx)
{
foreach (var team in teams)
{
if (!ctx.Teams.Any(pl => pl.Id == team.Id))
{
ctx.Teams.Add(team);
}
}
foreach (var stadium in stadiums)
{
if (!ctx.Stadiums.Any(pl => pl.Id == stadium.Id))
{
ctx.Stadiums.Add(stadium);
}
}
ctx.SaveChanges();
}
MessageBox.Show(
"The teams, couches, stadiums and towns are inserted",
"Teams insert",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (DataException)
{
MessageBox.Show(
"No connection to MongoDb!!!",
"MongoDb",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
/// <summary>
/// Gets report for all teams - Id, Name, Owner, Coach, NumberOfPlayers and NumberOfMatches
/// </summary>
/// <returns>Returns a collection of DtoTeamReport</returns>
public ICollection<DtoTeamReport> GetTeamReport()
{
var ctx = new FootballContext();
using (ctx)
{
var teamReports = ctx.Teams.Select(t => new DtoTeamReport
{
Id = t.Id,
Name = t.Name,
Owner = t.Owner.FirstName + " " + t.Owner.LastName,
Coach = t.Coach.FirstName + " " + t.Coach.LastName,
NumberOfPlayers = t.Players.Count,
NumbersOfMatches = t.Matches.Count
}).ToList();
return teamReports;
}
}
public DtoMatchToDbMatchConverter(IXmlToDtoMatchConverter dtoModels, FootballContext db)
{
this.DtoModels = dtoModels;
this.Db = db;
}
/// <summary>
/// Fill the players with data taken from ZIP file
/// </summary>
/// <param name="teams">Gets a dictionary with KEY of type string and VALUE of type List<Player></param>
public void FillPlayersFromZip(Dictionary<string, List<Player>> teams)
{
var ctx = new FootballContext();
using (ctx)
{
foreach (var team in teams)
{
var team1 = ctx.Teams.FirstOrDefault(t => t.Name == team.Key);
if (team1 == null)
{
continue;
}
foreach (var player in team.Value)
{
var currPlayer = ctx.Players
.SingleOrDefault(pl => pl.Number == player.Number && pl.Team.Name == team.Key);
if (currPlayer == null)
{
player.Team = team1;
ctx.Players.Add(player);
}
else
{
currPlayer.Salary = player.Salary;
currPlayer.Position = player.Position;
currPlayer.FirstName = player.FirstName;
currPlayer.LastName = player.LastName;
}
}
}
ctx.SaveChanges();
}
}
/// <summary>
/// Gets matches data - Date, Town, Stadium, HomeTeam, AwayTeam and Result for export in PDF
/// </summary>
/// <returns>Returns a dictionary with KEY of type string and VALUE of type List<DtoPdfExportTable></returns>
public Dictionary<string, List<DtoPdfExportTable>> GetDataForPdfExport()
{
using (var ctx = new FootballContext())
{
Dictionary<string, List<DtoPdfExportTable>> dataForPdfExport = ctx.Matches
.Select(m => new DtoPdfExportTable
{
Date = m.Date,
Town = m.Stadium.Town.Name,
Stadium = m.Stadium.Name,
HomeTeam = m.HomeTeam.Name,
AwayTeam = m.AwayTeam.Name,
Result = m.HomeScore + " : " + m.AwayScore
})
.GroupBy(g => g.Town)
.ToDictionary(k => k.Key, v => v.ToList());
return dataForPdfExport;
}
}
private void FillFromXml_btn_Click(object sender, EventArgs e)
{
var repo = new MSSqlRepository();
var ctx = new FootballContext();
var xmlToDtoConverter = new XmlToDtoMatchConverter(XmlMatchesPath);
var dtoToMatchModelConverter = new DtoMatchToDbMatchConverter(xmlToDtoConverter, ctx);
var matches = dtoToMatchModelConverter.GetAllMatches();
try
{
repo.FillMatchesFromXml(matches);
MessageBox.Show(
"The matches are inserted",
"Matches insert",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception)
{
// Find appropriate exception
MessageBox.Show(
"Something bad happened",
"Fatal Error",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Information);
}
}