private static void ProcessCombantants(SQLiteConnection dbConnection, DestinySqlEntities db)
{
var sql = "SELECT quote(json) FROM DestinyCombatantDefinition";
var command = new SQLiteCommand(sql, dbConnection);
var reader = command.ExecuteReader();
while (reader.Read())
{
var jsonStripped = ((string)reader["quote(json)"]).Replace("'{", "{").Replace("}'", "}");
var item = JsonConvert.DeserializeObject <DestinyDailyApiManager.Models.Manifest.Combatant.Combatant>(jsonStripped);
var mappedItem = db.Combatants.FirstOrDefault(c => c.id == item.combatantHash);
if (mappedItem == null)
{
mappedItem = new Combatant()
{
id = item.combatantHash,
name = item.combatantName,
desc = item.description,
icon = item.icon,
image = item.image
};
db.Combatants.Add(mappedItem);
}
else
{
mappedItem.id = item.combatantHash;
mappedItem.name = item.combatantName;
mappedItem.desc = item.description;
mappedItem.icon = item.icon;
mappedItem.image = item.image;
}
}
try { db.SaveChanges(); }
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
}
public XurManager()
{
db = new DestinySqlEntities();
db2 = new DestinyDaily2Entities();
}
public NightFallManager()
{
db = new DestinySqlEntities();
db2 = new DestinyDaily2Entities();
}
private static void ProcessManifestActivities(SQLiteConnection dbConnection, DestinySqlEntities db)
{
var sql = "SELECT quote(json) FROM DestinyActivityDefinition";
var command = new SQLiteCommand(sql, dbConnection);
var reader = command.ExecuteReader();
while (reader.Read())
{
var jsonStripped = ((string)reader["quote(json)"]).Replace("'{", "{").Replace("}'", "}");
var item = JsonConvert.DeserializeObject <ActivityDefinition>(jsonStripped);
var mappedItem = db.ManifestActivities.FirstOrDefault(c => c.id == item.activityHash);
if (mappedItem == null)
{
mappedItem = new ManifestActivity()
{
id = item.activityHash,
desc = item.activityDescription,
icon = item.icon,
name = item.activityName,
pgcricon = item.pgcrImage
};
db.ManifestActivities.Add(mappedItem);
if (item.skulls != null && item.skulls.Any())
{
foreach (var skull in item.skulls)
{
var newSkull = new ManifestSkull()
{
activityhash = item.activityHash,
name = skull.displayName
};
db.ManifestSkulls.Add(newSkull);
}
}
if (item.rewards != null && item.rewards.Any())
{
foreach (var rewardList in item.rewards)
{
foreach (var reward in rewardList.rewardItems)
{
var newReward = new ManifestReward()
{
activityhash = item.activityHash,
rewardHash = reward.itemHash,
value = reward.value
};
db.ManifestRewards.Add(newReward);
}
}
}
}
else
{
mappedItem.id = item.activityHash;
mappedItem.desc = item.activityDescription;
mappedItem.icon = item.icon;
mappedItem.name = item.activityName;
mappedItem.pgcricon = item.pgcrImage;
}
}
try { db.SaveChanges(); }
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
}
public DailyManager()
{
db = new DestinySqlEntities();
}
public TrialsManager()
{
db = new DestinySqlEntities();
}
public PrisonManager()
{
db = new DestinySqlEntities();
bountyManager = new BountyManager();
}
public VendorManager()
{
db = new DestinySqlEntities();
}
