private void AddClassBtn_Click(object sender, EventArgs e)
{
DAOs.ClassBase.DAOclassBase adicionar = new DAOs.ClassBase.DAOclassBase();
adicionar.ClasseNome = TxtBxClassName.Text;
adicionar.Strengh = Convert.ToInt32(TxtBxClassStr.Text);
adicionar.Intell = Convert.ToInt32(TxtBxClassIntell.Text);
adicionar.Charisma = Convert.ToInt32(TxtBxClassChar.Text);
adicionar.Speed = Convert.ToInt32(TxtBxClassSpeed.Text);
adicionar.HP = Convert.ToInt32(TxtBxClassHP.Text);
adicionar.Insert(adicionar);
}
public void Insert(DAOclassBase adicionar)
{
try
{
ConnectionOpen();
MySqlCommand query = new MySqlCommand("INSERT INTO ClassBase(ClasseNome, strengh, intelligence, charisma, speed, HP)" +
"VALUES(@classe, @strengh, @intell, @charisma, @speed, @HP)", conn);
query.Parameters.AddWithValue("@classe", ClasseNome);
query.Parameters.AddWithValue("@strengh", Strengh);
query.Parameters.AddWithValue("@intell", Intell);
query.Parameters.AddWithValue("@charisma", Charisma);
query.Parameters.AddWithValue("@speed", Speed);
query.Parameters.AddWithValue("@HP", HP);
query.ExecuteNonQuery();
}
catch (SqlException err)
{
MessageBox.Show("ERRO:" + err.Message);
ConnectionClose();
}
}