public async Task UpdateSpreadSheet(CommandContext ctx, string clanTag)
{
var roles = ctx.Member.Roles.ToList();
var verification = await IsVerifiedAsync(ctx, true);
var clan = await GetClanFromTagOrNameAsync(ctx, clanTag);
clanTag = clanTag.ToLower();
if (clan != null && verification == ErrorCode.Qualify && !string.IsNullOrEmpty(clan.details.Tag))
{
var discordEmbed = Core.Discord.CreateFancyMessage(DiscordColor.Orange, "Scanning for Changes...");
DiscordMessage msg = await ctx.RespondAsync(discordEmbed);
await SpreadsheetTools.Read(clan);
var _ = await SpreadsheetTools.CheckForChangesAsync(clan);
if (_.TotalChanges > 0)
{
TimeSpan t = TimeSpan.FromSeconds((_.addedUsers.Count * 5) + (_.updatedUsers.Count * 0.1) + (_.removedUsers.Count * 0.1));
discordEmbed = Core.Discord.CreateFancyMessage(DiscordColor.Yellow, "Found changes", string.Format("{0} change(s) found...", _.TotalChanges), new List <Field>()
{
new Field("Time Left", t.ToString(@"mm\:ss"))
});
await msg.ModifyAsync(discordEmbed);
await SpreadsheetTools.SelectiveUpdate(clan, _, new() { msg }, UpdateSpreadsheetProgress);
discordEmbed = Core.Discord.CreateFancyMessage(clan.details.DiscordColour, "Done", string.Format("Successfully processed {0} changes.", _.TotalChanges));
await msg.ModifyAsync(discordEmbed);
}
else
{
await SpreadsheetTools.SelectiveUpdate(clan);
discordEmbed = Core.Discord.CreateFancyMessage(DiscordColor.SpringGreen, "No changes found", "To update steam names, please run a bulk update.");
await msg.ModifyAsync(discordEmbed);
}
await ThankUsage(ctx, clan, 100);
}
}
public async Task DisplayUsers(CommandContext ctx, string clanTag, [RemainingText] string mode)
{
var roles = ctx.Member.Roles.ToList();
var verification = await IsVerifiedAsync(ctx, true);
var clan = await GetClanFromTagOrNameAsync(ctx, clanTag);
clanTag = clanTag.ToLower();
if (clan != null && verification == ErrorCode.Qualify && !string.IsNullOrEmpty(clan.details.Tag))
{
if (string.IsNullOrEmpty(mode) || mode == "spreadsheet" || mode == "sheet")
{
await SpreadsheetTools.Read(clan);
var users = clan.members.SpreadsheetUsers.ToList();
users = users.OrderBy(t => t.SteamName).ToList();
Core.Discord.SendFancyListMessage(ctx.Channel, clan, users, "Users on spreadsheet for " + clan.details.Name + ":");
await ThankUsage(ctx, clan, 100);
}
else if (mode == "saved data" || mode == "saved" || mode == "file")
{
List <SpreadsheetTools.User> users = clan.members.BungieUsers;
users = users.OrderBy(t => t.SteamName).ToList();
Core.Discord.SendFancyListMessage(ctx.Channel, clan, users, "Users for " + clan.details.Name + ":");
await ThankUsage(ctx, clan, 100);
}
else
{
var discordEmbed = Core.Discord.CreateFancyMessage(DiscordColor.IndianRed, "Sorry!", "Additional arguments required. eithe use:\ndisplayusers sheet or displayusers saved");
await ctx.RespondAsync(discordEmbed);
}
}
}
public static async Task Read(Clan clan)
{
await SpreadsheetTools.Read(clan);
}
