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