/// <summary> /// Creates a new DB entry for a team member. /// </summary> /// <param name="teamMember">Member to be added to the DB.</param> /// <param name="teamId">Team ID that the member should be added to.</param> /// <returns>ID of the newly added Team Member entry on success, 0 on failure.</returns> public static int CreateNewTeamMember(ContestTeamMember teamMember, int teamId) { try { int contestId = TeamDAO.GetContestIdFromTeamId(teamId); using (SqlConnection connection = ConnectionManager.GetConnection()) { if (TeamDAO.UserCompetingInContest(teamMember.UserId, contestId)) { throw new Exception("User is already competing in the contest"); } var data = new ActivEarthDataProvidersDataContext(connection); var userData = new TeamMemberDataProvider { contest_id = contestId, team_id = teamId, user_id = teamMember.UserId, score = teamMember.Score, initialized = teamMember.Initialized, initial_score = teamMember.InitialScore }; data.TeamMemberDataProviders.InsertOnSubmit(userData); data.SubmitChanges(); return userData.id; } } catch (Exception) { return 0; } }
/// <summary> /// Creates a new DB entry for a team member. /// </summary> /// <param name="teamMember">Member to be added to the DB.</param> /// <param name="teamId">Team ID that the member should be added to.</param> /// <returns>ID of the newly added Team Member entry on success, 0 on failure.</returns> public static int CreateNewTeamMember(TeamMember teamMember, int teamId) { try { using (SqlConnection connection = ConnectionManager.GetConnection()) { var data = new ActivEarthDataProvidersDataContext(connection); var userData = new TeamMemberDataProvider { team_id = (int)teamId, user_id = (int)teamMember.User.UserID, initialized = teamMember.Initialized, initial_score = teamMember.InitialScore }; data.TeamMemberDataProviders.InsertOnSubmit(userData); data.SubmitChanges(); return userData.id; } } catch (Exception) { return 0; } }
partial void DeleteTeamMemberDataProvider(TeamMemberDataProvider instance);
partial void UpdateTeamMemberDataProvider(TeamMemberDataProvider instance);
partial void InsertTeamMemberDataProvider(TeamMemberDataProvider instance);
private void detach_TeamMemberDataProviders(TeamMemberDataProvider entity) { this.SendPropertyChanging(); entity.UserDataProvider = null; }
private void attach_TeamMemberDataProviders(TeamMemberDataProvider entity) { this.SendPropertyChanging(); entity.ContestDataProvider = this; }