public void Excluir(BLL.CategoriaBLL c) { SqlCommand cmd = new SqlCommand(); cmd.Connection = con.Conectar(); cmd.CommandText = @"DELETE FROM TBCategoria WHERE ID = @id"; cmd.Parameters.AddWithValue("@id", c.Id); cmd.ExecuteNonQuery(); con.Desconectar(); }
protected void btnCadastrar_Click(object sender, EventArgs e) { BLL.CategoriaBLL c = new BLL.CategoriaBLL(); c.Descricao = txtDescricao.Text; DAL.CategoriaDAL cDAL = new DAL.CategoriaDAL(); cDAL.Cadastrar(c); txtDescricao.Text = ""; txtDescricao.Focus(); }
public void Cadastrar(BLL.CategoriaBLL c) { SqlCommand cmd = new SqlCommand(); cmd.Connection = con.Conectar(); cmd.CommandText = @"INSERT INTO TBCategoria( DESCRICAO)VALUES(@descricao)"; cmd.Parameters.Add("@descricao", SqlDbType.VarChar).Value = c.Descricao; cmd.ExecuteNonQuery(); con.Desconectar(); }
public void Atualizar(BLL.CategoriaBLL c) { SqlCommand cmd = new SqlCommand(); cmd.Connection = con.Conectar(); cmd.CommandText = @"UPDATE TBCategoria SET DESCRICAO = @descricao WHERE ID = @id"; cmd.Parameters.AddWithValue("@id", c.Id); cmd.Parameters.AddWithValue("@descricao", c.Descricao); cmd.ExecuteNonQuery(); con.Desconectar(); }
public DataTable Consultar(BLL.CategoriaBLL c) { DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con.Conectar(); cmd.CommandText = @"SELECT ID,DESCRICAO FROM TBCategoria WHERE DESCRICAO LIKE @descricao"; cmd.Parameters.AddWithValue("@descricao", "%" + c.Descricao + "%"); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(dt); con.Desconectar(); return(dt); }