public void UpdateScore(User u, int challengeId) { Challenge challenge = _db.Set<Challenge>().Where(x => x.Id == challengeId).FirstOrDefault(); Score score = _db.Set<Score>().Where(x => (x.UserId == u.Id) && (x.Challenge.Id == challenge.Id)).FirstOrDefault(); score.Points = CalculateScore(u.Difficulty, challenge.Difficulty); _db.SaveChanges(); }
public int GetUserScore(User u) { List<Score> scores = GetAllUserScores(u); int totalScore = 0; foreach(Score s in scores) { totalScore += s.Points; } return totalScore; }
public void AddNewScore(User u, int challengeId) { Challenge challenge = _db.Set<Challenge>().Where(x => x.Id == challengeId).FirstOrDefault(); Score score = new Score() { Challenge = challenge, User = u, UserId = u.Id, Points = 0 }; _db.Set<Score>().Add(score); _db.SaveChanges(); }
public UserModel MapToUserModel(User entity) { if (entity != null) { return new UserModel() { NmbrOfChildren = entity.NmbrOfChildren, Email = entity.Email, UserName = entity.Email, IsStudent = entity.IsStudent, Language = entity.Language, BirthDate = entity.BirthDate, Gender = entity.Gender, Difficulty = entity.Difficulty, SendNewsletter = entity.SendNewsletter }; } else return new UserModel(); }
public List<Score> GetAllUserScores(User u) { return _db.Set<Score>().Where(x => x.UserId == u.Id).ToList(); }
public int InsertUser(User u) { _db.Set<User>().Add(u); return _db.SaveChanges(); }
public void DeleteUser(User u) { _db.Set<User>().Remove(u); }