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;
}
}