public IMessage AddMessage(IMessage message)
{
var parameters = new List <NpgsqlParameter>();
parameters.Add(_postgreHelper.CreateParameter("@content", 128, message.Content, DbType.String));
parameters.Add(_postgreHelper.CreateParameter("@dateTime", message.DateTime, DbType.DateTime));
parameters.Add(_postgreHelper.CreateParameter("@number", message.Number, DbType.Int32));
var sqlCommand = "INSERT INTO messages(content, dateTime, number) VALUES(@content, @dateTime, @number)";
try
{
_postgreHelper.Insert(sqlCommand, CommandType.Text, parameters);
}
catch (NpgsqlException ex)
{
_logger.LogError(ex.Message);
throw ex;
}
catch (Exception ex)
{
_logger.LogError(ex.Message);
throw ex;
}
return(message);
}
