private static void addTradingPortCommodityPrice(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.AddValueToTable("TradingPortCommodityPrice", portPriceGuids);
}
private static void addTradingPort(SQLiteDB db, TradingPort port)
{
Dictionary <string, string> portFieldValues = new Dictionary <string, string>();
portFieldValues.Add("Guid", port.Guid.ToString());
portFieldValues.Add("Name", port.Name);
db.AddValueToTable("TradingPort", portFieldValues);
}
private static void addCommodity(SQLiteDB db, Commodity commodity)
{
Dictionary <string, string> commodityFieldValues = new Dictionary <string, string>();
commodityFieldValues.Add("Guid", commodity.Guid.ToString());
commodityFieldValues.Add("Name", commodity.Name);
db.AddValueToTable("Commodity", commodityFieldValues);
}
private static void addPricePoint(SQLiteDB db, PricePoint point, CommodityPrice price)
{
Dictionary <string, string> pointFieldValues = new Dictionary <string, string>();
pointFieldValues.Add("CommodityPriceGuid", price.Guid.ToString());
pointFieldValues.Add("Price", point.Price.ToString());
pointFieldValues.Add("DateTime", point.DateTime.Ticks.ToString());
db.AddValueToTable("PricePoint", pointFieldValues);
}
private static void addCommodityPrice(SQLiteDB db, CommodityPrice price)
{
Dictionary <string, string> priceFieldValues = new Dictionary <string, string>();
priceFieldValues.Add("Guid", price.Guid.ToString());
priceFieldValues.Add("CommodityGuid", price.Commodity.Guid.ToString());
priceFieldValues.Add("Type", price.Type.ToString());
db.AddValueToTable("CommodityPrice", priceFieldValues);
}