Exemple #1
0
        public void Delete(Modelo.Pacote obj)
        {
            SqlConnection conn = new SqlConnection(connectionString);

            DAL.DALAvaliacao       DA  = new DALAvaliacao();
            DAL.DALTransacaoPacote DT  = new DALTransacaoPacote();
            DAL.DALPacote_Refeicao DPR = new DALPacote_Refeicao();
            DAL.DALHistorico       DH  = new DALHistorico();

            DA.DeletePacote(obj.id);
            DT.DeletePacote(obj.id);
            DPR.DeletePacote(obj.id);
            DH.DeletePacote(obj.id);

            conn.Open();
            SqlCommand com = conn.CreateCommand();
            SqlCommand cmd = new SqlCommand("DELETE FROM Pacote WHERE id = @Pacote_id", conn);

            cmd.Parameters.AddWithValue("@Pacote_id", obj.id);
            cmd.ExecuteNonQuery();
            conn.Close();
        }