public static void AddBan(ulong id, BanDataNode ban, string username = "")
{
int pos = 2;
ExcelRange cells = StrikeLog.Workbook.Worksheets[StrikeLogPage].Cells;
while (cells["A" + pos].Value != null)
{
if (Convert.ToUInt64(cells["A" + pos].Value.ToString()) == id)
{
cells[$"J{pos}:L{pos}"].LoadFromArrays(ban.GetBanForExcel());
KLog.Info($"Banned user {(string.IsNullOrWhiteSpace(username) ? id.ToString() : username)} by {ban.Moderator} for reason: {ban.Reason}. Ban added in cell range J{pos}:L{pos}.");
SaveExcel();
return;
}
pos++;
}
// User doesn't have an entry, so is likely just a troll.
GenUserStrike(pos, id);
cells[$"J{pos}:L{pos}"].LoadFromArrays(ban.GetBanForExcel());
// Set auto fit
cells[StrikeLog.Workbook.Worksheets[StrikeLogPage].Dimension.Address].AutoFitColumns();
KLog.Info($"Banned user {(string.IsNullOrWhiteSpace(username) ? id.ToString() : username)} by {ban.Moderator} for reason: {ban.Reason}. Ban added in cell range J{pos}:L{pos}.");
SaveExcel();
}
public static void AddBan(SocketUser target, BanDataNode ban)
{
int pos = GetEntryPos(target.Id);
ExcelRange cells = StrikeLog.Workbook.Worksheets[StrikeLogPage].Cells;
cells[$"J{pos}:L{pos}"].LoadFromArrays(ban.GetBanForExcel());
KLog.Info($"Banned user {BotUtils.GetFullUsername(target)} by {ban.Moderator} for reason: {ban.Reason}. Ban added in cell range J{pos}:L{pos}.");
SaveExcel();
// User doesn't have an entry, so is likely just a troll.
GenUserStrike(pos, target);
cells[$"J{pos}:L{pos}"].LoadFromArrays(ban.GetBanForExcel());
// Set auto fit
cells[StrikeLog.Workbook.Worksheets[StrikeLogPage].Dimension.Address].AutoFitColumns();
KLog.Info($"Banned user {BotUtils.GetFullUsername(target)} by {ban.Moderator} for reason: {ban.Reason}. Ban added in cell range J{pos}:L{pos}.");
SaveExcel();
}
