public bool AlterarEditora(int id, Editora editora)
 {
     try
     {
         using (var db = new RealBooksContexto())
         {
             using (var transaction = db.Database.BeginTransaction())
             {
                 try
                 {
                     var resultEditora = db.Editoras.Where(e => e.EditoraId == id).FirstOrDefault();
                     resultEditora.Nome          = editora.Nome;
                     resultEditora.Email         = editora.Email;
                     resultEditora.Cnpj          = editora.Cnpj;
                     resultEditora.Telefone      = editora.Telefone;
                     resultEditora.NumeroCelular = editora.NumeroCelular;
                     db.SaveChanges();
                     transaction.Commit();
                 }
                 catch (Exception e)
                 {
                     transaction.Rollback();
                     throw e;
                 }
             }
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
     return(true);
 }
 public List <Editora> listarEditoras()
 {
     try
     {
         using (var db = new RealBooksContexto())
         {
             return(db.Editoras.ToList());
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public List <Editora> listarEditorasPorId(int id)
 {
     try
     {
         using (var db = new RealBooksContexto())
         {
             return(db.Editoras.Where(p => p.EditoraId == id).ToList());
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public bool RegistraEditora(Editora editora)
 {
     try
     {
         using (var db = new RealBooksContexto())
         {
             db.Editoras.Add(editora);
             db.SaveChanges();
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
     return(true);
 }
 public bool RemoverEditora(int id)
 {
     try
     {
         using (var db = new RealBooksContexto())
         {
             var editora = db.Editoras.Where(i => i.EditoraId == id).FirstOrDefault();
             db.Editoras.Remove(editora);
             db.SaveChanges();
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
     return(true);
 }