public async void SaveCommandLogToDb(string command, string user, string message, DateTime messageTime)
{
var _context = new ServerDbContext(new DbContextOptionsBuilder <ServerDbContext>().UseSqlServer(_connectionString).Options);
var existingMessage = await _context.CommandLogs.Where(c => (c.Message == message) && (c.ChannelModelId == _channel.Id)).ToListAsync();
if (existingMessage.Count == 0)
{
var commandLog = new CommandLogsModel
{
Command = command,
User = user,
Message = message,
MessageTime = messageTime,
ChannelModelId = _channel.Id
};
_context.CommandLogs.Add(commandLog);
_context.SaveChanges();
}
_context.Dispose();
}
