From a9b520b0d51db85cec0c11c11d22ee70414e5034 Mon Sep 17 00:00:00 2001
From: Dayana31 <70593166+Dayana31@users.noreply.github.com>
Date: Sat, 28 May 2022 18:16:11 -0500
Subject: Imp de Dao

---
 .../edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java | 87 ++++++++++++++++++++++
 .../edu/pucp/odiparback/dao/imp/AveriaDaoImp.java  | 87 ++++++++++++++++++++++
 .../edu/pucp/odiparback/dao/imp/CamionDaoImp.java  | 87 ++++++++++++++++++++++
 .../edu/pucp/odiparback/dao/imp/ClienteDaoImp.java | 86 +++++++++++++++++++++
 .../pe/edu/pucp/odiparback/dao/imp/PTGDaoImp.java  | 86 +++++++++++++++++++++
 .../edu/pucp/odiparback/dao/imp/PedidoDaoImp.java  | 85 +++++++++++++++++++++
 .../edu/pucp/odiparback/dao/imp/RegionDaoImp.java  | 85 +++++++++++++++++++++
 .../pe/edu/pucp/odiparback/dao/imp/RutaDaoImp.java | 85 +++++++++++++++++++++
 .../pucp/odiparback/dao/imp/TipoAveriaDaoImp.java  | 85 +++++++++++++++++++++
 .../pucp/odiparback/dao/imp/TipoCamionDaoImp.java  | 85 +++++++++++++++++++++
 .../edu/pucp/odiparback/dao/imp/TramoDaoImp.java   | 85 +++++++++++++++++++++
 .../pucp/odiparback/dao/imp/TramoRutaDaoImp.java   | 86 +++++++++++++++++++++
 .../edu/pucp/odiparback/dao/imp/UsuarioDaoImp.java | 85 +++++++++++++++++++++
 13 files changed, 1114 insertions(+)
 create mode 100644 back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java
 create mode 100644 back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AveriaDaoImp.java
 create mode 100644 back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/CamionDaoImp.java
 create mode 100644 back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/ClienteDaoImp.java
 create mode 100644 back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PTGDaoImp.java
 create mode 100644 back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PedidoDaoImp.java
 create mode 100644 back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RegionDaoImp.java
 create mode 100644 back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RutaDaoImp.java
 create mode 100644 back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoAveriaDaoImp.java
 create mode 100644 back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoCamionDaoImp.java
 create mode 100644 back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoDaoImp.java
 create mode 100644 back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoRutaDaoImp.java
 create mode 100644 back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/UsuarioDaoImp.java

diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java
new file mode 100644
index 0000000..575d38a
--- /dev/null
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java
@@ -0,0 +1,87 @@
+package pe.edu.pucp.odiparback.dao.imp;
+import java.util.List;
+
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+
+import pe.edu.pucp.odiparback.models.Almacen;
+import pe.edu.pucp.odiparback.dao.AlmacenDao;
+
+import org.springframework.stereotype.Repository;
+import org.springframework.transaction.annotation.Transactional;
+
+
+@Transactional
+@Repository
+@SuppressWarnings("unchecked")
+public class AlmacenDaoImp implements AlmacenDao {
+    @PersistenceContext
+    EntityManager entityManager;
+
+    @Transactional
+    @Override
+    public List<Almacen> getAll() {
+        List<Almacen> resultado = null;
+        try{
+            String query = "SELECT * FROM ODP_Almacen";
+            resultado =  entityManager.createQuery(query).getResultList();
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public Almacen get(int id) {
+        Almacen resultado = null;
+        try {
+            resultado = entityManager.find(Almacen.class, id);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public void register(Almacen almacen) {
+        try {
+            entityManager.merge(almacen);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+    }
+
+    @Transactional
+    @Override
+    public Almacen update(Almacen almacen) {
+        try {
+            entityManager.merge(almacen);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        return almacen;
+    }
+
+    @Transactional
+    @Override
+    public void delete(int id) {
+        Almacen resultado = get(id);
+        try {
+            entityManager.remove(resultado);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+    }
+    
+}
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AveriaDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AveriaDaoImp.java
new file mode 100644
index 0000000..1bf1882
--- /dev/null
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AveriaDaoImp.java
@@ -0,0 +1,87 @@
+package pe.edu.pucp.odiparback.dao.imp;
+import java.util.List;
+
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+
+import pe.edu.pucp.odiparback.models.Averia;
+import pe.edu.pucp.odiparback.dao.AveriaDao;
+
+import org.springframework.stereotype.Repository;
+import org.springframework.transaction.annotation.Transactional;
+
+
+@Transactional
+@Repository
+@SuppressWarnings("unchecked")
+public class AveriaDaoImp implements AveriaDao{
+    @PersistenceContext
+    EntityManager entityManager;
+
+    @Transactional
+    @Override
+    public List<Averia> getAll() {
+        List<Averia> resultado = null;
+        try{
+            String query = "SELECT * FROM ODP_Averia";
+            resultado =  entityManager.createQuery(query).getResultList();
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public Averia get(int id) {
+        Averia resultado = null;
+        try {
+            resultado = entityManager.find(Averia.class, id);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public void register(Averia averia) {
+        try {
+            entityManager.merge(averia);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+    }
+
+    @Transactional
+    @Override
+    public Averia update(Averia averia) {
+        try {
+            entityManager.merge(averia);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        return averia;
+    }
+
+    @Transactional
+    @Override
+    public void delete(int id) {
+        Averia resultado = get(id);
+        try {
+            entityManager.remove(resultado);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+    }
+    
+}
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/CamionDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/CamionDaoImp.java
new file mode 100644
index 0000000..4c97808
--- /dev/null
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/CamionDaoImp.java
@@ -0,0 +1,87 @@
+package pe.edu.pucp.odiparback.dao.imp;
+import java.util.List;
+
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+
+import pe.edu.pucp.odiparback.models.Camion;
+import pe.edu.pucp.odiparback.dao.CamionDao;
+
+import org.springframework.stereotype.Repository;
+import org.springframework.transaction.annotation.Transactional;
+
+
+@Transactional
+@Repository
+@SuppressWarnings("unchecked")
+public class CamionDaoImp implements CamionDao {
+    @PersistenceContext
+    EntityManager entityManager;
+
+    @Transactional
+    @Override
+    public List<Camion> getAll() {
+        List<Camion> resultado = null;
+        try{
+            String query = "SELECT * FROM ODP_Camion";
+            resultado =  entityManager.createQuery(query).getResultList();
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public Camion get(int id) {
+        Camion resultado = null;
+        try {
+            resultado = entityManager.find(Camion.class, id);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public void register(Camion camion) {
+        try {
+            entityManager.merge(camion);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+    }
+
+    @Transactional
+    @Override
+    public Camion update(Camion camion) {
+        try {
+            entityManager.merge(camion);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        return camion;
+    }
+
+    @Transactional
+    @Override
+    public void delete(int id) {
+        Camion resultado = get(id);
+        try {
+            entityManager.remove(resultado);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+    }
+    
+}
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/ClienteDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/ClienteDaoImp.java
new file mode 100644
index 0000000..2a9ae44
--- /dev/null
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/ClienteDaoImp.java
@@ -0,0 +1,86 @@
+package pe.edu.pucp.odiparback.dao.imp;
+import java.util.List;
+
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+
+import pe.edu.pucp.odiparback.models.Cliente;
+import pe.edu.pucp.odiparback.dao.ClienteDao;
+
+import org.springframework.stereotype.Repository;
+import org.springframework.transaction.annotation.Transactional;
+
+
+@Transactional
+@Repository
+@SuppressWarnings("unchecked")
+public class ClienteDaoImp implements ClienteDao {
+    @PersistenceContext
+    EntityManager entityManager;
+
+    @Transactional
+    @Override
+    public List<Cliente> getAll() {
+        List<Cliente> resultado = null;
+        try{
+            String query = "SELECT * FROM ODP_Cliente";
+            resultado =  entityManager.createQuery(query).getResultList();
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public Cliente get(int id) {
+        Cliente resultado = null;
+        try {
+            resultado = entityManager.find(Cliente.class, id);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public void register(Cliente cliente) {
+        try {
+            entityManager.merge(cliente);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+    }
+
+    @Transactional
+    @Override
+    public Cliente update(Cliente cliente) {
+        try {
+            entityManager.merge(cliente);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        return cliente;
+    }
+
+    @Transactional
+    @Override
+    public void delete(int id) {
+        Cliente resultado = get(id);
+        try {
+            entityManager.remove(resultado);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+    }
+    
+}
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PTGDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PTGDaoImp.java
new file mode 100644
index 0000000..ac076cf
--- /dev/null
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PTGDaoImp.java
@@ -0,0 +1,86 @@
+package pe.edu.pucp.odiparback.dao.imp;
+import java.util.List;
+
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+
+import pe.edu.pucp.odiparback.models.PTG;
+import pe.edu.pucp.odiparback.dao.PTGDao;
+
+import org.springframework.stereotype.Repository;
+import org.springframework.transaction.annotation.Transactional;
+
+
+@Transactional
+@Repository
+@SuppressWarnings("unchecked")
+public class PTGDaoImp implements PTGDao{
+    @PersistenceContext
+    EntityManager entityManager;
+
+    @Transactional
+    @Override
+    public List<PTG> getAll() {
+        List<PTG> resultado = null;
+        try{
+            String query = "SELECT * FROM ODP_PTG";
+            resultado =  entityManager.createQuery(query).getResultList();
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public PTG get(int id) {
+        PTG resultado = null;
+        try {
+            resultado = entityManager.find(PTG.class, id);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public void register(PTG planTransporte) {
+        try {
+            entityManager.merge(planTransporte);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+    }
+
+    @Transactional
+    @Override
+    public PTG update(PTG planTransporte) {
+        try {
+            entityManager.merge(planTransporte);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        return planTransporte;
+    }
+
+    @Transactional
+    @Override
+    public void delete(int id) {
+        PTG resultado = get(id);
+        try {
+            entityManager.remove(resultado);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+    }
+    
+}
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PedidoDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PedidoDaoImp.java
new file mode 100644
index 0000000..3ebc387
--- /dev/null
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PedidoDaoImp.java
@@ -0,0 +1,85 @@
+package pe.edu.pucp.odiparback.dao.imp;
+import java.util.List;
+
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+
+import pe.edu.pucp.odiparback.models.Pedido;
+import pe.edu.pucp.odiparback.dao.PedidoDao;
+
+import org.springframework.stereotype.Repository;
+import org.springframework.transaction.annotation.Transactional;
+
+
+@Transactional
+@Repository
+@SuppressWarnings("unchecked")
+public class PedidoDaoImp implements PedidoDao {
+    @PersistenceContext
+    EntityManager entityManager;
+
+    @Transactional
+    @Override
+    public List<Pedido> getAll() {
+        List<Pedido> resultado = null;
+        try{
+            String query = "SELECT * FROM ODP_Pedido";
+            resultado =  entityManager.createQuery(query).getResultList();
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public Pedido get(int id) {
+        Pedido resultado = null;
+        try {
+            resultado = entityManager.find(Pedido.class, id);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public void register(Pedido pedido) {
+        try {
+            entityManager.merge(pedido);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+    }
+
+    @Transactional
+    @Override
+    public Pedido update(Pedido pedido) {
+        try {
+            entityManager.merge(pedido);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        return pedido;
+    }
+
+    @Transactional
+    @Override
+    public void delete(int id) {
+        Pedido resultado = get(id);
+        try {
+            entityManager.remove(resultado);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+    }
+    
+}
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RegionDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RegionDaoImp.java
new file mode 100644
index 0000000..15788d4
--- /dev/null
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RegionDaoImp.java
@@ -0,0 +1,85 @@
+package pe.edu.pucp.odiparback.dao.imp;
+import java.util.List;
+
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+
+import pe.edu.pucp.odiparback.models.Region;
+import pe.edu.pucp.odiparback.dao.RegionDao;
+
+import org.springframework.stereotype.Repository;
+import org.springframework.transaction.annotation.Transactional;
+
+
+@Transactional
+@Repository
+@SuppressWarnings("unchecked")
+public class RegionDaoImp implements RegionDao {
+    @PersistenceContext
+    EntityManager entityManager;
+
+    @Transactional
+    @Override
+    public List<Region> getAll() {
+        List<Region> resultado = null;
+        try{
+            String query = "SELECT * FROM ODP_Region";
+            resultado =  entityManager.createQuery(query).getResultList();
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public Region get(int id) {
+        Region resultado = null;
+        try {
+            resultado = entityManager.find(Region.class, id);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public void register(Region region) {
+        try {
+            entityManager.merge(region);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+    }
+
+    @Transactional
+    @Override
+    public Region update(Region region) {
+        try {
+            entityManager.merge(region);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        return region;
+    }
+
+    @Transactional
+    @Override
+    public void delete(int id) {
+        Region resultado = get(id);
+        try {
+            entityManager.remove(resultado);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+    }
+    
+}
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RutaDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RutaDaoImp.java
new file mode 100644
index 0000000..0e491b7
--- /dev/null
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RutaDaoImp.java
@@ -0,0 +1,85 @@
+package pe.edu.pucp.odiparback.dao.imp;
+import java.util.List;
+
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+
+import pe.edu.pucp.odiparback.models.Ruta;
+import pe.edu.pucp.odiparback.dao.RutaDao;
+
+import org.springframework.stereotype.Repository;
+import org.springframework.transaction.annotation.Transactional;
+
+
+@Transactional
+@Repository
+@SuppressWarnings("unchecked")
+public class RutaDaoImp implements RutaDao {
+    @PersistenceContext
+    EntityManager entityManager;
+
+    @Transactional
+    @Override
+    public List<Ruta> getAll() {
+        List<Ruta> resultado = null;
+        try{
+            String query = "SELECT * FROM ODP_Ruta";
+            resultado =  entityManager.createQuery(query).getResultList();
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public Ruta get(int id) {
+        Ruta resultado = null;
+        try {
+            resultado = entityManager.find(Ruta.class, id);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public void register(Ruta ruta) {
+        try {
+            entityManager.merge(ruta);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+    }
+
+    @Transactional
+    @Override
+    public Ruta update(Ruta ruta) {
+        try {
+            entityManager.merge(ruta);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        return ruta;
+    }
+
+    @Transactional
+    @Override
+    public void delete(int id) {
+        Ruta resultado = get(id);
+        try {
+            entityManager.remove(resultado);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+    }
+    
+}
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoAveriaDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoAveriaDaoImp.java
new file mode 100644
index 0000000..f2980cf
--- /dev/null
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoAveriaDaoImp.java
@@ -0,0 +1,85 @@
+package pe.edu.pucp.odiparback.dao.imp;
+import java.util.List;
+
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+
+import pe.edu.pucp.odiparback.models.TipoAveria;
+import pe.edu.pucp.odiparback.dao.TipoAveriaDao;
+
+import org.springframework.stereotype.Repository;
+import org.springframework.transaction.annotation.Transactional;
+
+
+@Transactional
+@Repository
+@SuppressWarnings("unchecked")
+public class TipoAveriaDaoImp implements TipoAveriaDao{
+    @PersistenceContext
+    EntityManager entityManager;
+
+    @Transactional
+    @Override
+    public List<TipoAveria> getAll() {
+        List<TipoAveria> resultado = null;
+        try{
+            String query = "SELECT * FROM ODP_TipoAveria";
+            resultado =  entityManager.createQuery(query).getResultList();
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public TipoAveria get(int id) {
+        TipoAveria resultado = null;
+        try {
+            resultado = entityManager.find(TipoAveria.class, id);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public void register(TipoAveria tipoAveria) {
+        try {
+            entityManager.merge(tipoAveria);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+    }
+
+    @Transactional
+    @Override
+    public TipoAveria update(TipoAveria tipoAveria) {
+        try {
+            entityManager.merge(tipoAveria);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        return tipoAveria;
+    }
+
+    @Transactional
+    @Override
+    public void delete(int id) {
+        TipoAveria resultado = get(id);
+        try {
+            entityManager.remove(resultado);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+    }
+    
+}
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoCamionDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoCamionDaoImp.java
new file mode 100644
index 0000000..0889570
--- /dev/null
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoCamionDaoImp.java
@@ -0,0 +1,85 @@
+package pe.edu.pucp.odiparback.dao.imp;
+import java.util.List;
+
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+
+import pe.edu.pucp.odiparback.models.TipoCamion;
+import pe.edu.pucp.odiparback.dao.TipoCamionDao;
+
+import org.springframework.stereotype.Repository;
+import org.springframework.transaction.annotation.Transactional;
+
+
+@Transactional
+@Repository
+@SuppressWarnings("unchecked")
+public class TipoCamionDaoImp implements TipoCamionDao{
+    @PersistenceContext
+    EntityManager entityManager;
+
+    @Transactional
+    @Override
+    public List<TipoCamion> getAll() {
+        List<TipoCamion> resultado = null;
+        try{
+            String query = "SELECT * FROM ODP_TipoCamion";
+            resultado =  entityManager.createQuery(query).getResultList();
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public TipoCamion get(int id) {
+        TipoCamion resultado = null;
+        try {
+            resultado = entityManager.find(TipoCamion.class, id);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public void register(TipoCamion tipoCamion) {
+        try {
+            entityManager.merge(tipoCamion);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+    }
+
+    @Transactional
+    @Override
+    public TipoCamion update(TipoCamion tipoCamion) {
+        try {
+            entityManager.merge(tipoCamion);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        return tipoCamion;
+    }
+
+    @Transactional
+    @Override
+    public void delete(int id) {
+        TipoCamion resultado = get(id);
+        try {
+            entityManager.remove(resultado);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+    }
+    
+}
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoDaoImp.java
new file mode 100644
index 0000000..717dcf2
--- /dev/null
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoDaoImp.java
@@ -0,0 +1,85 @@
+package pe.edu.pucp.odiparback.dao.imp;
+import java.util.List;
+
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+
+import pe.edu.pucp.odiparback.models.Tramo;
+import pe.edu.pucp.odiparback.dao.TramoDao;
+
+import org.springframework.stereotype.Repository;
+import org.springframework.transaction.annotation.Transactional;
+
+
+@Transactional
+@Repository
+@SuppressWarnings("unchecked")
+public class TramoDaoImp implements TramoDao{
+    @PersistenceContext
+    EntityManager entityManager;
+
+    @Transactional
+    @Override
+    public List<Tramo> getAll() {
+        List<Tramo> resultado = null;
+        try{
+            String query = "SELECT * FROM ODP_Tramo";
+            resultado =  entityManager.createQuery(query).getResultList();
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public Tramo get(int id) {
+        Tramo resultado = null;
+        try {
+            resultado = entityManager.find(Tramo.class, id);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public void register(Tramo tramo) {
+        try {
+            entityManager.merge(tramo);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+    }
+
+    @Transactional
+    @Override
+    public Tramo update(Tramo tramo) {
+        try {
+            entityManager.merge(tramo);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        return tramo;
+    }
+
+    @Transactional
+    @Override
+    public void delete(int id) {
+        Tramo resultado = get(id);
+        try {
+            entityManager.remove(resultado);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+    }
+    
+}
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoRutaDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoRutaDaoImp.java
new file mode 100644
index 0000000..1808c61
--- /dev/null
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoRutaDaoImp.java
@@ -0,0 +1,86 @@
+package pe.edu.pucp.odiparback.dao.imp;
+import java.util.List;
+
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+
+import pe.edu.pucp.odiparback.models.TramoRuta;
+import pe.edu.pucp.odiparback.dao.TramoRutaDao;
+
+import org.springframework.stereotype.Repository;
+import org.springframework.transaction.annotation.Transactional;
+
+
+@Transactional
+@Repository
+@SuppressWarnings("unchecked")
+public class TramoRutaDaoImp implements TramoRutaDao {
+    @PersistenceContext
+    EntityManager entityManager;
+
+    @Transactional
+    @Override
+    public List<TramoRuta> getAll() {
+        List<TramoRuta> resultado = null;
+        try{
+            String query = "SELECT * FROM ODP_TramoRuta";
+            resultado =  entityManager.createQuery(query).getResultList();
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public TramoRuta get(int id) {
+        TramoRuta resultado = null;
+        try {
+            resultado = entityManager.find(TramoRuta.class, id);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public void register(TramoRuta tramoRuta) {
+        try {
+            entityManager.merge(tramoRuta);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+    }
+
+    @Transactional
+    @Override
+    public TramoRuta update(TramoRuta tramoRuta) {
+        try {
+            entityManager.merge(tramoRuta);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        return tramoRuta;
+    }
+
+    @Transactional
+    @Override
+    public void delete(int id) {
+        TramoRuta resultado = get(id);
+        try {
+            entityManager.remove(resultado);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+    }
+    
+}
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/UsuarioDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/UsuarioDaoImp.java
new file mode 100644
index 0000000..c0e6ef1
--- /dev/null
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/UsuarioDaoImp.java
@@ -0,0 +1,85 @@
+package pe.edu.pucp.odiparback.dao.imp;
+import java.util.List;
+
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+
+import pe.edu.pucp.odiparback.models.Usuario;
+import pe.edu.pucp.odiparback.dao.UsuarioDao;
+
+import org.springframework.stereotype.Repository;
+import org.springframework.transaction.annotation.Transactional;
+
+
+@Transactional
+@Repository
+@SuppressWarnings("unchecked")
+public class UsuarioDaoImp implements UsuarioDao{
+    @PersistenceContext
+    EntityManager entityManager;
+
+    @Transactional
+    @Override
+    public List<Usuario> getAll() {
+        List<Usuario> resultado = null;
+        try{
+            String query = "SELECT * FROM ODP_Usuario";
+            resultado =  entityManager.createQuery(query).getResultList();
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public Usuario get(int id) {
+        Usuario resultado = null;
+        try {
+            resultado = entityManager.find(Usuario.class, id);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
+    @Transactional
+    @Override
+    public void register(Usuario usuario) {
+        try {
+            entityManager.merge(usuario);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+    }
+
+    @Transactional
+    @Override
+    public Usuario update(Usuario usuario) {
+        try {
+            entityManager.merge(usuario);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        return usuario;
+    }
+
+    @Transactional
+    @Override
+    public void delete(int id) {
+        Usuario resultado = get(id);
+        try {
+            entityManager.remove(resultado);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+    }
+    
+}
-- 
cgit v1.2.3