public virtual void IncreaseIncorrectCount(string word) { using (var context = new KartuvesDbContext()) { var inc = context.Words.FirstOrDefault(x => x.Name == word); inc.WordNotGuessedCount++; context.SaveChanges(); } }
public virtual List <User> ReadAllUsersData() { List <User> users = new List <User>(); using (var context = new KartuvesDbContext()) { users = context.Users.Select(x => x).ToList(); context.SaveChanges(); } return(users); }
public virtual void UpdateUser(User user, Word word, ScoreBoard scoreBoard) { using (var context = new KartuvesDbContext()) { user = context.Users.FirstOrDefault(u => user.Id == u.Id); if (user != null && scoreBoard != null) { user.ScoreBoards.Add(scoreBoard); context.SaveChanges(); } } }
public virtual void DeleteUser(int userId) { using (var context = new KartuvesDbContext()) { var user = context.Users.FirstOrDefault(x => x.Id == userId); if (user != null) { context.Users.Remove(user); context.SaveChanges(); } } }
public virtual void CreateUser(string name) { if (!string.IsNullOrEmpty(name)) { using (var context = new KartuvesDbContext()) { context.Users.Add(new User { Name = name }); context.SaveChanges(); } } }
public virtual ScoreBoard CreateScoreBoard(User user, Word word, int guessCount, bool isCorrect) { ScoreBoard sb = new ScoreBoard() { User = user, Word = word, WordToGuess = word.Name, Time = DateTime.UtcNow, GuessCount = guessCount, IsCorrect = isCorrect }; using (var context = new KartuvesDbContext()) { context.ScoreBoards.Add(sb); context.SaveChanges(); } return(sb); }