public void addMissingItems() { try { string sql = "SELECT DISTINCT slot, item, short_event_name FROM loot AS l WHERE NOT EXISTS(SELECT 1 FROM items WHERE item = l.item AND short_event_name = l.short_event_name AND slot = l.slot) AND NOT EXISTS(SELECT 1 FROM items WHERE is_global = 'Yes' AND item = l.item AND slot = l.slot)"; DbDataReader rs = DBManager.getManager().executeQuery(sql); while (rs.Read()) { string slot = rs[0].ToString().Trim(); string item = rs[1].ToString().Trim(); string eventName = rs[2].ToString().Trim(); logger.Info(String.Format("Inserting loot entry. [{0}, {1}, {2}]", slot, item, eventName)); // Send the new row to the API for insertion. IList <Object> values = new List <Object> { slot, item, eventName }; GDriveManager.appendSpreadsheet(Constants.ITEMS_ID, "ROFItems", values); DBManager.getManager().insertItemEntry(slot, item, eventName, "", "", ""); } } catch (Exception e) { logger.Error("Failed to insert loot entry", e); throw e; } }
public void insertNewLootEntry(string date, string name, string eventName, string item, string slot, string rot, string altLoot) { try { // Create a local representation of the new row. IList <Object> values = new List <Object> { date, name, eventName, item, slot, rot, altLoot }; GDriveManager.appendSpreadsheet(logURI, "RainOfFearLoot", values); logger.Info(String.Format("Inserted loot entry. [{0}, {1}, {2}, {3}, {4}, {5}, {6}]", date, name, eventName, item, slot, rot, altLoot)); } catch (Exception e) { logger.Error(String.Format("Failed to insert loot entry [{0}, {1}, {2}, {3}, {4}, {5}, {6}]", date, name, eventName, item, slot, rot, altLoot), e); throw e; } }