CodeImp.Gluon.GroceriesItem.SqlUpdateOrInsert C# (CSharp) Метод

        public bool SqlUpdateOrInsert(bool increasecount)
        {
            string q = "INSERT INTO `groceries` " +
                            "(`name`, `list`, `count`) " +
                       "VALUES " +
                            "('" + name + "', '" + list + "', '" + count + "') " +
                       "ON DUPLICATE KEY UPDATE `count` = '" + count + "';";

            General.DB.ConnectSafe();
            int result = General.DB.Update(q);
            bool success = (result > 0);

            // Update the count
            if(success && increasecount)
                success = SqlUpdateOrInsertCount();

            General.DB.Disconnect();
            return success;
        }

        // A quick item is clicked
        private void quickitem_Click(object sender, EventArgs e)
        {
            DisplayButton quickitembutton = (DisplayButton)sender;

            int index = GetIndexByName(quickitembutton.Text);

            if (index > -1)
            {
                items[index].count++;
                items[index].SqlUpdateOrInsert(false);
            }
            else
            {
                GroceriesItem newitem = new GroceriesItem();
                newitem.name  = quickitembutton.Text;
                newitem.count = 1;
                newitem.list  = selectedlist;
                newitem.SqlUpdateOrInsert(true);
                items = General.Groceries.GetAllItems(selectedlist).ToArray();
            }

            RefreshMainItems();
        }