ActivEarth.DAO.TeamDAO.GetTeamFromTeamId C# (CSharp) Метод

GetTeamFromTeamId() публичный статический Метод

Retrieves a Team from the DB based on its ID.
public static GetTeamFromTeamId ( int teamId, bool loadMembers ) : ContestTeam
teamId int Identifier of the team to retrieve.
loadMembers bool Indicates whether or not the team member list should be populated.
Результат ActivEarth.Objects.Competition.Contests.ContestTeam
        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;
            }
        }