public async Task <double> PrecentileFinder(int userID) { var currentUserScore = await _pokemonUserSQLStore.SelectPlayerAverageScore(userID); var listOfUsers = await _pokemonUserSQLStore.SelectAllScores(); var numOfBottomPrecentile = 0; //var userCount = listOfUsers.Count(); var listOfUsersInList = new List <double>(); foreach (var allPlayerScores in listOfUsers) { listOfUsersInList.Add(allPlayerScores); } var userCount = listOfUsersInList.Count(); foreach (var allPlayersScoress in listOfUsersInList) { if (allPlayersScoress < currentUserScore) { numOfBottomPrecentile += 1; } } var userPrecentile = (1d - (Convert.ToDouble(numOfBottomPrecentile) / Convert.ToDouble(userCount))); return(userPrecentile); }
public async Task <IEnumerable <double> > SelectAllScores() { var averageScores = await _pokemonUserSQLStore.SelectAllScores(); return(averageScores); }