import { createServerComponentClient } from "@supabase/auth-helpers-nextjs";
import { NextApiRequest, NextApiResponse } from "next";
import { cookies } from "next/headers";

export default async function deleteWaterType(req: NextApiRequest, res: NextApiResponse) {
  if (req.method === "DELETE") {
    const { water_id } = req.body as { water_id: number }; // You can pass the water_id in the request body

    try {
      // Use the water_id to specify which record to delete
      const supabase = createServerComponentClient({ cookies });
      const { data, error } = await supabase
        .from("water_type") // Replace with your table name
        .delete()
        .eq("id", Number(water_id));

      if (error) {
        return res.status(500).json({ error: "Error deleting record" });
      }

      console.log("Response data:", data); // Changed "res" to "data" to log the correct variable
      return res.status(200).json({ message: "Record deleted successfully" });
    } catch (error) {
      return res.status(500).json({ error: "Error deleting record" });
    }
  } else {
    return res.status(405).json({ error: "Method not allowed" });
  }
}

   try {
      const response = await fetch("/auth/actions/waterTypes/deleteWaterType", {
        method: "DELETE",
        body: JSON.stringify({ water_id }),
        headers: {
          "Content-Type": "application/json",
        },
      });

      console.log(response,"response")

      if (response.status === 200) {
        console.log(`Deleted record with ID: ${water_id}`);
        setErrorMessage(null);
      } else {
        const errorResponse = await response.json();
        setErrorMessage(errorResponse.error);
      }

      toggleClose();
    } catch (error) {
      console.error("Error deleting record:", error);
      setErrorMessage("An error occurred while deleting the record.");
    }
  };