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(""); }