/// <summary>
/// Editing the embedded message
/// </summary>
/// <param name="builder">Builder</param>
/// <returns>A <see cref="Task"/> representing the asynchronous operation.</returns>
public override Task EditMessage(DiscordEmbedBuilder builder)
{
builder.WithTitle(LocalizationGroup.GetText("ChooseCommandTitle", "Raid template configuration"));
builder.WithDescription(LocalizationGroup.GetText("ChooseCommandDescription", "With this assistant you are able to configure the raid templates. The following templates are already created:"));
var templatesBuilder = new StringBuilder();
var templates = GetTemplates();
if (templates.Count > 0)
{
foreach (var template in templates)
{
templatesBuilder.AppendLine(Formatter.Bold($"{DiscordEmojiService.GetBulletEmoji(CommandContext.Client)} {template}"));
}
}
else
{
templatesBuilder.Append('\u200B');
}
builder.AddField(LocalizationGroup.GetText("TemplatesField", "Templates"), templatesBuilder.ToString());
return(Task.CompletedTask);
}
/// <summary>
/// Executes the job
/// </summary>
/// <returns>A <see cref="Task"/> representing the asynchronous operation.</returns>
public override async Task ExecuteAsync()
{
var serviceProvider = GlobalServiceProvider.Current.GetServiceProvider();
await using (serviceProvider.ConfigureAwait(false))
{
var client = serviceProvider.GetService <DiscordClient>();
var userManagementService = serviceProvider.GetService <UserManagementService>();
using (var dbFactory = RepositoryFactory.CreateInstance())
{
foreach (var configuration in dbFactory.GetRepository <GuildSpecialRankConfigurationRepository>()
.GetQuery()
.Where(obj => obj.IsDeleted == false)
.Select(obj => new
{
obj.Id,
obj.Guild.DiscordServerId,
obj.MaximumPoints,
Roles = obj.GuildSpecialRankRoleAssignments
.Select(obj2 => new
{
obj2.DiscordRoleId,
obj2.Points
}),
IgnoreRoles = obj.GuildSpecialRankIgnoreRoleAssignments
.Select(obj2 => obj2.DiscordRoleId)
})
.ToList())
{
var points = new List <(ulong UserId, double Points)>();
var guild = await client.GetGuildAsync(configuration.DiscordServerId)
.ConfigureAwait(false);
foreach (var user in await guild.GetAllMembersAsync()
.ConfigureAwait(false))
{
if (configuration.IgnoreRoles.Any(obj => user.Roles.Any(obj2 => obj2.Id == obj)) == false)
{
foreach (var role in configuration.Roles)
{
if (user.Roles.Any(obj => obj.Id == role.DiscordRoleId))
{
points.Add((user.Id, role.Points));
}
}
}
}
var discordUserAccountIds = points.Select(obj => obj.UserId)
.ToList();
var users = dbFactory.GetRepository <DiscordAccountRepository>()
.GetQuery()
.Where(obj => discordUserAccountIds.Contains(obj.Id))
.ToDictionary(obj => obj.Id, obj => obj.UserId);
foreach (var pointsPerUser in points.GroupBy(obj => obj.UserId))
{
await userManagementService.CheckDiscordAccountAsync(pointsPerUser.Key)
.ConfigureAwait(false);
var transaction = dbFactory.BeginTransaction(IsolationLevel.RepeatableRead);
await using (transaction.ConfigureAwait(false))
{
if (users.TryGetValue(pointsPerUser.Key, out var userId))
{
if (await dbFactory.GetRepository <GuildSpecialRankPointsRepository>()
.AddPoints(configuration.Id, configuration.MaximumPoints, userId, pointsPerUser.Select(obj => obj.Points).ToList())
.ConfigureAwait(false))
{
await transaction.CommitAsync()
.ConfigureAwait(false);
}
}
}
}
}
var channels = dbFactory.GetRepository <GuildChannelConfigurationRepository>()
.GetQuery()
.Select(obj => obj);
foreach (var configuration in dbFactory.GetRepository <GuildSpecialRankConfigurationRepository>()
.GetQuery()
.Where(obj => obj.IsDeleted == false)
.Select(obj => new
{
obj.Id,
obj.Description,
obj.Guild.DiscordServerId,
obj.DiscordRoleId,
ChannelId = channels.Where(obj2 => obj2.GuildId == obj.GuildId &&
obj2.Type == GuildChannelConfigurationType.SpecialRankRankChange)
.Select(obj2 => (ulong?)obj2.DiscordChannelId)
.FirstOrDefault(),
Users = obj.GuildSpecialRankPoints
.Where(obj2 => obj2.Points > obj.RemoveThreshold)
.SelectMany(obj2 => obj2.User
.DiscordAccounts
.Select(obj3 => new
{
obj3.Id,
IsGrantRole = obj2.Points > obj.GrantThreshold
})),
IgnoreRoles = obj.GuildSpecialRankIgnoreRoleAssignments
.Select(obj2 => obj2.DiscordRoleId)
})
.ToList())
{
var actions = new List <(bool IsGrant, DiscordMember User, ulong RoleId)>();
var guild = await client.GetGuildAsync(configuration.DiscordServerId)
.ConfigureAwait(false);
foreach (var user in await guild.GetAllMembersAsync()
.ConfigureAwait(false))
{
if (configuration.IgnoreRoles.Any(obj => user.Roles.Any(obj2 => obj2.Id == obj)) == false)
{
var isRoleAssigned = user.Roles.Any(obj => obj.Id == configuration.DiscordRoleId);
if (isRoleAssigned)
{
if (configuration.Users.Any(obj => obj.Id == user.Id) == false)
{
actions.Add((false, user, configuration.DiscordRoleId));
}
}
else if (configuration.Users.FirstOrDefault(obj => obj.Id == user.Id)?.IsGrantRole == true)
{
actions.Add((true, user, configuration.DiscordRoleId));
}
}
}
if (actions.Count > 0)
{
foreach (var action in actions)
{
try
{
var role = action.User.Guild.GetRole(action.RoleId);
if (role != null)
{
if (action.IsGrant)
{
await action.User
.GrantRoleAsync(role)
.ConfigureAwait(false);
LoggingService.AddJobLogEntry(LogEntryLevel.Warning, nameof(GuildSpecialRankPointsJob), $"Role granted: configuration {configuration.Id}; user: {action.User.Id}; role: {role.Id}");
}
else
{
await action.User
.RevokeRoleAsync(role)
.ConfigureAwait(false);
LoggingService.AddJobLogEntry(LogEntryLevel.Warning, nameof(GuildSpecialRankPointsJob), $"Role revoked: configuration {configuration.Id}; user: {action.User.Id}; role: {role.Id}");
}
}
else
{
LoggingService.AddJobLogEntry(LogEntryLevel.Error, nameof(GuildSpecialRankPointsJob), "Role assignment", $"Unknown role {action.RoleId} at {action.User.Guild.Id}", null);
}
}
catch (Exception ex)
{
LoggingService.AddJobLogEntry(LogEntryLevel.Error, nameof(GuildSpecialRankPointsJob), "Role assignment", null, ex);
}
}
if (configuration.ChannelId != null)
{
var builder = new DiscordEmbedBuilder();
builder.WithTitle(LocalizationGroup.GetText("RoleAssignment", "Role assignment"));
builder.WithDescription($"{configuration.Description} ({guild.GetRole(configuration.DiscordRoleId).Mention})");
builder.WithColor(DiscordColor.DarkBlue);
if (actions.Any(obj => obj.IsGrant == false))
{
var stringBuilder = new StringBuilder();
foreach (var action in actions.Where(obj => obj.IsGrant == false))
{
stringBuilder.AppendLine(DiscordEmojiService.GetBulletEmoji(client) + " " + action.User.Mention);
}
builder.AddField(LocalizationGroup.GetText("RemovedRoles", "Removed roles"), stringBuilder.ToString());
}
if (actions.Any(obj => obj.IsGrant))
{
var stringBuilder = new StringBuilder();
foreach (var action in actions.Where(obj => obj.IsGrant))
{
stringBuilder.AppendLine(DiscordEmojiService.GetBulletEmoji(client) + " " + action.User.Mention);
}
builder.AddField(LocalizationGroup.GetText("GrantedRoles", "Granted roles"), stringBuilder.ToString());
}
var channel = await client.GetChannelAsync(configuration.ChannelId.Value)
.ConfigureAwait(false);
await channel.SendMessageAsync(builder)
.ConfigureAwait(false);
}
else
{
LoggingService.AddJobLogEntry(LogEntryLevel.Warning, nameof(GuildSpecialRankPointsJob), $"No notification channel for configuration {configuration.Id}");
}
}
}
}
}
}