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