public async Task <string> AddOneRecordREST(string PlayerscoreJSON) { string yn = "0"; // default is failed if (String.IsNullOrEmpty(PlayerscoreJSON)) { return(yn); } try { JObject json = JObject.Parse(PlayerscoreJSON); Playerscore playerscore = new Playerscore(); playerscore.PlayerName = (string)json["PlayerName"]; playerscore.Score = Convert.ToInt32((string)json["Score"]); playerscore.GameId = Convert.ToInt32((string)json["GameId"]); int result = await _playerscoreManager.AddOnePlayerscoreToTable(playerscore); if (result == ErrorCodeModel.Succeeded) { yn = "1"; } } catch (Exception ex) { string msg = ex.StackTrace.ToString(); Console.WriteLine("AddOneRecordREST failed:\n" + msg); } return(yn); }
void FormatHighscores(string textStream) { string[] entries = textStream.Split(new char[] { '\n' }, System.StringSplitOptions.RemoveEmptyEntries); highscoresList = new Highscore[entries.Length]; for (int i = 0; i < entries.Length; i++) { string[] entryInfo = entries[i].Split(new char[] { '|' }); string username = entryInfo[0]; int score = int.Parse(entryInfo[1]); int time = int.Parse(entryInfo[2]); highscoresList[i] = new Highscore(username, score, time); print(highscoresList[i].username + ": " + highscoresList[i].score + ": " + highscoresList[i].time); if (highscoresList[i].username == ScoreManager.playername) { int rank = i + 1; PlayerscoresList = new Playerscore(rank, username, score, time); Debug.Log(PlayerscoresList.username + "is found"); highscoreDisplay.DisplayPlayerRank(PlayerscoresList); } else { // print("Error on finding" ); } } }
/// <summary> /// Finds the one playerscore by identifier. /// </summary> /// <returns>The one playerscore by identifier (Playerscore.Id).</returns> /// <param name="id">the id of the playerscore.</param> public async Task <Playerscore> FindOnePlayerscoreById(int id) { Playerscore playerscore = await _context.Playerscore .Where(x => x.Id == id).SingleOrDefaultAsync(); return(playerscore); }
private void UpdateScore(bool PlayerWon) { if (PlayerWon) { Playerscore++; label6.Text = "Win"; ourscore.Text = Playerscore.ToString(); } else { Enemyscore++; label6.Text = "Lose"; enemyscorelabel.Text = Enemyscore.ToString(); } }
/// <summary> /// Deletes the one playerscore by identifier. /// </summary> /// <returns>Return the error code.</returns> /// <param name="id">Identifier.</param> public async Task <int> DeleteOnePlayerscoreById(int id) { int result = ErrorCodeModel.ErrorBecauseBugs; if (id == 0) { // its a bug, the id of playerscore cannot be 0 result = ErrorCodeModel.ErrorBecauseBugs; return(result); } Playerscore orgPlayerscore = await FindOnePlayerscoreById(id); if (orgPlayerscore == null) { // the original playerscore does not exist any more result = ErrorCodeModel.OriginalPlayerscoreNotExist; } else { using (var dbTransaction = _context.Database.BeginTransaction()) { try { _context.Playerscore.Remove(orgPlayerscore); await _context.SaveChangesAsync(); dbTransaction.Commit(); result = ErrorCodeModel.Succeeded; // succeeded to update } catch (DbUpdateException ex) { string msg = ex.ToString(); Console.WriteLine("Failed to delete one playerscore. Please see log file.\n" + msg); dbTransaction.Rollback(); result = ErrorCodeModel.DatabaseError; } } } return(result); }
private void UpdateStateOfRequest(StateOfRequest mState, Playerscore firstPlayerscore, int pageNo, int pageSize, int totalRecords, int totalPages, bool isFind = false) { mState.CurrentPageNo = pageNo; mState.PageSize = pageSize; mState.TotalRecords = totalRecords; mState.TotalPages = totalPages; if (firstPlayerscore != null) { mState.FirstId = firstPlayerscore.Id; if (!isFind) { // mState.OrgId = mState.FirstId; } } else { mState.OrgId = 0; mState.OrgNo = ""; mState.FirstId = 0; } }
/// <summary> /// Adds the one playerscore to table. /// </summary> /// <returns>Return the error code.</returns> /// <param name="playerscore">Playerscore.</param> public async Task <int> AddOnePlayerscoreToTable(Playerscore playerscore) { int result = ErrorCodeModel.ErrorBecauseBugs; if (playerscore == null) { // the data for updating is empty result = ErrorCodeModel.PlayerscoreIsNull; return(result); } if (string.IsNullOrEmpty(playerscore.PlayerName)) { // the playerscore no that input by user is empty result = ErrorCodeModel.PlayerNameIsEmpty; return(result); } using (var dbTransaction = _context.Database.BeginTransaction()) { try { _context.Add(playerscore); await _context.SaveChangesAsync(); dbTransaction.Commit(); result = ErrorCodeModel.Succeeded; } catch (DbUpdateException ex) { string errorMsg = ex.ToString(); Console.WriteLine("Failed to add one playerscore: \n" + errorMsg); dbTransaction.Rollback(); result = ErrorCodeModel.DatabaseError; } } return(result); }
public void DisplayPlayerRank(Playerscore PlayerscoresList) { playerscoreField.text = "Your are on " + PlayerscoresList.rank + " Place :" + PlayerscoresList.username + " - " + PlayerscoresList.score + " - " + convertsecondtoformat(PlayerscoresList.time); }
/// <summary> /// Updates the one playerscore by identifier. /// </summary> /// <returns>Return the error code</returns> /// <param name="id">Identifier.</param> /// <param name="playerscore">Playerscore.</param> public async Task <int> UpdateOnePlayerscoreById(int id, Playerscore playerscore) { int result = ErrorCodeModel.ErrorBecauseBugs; if (id == 0) { // its a bug, id of playerscore cannot be 0 result = ErrorCodeModel.ErrorBecauseBugs; return(result); } if (playerscore == null) { // the data for updating is empty result = ErrorCodeModel.PlayerscoreIsNull; return(result); } if (string.IsNullOrEmpty(playerscore.PlayerName)) { // the playerscore name that input by user is empty result = ErrorCodeModel.PlayerNameIsEmpty; return(result); } Playerscore orgPlayerscore = await FindOnePlayerscoreById(id); if (orgPlayerscore == null) { // the original playerscore does not exist any more result = ErrorCodeModel.OriginalPlayerscoreNotExist; return(result); } else { orgPlayerscore.CopyFrom(playerscore); // check if entry state changed if ((_context.Entry(orgPlayerscore).State) == EntityState.Modified) { using (var dbTransaction = _context.Database.BeginTransaction()) { try { await _context.SaveChangesAsync(); dbTransaction.Commit(); result = ErrorCodeModel.Succeeded; // succeeded to update } catch (DbUpdateException ex) { string msg = ex.ToString(); Console.WriteLine("Failed to update Playerscore table: \n" + msg); dbTransaction.Rollback(); result = ErrorCodeModel.DatabaseError; } } } else { result = ErrorCodeModel.PlayerscoreNotChanged; // no changed } } return(result); }
/// <summary> /// Finds the one playerscore by playerscore no. /// </summary> /// <returns>The one playerscore by playerscore no.</returns> /// <param name="playerName">Playerscore no.</param> public async Task <Playerscore> FindOnePlayerscoreByPlayerName(string playerName) { Playerscore playerscore = await _context.Playerscore.Where(x => x.PlayerName == playerName).SingleOrDefaultAsync(); return(playerscore); }