public Boolean DeletePrevDataInDB() { DBManager dbManager = new DBManager(); MySqlConnection con = null; try { String ip = Config.DB_SERVER_IP; con = dbManager.CreateConnection(ip, Config.DATABASE_CORREL); con.Open(); String query = String.Format("delete from raw_price_data where Ticker = '{0}'", kStockPerFinanceAsset); MySqlCommand cmd = new MySqlCommand(query, con); int ret = cmd.ExecuteNonQuery(); if (ret < 0) { throw new Exception(); } return true; } catch (System.Exception e) { logger.Error(e.ToString()); } finally { dbManager.Close(con); } return false; }
public Boolean InsertDataIntoDB() { DBManager dbManager = new DBManager(); MySqlConnection con = null; try { String ip = Config.DB_SERVER_IP; con = dbManager.CreateConnection(ip, Config.DATABASE_CORREL); con.Open(); foreach (Tuple<DateTime, double> row in _data) { InsertDataIntoDB_Raw(con, row); } return true; } catch (System.Exception e) { logger.Error(e.ToString()); } finally { dbManager.Close(con); } return false; }