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