<?php 
include '../pdoconnection.php';
include '../Class/Room.php';
include '../Class/Promotion.php';
if (isset($_GET['promoid'])) {
    $roomid = $_GET['promoid'];
    $sql = "SELECT * FROM tblpromotion WHERE Room_ID='promoid'";
    $result = $conn->query($sql);
    $row = $result->fetch(PDO::FETCH_ASSOC);
    $promoroom = new Promotion();
    $promoroom->RoomID = $roomid;
    $promoroom->CategoryName = $row['CategoryName'];
    $promoroom->PromoRate = $row['Promo_Rate'];
    $promoroom->Descript = $row['Description'];
    $promoroom->Status = $row['Status'];
    $promoroom->DateStart = $row['Date_Start'];
    $promoroom->DateEnd = $row['Date_End'];
    if ($promoroom->Deletepromo()) {
        header('location:ManageRoom.php');
    }
}