public async Task <int> SaveAsync(SnapshotPrice price)
{
using (var conn = new MySqlConnection(_appSettings.CoinSongDb))
{
await conn.OpenAsync();
var priceId = await conn.ExecuteAsync($@"
INSERT INTO Prices (
Coin,
Price,
Currency,
Ask,
Bid,
Size,
Time)
VALUES (
@Coin,
@Price,
@Currency,
@Ask,
@Bid,
@Size,
@Time
)
", new
{
Coin = price.Coin.ToUpperString(),
price.Price,
Currency = price.Currency.ToUpperString(),
price.Ask,
price.Bid,
price.Size,
price.Time
});
return(priceId);
}
}
public async Task <int> SaveAsync(SnapshotPrice price)
{
return(0);
// using (var conn = new MySqlConnection(_gdaxOptions.CoinSongDb))
// {
// await conn.OpenAsync();
// var priceId = await conn.ExecuteAsync($@"
// INSERT INTO Prices (
// Coin,
// Price,
// Currency,
// Ask,
// Bid,
// Size,
// Time)
// VALUES (
// @Coin,
// @Price,
// @Currency,
// @Ask,
// @Bid,
// @Size,
// @Time
// )
// ", new
// {
// Coin = price.Coin.ToUpperString(),
// price.Price,
// Currency = price.Currency.ToUpperString(),
// price.Ask,
// price.Bid,
// price.Size,
// price.Time
// });
//
// return priceId;
// }
}