public TradingPortsViewModel(SCDataManager dataManager)
{
this.Ports = new ReadOnlyObservableCollection <TradingPort>(dataManager.TradingPorts);
this.Commodities = new ReadOnlyObservableCollection <Commodity>(dataManager.Commodities);
this.AddPriceCommand = new RelayCommand(addPriceExecute, canAddPrice);
}
public static bool SaveNew(string path, SCDataManager dataManager)
{
if (File.Exists(path))
{
Console.WriteLine("File exists at SaveNew() path. Path: {0}", path);
return(false);
}
using (SQLiteDB db = new SQLiteDB(path))
{
createDatabaseTables(db);
foreach (Commodity commodity in dataManager.Commodities)
{
addCommodity(db, commodity);
}
foreach (TradingPort port in dataManager.TradingPorts)
{
addTradingPort(db, port);
foreach (CommodityPrice price in port.Prices)
{
addCommodityPrice(db, price);
addTradingPortCommodityPrice(db, port, price);
foreach (PricePoint point in price.PriceHistory)
{
addPricePoint(db, point, price);
}
}
}
}
return(true);
}
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);
}
}
