private static async Task LoadFromJson()
{
if (!File.Exists(InitialDataFile))
{
Logger.Warning($"Cannot find {Path.GetFullPath(InitialDataFile)}");
return;
}
using var s = File.OpenRead(InitialDataFile);
using var sr = new StreamReader(s);
using var reader = new JsonTextReader(sr);
using var context = new MapleDbContext();
try
{
var sw = Stopwatch.StartNew();
var serializer = new JsonSerializer();
var data = serializer.Deserialize <Dictionary <int, List <LootReference> > >(reader);
foreach (var item in data.Values.SelectMany(x => x))
{
if (!CachedData.Mobs.Data.ContainsKey(item.MobId))
{
Logger.Warning($"Skipping loot - Cannot find Mob with ID={item.MobId} in DataProvider");
continue;
}
if (!item.IsMeso && !CachedData.Items.Data.ContainsKey(item.ItemId))
{
Logger.Warning($"Skipping loot - Cannot find Item with ID={item.ItemId} in DataProvider");
continue;
}
context.Loots.Add(new LootEntity
{
Chance = item.Chance,
IsMeso = item.IsMeso,
ItemId = item.ItemId,
MaximumQuantity = item.MaximumQuantity,
MinimumQuantity = item.MinimumQuantity,
MobId = item.MobId,
QuestId = item.QuestId
});
}
await context.SaveChangesAsync();
Logger.Information("Populated database in {0}ms.", sw.ElapsedMilliseconds);
}
catch (Exception e)
{
Logger.Error(e, "Error while loading changes from JSON");
}
}
private static async Task LoadFromDatabase(MapleDbContext context)
{
Logger.Information("Loading Loot from database");
var entities = context
.Loots
.ToList()
.GroupBy(x => x.MobId)
.ToList();
entities
.ForEach(x =>
{
if (!CachedData.Mobs?.Data?.ContainsKey(x.Key) ?? true)
{
Logger.Warning($"Removing loot - Cannot find Mob with ID={x.Key} in DataProvider");
context.Loots.RemoveRange(x);
return;
}
var loots = CachedData.Mobs.Data[x.Key].Loots;
loots.Clear();
x
.ToList()
.ForEach(item =>
{
if (!item.IsMeso && !CachedData.Items.Data.ContainsKey(item.ItemId))
{
Logger.Warning(
$"Removing loot - Cannot find Item with ID={item.ItemId} in DataProvider");
context.Loots.Remove(item);
return;
}
loots.Add(new LootReference
{
Chance = item.Chance,
IsMeso = item.IsMeso,
ItemId = item.ItemId,
MaximumQuantity = item.MaximumQuantity,
MinimumQuantity = item.MinimumQuantity,
MobId = item.MobId,
QuestId = item.QuestId
});
});
});
await context.SaveChangesAsync();
}