private void RegisterScore() { // Checks username if (string.IsNullOrEmpty(usernameText.text) || string.IsNullOrWhiteSpace(usernameText.text)) { messageText.text = "Please, inform the Username!"; return; } // Checks score if (string.IsNullOrEmpty(scoreText.text) || string.IsNullOrWhiteSpace(scoreText.text)) { messageText.text = "Please, inform the Score!"; return; } // Fills model ScoreboardMODEL model = new ScoreboardMODEL(); model.Username = usernameText.text; model.Score = decimal.Parse(scoreText.text); model.ScoreDate = DateTime.Now; ScoreboardDAO scoreboardDAO = new ScoreboardDAO(); string exceptionMessage; bool hasInserted = scoreboardDAO.InsertScoreboard(model, out exceptionMessage); messageText.text = (hasInserted ? "Score registered sucessfully!" : string.Concat("Error on register the Score! ", exceptionMessage)); }
private void DrawTable() { CleanTable(); // Search ScoreboardDAO scoreboardDAO = new ScoreboardDAO(); List <ScoreboardMODEL> listModels = scoreboardDAO.ListScoreboard(); // Params int rankingIndex = 1; float currentPosY = -160; for (int index = 0; index < listModels.Count; index++) { ScoreboardMODEL model = listModels[index]; for (int j = 0; j < 1; j++) { CreateTextElement("Cell", rankingIndex.ToString(), defaultPosition); CreateTextElement("Cell", model.ScoreID.ToString(), defaultPosition); CreateTextElement("Cell", model.Username, defaultPosition); CreateTextElement("Cell", model.Score.ToString(), defaultPosition); CreateTextElement("Cell", model.ScoreDate.ToString(), defaultPosition); CreateButtonElement("Cell", model.ScoreID.ToString(), "Update", defaultPosition); CreateButtonElement("Cell", model.ScoreID.ToString(), "Delete", defaultPosition); currentPosY -= 100f; defaultPosition = new Vector3(-1100, currentPosY, 0); } rankingIndex++; } }
private void LoadScoreData(int scoreID) { if (scoreID <= 0) { return; } // Loads data ScoreboardDAO scoreboardDAO = new ScoreboardDAO(); ScoreboardMODEL model = scoreboardDAO.ListScoreboardByID(scoreID); usernameText.text = model.Username; scoreText.text = model.Score.ToString(); }
private void DeleteScore(int scoreID) { // Cancels if (scoreID <= 0) { return; } ScoreboardDAO scoreboardDAO = new ScoreboardDAO(); string exceptionMessage; bool hasDeleted = scoreboardDAO.Delete(scoreID, out exceptionMessage); if (hasDeleted) { messageText.text = "Score deleted sucessfully"; DrawTable(); } else { messageText.text = string.Concat("Error on delete Score! ", exceptionMessage); } }