private void ButtonUpdate_Click(object sender, EventArgs e)
{
if (!ValidateData())
{
MessageBox.Show("You must use numbers in fields except for name.");
return;
}
int result = 0;
var db = new AccountDB();
var dbError = db.Open();
if (dbError.Number != 0)
{
var errorText = $"Cannot connect to database {Environment.NewLine}";
errorText += $"Error Number: {dbError.Number}{Environment.NewLine}";
errorText += $"Error Message: {dbError.Message}";
MessageBox.Show(errorText);
}
else
{
if (db.Connected)
{
var character = FillCharacterData();
// Se hovuer alguma alteração no nome, procura na db.
if (name != character.Name)
{
if (db.ExistCharacter(character.Name))
{
MessageBox.Show("Name is already in use.");
db.Close();
return;
}
}
result = db.UpdateCharacter(CharacterId, ref character);
MessageBox.Show("Character updated.");
}
else
{
MessageBox.Show("Database is not connected.");
}
}
db.Close();
if (result > 0)
{
Close();
}
}
