private QuoteServerEvent GetQuoteServerEventFromRecord(NpgsqlDataReader reader)
{
var quoteServerEvent = new QuoteServerEvent
{
StockSymbol = reader.GetString(9),
Price = reader.GetDecimal(10),
QuoteServerTime = reader.GetDateTime(14),
CryptoKey = reader.GetString(15)
};
FillBaseEventPropertiesFromRecord(quoteServerEvent, reader);
return quoteServerEvent;
}
public void LogQuoteServerEvent(QuoteServerEvent quoteServerEvent)
{
using (var command = new NpgsqlCommand("log_quote_server_event"))
{
Log.DebugFormat("Inserting quote server event {0} into databse...", quoteServerEvent.Id);
command.CommandType = System.Data.CommandType.StoredProcedure;
AddCommonEventPropertyParametersToCommand(command, quoteServerEvent);
command.Parameters.Add(new NpgsqlParameter
{
NpgsqlDbType = NpgsqlDbType.Char,
Value = quoteServerEvent.StockSymbol
});
command.Parameters.Add(new NpgsqlParameter
{
NpgsqlDbType = NpgsqlDbType.Money,
Value = quoteServerEvent.Price
});
command.Parameters.Add(new NpgsqlParameter
{
NpgsqlDbType = NpgsqlDbType.TimestampTZ,
Value = quoteServerEvent.QuoteServerTime
});
command.Parameters.Add(new NpgsqlParameter
{
NpgsqlDbType = NpgsqlDbType.Varchar,
Value = quoteServerEvent.CryptoKey
});
int id = ExecuteInsertCommand(command);
Log.DebugFormat(CultureInfo.InvariantCulture,
"Successfully inserted quote server event {0} (database id = {1}).", quoteServerEvent.Id, id);
}
}