<?php
require_once '../config/db.php';

// ADD EVENT
if (isset($_POST['action']) && $_POST['action'] == 'add') {

    $sql = "INSERT INTO event_master (EventName, CountryId, Status, CreateDateTime) 
            VALUES (?, ?, ?, NOW())";

    $stmt = $conn->prepare($sql);
    $stmt->bind_param("sii", $_POST['EventName'], $_POST['CountryId'], $_POST['Status']);
    $stmt->execute();

    header("Location: view_event.php?msg=added");
    exit;
}

// UPDATE STATUS
if (isset($_GET['changeStatus'])) {
    $EventId = intval($_GET['changeStatus']);
    $Status  = intval($_GET['status']);

    $sql = "UPDATE event_master SET Status = ?, UpdateDateTime = NOW() WHERE EventId = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("ii", $Status, $EventId);
    $stmt->execute();

    header("Location: view_event.php?msg=status_update");
    exit;
}

// DELETE EVENT
if (isset($_GET['delete'])) {
    $EventId = intval($_GET['delete']);

    $sql = "DELETE FROM event_master WHERE EventId = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("i", $EventId);
    $stmt->execute();

    header("Location: view_event.php?msg=deleted");
    exit;
}