Tibialyzer.Hunt.GetUsedItems C# (CSharp) Method

        public List<Tuple<Item, int>> GetUsedItems()
        {
            lock (huntLock) {
                List<Tuple<Item, int>> items = new List<Tuple<Item, int>>();
                foreach (var val in usedItems) {
                    int count = val.Value.GetItemCount();
                    if (count > 1) {
                        items.Add(new Tuple<Item, int>(val.Key, count));
                    }
                }
                return items;
            }
        }

        public static void UpdateUsedItems(Hunt h)
        {
            var usedItems = h.GetUsedItems();

            lock (lootLock) {
                foreach (var item in usedItems)
                {
                    int itemid = item.Item1.id;
                    int amount = item.Item2;

                    int    value  = 0;
                    object result = ExecuteScalar(String.Format("SELECT itemid FROM {0} WHERE itemid={1}", h.GetWasteTableName(), itemid));
                    if (result != null && int.TryParse(result.ToString(), out value))
                    {
                        ExecuteNonQuery(String.Format("UPDATE {0} SET amount={1} WHERE itemid={2}", h.GetWasteTableName(), amount, itemid));
                    }
                    else
                    {
                        ExecuteNonQuery(String.Format("INSERT INTO {0} (itemid, amount) VALUES ({1}, {2})", h.GetWasteTableName(), itemid, amount));
                    }
                }
            }
        }