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; } }