/// <summary> /// Insert a command that was ran into the database. /// </summary> public static void InsertCommand(DateTime dateTime, ulong serverId, ulong channelId, ulong userId, string username, string userDisplay, ulong messageId, string message, string command, string parameters, ulong?replyMessageId) { try { using StatisticsContext statistics = new StatisticsContext(); Command item = new Command { DateTime = dateTime, ServerId = serverId, ChannelId = channelId, UserId = userId, Username = username, UserDisplay = userDisplay, MessageId = messageId, Message = message, CommandName = command, Parameters = parameters, ReplyMessageId = replyMessageId }; statistics.Commands.Add(item); statistics.SaveChanges(); } catch (Exception ex) { LoggingManager.Log.Error(ex); } }
/// <summary> /// Insert a user change event into the database. /// </summary> public static void InsertUserChange(DateTime dateTime, ulong?serverId, ulong userId, NameChangeType changeType, string oldUsername, string newUsername, string oldUsernameDiscriminator, string newUsernameDiscriminator, string oldUserDisplay, string newUserDisplay, string backblazeAvatarBucket, string backblazeAvatarFilename, string backblazeAvatarUrl) { try { using StatisticsContext statistics = new StatisticsContext(); UserChange item = new UserChange { DateTime = dateTime, ServerId = serverId, UserId = userId, ChangeType = changeType, OldUsername = oldUsername, NewUsername = newUsername, OldUsernameDiscriminator = oldUsernameDiscriminator, NewUsernameDiscriminator = newUsernameDiscriminator, OldUserDisplay = oldUserDisplay, NewUserDisplay = newUserDisplay, BackblazeAvatarBucket = backblazeAvatarBucket, BackblazeAvatarFilename = backblazeAvatarFilename, BackblazeAvatarUrl = backblazeAvatarUrl }; statistics.UserChanges.Add(item); statistics.SaveChanges(); } catch (Exception ex) { LoggingManager.Log.Error(ex); } }