Index: src/main/java/com/example/moviezone/model/Seat.java
===================================================================
--- src/main/java/com/example/moviezone/model/Seat.java	(revision 8d49568b45934c7dcbd70459d458916e4faa5ef0)
+++ src/main/java/com/example/moviezone/model/Seat.java	(revision 64ee7f450ed7bddbe5e9254cecde3a53ef0a9c68)
@@ -19,5 +19,5 @@
     @ManyToOne
     @JoinColumn(name = "id_room")
-    Projection_Room projection_room;
+    Projection_Room projection;
     @ManyToOne
     @JoinColumn(name = "id_category")
Index: src/main/java/com/example/moviezone/repository/ProjectionIsPlayedInRoomRepository.java
===================================================================
--- src/main/java/com/example/moviezone/repository/ProjectionIsPlayedInRoomRepository.java	(revision 8d49568b45934c7dcbd70459d458916e4faa5ef0)
+++ src/main/java/com/example/moviezone/repository/ProjectionIsPlayedInRoomRepository.java	(revision 64ee7f450ed7bddbe5e9254cecde3a53ef0a9c68)
@@ -4,8 +4,11 @@
 import com.example.moviezone.model.manytomany.ProjectionIsPlayedInRoomId;
 import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.repository.query.Param;
 
 import java.util.List;
 
 public interface ProjectionIsPlayedInRoomRepository extends JpaRepository<ProjectionIsPlayedInRoom, ProjectionIsPlayedInRoomId> {
-    List<ProjectionIsPlayedInRoom> findAllById_projection(Integer id_projection);
+    @Query("SELECT pir FROM ProjectionIsPlayedInRoom pir WHERE pir.id_projection = :id_projection")
+    List<ProjectionIsPlayedInRoom> findAllByProjectionId(@Param("id_projection") Integer id_projection);
 }
Index: src/main/java/com/example/moviezone/repository/SeatRepository.java
===================================================================
--- src/main/java/com/example/moviezone/repository/SeatRepository.java	(revision 8d49568b45934c7dcbd70459d458916e4faa5ef0)
+++ src/main/java/com/example/moviezone/repository/SeatRepository.java	(revision 64ee7f450ed7bddbe5e9254cecde3a53ef0a9c68)
@@ -10,4 +10,4 @@
 @Repository
 public interface SeatRepository extends JpaRepository<Seat,Integer> {
-    List<Seat> findAllByProjection_room(Projection_Room projection_room);
+    List<Seat> findAllByProjection(Projection_Room projection);
 }
Index: src/main/java/com/example/moviezone/service/Impl/ProjectionIsPlayedInRoomServiceImpl.java
===================================================================
--- src/main/java/com/example/moviezone/service/Impl/ProjectionIsPlayedInRoomServiceImpl.java	(revision 8d49568b45934c7dcbd70459d458916e4faa5ef0)
+++ src/main/java/com/example/moviezone/service/Impl/ProjectionIsPlayedInRoomServiceImpl.java	(revision 64ee7f450ed7bddbe5e9254cecde3a53ef0a9c68)
@@ -1,7 +1,11 @@
 package com.example.moviezone.service.Impl;
 
+import com.example.moviezone.model.manytomany.ProjectionIsPlayedInRoom;
 import com.example.moviezone.repository.ProjectionIsPlayedInRoomRepository;
 import com.example.moviezone.service.ProjectionIsPlayedInRoomService;
 import org.springframework.stereotype.Service;
+
+import java.util.List;
+import java.util.Optional;
 
 @Service
@@ -13,3 +17,7 @@
     }
 
+    @Override
+    public List<ProjectionIsPlayedInRoom> getProjectionPlayedInRoom(Integer id) {
+        return projectionIsPlayedInRoomRepository.findAllByProjectionId(id);
+    }
 }
Index: src/main/java/com/example/moviezone/service/Impl/SeatServiceImpl.java
===================================================================
--- src/main/java/com/example/moviezone/service/Impl/SeatServiceImpl.java	(revision 8d49568b45934c7dcbd70459d458916e4faa5ef0)
+++ src/main/java/com/example/moviezone/service/Impl/SeatServiceImpl.java	(revision 64ee7f450ed7bddbe5e9254cecde3a53ef0a9c68)
@@ -24,5 +24,5 @@
     @Override
     public List<Seat> findAllByProjection_Room(Projection_Room projection_room) {
-        return seatRepository.findAllByProjection_room(projection_room);
+        return seatRepository.findAllByProjection(projection_room);
     }
 }
Index: src/main/java/com/example/moviezone/service/ProjectionIsPlayedInRoomService.java
===================================================================
--- src/main/java/com/example/moviezone/service/ProjectionIsPlayedInRoomService.java	(revision 8d49568b45934c7dcbd70459d458916e4faa5ef0)
+++ src/main/java/com/example/moviezone/service/ProjectionIsPlayedInRoomService.java	(revision 64ee7f450ed7bddbe5e9254cecde3a53ef0a9c68)
@@ -1,6 +1,12 @@
 package com.example.moviezone.service;
 
+import com.example.moviezone.model.Film;
+import com.example.moviezone.model.manytomany.ProjectionIsPlayedInRoom;
+
+import java.util.List;
+import java.util.Optional;
+
 public interface ProjectionIsPlayedInRoomService {
-
+    List<ProjectionIsPlayedInRoom> getProjectionPlayedInRoom(Integer id);
 
 }
Index: src/main/java/com/example/moviezone/web/HomeController.java
===================================================================
--- src/main/java/com/example/moviezone/web/HomeController.java	(revision 8d49568b45934c7dcbd70459d458916e4faa5ef0)
+++ src/main/java/com/example/moviezone/web/HomeController.java	(revision 64ee7f450ed7bddbe5e9254cecde3a53ef0a9c68)
@@ -36,9 +36,8 @@
 private final CinemaOrganizesEventService cinemaOrganizesEventService;
 private final CinemaPlaysFilmService cinemaPlaysFilmService;
-private final ProjectionIsPlayedInRoomRepository projectionIsPlayedInRoomRepository;
-
-
-    public HomeController(FilmService filmService, UserService userService, ProjectionService projectionService, EventService eventService, TicketService ticketService, WorkerService workerService, CustomerRatesFilmService customerRatesFilmService, CinemaService cinemaService, CinemaOrganizesEventService cinemaOrganizesEventService, CinemaPlaysFilmService cinemaPlaysFilmService, ProjectionIsPlayedInRoomRepository projectionIsPlayedInRoomRepository) {
-
+private final ProjectionIsPlayedInRoomService projectionIsPlayedInRoomService;
+
+
+    public HomeController(FilmService filmService, UserService userService, ProjectionService projectionService, EventService eventService, TicketService ticketService, WorkerService workerService, CustomerRatesFilmService customerRatesFilmService, CinemaService cinemaService, CinemaOrganizesEventService cinemaOrganizesEventService, CinemaPlaysFilmService cinemaPlaysFilmService, ProjectionIsPlayedInRoomService projectionIsPlayedInRoomService) {
         this.filmService = filmService;
         this.userService = userService;
@@ -51,5 +50,5 @@
         this.cinemaOrganizesEventService = cinemaOrganizesEventService;
         this.cinemaPlaysFilmService = cinemaPlaysFilmService;
-        this.projectionIsPlayedInRoomRepository = projectionIsPlayedInRoomRepository;
+        this.projectionIsPlayedInRoomService = projectionIsPlayedInRoomService;
     }
 
@@ -285,5 +284,5 @@
 
 
-        List<ProjectionIsPlayedInRoom> p= projectionIsPlayedInRoomRepository.findAllById_projection(id_projection);
+        List<ProjectionIsPlayedInRoom> p= projectionIsPlayedInRoomService.getProjectionPlayedInRoom(id_projection);
 
         model.addAttribute("projection",projection);