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);
}
}
