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