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