Index: src/main/java/com/example/moviezone/repository/SeatRepository.java
===================================================================
--- src/main/java/com/example/moviezone/repository/SeatRepository.java	(revision 3242ef4a24cd69e2e10646e919b1e21b399d36a4)
+++ src/main/java/com/example/moviezone/repository/SeatRepository.java	(revision fdc651c3b08ccf0c24f6d0d115b26594a1fc0b50)
@@ -1,9 +1,13 @@
 package com.example.moviezone.repository;
 
+import com.example.moviezone.model.Projection_Room;
 import com.example.moviezone.model.Seat;
 import org.springframework.data.jpa.repository.JpaRepository;
 import org.springframework.stereotype.Repository;
 
+import java.util.List;
+
 @Repository
 public interface SeatRepository extends JpaRepository<Seat,Integer> {
+    List<Seat> findAllByProjection_room(Projection_Room projection_room);
 }
Index: src/main/java/com/example/moviezone/service/Impl/SeatServiceImpl.java
===================================================================
--- src/main/java/com/example/moviezone/service/Impl/SeatServiceImpl.java	(revision fdc651c3b08ccf0c24f6d0d115b26594a1fc0b50)
+++ src/main/java/com/example/moviezone/service/Impl/SeatServiceImpl.java	(revision fdc651c3b08ccf0c24f6d0d115b26594a1fc0b50)
@@ -0,0 +1,28 @@
+package com.example.moviezone.service.Impl;
+
+import com.example.moviezone.model.Projection_Room;
+import com.example.moviezone.model.Seat;
+import com.example.moviezone.repository.SeatRepository;
+import com.example.moviezone.service.SeatService;
+import org.springframework.stereotype.Service;
+
+import java.util.List;
+
+@Service
+public class SeatServiceImpl implements SeatService {
+    private final SeatRepository seatRepository;
+
+    public SeatServiceImpl(SeatRepository seatRepository) {
+        this.seatRepository = seatRepository;
+    }
+
+    @Override
+    public List<Seat> findAllSeats() {
+        return seatRepository.findAll();
+    }
+
+    @Override
+    public List<Seat> findAllByProjection_Room(Projection_Room projection_room) {
+        return seatRepository.findAllByProjection_room(projection_room);
+    }
+}
Index: src/main/java/com/example/moviezone/service/SeatService.java
===================================================================
--- src/main/java/com/example/moviezone/service/SeatService.java	(revision fdc651c3b08ccf0c24f6d0d115b26594a1fc0b50)
+++ src/main/java/com/example/moviezone/service/SeatService.java	(revision fdc651c3b08ccf0c24f6d0d115b26594a1fc0b50)
@@ -0,0 +1,11 @@
+package com.example.moviezone.service;
+
+import com.example.moviezone.model.Projection_Room;
+import com.example.moviezone.model.Seat;
+
+import java.util.List;
+
+public interface SeatService {
+    List<Seat> findAllSeats();
+    List<Seat> findAllByProjection_Room(Projection_Room projection_room);
+}