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

Документация по классу TeamDAO Показать файл Открыть проект

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

Creates a new DB entry for a team member.

public static CreateNewTeamMember ( ContestTeamMember teamMember, int teamId ) : int
teamMember	ActivEarth.Objects.Competition.Contests.ContestTeamMember	Member to be added to the DB.
teamId	int	Team ID that the member should be added to.
Результат	int

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