public async Task NewUser(SocketUser user = null)
{
var socketUser = user ?? Context.User;
using (RileyBotContext context = new RileyBotContext())
{
bool found = context.Users.Any(u => u.DiscordId == socketUser.Id);
if (!found)
{
context.Users.Add(new User
{
DiscordId = socketUser.Id,
Added = DateTime.Now
});
context.SaveChanges();
await ReplyAsync($"<@{socketUser.Id}> has been added successfully.");
}
else
{
await ReplyAsync($"Error adding <@{socketUser.Id}>. User already exists.");
}
}
}
public async Task NewDrop(
string name,
int killcount,
int points,
SocketUser user = null)
{
var socketUser = user ?? Context.User;
using (RileyBotContext context = new RileyBotContext())
{
try
{
context.Drops.Add(new Drop
{
Name = name,
KillCount = killcount,
Points = points,
UserId = context.Users.Where(u => u.DiscordId == socketUser.Id).FirstOrDefault().UserId
});
context.SaveChanges();
}
catch (Exception ex)
{
await ReplyAsync($"Error adding <@{socketUser.Id}'s Drop>");
}
finally
{
await ReplyAsync($"<@{socketUser.Id}>'s Drop has been added successfully.");
}
}
}
public async Task NewLink(
string link,
SocketUser user = null)
{
var socketUser = user ?? Context.User;
using (RileyBotContext context = new RileyBotContext())
{
try
{
context.Links.Add(new Link
{
LinkUrl = link,
UserId = context.Users.Where(u => u.DiscordId == socketUser.Id).FirstOrDefault().UserId
});
context.SaveChanges();
}
catch (Exception ex)
{
await ReplyAsync($"Error adding <@{socketUser.Id}'s Link>");
}
finally
{
await ReplyAsync($"<@{socketUser.Id}>'s Link has been added successfully.");
}
}
}
public IEnumerable <User> Get()
{
using (RileyBotContext context = new RileyBotContext())
{
var users = context.Users.ToArray();
return(users);
}
}
public IEnumerable <Drop> Get()
{
using (RileyBotContext context = new RileyBotContext())
{
var drops = context.Drops;
return(drops.ToArray());
}
}
public IEnumerable <Link> Get()
{
using (RileyBotContext context = new RileyBotContext())
{
var links = context.Links;
var l = links.ToArray();
return(l);
}
}
public async Task RandomLink()
{
using (RileyBotContext context = new RileyBotContext())
{
int maxId = context.Links.Select(x => x.LinkId).Max();
var random = new Random();
int rng = random.Next(1, maxId);
Link link = context.Links.Where(x => x.LinkId == rng).FirstOrDefault();
await ReplyAsync($"{link.LinkUrl}");
}
}
public async Task UsersTable(SocketUser user = null)
{
var socketUser = user ?? Context.User;
using (RileyBotContext context = new RileyBotContext())
{
var users = context.Users.ToList();
StringBuilder sb = new StringBuilder();
foreach (User u in users)
{
sb.Append($"DiscordId: {u.DiscordId}, ");
}
await ReplyAsync($"{sb.ToString()}");
}
}
public async Task DropsTable(SocketUser user = null)
{
var socketUser = user ?? Context.User;
var drops = new List <Drop>();
using (RileyBotContext context = new RileyBotContext())
{
var userData = context.Users.Where(u => u.DiscordId == socketUser.Id).FirstOrDefault();
drops = context.Drops.Where(d => d.UserId == userData.UserId).ToList();
drops = context.Drops.ToList();
StringBuilder sb = new StringBuilder();
foreach (var d in drops)
{
sb.Append($"user: {d.UserId}, dropname: {d.Name}, ");
}
await ReplyAsync($"{sb.ToString()}");
}
}
