public void ReminderLoop() { InquisitionContext db = new InquisitionContext(); List <Reminder> Reminders; while (true) { Reminders = db.Reminders.ToList(); List <Reminder> FinishedReminders = new List <Reminder>(); foreach (Reminder r in Reminders) { if (DateTime.Now >= r.DueDate) { _client.GetUser(ulong.Parse(r.UserId)).SendMessageAsync($"Reminder: {r.Message}"); FinishedReminders.Add(r); } } if (FinishedReminders.Count != 0) { db.Reminders.RemoveRange(FinishedReminders); db.SaveChanges(); } Thread.Sleep(5000); } }
private async Task PopulateDbAsync() { List <Data.Game> Games = new List <Data.Game> { new Data.Game { Name = "Space Engineers", Port = "3080", Version = "?" }, new Data.Game { Name = "StarMade", Port = "3070", Version = ".654" }, new Data.Game { Name = "Project Zomboid", Port = "3050", Version = "37.14" }, new Data.Game { Name = "Starbound", Port = "3040", Version = "1.2.2" }, new Data.Game { Name = "Terraria", Port = "3030", Version = "1.3.5.3" }, new Data.Game { Name = "Factorio", Port = "3020", Version = "15.18" }, new Data.Game { Name = "7 Days to die", Port = "3010", Version = "16 b138" }, new Data.Game { Name = "GMod - Sandbox", Port = "3003", Version = "?" }, new Data.Game { Name = "GMod - Murder", Port = "3000", Version = "?" } }; InquisitionContext db = new InquisitionContext(); await db.Games.AddRangeAsync(Games); await db.SaveChangesAsync(); }