public void StageScoreBoard() { var users = _userManager.Users.ToList(); foreach (var user in users) { //check for a score record, if exists, display, if not, create var userScoreRecord = _context.UserScoreRecord .FirstOrDefault(m => m.UserFriendlyName == user.UserFriendlyName); if (userScoreRecord == null) { userScoreRecord = new UserScoreRecord { UserFriendlyName = user.UserFriendlyName, CreatedDate = DateTime.Now }; _context.UserScoreRecord.Add(userScoreRecord); _context.SaveChanges(); } //check for null username and populate if (userScoreRecord.UserName == null) { userScoreRecord.UserName = user.UserName; _context.SaveChanges(); } } }
public async Task <IActionResult> Edit(int id, [Bind("UserScoreRecordID,UserFriendlyName,BaseScore,BonusScore,TotalScore,CreatedDate")] UserScoreRecord userScoreRecord) { string username = HttpContext.User.Identity.Name; //string user = UserManager.GetUserName(User); if (!admins.Contains(username)) { return(Unauthorized()); } if (id != userScoreRecord.UserScoreRecordID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(userScoreRecord); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!UserScoreRecordExists(userScoreRecord.UserScoreRecordID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(userScoreRecord)); }