Example #1
0
        public void LoadHallOfFame()
        {
            ranks         = new Dictionary <uint, UserRank>();
            usersWithRank = new List <UserCompetition>();

            usersWithRank = new List <UserCompetition>();
            usersWithRank.Clear();
            using (IQueryAdapter queryReactor = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
            {
                ranks         = new Dictionary <uint, UserRank>();
                usersWithRank = new List <UserCompetition>();

                queryReactor.SetQuery("SELECT * FROM `users` WHERE `gotw_points` >= '1' AND `rank` = '1' ORDER BY `gotw_points` DESC LIMIT 16");
                DataTable gUsersTable = queryReactor.getTable();

                foreach (DataRow Row in gUsersTable.Rows)
                {
                    var staff = new UserCompetition(Row);
                    if (!usersWithRank.Contains(staff))
                    {
                        usersWithRank.Add(staff);
                    }
                }
            }
        }
Example #2
0
        public bool RemoveUser(int id, User user)
        {
            Competition competition = this
                                      .Context
                                      .Competitions
                                      .FirstOrDefault(c => c.Id == id);

            if (competition == null || user == null)
            {
                return(false);
            }

            Competitor competitor = competition
                                    .Competitors
                                    .FirstOrDefault(c => c.User.UserName == user.UserName);

            if (competitor == null)
            {
                return(false);
            }

            competition.Competitors.Remove(competitor);
            UserCompetition remove = user.Competitions.First(c => c.CompetitionId == id);

            user.Competitions.Remove(remove);
            this.Context.SaveChanges();

            return(true);
        }
 public void RemoveUserFromEvent(UserCompetition userCompetition)
 {
     context.Remove(userCompetition);
 }