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