public bool UpdatePlayer(dbPlayer oldPlayer, dbPlayer newPlayer) { try { _playerRepo.Save(oldPlayer, newPlayer); return(true); } catch (Exception ex) { return(false); } }
public void Save(dbPlayer oldPlayer, dbPlayer newPlayer) { var sqlUpdate = String.Format("UPDATE Players SET Name='{0}', Email='{1}' WHERE ID={2}", newPlayer.Name, newPlayer.Email, oldPlayer.ID); _dataContext.ExecuteCommand(sqlUpdate); }
public async Task <ActionResult> SetPlayerName(IndexViewModel model) { _telemetryClient.TrackTrace(new TraceTelemetry("Start DisplayName set")); var user = await UserManager.FindByIdAsync(User.Identity.GetUserId()); // Check Mode: Pair Player or Change Name var allPlayers = _playerManager.GetAllPlayers(); if (allPlayers.Any(p => p.Email == user.Email)) { try { _telemetryClient.TrackTrace(new TraceTelemetry("Mode: Changing DisplayName")); var oldPlayerObj = allPlayers.First(p => p.Email == user.Email); var oldPlayer = new dbPlayer { ID = oldPlayerObj.ID, Name = oldPlayerObj.Name, Email = oldPlayerObj.Email }; var newPlayer = new dbPlayer { ID = oldPlayerObj.ID, Name = model.NewDisplayName, Email = oldPlayerObj.Email }; _playerManager.UpdatePlayer(oldPlayer, newPlayer); return(await Index(ManageMessageId.SetDisplayNameSuccess)); } catch (Exception ex) { _telemetryClient.TrackException(ex); return(await Index(ManageMessageId.Error)); } } else { try { _telemetryClient.TrackTrace(new TraceTelemetry("Mode: Pairing DisplayName")); var oldPlayerObj = allPlayers.First(p => p.Name == model.NewDisplayName); var oldPlayer = new dbPlayer { ID = oldPlayerObj.ID, Name = oldPlayerObj.Name, Email = oldPlayerObj.Email }; var newPlayer = new dbPlayer { ID = oldPlayerObj.ID, Name = oldPlayer.Name, Email = user.Email }; _playerManager.UpdatePlayer(oldPlayer, newPlayer); return(await Index(ManageMessageId.SetDisplayNameSuccess)); } catch (Exception ex) { _telemetryClient.TrackException(ex); return(await Index(ManageMessageId.Error)); } } return(RedirectToAction("Index", new { message = ManageMessageId.SetDisplayNameSuccess })); }