public async Task LoadTeamCompetitorMembersAsync(TeamCompetitor competitor)
{
var query = from tcm in context.TeamCompetitorMembers.Include(m => m.Member)
where tcm.TeamId == competitor.Id
select tcm;
await query.LoadAsync();
}
public async Task UpdateTeamCompetitorMembersAsync(TeamCompetitor competitor, Guid competitionId, Guid[] members)
{
using (var transaction = context.UseOrBeginTransaction(IsolationLevel.RepeatableRead))
try
{
competitor.Members.Clear();
await context.SaveChangesAsync();
foreach (var personCompetitor in await(from c in Competitors(competitionId).OfType <PersonCompetitor>()
where members.Contains(c.Id)
select c).ToListAsync())
{
competitor.Members.Add(new TeamCompetitorMember
{
Team = competitor,
Member = personCompetitor,
Order = Array.IndexOf(members, personCompetitor.Id)
});
}
await context.SaveChangesAsync();
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
}
public async Task AddCompetitorAsync(Competition competition, TeamCompetitor competitor, Guid[] members)
{
using (var transaction = context.BeginTransaction(IsolationLevel.RepeatableRead))
try
{
competitor.StartNumber = competitor.StartNumber > 0
? competitor.StartNumber
: await(from d in context.Competitors
where d.ListId == competitor.ListId
select d.StartNumber).DefaultIfEmpty(0).MaxAsync() + 1;
competitor.EntityId = Guid.NewGuid();
competitor.Members = new List <TeamCompetitorMember>();
await AddCompetitorAsync(competitor);
if (members != null)
{
await UpdateTeamCompetitorMembersAsync(competitor, competition.Id, members);
}
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
}
public void Given_NoGamesPlayed_When_CalculateTable_Then_AllZeroesTable()
{
//Arrange
var pointSystem = new PointSystem(3, 1, 0);
var teamLiverpool = new TeamCompetitor
{
Team = new Team {
Name = "Liverpool"
}
};
var teamChelsea = new TeamCompetitor
{
Team = new Team {
Name = "Chelsea"
}
};
var teamManCity = new TeamCompetitor
{
Team = new Team {
Name = "Manchester City"
}
};
var teamTottenham = new TeamCompetitor
{
Team = new Team {
Name = "Tottenham Hotspur"
}
};
var teams = new List <TeamCompetitor> {
teamLiverpool, teamChelsea, teamManCity, teamTottenham
};
teams = teams.OrderBy(t => t.Team.Name).ToList();
var rounds = new List <TeamLeagueRound>();
//Act
var table = new TeamLeagueTable();
table.CalculateTable(teams, rounds, pointSystem);
//Assert
table.Items.ForEach(i =>
{
i.GamesWon.Should().Be(0);
i.GamesDrawn.Should().Be(0);
i.GamesLost.Should().Be(0);
i.GoalsFor.Should().Be(0);
i.GoalsAgainst.Should().Be(0);
i.GoalDifference.Should().Be(0);
i.Points.Should().Be(0);
});
table.Items[0].Team.Should().Be(teamChelsea.Team);
table.Items[1].Team.Should().Be(teamLiverpool.Team);
table.Items[2].Team.Should().Be(teamManCity.Team);
table.Items[3].Team.Should().Be(teamTottenham.Team);
}
public ActionResult AddCompetitor(TeamCompetitor teamCompetitor)
{
if (ModelState.IsValid)
{
_db.TeamCompetitors.Add(teamCompetitor);
_db.SaveChanges();
var teamRegisterCard = _db.TeamRegisterCards.Find(teamCompetitor.TeamRegisterCardId);
return(RedirectToAction("Details", "TeamCompetitions", new { id = teamRegisterCard.TeamCompetitionId }));
}
return(View());
}
public static string FormatMembers(TeamCompetitor competitor)
{
if (competitor == null)
{
return(null);
}
var formatter = new Func <TeamCompetitorMember, string>(m => m.Reserve.HasValue
? string.Format(Resources.ReserveFormat, m.Member.FullName, m.Reserve.Value)
: m.Member.FullName);
return(string.Join(", ", competitor.Members.OrderBy(m => m.Order).Select(m => formatter(m))));
}
public ActionResult AddCompetitor(int teamRegistercardId)
{
var teamRegisterCard = _db.TeamRegisterCards.Find(teamRegistercardId);
var teamCompetitor = new TeamCompetitor
{
TeamRegisterCardId = teamRegistercardId,
TeamRegisterCard = teamRegisterCard
};
var competition = teamRegisterCard.TeamCompetition;
teamCompetitor.InitialiseShoots(competition.Distances.ToList(), competition.NumberOfSightingShots, competition.NumberOfScoringShots);
return(View(teamCompetitor));
}
public void Given_GamesPlayed_When_CalculateTable_Then_CorrectTable()
{
//Arrange
var pointSystem = new PointSystem(3, 1, 0);
var teamLiverpool = new TeamCompetitor
{
Team = new Team {
Name = "Liverpool"
}
};
var teamChelsea = new TeamCompetitor
{
Team = new Team {
Name = "Chelsea"
}
};
var teamManCity = new TeamCompetitor
{
Team = new Team {
Name = "Manchester City"
}
};
var teamTottenham = new TeamCompetitor
{
Team = new Team {
Name = "Tottenham Hotspur"
}
};
var teams = new List <TeamCompetitor> {
teamLiverpool, teamChelsea, teamManCity, teamTottenham
};
teams = teams.OrderBy(t => t.Team.Name).ToList();
#region Rounds
var rounds = new List <TeamLeagueRound>
{
new TeamLeagueRound
{
Matches = new List <TeamLeagueMatch>
{
new TeamLeagueMatch
{
MatchEntries = new List <TeamMatchEntry>
{
new TeamMatchEntry
{
HomeAway = HomeAway.Home,
Team = teamLiverpool.Team,
Score = new IntegerScore {
Value = 2
}
},
new TeamMatchEntry
{
HomeAway = HomeAway.Away,
Team = teamChelsea.Team,
Score = new IntegerScore {
Value = 0
}
}
}
},
new TeamLeagueMatch
{
MatchEntries = new List <TeamMatchEntry>
{
new TeamMatchEntry
{
HomeAway = HomeAway.Home,
Team = teamManCity.Team,
Score = new IntegerScore {
Value = 1
}
},
new TeamMatchEntry
{
HomeAway = HomeAway.Away,
Team = teamTottenham.Team,
Score = new IntegerScore {
Value = 0
}
}
}
}
}
},
new TeamLeagueRound
{
Matches = new List <TeamLeagueMatch>
{
new TeamLeagueMatch
{
MatchEntries = new List <TeamMatchEntry>
{
new TeamMatchEntry
{
HomeAway = HomeAway.Home,
Team = teamManCity.Team,
Score = new IntegerScore {
Value = 1
}
},
new TeamMatchEntry
{
HomeAway = HomeAway.Away,
Team = teamLiverpool.Team,
Score = new IntegerScore {
Value = 1
}
}
}
},
new TeamLeagueMatch
{
MatchEntries = new List <TeamMatchEntry>
{
new TeamMatchEntry
{
HomeAway = HomeAway.Home,
Team = teamTottenham.Team,
Score = new IntegerScore {
Value = 2
}
},
new TeamMatchEntry
{
HomeAway = HomeAway.Away,
Team = teamChelsea.Team,
Score = new IntegerScore {
Value = 2
}
}
}
}
}
}
};
#endregion
//Act
var table = new TeamLeagueTable();
table.CalculateTable(teams, rounds, pointSystem);
//Assert
var position1 = table.Items[0];
position1.Position.Should().Be(1);
position1.Team.Should().Be(teamLiverpool.Team);
position1.GamesWon.Should().Be(1);
position1.GamesDrawn.Should().Be(1);
position1.GamesLost.Should().Be(0);
position1.GoalsFor.Should().Be(3);
position1.GoalsAgainst.Should().Be(1);
position1.GoalDifference.Should().Be(2);
position1.Points.Should().Be(4);
var position2 = table.Items[1];
position2.Position.Should().Be(2);
position2.Team.Should().Be(teamManCity.Team);
position2.GamesWon.Should().Be(1);
position2.GamesDrawn.Should().Be(1);
position2.GamesLost.Should().Be(0);
position2.GoalsFor.Should().Be(2);
position2.GoalsAgainst.Should().Be(1);
position2.GoalDifference.Should().Be(1);
position2.Points.Should().Be(4);
var position3 = table.Items[2];
position3.Position.Should().Be(3);
position3.Team.Should().Be(teamTottenham.Team);
position3.GamesWon.Should().Be(0);
position3.GamesDrawn.Should().Be(1);
position3.GamesLost.Should().Be(1);
position3.GoalsFor.Should().Be(2);
position3.GoalsAgainst.Should().Be(3);
position3.GoalDifference.Should().Be(-1);
position3.Points.Should().Be(1);
var position4 = table.Items[3];
position4.Position.Should().Be(4);
position4.Team.Should().Be(teamChelsea.Team);
position4.GamesWon.Should().Be(0);
position4.GamesDrawn.Should().Be(1);
position4.GamesLost.Should().Be(1);
position4.GoalsFor.Should().Be(2);
position4.GoalsAgainst.Should().Be(4);
position4.GoalDifference.Should().Be(-2);
position4.Points.Should().Be(1);
}
