Closed italopessoa closed 4 months ago
The GetAllAsync()
method in the OrderRepositoryDapper
class has been updated to enhance the SQL query. The method now filters orders to include only those with status values 2, 3, and 4, and sorts the results by status in descending order followed by the creation date. This change aims to streamline order retrieval based on specific statuses and ensure a more organized display of orders.
File | Summary of Changes |
---|---|
src/.../OrderRepositoryDapper.cs |
Modified the GetAllAsync() method to filter orders by status values 2, 3, 4 and sort by status in descending order and creation date. |
sequenceDiagram
participant Client
participant OrderRepositoryDapper
participant Database
Client->>OrderRepositoryDapper: GetAllAsync()
OrderRepositoryDapper->>Database: Execute SQL Query with status filter and order by clauses
Database-->>OrderRepositoryDapper: Return filtered and sorted orders
OrderRepositoryDapper-->>Client: Return ReadOnlyCollection<Order>
Thank you for using CodeRabbit. We offer it for free to the OSS community and would appreciate your support in helping us grow. If you find it useful, would you consider giving us a shout-out on your favorite social media?