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

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

Updates the entry of any members already existing on the team, and creates new entries for new members of the team.
public static UpdateTeamMembers ( ContestTeam team ) : bool
team ActivEarth.Objects.Competition.Contests.ContestTeam Team whose members must be updated.
Результат bool
        public static bool UpdateTeamMembers(ContestTeam team)
        {
            try
            {
                foreach (ContestTeamMember user in team.Members)
                {

                    using (SqlConnection connection = ConnectionManager.GetConnection())
                    {
                        var data = new ActivEarthDataProvidersDataContext(connection);

                        var dbUser =
                            (from u in data.TeamMemberDataProviders
                             where u.team_id == team.ID && u.user_id == user.UserId
                             select u).FirstOrDefault();
                        if (dbUser != null)
                        {
                            dbUser.score = user.Score;
                            dbUser.initial_score = user.InitialScore;
                            dbUser.initialized = user.Initialized;

                            data.SubmitChanges();
                        }
                        else
                        {
                            if (CreateNewTeamMember(user, team.ID) == 0)
                            {
                                return false;
                            }
                        }
                    }
                }

                return true;
            }
            catch (Exception)
            {
                return false;
            }
        }