public void save(string portflio, Interace.Quant.Trade trade) { using (var conn = new MySqlConnection(Configuration.quantdb)) { conn.Open(); var upsert = "INSERT IGNORE orders (portflio,code,date,dir,quantity,comments) " + $"VALUES ('{trade.portflio}','{trade.code}','{trade.date:yyyy-MM-dd HH:mm:ss}','{trade.dir}',{trade.quantity},'{trade.comments ?? "-"}')"; conn.Execute(upsert); } }
public bool tradeexists(string portflio, Interace.Quant.Trade trade) { using (var conn = new MySqlConnection(Configuration.quantdb)) { conn.Open(); return(conn .Query <Interace.Quant.Trade>( "select * from orders where portflio=@portflio and code=@code and date=@date", new { portflio = portflio, code = trade.code, date = trade.date.ToString("yyyy-MM-dd HH:mm:ss") }) .Any()); } }