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