public static void DeleteTransaction(int transaction_id)
{
var attrValue = DB_IO.AttrValue();
attrValue[DB_API.TransactionEnt.transaction_id] = transaction_id;
DB_IO.Delete(DB_IO.DB_Interface.pr_delete_transaction, attrValue);
}
public static void DeleteMoneyAccount(int account_id)
{
var attrValue = DB_IO.AttrValue();
attrValue[MoneyAccountEnt.account_id] = account_id;
DB_IO.Delete(DB_IO.DB_Interface.pr_delete_money_account, attrValue);
}
public static void DeleteUser(string email)
{
var attrValue = DB_IO.AttrValue();
attrValue[UserEnt.email] = email;
DB_IO.Delete(DB_IO.DB_Interface.pr_delete_user, attrValue);
}
public static void MoneyAccountRemoveUser(int account_id, string user_email)
{
var attrValue = DB_IO.AttrValue();
attrValue[MoneyAccountEnt.account_id] = account_id;
attrValue[MoneyAccountEnt.user_email] = user_email;
DB_IO.Delete(DB_IO.DB_Interface.pr_money_account_remove_user, attrValue);
}
public static void DeleteStocksByCompany(int accountID, string company, double purchasePrice, double askPrice)
{
var attrValue = DB_IO.AttrValue();
attrValue[DB_API.StockEnt.account_id] = accountID;
attrValue[DB_API.StockEnt.company] = company;
attrValue[DB_API.StockEnt.purchase_price] = purchasePrice;
attrValue[DB_API.StockEnt.ask_price] = askPrice;
DB_IO.Delete(DB_IO.DB_Interface.pr_delete_purchased_stocks, attrValue);
}
public static void DeleteStockByTicker(int accountID, int ticker, double purchasePrice, double askPrice)
{
var attrValue = DB_IO.AttrValue();
attrValue[DB_API.StockEnt.account_id] = accountID;
attrValue[DB_API.StockEnt.ticker] = ticker;
attrValue[DB_API.StockEnt.purchase_price] = purchasePrice;
attrValue[DB_API.StockEnt.ask_price] = askPrice;
DB_IO.Delete(DB_IO.DB_Interface.pr_delete_purchased_stocks, attrValue);
}