public void AddUserToDB(NeroLib.User user)
{
using (var db = new UsersContext()) {
db.Users.Add(user);
db.SaveChanges();
}
}
public void UpdateUser(NeroLib.User user)
{
using (var db = new UsersContext()) {
db.Users.Remove(user);
db.SaveChanges();
AddUserToDB(user);
}
}
public NeroLib.User LoadUser(NeroLib.User user)
{
if (dba.CheckIfUserExists(user))
{
return(dba.ReturnUser(user.UserId));
}
else
{
return(null);
}
}
public bool CheckIfUserExists(NeroLib.User user)
{
using (var db = new UsersContext()) {
if (db.Users.Any(u => u.UserId == user.UserId))
{
return(true);
}
else
{
return(false);
}
}
}
public void CountWorldPopulation(NeroLib.User user)
{
using (var db = new UsersContext()) {
var worlds = db.Worlds
//.Where(w => w.WorldId == user.WorldId)
.Include(w => w.Users);
//.FirstOrDefault();
foreach (var world in worlds)
{
world.Population = 0;
world.Population += (uint)world.Users.Count();
db.Worlds.Update(world);
}
db.SaveChanges();
}
}
public string GetListParse(NeroLib.User argUser)
{
//await GetParse(argUser);
var user = argUser;
user = LoadUser(user);
var reply = $"";
var pCollection = user.Parses.OrderBy(p => p.Percent).Reverse().Take(10);
foreach (var p in pCollection)
{
reply += $"\n**{p.JobAbrv.ToUpper()} | {p.Name}**: {p.Percent.ToString().Substring(0,5)}% - {p.PerSecondAmount}";
}
return(reply);
}
public async Task GetParse(NeroLib.User argUser)
{
NeroLib.User user = LoadUser(argUser);
NeroLib.World requestedWorld = dba.ReturnWorld(user.WorldId);
Console.WriteLine($"Username: {user.Username}\nDiscordID: {user.UserId}\nCharacter Name: {user.Name}\nCharacter World: {user.World}");
var SavageUrl = new Uri($"https://www.fflogs.com/v1/parses/character/{user.Name}/{requestedWorld.WorldName}/{requestedWorld.Region}/?api_key={LibConfiguration.Load().FFLogsKey}");
var TrialUrl = new Uri($"https://www.fflogs.com/v1/parses/character/{user.Name}/{requestedWorld.WorldName}/{requestedWorld.Region}/?api_key={LibConfiguration.Load().FFLogsKey}&zone=15");
var UltimateUrl = new Uri($"https://www.fflogs.com/v1/parses/character/{user.Name}/{requestedWorld.WorldName}/{requestedWorld.Region}/?api_key={LibConfiguration.Load().FFLogsKey}&zone=19");
Console.WriteLine($"FFLogs API URL: {SavageUrl}");
await LogParse(user, SavageUrl);
await LogParse(user, TrialUrl);
await LogParse(user, UltimateUrl);
}
