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);
}
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 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 void selectedPortChanged(TradingPort port)
{
this.buyPrices = new ReadOnlyObservableSubset <CommodityPrice>(port.Prices, price => price.Type == PriceType.Buy);
this.sellPrices = new ReadOnlyObservableSubset <CommodityPrice>(port.Prices, price => price.Type == PriceType.Sell);
selectedTypeChanged(this.SelectedType);
}
public static SCDataManager Load(string path)
{
using (SQLiteDB db = new SQLiteDB(path))
{
SCDataManager dataManager = new SCDataManager();
//Commodity
DataTable commodityTable = db.GetDataFromTable("Commodity");
foreach (DataRow row in commodityTable.Rows)
{
Guid guid = new Guid(row.ItemArray[0].ToString());
string name = row.ItemArray[1].ToString();
Commodity commodity = new Commodity(name, guid);
dataManager.Commodities.Add(commodity);
}
Dictionary <Guid, Commodity> commodityDict = createGuidDictionary(dataManager.Commodities);
//TradingPort
DataTable tradingPortTable = db.GetDataFromTable("TradingPort");
foreach (DataRow row in tradingPortTable.Rows)
{
Guid guid = new Guid(row.ItemArray[0].ToString());
string name = row.ItemArray[1].ToString();
TradingPort port = new TradingPort(name, guid);
dataManager.TradingPorts.Add(port);
}
Dictionary <Guid, TradingPort> portDict = createGuidDictionary(dataManager.TradingPorts);
//TradingPortComodityPrice
DataTable portPriceTable = db.GetDataFromTable("TradingPortCommodityPrice");
Dictionary <Guid, TradingPort> priceToPort = new Dictionary <Guid, TradingPort>();
foreach (DataRow row in portPriceTable.Rows)
{
Guid portGuid = new Guid(row.ItemArray[0].ToString());
Guid priceGuid = new Guid(row.ItemArray[1].ToString());
priceToPort.Add(priceGuid, portDict[portGuid]);
}
//CommodityPrice
DataTable priceTable = db.GetDataFromTable("CommodityPrice");
List <CommodityPrice> allPrices = new List <CommodityPrice>();
foreach (DataRow row in priceTable.Rows)
{
Guid guid = new Guid(row.ItemArray[0].ToString());
Guid commodityGuid = new Guid(row.ItemArray[1].ToString());
Commodity commodity = commodityDict[commodityGuid];
PriceType type = PriceTypeUtils.ConvertString(row.ItemArray[2].ToString());
CommodityPrice price = new CommodityPrice(commodity, type, guid);
TradingPort port = priceToPort[price.Guid];
port.Prices.Add(price);
allPrices.Add(price);
}
Dictionary <Guid, CommodityPrice> priceDict = createGuidDictionary(allPrices);
//PricePoint
DataTable pointTable = db.GetDataFromTable("PricePoint");
foreach (DataRow row in pointTable.Rows)
{
Guid commodityPriceGuid = new Guid(row.ItemArray[0].ToString());
double priceDouble = (double)row.ItemArray[1];
DateTime dateTime = new DateTime(Convert.ToInt64(row.ItemArray[2]));
CommodityPrice commodityPrice = priceDict[commodityPriceGuid];
commodityPrice.AddPrice(priceDouble, dateTime);
}
return(dataManager);
}
}
