public static async Task <DiscordMessage> CreateOrGetAsync(Discord.IMessage message) { var db = new ApplicationDataContext(); var dm = db.DiscordMessages.Where(m => m.Id == message.Id).FirstOrDefault(); db.Dispose(); if (dm == null) { await CreateAsync(message); } return(dm); }
public static async Task LogAsync(string message) { var log = new Log() { DateTime = DateTime.Now, Message = message }; Console.WriteLine($"{DateTime.Now} {log.Message}"); var db = new ApplicationDataContext(); db.Add(log); await db.SaveChangesAsync(); db.Dispose(); }
public static async Task <DiscordMessage> CreateAsync(Discord.IMessage message) { await DiscordChannel.CreateOrGetAsync(message.Channel); using (var db = new ApplicationDataContext()) { var dm = new DiscordMessage() { Id = message.Id, AuthorId = message.Author.Id, ChannelId = message.Channel.Id, Created = DateTime.Now, IsDeleted = false, Text = message.Content }; db.Add(dm); await db.SaveChangesAsync(); return(dm); } }
public async static Task Log(SocketUser user, SocketChannel chan, string eventName) { var u = await DiscordUser.CreateOrGetAsync(user); var c = await DiscordVoiceChannel.CreateOrGetAsync(chan); var vel = new VoiceEventLog() { Date = DateTime.Now, ChannelId = c.Id, UserId = u.Id, EventType = eventName }; var db = new ApplicationDataContext(); db.Add(vel); await db.SaveChangesAsync(); db.Dispose(); }
public static async Task LogAsync(SocketUser user, string message) { await DiscordUser.CreateOrGetAsync(user); var log = new Log() { UserId = user.Id, Message = message }; Console.WriteLine($"{DateTime.Now} {log.Message}"); var db = new ApplicationDataContext(); db.Add(log); await db.SaveChangesAsync(); db.Dispose(); }
public static async Task LogAsync(SocketUser user, SocketVoiceChannel channel, string eventName) { var db = new ApplicationDataContext(); await DiscordUser.CreateOrGetAsync(user); var log = new Log() { UserId = user.Id, ChannelId = channel.Id, DateTime = DateTime.Now }; log.Message = $"{user.Username} {eventName} in {channel.Name}"; Console.WriteLine($"{DateTime.Now} {log.Message}"); db.Add(log); await db.SaveChangesAsync(); db.Dispose(); }
public static async Task <DiscordChannel> CreateOrGetAsync(IMessageChannel channel) { var chan = Program._discordChannels.Where(c => c.Id == channel.Id).FirstOrDefault(); if (chan == null) { var db = new ApplicationDataContext(); chan = new DiscordChannel() { Id = channel.Id, Name = channel.Name }; db.Add(chan); Program._discordChannels = await db.DiscordChannels.ToListAsync(); await db.SaveChangesAsync(); db.Dispose(); } return(chan); }