public static ContestTeam GetTeamFromTeamId(int teamId, bool loadMembers)
{
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
ContestTeam team = (from c in data.TeamDataProviders
where c.id == teamId
select
new ContestTeam
{
ID = c.id,
Name = c.name,
Score = (float)c.score,
IsLocked = c.locked,
GroupId = c.group_id,
ContestId = c.contest_id,
Bracket = c.bracket
}).FirstOrDefault();
if (loadMembers && team != null)
{
team.Members = GetTeamMembersFromTeamId(team.ID);
}
return team;
}
}