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