public void loadLootInfo()
{
if (!isLoading)
{
isLoading = true;
loadLogFeed();
IDictionary <string, int> headerMap = GDriveManager.getHeaderMap(logFeed.Values);
List <BulkLoader> rows = new List <BulkLoader>();
// Iterate through each row
foreach (IList <Object> row in logFeed.Values.Skip(1))
{
LootEntry loot = new LootEntry();
loot.date = GDriveManager.readCell(row, headerMap["date"]);
loot.name = GDriveManager.readCell(row, headerMap["name"]);
loot.eventName = GDriveManager.readCell(row, headerMap["event"]);
loot.item = GDriveManager.readCell(row, headerMap["item"]);
loot.slot = GDriveManager.readCell(row, headerMap["slot"]);
loot.rot = GDriveManager.readCell(row, headerMap["rot"]);
loot.altLoot = GDriveManager.readCell(row, headerMap["alt loot"]);
rows.Add(loot);
}
DBManager.getManager().emptyTable("loot");
DBManager.getManager().bulkInsert(rows, "loot");
isLoading = false;
}
}
public void loadLootInfo()
{
if (!isLoading) {
isLoading = true;
loadLogFeed();
List<BulkLoader> rows = new List<BulkLoader>();
// Add the loot log to the database
foreach (ListEntry row in logFeed.Entries) {
LootEntry loot = new LootEntry();
// Iterate over the remaining columns
foreach (ListEntry.Custom element in row.Elements) {
switch (element.LocalName.ToLower()) {
case "date":
loot.date = element.Value;
break;
case "name":
loot.name = element.Value;
break;
case "event":
loot.eventName = element.Value;
break;
case "item":
loot.item = element.Value;
break;
case "slot":
loot.slot = element.Value;
break;
case "rot":
loot.rot = element.Value;
break;
case "altloot":
loot.altLoot = element.Value;
break;
}
}
rows.Add(loot);
}
DBManager.getManager().emptyTable("loot");
DBManager.getManager().bulkInsert(rows, "loot");
isLoading = false;
}
}
