string Execute_Update_Differences()
{
Differences df = new Differences();
//df.CaVirtexBTC_CoinbaseBTC();
//df.CaVirtexBTC_KrakenBTC_KrakenLTC_CaVirtexBTC();
APIs.Firebase fb = new APIs.Firebase();
fb.ClearAllData();
df.Update_Paths();
df.Update_Paths_All();
return("");
}
string Execute_Update_Differences()
{
Differences df = new Differences();
//df.CaVirtexBTC_CoinbaseBTC();
//df.CaVirtexBTC_KrakenBTC_KrakenLTC_CaVirtexBTC();
APIs.Firebase fb = new APIs.Firebase();
DataTable dtmarketdata = Bitcoin_Notify_DB.SPs.ViewMarketDataAll().GetDataSet().Tables[0];
DataColumn[] keyColumns1 = new DataColumn[1];
keyColumns1[0] = dtmarketdata.Columns["market_key"];
dtmarketdata.PrimaryKey = keyColumns1;
DataTable dtmarkets = Bitcoin_Notify_DB.SPs.ViewMarketsAll().GetDataSet().Tables[0];
DataColumn[] keyColumns2 = new DataColumn[1];
keyColumns2[0] = dtmarkets.Columns["market_key"];
dtmarkets.PrimaryKey = keyColumns2;
DataTable dtnodes = Bitcoin_Notify_DB.SPs.ViewExchangeCurrenciesAll().GetDataSet().Tables[0];
DataColumn[] keyColumns3 = new DataColumn[1];
keyColumns3[0] = dtnodes.Columns["exchange_currency_key"];
dtnodes.PrimaryKey = keyColumns3;
DataTable dtmarketorderbooks = Bitcoin_Notify_DB.SPs.ViewMarketOrderbooksAll().GetDataSet().Tables[0];
DataColumn[] keyColumns4 = new DataColumn[1];
keyColumns4[0] = dtnodes.Columns["market_key"];
dtmarketorderbooks.PrimaryKey = keyColumns4;
Hashtable hsnodes = new Hashtable();
foreach (DataRow dr in dtnodes.Rows)
{
hsnodes.Add(Convert.ToInt32(dr["exchange_currency_key"]), sitetemp.MappingMarketNode(dr));
}
//setup list of nodes by exchange
List <Hashtable> lshsnodesbyexchange = new List <Hashtable>();
DataTable dttemp = Bitcoin_Notify_DB.SPs.ViewExchangesAll().GetDataSet().Tables[0];
foreach (DataRow dr in dttemp.Rows)
{
//each exchange
Hashtable hsnodesbyexchange = new Hashtable();
lshsnodesbyexchange.Add(hsnodesbyexchange);
}
foreach (DictionaryEntry entry in hsnodes)
{
Models.MarketNode node = (Models.MarketNode)entry.Value;
Hashtable hsnodesbyexchange = lshsnodesbyexchange[node.exchange_key - 1];
hsnodesbyexchange.Add(node.exchange_currency_key, node);
lshsnodesbyexchange[node.exchange_key - 1] = hsnodesbyexchange;
}
//custom path from db
//df.Update_Paths(dtmarketdata, dtmarkets, dtnodes);
//automated paths
df.Update_Paths_All(dtmarketdata, dtmarkets, hsnodes, dtnodes, lshsnodesbyexchange, dtmarketorderbooks);
hsnumberofthreads.Clear();
return("");
}
