public void Incluir(EntityCategoria entity)
{
using (SqlConnection cnn = new SqlConnection(ConnectionString))
{
cnn.Open();
SqlCommand cmd = cnn.CreateCommand();
cmd.CommandText = "INSERT INTO categoria (nm_categoria, ds_categoria) VALUES (@nm_categoria, @ds_categoria)";
cmd.Parameters.Add(new SqlParameter("@nm_categoria", entity.NmCategoria));
cmd.Parameters.Add(new SqlParameter("@ds_categoria", entity.DsCategoria));
cmd.ExecuteNonQuery();
}
}
public void Atualizar(EntityCategoria entity)
{
using (SqlConnection cnn = new SqlConnection(ConnectionString))
{
cnn.Open();
SqlCommand cmd = cnn.CreateCommand();
cmd.CommandText = "UPDATE categoria SET nm_categoria = @nm_categoria, ds_categoria = @ds_categoria WHERE cd_categoria = @cd_categoria";
cmd.Parameters.Add(new SqlParameter("@cd_categoria", entity.CdCategoria));
cmd.Parameters.Add(new SqlParameter("@nm_categoria", entity.NmCategoria));
cmd.Parameters.Add(new SqlParameter("@ds_categoria", entity.DsCategoria));
cmd.ExecuteNonQuery();
}
}
public void Incluir(EntityCategoria entity)
{
dal.Incluir(entity);
}
public void Atualizar(EntityCategoria entity)
{
dal.Atualizar(entity);
}
