Package com.esprit.services.products

Class OrderItemService

java.lang.Object
com.esprit.services.products.OrderItemService
All Implemented Interfaces:
IService<OrderItem>
public class OrderItemService extends Object implements IService<OrderItem>

  • Field Details

    • LOGGER

      private static final Logger LOGGER

    • connection

      private final Connection connection

  • Constructor Details

    • OrderItemService

      public OrderItemService()
      Performs OrderItemService operation.

  • Method Details

    • create

      public void create(OrderItem orderItem)
      Specified by:
      create in interface IService<OrderItem>

    • read

      public List<OrderItem> read()
      Specified by:
      read in interface IService<OrderItem>

    • readOrderItem

      public List<OrderItem> readOrderItem(Long orderId)
      Performs readOrderItem operation.
      Returns:
      the result of the operation

    • update

      public void update(OrderItem orderItem)
      Specified by:
      update in interface IService<OrderItem>

    • delete

      public void delete(OrderItem orderItem)
      Specified by:
      delete in interface IService<OrderItem>

    • getOrderItemsByOrder

      public List<OrderItem> getOrderItemsByOrder(int orderId)
      Retrieves the OrderItemsByOrder value.
      Returns:
      the OrderItemsByOrder value

    • getTotalQuantityByCategoryAndDate

      public int getTotalQuantityByCategoryAndDate(String categoryName, String formattedDate)
      Retrieves the TotalQuantityByCategoryAndDate value.
      Returns:
      the TotalQuantityByCategoryAndDate value

    • getItemsByOrder

      public List<OrderItem> getItemsByOrder(int orderId)
      Retrieves the ItemsByOrder value.
      Returns:
      the ItemsByOrder value

    • getAverageRatingSorted

      public List<OrderItem> getAverageRatingSorted()
      Retrieves the AverageRatingSorted value.
      Returns:
      the AverageRatingSorted value