public static void saveClick(string User, string pass, int score) { using (var db = new UserDetailsContext()) { var user = new User() { Name = User, Password = pass }; var uScore = new UserScore() { Score = score, User = user }; db.Users.Add(user); db.Scores.Add(uScore); db.SaveChanges(); } Window3 win3 = new Window3(); win3.Show(); }
public static void alteredSaveClick(string UserString, string pass, int score) { // if the username already exists, only update their score, don't make a new account using (var db = new UserDetailsContext()) { var MatchCount = db.Users.Count(u => u.Name == UserString); if (MatchCount > 0) { UserScore scoreQuery = (from userq in db.Users join scoreq in db.Scores on userq.UserId equals scoreq.User.UserId where userq.Name == UserString select scoreq).SingleOrDefault(); if (scoreQuery.Score < score) { scoreQuery.Score = score; } else { scoreQuery.Score = scoreQuery.Score; } db.SaveChanges(); } else { var user = new User() { Name = UserString, Password = pass }; var uScore = new UserScore() { Score = score, User = user }; db.Users.Add(user); db.Scores.Add(uScore); db.SaveChanges(); } } Window3 win3 = new Window3(); win3.Show(); }
//for unit tests public static bool CheckScore(string UserName, int score) { using (var db = new UserDetailsContext()) { var MatchCount = db.Users.Count(u => u.Score.Score == score); if (MatchCount > 0) { return(true); } else { return(false); } } }
//for unit tests public static bool CheckPassword(string UserName, string Password) { using (var db = new UserDetailsContext()) { var MatchCount = db.Users.Count(u => u.Password == Password); if (MatchCount > 0) { return(true); } else { return(false); } } }
public static bool SubClick(string username, string password) { using (var db = new UserDetailsContext()) { var MatchCount = db.Users.Count(u => u.Name == username); if (MatchCount > 0) { return(true); } else { return(false); } } }
public static IEnumerable <User> ScoreBox() { using (var db = new UserDetailsContext()) { var scoreQuery = from user in db.Users join score in db.Scores on user.UserId equals score.User.UserId select new User { Name = user.Name, Score = score }; var newView = scoreQuery.OrderByDescending(x => x.Score.Score); return(newView.ToList().Take(20)); } }