public static long AddMatch(Match match)
{
using (var context = new StffContext())
{
var homeTeamRow = GetTeamRow(match.HomeTeam, context);
var awayTeamRow = GetTeamRow(match.AwayTeam, context);
var referee = GetRefereeRow(match.Ref.ExternalId, context);
var assRef1 = GetRefereeRow(match.Ref.ExternalId, context);
var assRef2 = GetRefereeRow(match.Ref.ExternalId, context);
var insertedRow = context.Match.AddMatchRow(
match.StartTime,
match.GameWeek,
homeTeamRow,
awayTeamRow,
referee,
assRef1,
assRef2,
match.Completed,
match.ExternalId);
insertedRow.AcceptChanges();
context.AcceptChanges();
foreach (var update in match.MatchUpdates)
{
AddMatchUpdate(update, insertedRow, context);
}
return(insertedRow.Id);
}
}
public static long AddPlayer(Player player, long teamId)
{
using (var context = new StffContext())
{
var teamRow = context.Team.Where(t => t.Id == teamId).Single();
var insertedRow = context.Player.AddPlayerRow(teamRow, player.FirstName, player.LastName, player.ExternalId);
insertedRow.AcceptChanges();
context.AcceptChanges();
return(insertedRow.Id);
}
}
public static long AddReferee(Referee referee)
{
using (var context = new StffContext())
{
var insertedRow = context.Referee.AddRefereeRow(referee.FirstName, referee.LastName, referee.Location, referee.ExternalId);
insertedRow.SetAdded();
insertedRow.AcceptChanges();
context.AcceptChanges();
return(insertedRow.Id);
}
}
public static Dictionary <long, long> GetTeamDictionary()
{
Dictionary <long, long> d = new Dictionary <long, long>();
using (var context = new StffContext())
{
foreach (var team in context.Team)
{
d.Add(team.ExternalId, team.Id);
}
}
return(d);
}
public static long AddTeam(Team team)
{
using (var context = new StffContext())
{
var newRow = context.Team.AddTeamRow(team.Name, team.Colors, team.AwayColors, team.ExternalId);
//context.Team.Rows.Add(newRow);
context.AcceptChanges();
TeamTableAdapter adapter = new TeamTableAdapter();
adapter.Update(context);
context.AcceptChanges();
return(newRow.Id);
}
}
public static Dictionary <long, Player> GetAllPlayers()
{
Dictionary <long, Player> players = new Dictionary <long, Player>();
using (var context = new StffContext())
{
foreach (var player in context.Player)
{
Player p = new Player();
p.ExternalId = player.ExternalId;
p.FirstName = player.FirstName;
p.LastName = player.SecondName;
players.Add(p.ExternalId, p);
}
}
return(players);
}
public static Dictionary <long, Referee> GetAllRefereesInternal()
{
Dictionary <long, Referee> referees = new Dictionary <long, Referee>();
using (var context = new StffContext())
{
foreach (var referee in context.Referee)
{
Referee r = new Referee();
r.ExternalId = referee.ExternalId;
r.FirstName = referee.FirstName;
r.LastName = referee.LastName;
r.Location = referee.Region;
referees.Add(referee.Id, r);
}
}
return(referees);
}
public static Dictionary <long, Player> GetAllPlayersForTeam(long externalTeamId)
{
Dictionary <long, Player> players = new Dictionary <long, Player>();
using (var context = new StffContext())
{
long teamId = context.Team.Where(team => team.ExternalId == externalTeamId).Select(t => t.Id).Single();
foreach (var player in context.Player.Where(p => p.TeamId == teamId))
{
Player p = new Player();
p.ExternalId = player.ExternalId;
p.FirstName = player.FirstName;
p.LastName = player.SecondName;
players.Add(p.ExternalId, p);
}
}
return(players);
}
public static Dictionary <long, Team> GetAllTeams()
{
Dictionary <long, Team> teams = new Dictionary <long, Team>();
using (var context = new StffContext())
{
foreach (var team in context.Team)
{
Team t = new Team();
t.AwayColors = team.AwayColors;
t.Colors = team.Colors;
t.ExternalId = team.ExternalId;
t.Name = team.TeamName;
teams.Add(t.ExternalId, t);
}
}
return(teams);
}
public static Dictionary <long, Match> GetAllMatches(
Dictionary <long, Referee> refCache,
Dictionary <long, Player> playerCache,
Dictionary <long, Team> teamCache)
{
Dictionary <long, Match> matches = new Dictionary <long, Match>();
using (var context = new StffContext())
{
foreach (var match in context.Match.ToList())
{
var updates = context.MatchUpdate.Where(mu => mu.MatchId == match.Id);
Match m = new Match();
m.AssRef1 = refCache[match.AssRefereeId1];
m.AssRef2 = refCache[match.AssRefereeId2];
m.AwayTeam = teamCache[match.AwayTeamid].ExternalId;
m.AwayTeamPlayers = new List <Player>();
foreach (var player in context.Player.Where(p => p.TeamId == match.AwayTeamid))
{
m.AwayTeamPlayers.Add(playerCache[player.Id]);
}
m.Completed = match.Completed;
m.ExternalId = match.ExternalMatchId;
m.GameWeek = match.GameWeek;
m.HomeTeam = teamCache[match.HomeTeamId].ExternalId;
m.HomeTeamPlayers = new List <Player>();
foreach (var player in context.Player.Where(p => p.TeamId == match.HomeTeamId))
{
m.HomeTeamPlayers.Add(playerCache[player.Id]);
}
m.MatchUpdates = new List <MatchUpdate>();
foreach (var mu in context.MatchUpdate.Where(update => update.MatchId == match.Id))
{
m.MatchUpdates.Add(MatchUpdate.GetUpdate(mu.HomeTeam, mu.Minute, playerCache[mu.PlayerId], (MatchUpdateType)Enum.Parse(typeof(MatchUpdateType), mu.Type)));
}
m.Ref = refCache[match.RefereeId];
m.StartTime = m.StartTime;
matches.Add(m.ExternalId, m);
}
}
return(matches);
}
private static StffContext.RefereeRow GetRefereeRow(long externalRefId, StffContext context)
{
return(context.Referee.Where(r => r.ExternalId == externalRefId).Single());
}
private static StffContext.PlayerRow GetPlayerRow(long externalTeamId, StffContext context)
{
return(context.Player.Where(p => p.ExternalId == externalTeamId).Single());
}
private static StffContext.TeamRow GetTeamRow(long externalTeamId, StffContext context)
{
return(context.Team.Where(t => t.ExternalId == externalTeamId).Single());
}
private static long AddMatchUpdate(MatchUpdate update, StffContext.MatchRow match, StffContext context)
{
var playerRow = context.Player.Where(p => p.ExternalId == update.Player.ExternalId).Single();
var insertedRow = context.MatchUpdate.AddMatchUpdateRow(update.Type.ToString(), update.Minute, playerRow, match, update.HomeTeam);
insertedRow.AcceptChanges();
context.AcceptChanges();
return(insertedRow.Id);
}
