public static void Excluir(Filial filial)
{
SqlConnection con = new SqlConnection(Utils.connectionString);
SqlCommand com = new SqlCommand();
com.Connection = con;
com.CommandText = "DELETE FROM Filial WHERE Cnpj = '@cnpj'";
com.Parameters.AddWithValue("@cnpj", filial.numCNPJ);
con.Open();
com.ExecuteNonQuery();
con.Close();
}
private void butCadastrar_Click(object sender, EventArgs e)
{
Filial f = new Filial(txtNome.Text, txtCnpj.Text);
string resultado = ValidaCampos();
if (!string.IsNullOrEmpty(resultado))
{
MessageBox.Show(resultado);
return;
}
GerFilial.Gravar(f);
limparTela();
}
public static void Gravar(Filial filial)
{
SqlConnection con = new SqlConnection(Utils.connectionString);
SqlCommand com = new SqlCommand();
com.Connection = con;
com.CommandText = "INSERT INTO Filial VALUES (@nome, @cnpj)";
com.Parameters.AddWithValue("@nome", filial.nome);
com.Parameters.AddWithValue("@cnpj", filial.numCNPJ);
con.Open();
com.ExecuteNonQuery();
con.Close();
}