public async Task SendPassToAll()
{
var loginCell = _config.CurrentValue.RaidbotsAccountData.LoginCellAddress;
var passwordCell = _config.CurrentValue.RaidbotsAccountData.PasswordCellAddress;
var allowedRole = _config.CurrentValue.RaidbotsAccountData.AllowerRoleId;
var login = await _googleService.ReadCellAsync(loginCell);
var password = await _googleService.ReadCellAsync(passwordCell);
foreach (var usr in _discord.GetGuild(_config.CurrentValue.MyGuildId).Users.Where(x => x.Roles.Any(y => y.Id == allowedRole)))
{
var container = new EmbedFieldBuilder
{
IsInline = true,
Name = "Dane logowania:",
Value = $"{("Login: "******"Hasło: ".Decorate(Decorator.Bold))}{password.Decorate(Decorator.Inline_code)}"
};
var emb = new EmbedBuilder
{
Color = Color.Blue,
Url = @"https://www.raidbots.com/auth",
Title = $"Konto do raidbotsów"
};
var footer = new EmbedFooterBuilder
{
Text = $"[{DateTime.Now:yyyy-MM-dd HH:mm:ss}]"
};
emb.Footer = footer;
emb.AddField(container);
try
{
await usr.SendMessageAsync(string.Empty, false, emb.Build());
await Context.Channel.SendMessageAsync($"Wysłano wiadomość z danymi dostępowymi do: {_discordContext.GetUserNickname(usr.Id)}");
}
catch (Discord.Net.HttpException ex)
{
if (ex.DiscordCode == 50007)
{
await Context.Channel.SendMessageAsync($"Użytkownik nie zezwala na DM: {_discordContext.GetUserNickname(usr.Id)}");
}
else
{
await Context.Channel.SendMessageAsync($"Błąd doscorda: {_discordContext.GetUserNickname(usr.Id)} ([{ex.DiscordCode}] - {ex.Message})");
}
}
catch (Exception ex)
{
await Context.Channel.SendMessageAsync($"Błąd bota: {_discordContext.GetUserNickname(usr.Id)} ({ex.Message})");
}
}
}
public async Task UserFlask()
{
var userDiscordTag = $"{Context.User.Username}#{Context.User.Discriminator}"; // create full DiscordTag
var userDiscordId = Context.User.Id;
var googleSettings = _config.CurrentValue.GoogleSettings; // gets curent value of GoogleSettings
var reportDate = await _googleService.ReadCellAsync(googleSettings.FlaskData.ReportDateAddres);
if (DateTime.TryParseExact(reportDate, googleSettings.FlaskData.ReportDateFormat, new CultureInfo("en-US"), DateTimeStyles.None, out var reportDateResoult))
{
var flaskData = await _googleService.ReadDataAsync <FlaskModel>(googleSettings.FlaskData.ReportValuesAddres);
var userData = flaskData.FirstOrDefault(x => x.DiscordId == userDiscordId);
if (userData != null)
{
var sb = new StringBuilder();
sb.AppendLine($"[Ostatnia aktualizacja: {reportDateResoult:dd.MM.yyyy HH:mm}]".Decorate(Decorator.Bold));
sb.Append(Context.User.Mention);
sb.Append($" <{userData.WowNick}> masz ");
sb.Append(userData.FlaskCount.ToString().Decorate(Decorator.Underline));
sb.Append($" {userData.FlaskCount.FlaskGrammaVariety()}");
if (userData.FlaskCount < 0)
{
sb.AppendLine(string.Empty);
sb.AppendLine(string.Empty);
sb.AppendLine("Jak najszybciej uzupełnij brakujące flaszki!".Decorate(Decorator.underline_bold_italics));
}
await Context.Channel.SendMessageAsync(sb.ToString());
}
else
{
await Context.Channel.SendMessageAsync("Brak w bazie... sorry\nJeżeli jest to błąd skontaktuj się z administratorem");
await _logger.WriteLog($"Can't find data in GooglSheets for user {userDiscordTag}({userDiscordId})");
}
}
else
{
await Context.Channel.SendMessageAsync("Wystąpił problem z bazą flaszek, skontaktuj się z administratorem");
await _logger.WriteLog($"Can't parse DateTime in GooglSheets: {(string.IsNullOrEmpty(reportDate) ? "null" : reportDate)}");
}
}
private async void SubstractFlasks(List <Friendly> characters, int count, DateTime fightDate)
{
var googleSettings = _config.CurrentValue.GoogleSettings;
var nerdRoster = await _googleService.GetNerdsAsync();
var curentValues = await _googleService.ReadDataAsync <FlaskModel>(googleSettings.FlaskData.ReportValuesAddres);
var newMembersLastRow = (await _googleService.ReadCellAsync(googleSettings.NewMembers.ConfigLastRow)).GetInt();
var newMembers = new List <Friendly>();
foreach (var character in characters)
{
var raider = nerdRoster.FirstOrDefault(x => x.AllNicks.Contains(character.Name, StringComparer.InvariantCultureIgnoreCase));
if (raider != null)
{
if (raider.Handled)
{
continue; // skip if already counted
}
var flaskData = curentValues.First(x => x.WowNick == raider.MainNick);
if (flaskData != null)
{
flaskData.FlaskCount -= count;
}
else
{
newMembers.Add(character); // missing data
}
raider.Handled = true;
}
else
{
newMembers.Add(character);
}
}
var rangeToSave = string.Format(googleSettings.FlaskData.ReportFlaskCountAddresTemplate, curentValues.Count + 1);
var valuesToSave = curentValues.Select(x => x.FlaskCount).ToList();
var newMembersRangeToSave = string.Format(googleSettings.NewMembers.NewMembersAddresTemplate, newMembersLastRow, newMembersLastRow + newMembers.Count);
var newMembersValuesToSave = newMembers.Select(x => new { fightDate = fightDate.ToString("yyyy-MM-dd"), x.Name, x.Server, x.Type }).ToList();
await _googleService.WriteDataAsync(rangeToSave, valuesToSave);
await _googleService.WriteDataAsync(newMembersRangeToSave, newMembersValuesToSave);
await _googleService.WriteDataAsync(googleSettings.FlaskData.ReportSubstarctDateAddres, DateTime.Now.ToString(googleSettings.FlaskData.ReportDateFormat));
}
