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