// Start is called before the first frame update void Start() { HighScore.SetText(string.Concat("Highscore: ", GameManager.highscore)); QuestionsAnswered.SetText(string.Concat("Most Questions Answered: ", GameManager.mostQuestions)); if (GameManager.timesPlayed != 0) { AverageScore.SetText(string.Concat("Average Score: ", (GameManager.totalscore / GameManager.timesPlayed))); } else { AverageScore.SetText("Average Score: 0"); } if (GameManager.bestPhoneme != "") { BestPhoneme.SetText(string.Concat("Best Phoneme: ", GameManager.bestPhoneme)); } else { BestPhoneme.SetText("Best Phoneme: N/A"); } if (GameManager.worstPhoneme != "") { WorstPhoneme.SetText(string.Concat("Worst Phoneme: ", GameManager.worstPhoneme)); } else { WorstPhoneme.SetText("Worst Phoneme: N/A"); } }
private void Start() { if (AverageTime != null) { AverageTime.Invoke(); } if (PlayedGames != null) { PlayedGames.Invoke(); } if (AverageScore != null) { AverageScore.Invoke(); } }
public AverageScore ScoreReport(Members members) { var averageScore = new AverageScore(); var allMemberScores = _playerScoreRepository.FindBy(x => x.MemberID == members.ID).ToList(); if (allMemberScores.Count > 0) { //Week Score var weekScore = allMemberScores.Where(x => GetWeekOfYear(x.DatePlayed) == GetWeekOfYear(DateTime.Now)); var actualWeekScore = 0.0; if (weekScore.Count() > 0) { actualWeekScore = weekScore.Select(x => x.Score).Sum() / weekScore.Count(); } //Month Score var monthScore = allMemberScores.Where(x => x.DatePlayed.Month == DateTime.Now.Month); var actualMonthScore = 0.0; if (monthScore.Count() > 0) { actualMonthScore = monthScore.Select(x => x.Score).Sum() / monthScore.Count(); } //Year Score var yearScore = allMemberScores.Where(x => x.DatePlayed.Year == DateTime.Now.Year); var actualYearScore = 0.0; if (yearScore.Count() > 0) { actualYearScore = yearScore.Select(x => x.Score).Sum() / yearScore.Count(); } averageScore.ScoreMonth = actualMonthScore; averageScore.ScoreWeek = actualWeekScore; averageScore.ScoreYear = actualYearScore; } return(averageScore); }
public string GetCountryInCsv() { return($"{CountryName};{AverageScore.ToString()};{MedianScore.ToString()};{MaxScore.ToString()};{MaxScorePerson};{MinScore.ToString()};{MinScorePerson};{RecordCount.ToString()}"); }
/// <summary> /// Filter by the media's average score /// </summary> public GraphQueryArgument <int> AverageScoreArgument(int value) { return(AverageScore.GetQueryArgumentAndSetValue(value)); }
public override string ToString() { return($"{Name} - Avg: {AverageScore.ToString("F3")}, Max: {MaxScore.ToString("F3")}"); }
public bool GetAverageScore(string _studentID, int _grade, List <AverageScore> averageScores) { bool success = Connect(); if (!success) { return(false); } try { AverageScore score; using (SqlCommand command = connection.CreateCommand()) { command.CommandType = System.Data.CommandType.Text; command.CommandText = "SELECT SCOREBOARD.SemesterAverage FROM LEARNRESULT JOIN SCOREBOARD ON LEARNRESULT.ScoreBoardSE01ID = SCOREBOARD.ScoreBoardID " + "WHERE LEARNRESULT.StudentID = @studentid AND Grade = @grade"; command.Parameters.AddWithValue("@studentid", _studentID); command.Parameters.AddWithValue("@grade", _grade); score = new AverageScore(AverageScore.ScoreType.HK1); using (SqlDataReader reader = command.ExecuteReader()) { reader.Read(); if (!reader.IsDBNull(0)) { score.Value = reader.GetDouble(0); } } averageScores.Add(score); } using (SqlCommand command = connection.CreateCommand()) { command.CommandType = System.Data.CommandType.Text; command.CommandText = "SELECT SCOREBOARD.SemesterAverage FROM LEARNRESULT JOIN SCOREBOARD ON LEARNRESULT.ScoreBoardSE02ID = SCOREBOARD.ScoreBoardID " + "WHERE LEARNRESULT.StudentID = @studentid AND Grade = @grade"; command.Parameters.AddWithValue("@studentid", _studentID); command.Parameters.AddWithValue("@grade", _grade); score = new AverageScore(AverageScore.ScoreType.HK2); using (SqlDataReader reader = command.ExecuteReader()) { reader.Read(); if (!reader.IsDBNull(0)) { score.Value = reader.GetDouble(0); } } averageScores.Add(score); } using (SqlCommand command = connection.CreateCommand()) { command.CommandType = System.Data.CommandType.Text; command.CommandText = "SELECT AverageScore FROM LEARNRESULT WHERE StudentID = @studentid AND Grade = @grade"; command.Parameters.AddWithValue("@studentid", _studentID); command.Parameters.AddWithValue("@grade", _grade); score = new AverageScore(AverageScore.ScoreType.CaNam); using (SqlDataReader reader = command.ExecuteReader()) { reader.Read(); if (!reader.IsDBNull(0)) { score.Value = reader.GetDouble(0); } } averageScores.Add(score); } } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } finally { Disconnect(); } return(true); }
public void TestInitialize() { score = new AverageScore(); }