private void bt_salvar_Click(object sender, EventArgs e)
{
Pecas peca = new Pecas();
peca.IdPeca = Convert.ToInt32(tbCodigo.Text);
peca.Peca = tbPeca.Text;
peca.Obs = tbObs.Text;
try
{
Pecas.Cadastrar(peca);
MessageBox.Show("Cadastro efetuado com sucesso!", "Cadastro", MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
}
catch (Exception ex)
{
MessageBox.Show("Erro ao cadastrar dados da Peça : " + ex.Message, "Erro");
}
}
private void bt_salvar_Click(object sender, EventArgs e)
{
Pecas peca = new Pecas();
peca.IdPeca = Convert.ToInt32(tbCodigo.Text);
peca.Peca = tbPeca.Text;
peca.Obs = tbObs.Text;
try
{
Pecas.Cadastrar(peca);
MessageBox.Show("Cadastro efetuado com sucesso!", "Cadastro", MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
}
catch (Exception ex)
{
MessageBox.Show("Erro ao cadastrar dados da Peça : " + ex.Message, "Erro");
}
}
public static void Cadastrar(Pecas peca)
{
using (FbConnection connection = DaoBanco.GetInstancia().getConexao())
{
try
{
connection.Open();
string mSQL = "INSERT INTO Pecas Values (" + peca.IdPeca + ",'" +
peca.Peca + "','" +
peca.Obs + "')";
FbCommand cmd = new FbCommand(mSQL, connection);
cmd.ExecuteNonQuery();
}
catch (FbException fbex)
{
throw fbex;
}
finally
{
connection.Close();
}
}
}
public static void Cadastrar(Pecas peca)
{
using (FbConnection connection = DaoBanco.GetInstancia().getConexao())
{
try
{
connection.Open();
string mSQL = "INSERT INTO Pecas Values (" + peca.IdPeca + ",'" +
peca.Peca + "','" +
peca.Obs + "')";
FbCommand cmd = new FbCommand(mSQL, connection);
cmd.ExecuteNonQuery();
}
catch (FbException fbex)
{
throw fbex;
}
finally
{
connection.Close();
}
}
}