Class InventoryDAO

java.lang.Object

app.dao.InventoryDAO

public class InventoryDAO
extends Object

Constructor Summary

Constructors

Constructor	Description
InventoryDAO()

Method Summary

Modifier and Type	Method	Description
void	addItem(InventoryItem item)
void	deductIngredients(Connection connection, int itemId, int quantityOrdered)
void	deductModIngredients(Connection conn, int modId, int quantityOrdered)
List<InventoryItem>	getAllInventoryItems()
Map<String, BigDecimal>	getTopInventoryUsage(int limit, LocalDate startDate, LocalDate endDate)
void	restockItem(int inventoryId, BigDecimal amount)
void	updateItem(InventoryItem item)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

InventoryDAO

public InventoryDAO()

Method Details

getAllInventoryItems

public List<InventoryItem> getAllInventoryItems()
                                         throws SQLException

Throws:

SQLException

getTopInventoryUsage

public Map<String, BigDecimal> getTopInventoryUsage(int limit,
 LocalDate startDate,
 LocalDate endDate)
                                             throws SQLException

Throws:

SQLException

restockItem

public void restockItem(int inventoryId,
 BigDecimal amount)
                 throws SQLException

Throws:

SQLException

addItem

public void addItem(InventoryItem item)
             throws SQLException

Throws:

SQLException

updateItem

public void updateItem(InventoryItem item)
                throws SQLException

Throws:

SQLException

deductIngredients

public void deductIngredients(Connection connection,
 int itemId,
 int quantityOrdered)
                       throws SQLException

Throws:

SQLException

deductModIngredients

public void deductModIngredients(Connection conn,
 int modId,
 int quantityOrdered)
                          throws SQLException

Throws:

SQLException