7.10.2. InvoiceManager Class

The ru.ibase.fbjavaex.managers.InvoiceManager class is a kind of business layer that will be used to direct adding, editing and deleting invoices and their items, along with invoice payment. All operations in this layer will be performed in a SNAPSHOT transaction. We have chosen to have our application perform all of the invoice management options in this class by calling stored procedures. It is not mandatory to do it this way, of course. It is just one option.

  1. package ru.ibase.fbjavaex.managers;
  3. import java.sql.Timestamp;
  4. import org.jooq.DSLContext;
  5. import org.springframework.beans.factory.annotation.Autowired;
  6. import org.springframework.transaction.annotation.Transactional;
  7. import org.springframework.transaction.annotation.Propagation;
  8. import org.springframework.transaction.annotation.Isolation;
  10. import static ru.ibase.fbjavaex.exampledb.Sequences.GEN_INVOICE_ID;
  11. import static ru.ibase.fbjavaex.exampledb.Routines.spAddInvoice;
  12. import static ru.ibase.fbjavaex.exampledb.Routines.spEditInvoice;
  13. import static ru.ibase.fbjavaex.exampledb.Routines.spPayForInovice;
  14. import static ru.ibase.fbjavaex.exampledb.Routines.spDeleteInvoice;
  15. import static ru.ibase.fbjavaex.exampledb.Routines.spAddInvoiceLine;
  16. import static ru.ibase.fbjavaex.exampledb.Routines.spEditInvoiceLine;
  17. import static ru.ibase.fbjavaex.exampledb.Routines.spDeleteInvoiceLine;
  19. /**
  20.  * Invoice manager
  21.  *
  22.  * @author Simonov Denis
  23.  */
  24. public class InvoiceManager {
  26.     @Autowired(required = true)
  27.     private DSLContext dsl;
  29.     /**
  30.      * Add invoice
  31.      *
  32.      * @param customerId
  33.      * @param invoiceDate
  34.      */
  35.     @Transactional(propagation = Propagation.REQUIRED,
  36.                    isolation = Isolation.REPEATABLE_READ)
  37.     public void create(Integer customerId,
  38.                        Timestamp invoiceDate) {
  39.         int invoiceId = this.dsl.nextval(GEN_INVOICE_ID).intValue();
  41.         spAddInvoice(this.dsl.configuration(),
  42.             invoiceId,
  43.             customerId,
  44.             invoiceDate);
  45.     }
  47.     /**
  48.      * Edit invoice
  49.      *
  50.      * @param invoiceId
  51.      * @param customerId
  52.      * @param invoiceDate
  53.      */
  54.     @Transactional(propagation = Propagation.REQUIRED,
  55.                    isolation = Isolation.REPEATABLE_READ)
  56.     public void edit(Integer invoiceId,
  57.                      Integer customerId,
  58.                      Timestamp invoiceDate) {
  59.         spEditInvoice(this.dsl.configuration(),
  60.             invoiceId,
  61.             customerId,
  62.             invoiceDate);
  63.     }
  65.     /**
  66.      * Payment of invoices
  67.      *
  68.      * @param invoiceId
  69.      */
  70.     @Transactional(propagation = Propagation.REQUIRED,
  71.                    isolation = Isolation.REPEATABLE_READ)
  72.     public void pay(Integer invoiceId) {
  73.         spPayForInovice(this.dsl.configuration(),
  74.             invoiceId);
  75.     }
  77.     /**
  78.      * Delete invoice
  79.      *
  80.      * @param invoiceId
  81.      */
  82.     @Transactional(propagation = Propagation.REQUIRED,
  83.                    isolation = Isolation.REPEATABLE_READ)
  84.     public void delete(Integer invoiceId) {
  85.         spDeleteInvoice(this.dsl.configuration(),
  86.             invoiceId);
  87.     }
  89.     /**
  90.      * Add invoice item
  91.      *
  92.      * @param invoiceId
  93.      * @param productId
  94.      * @param quantity
  95.      */
  96.     @Transactional(propagation = Propagation.REQUIRED,
  97.                    isolation = Isolation.REPEATABLE_READ)
  98.     public void addInvoiceLine(Integer invoiceId,
  99.                                Integer productId,
  100.                                Integer quantity) {
  101.         spAddInvoiceLine(this.dsl.configuration(),
  102.             invoiceId,
  103.             productId,
  104.             quantity);
  105.     }
  107.     /**
  108.      * Edit invoice item
  109.      *
  110.      * @param invoiceLineId
  111.      * @param quantity
  112.      */
  113.     @Transactional(propagation = Propagation.REQUIRED,
  114.                    isolation = Isolation.REPEATABLE_READ)
  115.     public void editInvoiceLine(Integer invoiceLineId,
  116.                                 Integer quantity) {
  117.         spEditInvoiceLine(this.dsl.configuration(),
  118.             invoiceLineId,
  119.             quantity);
  120.     }
  122.     /**
  123.      * Delete invoice item
  124.      *
  125.      * @param invoiceLineId
  126.      */
  127.     @Transactional(propagation = Propagation.REQUIRED,
  128.                    isolation = Isolation.REPEATABLE_READ)
  129.     public void deleteInvoiceLine(Integer invoiceLineId) {
  130.         spDeleteInvoiceLine(this.dsl.configuration(),
  131.             invoiceLineId);
  132.     }
  133. }