Module CI

Package com.shr4pnel.db

Class StockRW

java.lang.Object

com.shr4pnel.db.StockR

com.shr4pnel.db.StockRW

public class StockRW
extends StockR

Implements read/write access to the stock database.

Since:

v0.1.0

Author:

shrapnelnet

See Also:

• WebApplication

Constructor Summary

Constructors

Constructor	Description
StockRW()	Constructor for StockRW.

Method Summary

Modifier and Type	Method	Description
void	addBasket(UUID orderID, String pNum, int quantity)	Add an item to the BasketTable
void	addOrder(UUID uuid)	Adds a new order to the OrderTable.
void	addStock(String pNum, int amount)	Adds stock (Re-stocks) to the store.
boolean	packOrder(String orderID)	Deletes an order, and all associated basket items from the database to simulate the order being packed.

Methods inherited from class com.shr4pnel.db.StockR

getAllOrdersToPack, getAllStock, getConnectionObject

Methods inherited from class java.lang.Object

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

Constructor Details

StockRW

public StockRW()
        throws com.shr4pnel.middleware.StockException

Constructor for StockRW.

Throws:

com.shr4pnel.middleware.StockException - if any.

Method Details

addStock

public void addStock(String pNum,
 int amount)

Adds stock (Re-stocks) to the store. Assumed to exist in database.

Parameters:

pNum - Product number

amount - Amount of stock to add

addOrder

public void addOrder(UUID uuid)

Adds a new order to the OrderTable.

Parameters:

uuid - A UUID, which is used as a primary key, as well as a foreign key in BasketTable

addBasket

public void addBasket(UUID orderID,
 String pNum,
 int quantity)

Add an item to the BasketTable

Parameters:

orderID - The ID of the order that the item belongs to

pNum - The Product Number of the item

quantity - The amount of the item to add

packOrder

public boolean packOrder(String orderID)

Deletes an order, and all associated basket items from the database to simulate the order being packed.

Parameters:

orderID - The order ID to be removed

Returns:

true, if successful