public function editProduct(Product $product)
 {
     $editStmt = $this->db->prepare("UPDATE\n                            products\n                       SET\n                            name = ?, model = ?, price = ?, quantity = ?, category_id = ?\n                        WHERE id = ?")->execute([$product->getProductname(), $product->getProductmodel(), $product->getProductprice(), $product->getProductquantity(), $product->getCategory(), $product->getId()]);
     if ($editStmt->getAffectedRows() > 0) {
         return true;
     }
     return false;
 }