Exemple #1
0
        public void Delete(Modelo.Clientes obj)
        {
            DAL.DALHistorico       AH = new DALHistorico();
            DAL.DALAvaliacao       DA = new DALAvaliacao();
            DAL.DALEndereco        DE = new DALEndereco();
            DAL.DALTransacaoPacote DT = new DALTransacaoPacote();

            DT.DeleteCliente(obj.id);
            DE.DeleteUsuario(obj.id);
            DA.DeleteCliente(obj.id);
            AH.DeleteUsuario(obj.id);

            SqlConnection conn = new SqlConnection(connectionString);

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

            cmd.Parameters.AddWithValue("@Clientes_id", obj.id);

            cmd.ExecuteNonQuery();
            conn.Close();
        }