private static void removeTradingPort(SQLiteDB db, TradingPort port)
{
Dictionary <string, string> id = new Dictionary <string, string>();
id.Add("Guid", port.Guid.ToString());
db.RemoveValueFromTable("TradingPort", id);
id = new Dictionary <string, string>();
id.Add("TradingPortGuid", port.Guid.ToString());
db.RemoveValueFromTable("TradingPortCommodityPrice", id);
}
private static void removePricePointsInCommodityPrice(SQLiteDB db, CommodityPrice price)
{
Dictionary <string, string> priceID = new Dictionary <string, string>();
priceID.Add("CommodityPriceID", price.Guid.ToString());
db.RemoveValueFromTable("PricePoint", priceID);
}
private static void removeCommodityPrice(SQLiteDB db, CommodityPrice price)
{
Dictionary <string, string> id = new Dictionary <string, string>();
id.Add("Guid", price.Guid.ToString());
db.RemoveValueFromTable("CommodityPrice", id);
}
private static void removeTradingPortCommodityPrice(SQLiteDB db, TradingPort port, CommodityPrice price)
{
Dictionary <string, string> portPriceGuids = new Dictionary <string, string>();
portPriceGuids.Add("TradingPortGuid", port.Guid.ToString());
portPriceGuids.Add("CommodityPriceGuid", price.Guid.ToString());
db.RemoveValueFromTable("TradingPortCommodityPriceTable", portPriceGuids);
}