// DELETE user by ID
router.delete('/register/:id', async (req, res) => {
  try {
    const { id } = req.params;

    if (!id) {
      return res.status(400).json({
        ResponseCode: "400",
        Result: "false",
        ResponseMsg: "User ID is required.",
      });
    }

    const [result] = await db.promise().query(
      "DELETE FROM register WHERE id = ?",
      [id]
    );

    if (result.affectedRows === 0) {
      return res.status(404).json({
        ResponseCode: "404",
        Result: "false",
        ResponseMsg: "No user found with this ID.",
      });
    }

    return res.status(200).json({
      ResponseCode: "200",
      Result: "true",
      ResponseMsg: `User with ID ${id} deleted successfully.`,
    });

  } catch (error) {
    console.error("Error deleting user:", error);
    return res.status(500).json({
      ResponseCode: "500",
      Result: "false",
      ResponseMsg: "Internal Server Error.",
    });
  }
});