/// <summary> /// Saves a Team as a new entry in the DB. /// </summary> /// <param name="team">Team object to add to the DB.</param> /// <returns>ID of the created team on success, 0 on failure.</returns> public static int CreateNewTeam(ContestTeam team) { try { int id; using (SqlConnection connection = ConnectionManager.GetConnection()) { var data = new ActivEarthDataProvidersDataContext(connection); var teamData = new TeamDataProvider { name = team.Name, score = team.Score, contest_id = team.ContestId, locked = team.IsLocked, group_id = team.GroupId, bracket = team.Bracket }; data.TeamDataProviders.InsertOnSubmit(teamData); data.SubmitChanges(); id = teamData.id; } TeamDAO.UpdateTeamMembers(team); return id; } catch (Exception) { return 0; } }
/// <summary> /// Saves a Team as a new entry in the DB. /// </summary> /// <param name="team">Team object to add to the DB.</param> /// <returns>ID of the created team on success, 0 on failure.</returns> public static int CreateNewTeam(Team team, int contestId) { try { int id; using (SqlConnection connection = ConnectionManager.GetConnection()) { var data = new ActivEarthDataProvidersDataContext(connection); var teamData = new TeamDataProvider { name = team.Name, score = team.Score, contest_id = contestId }; data.TeamDataProviders.InsertOnSubmit(teamData); data.SubmitChanges(); id = teamData.id; } UpdateTeamMembers(team); return id; } catch (Exception) { return 0; } }
partial void DeleteTeamDataProvider(TeamDataProvider instance);
partial void UpdateTeamDataProvider(TeamDataProvider instance);
partial void InsertTeamDataProvider(TeamDataProvider instance);
private void detach_TeamDataProviders(TeamDataProvider entity) { this.SendPropertyChanging(); entity.ContestDataProvider = null; }
private void attach_TeamDataProviders(TeamDataProvider entity) { this.SendPropertyChanging(); entity.GroupDataProvider = this; }