public void EditHardware(HardwareItem hardwareItem)
 {
     using (SQLiteCommand com = new SQLiteCommand(con))
     {
         com.CommandText = "UPDATE hardware_items SET itemID = '" + hardwareItem.itemID + "', itemName = '" + hardwareItem.itemName + "', price = '" + hardwareItem.price + "', weight = '" + hardwareItem.Weight + "' WHERE itemID = '" + hardwareItem.itemID + "' ;";
         com.ExecuteNonQuery();
     }
 }
        public void SaveHardwareItem(HardwareItem hardwareItemToSave)
        {
            using (SQLiteCommand com = new SQLiteCommand(con))
            {
                com.CommandText = "INSERT INTO hardware_items (itemID, itemName, price, weight) VALUES ('" + hardwareItemToSave.itemID + "','" + hardwareItemToSave.itemName + "', '" + hardwareItemToSave.price + "', '" + hardwareItemToSave.Weight + "')";

                com.ExecuteNonQuery();
                com.Dispose();
            }
        }
        public void DeleteHardwareItem(HardwareItem hardwareitemToDelete)
        {
            itemsBaza db1 = new itemsBaza();

            db1.ReadItems();

            using (SQLiteCommand com = new SQLiteCommand(con))
            {
                com.CommandText = "DELETE FROM hardware_items WHERE (itemID ='" + hardwareitemToDelete.itemID + "');";

                com.ExecuteNonQuery();
                com.Dispose();
            }
        }
        public List <HardwareItem> ReadItemsH()
        {
            List <HardwareItem> seznam = new List <HardwareItem>();

            using (SQLiteCommand com = new SQLiteCommand(con))
            {
                com.CommandText = "SELECT * FROM hardware_items";
                SQLiteDataReader reader = com.ExecuteReader();
                while (reader.Read())
                {
                    HardwareItem Item = new HardwareItem(Convert.ToString(reader.GetInt32(1)), reader.GetString(2), reader.GetDouble(3), reader.GetDouble(4));
                    seznam.Add(Item);
                }
            }
            return(seznam);
        }