public void commitTransaction(Transaction trans) {
String process = trans.getProcess();
Trader trader = trans.getTrader();
int qty = trans.getQty();
double price = trans.getPrice();
double balance = trader.getBalance();
if (process.equals("sell")) balance = balance - qty * price - 5;
else balance = balance + qty * price - 5;
trans.setStatus("success");
trader.setBalance(balance);
trader.setTransaction(trans);
traderD.save(trader);
}
public void csvToTransactions(String path) {
String csvFile = path;
BufferedReader br = null;
String line = "";
String cvsSplitBy = ",";
try {
br = new BufferedReader(new FileReader(csvFile));
br.readLine();
while ((line = br.readLine()) != null) {
// use comma as separator
String[] csvString = line.split(cvsSplitBy);
int tid = Integer.parseInt(csvString[0]);
int qty = Integer.parseInt(csvString[1]);
String status = csvString[2];
String t_date = csvString[3];
String process = csvString[4];
double price = Double.parseDouble(csvString[5]);
Transaction transaction = new Transaction();
Trader trader = traderD.findById(tid);
transaction.setPrice(price);
transaction.setProcess(process);
transaction.setQty(qty);
transaction.setStatus(status);
transaction.setT_date(t_date);
transaction.setTrader(trader);
commitTransaction(transaction);
}
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} finally {
if (br != null) {
try {
br.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
public List<Stock> getStocks() {
return stockD.findAll();
}
public void deleteStock(Stock stock) {
Stock mystock = stockD.findBy("sname", stock.getSname());
stockD.delete(mystock);
}
public void addStock(Stock stock) {
stockD.save(stock);
}
public void failTransaction(int trans_id) {
Transaction trans = transD.findBy("trans_id", trans_id);
trans.setStatus("reject");
transD.save(trans);
}