public function AddUser()
{
$success = false;
$sql = "insert into tblusers (FirstName,LastName,City,Address,Province,Country,Username,Password,Contact,Email) values ('{$this->Firstname}','{$this->Lastname}','{$this->City}','{$this->Address}','{$this->Province}','{$this->Country}','{$this->Username}','{$this->Password}','{$this->Contact}','{$this->Email}')";
try {
include '../connection.php';
$query = mysqli_query($conn, $sql);
$success = true;
} catch (mysqliException $ex) {
$success = false;
$ex - getMesssage();
}
mysqli_close($conn);
return $success;
}
public function DeleteCategory()
{
$success = false;
$sql = "delete from tblcategories where Category_ID='{$this->CategoryID}'";
try {
include '../../connection.php';
$query = mysqli_query($conn, $sql);
$success = true;
} catch (mysqliException $ex) {
$success = false;
$ex - getMesssage();
}
mysqli_close($conn);
return $success;
}
public function NotifyUser()
{
$success = false;
$datenow = date('Y-m-d');
$s = 1;
$sql = "insert into tblnotifications (FromUser,ToUser,Message,DateRecieved,Unread) values ('{$this->FromUser}','{$this->ToUser}','{$this->Message}','{$datenow}',2)";
try {
include '../../connection.php';
$query = mysqli_query($conn, $sql);
$success = true;
} catch (mysqliException $ex) {
$success = false;
$ex - getMesssage();
}
mysqli_close($conn);
return $success;
}
public function DeleteAddon()
{
$success = false;
$sql = "delete from tbladdons where addon_id='{$this->AddonID}'";
try {
include '../connection.php';
$query = mysqli_query($conn, $sql);
$success = true;
} catch (mysqliException $ex) {
$success = false;
$ex - getMesssage();
}
mysqli_close($conn);
return $success;
}
public function AddReserve()
{
$success = false;
//$from = DateTime::createFromFormat('d/m/Y', $this->Arrival)->format('Y-m-d');
//$to = DateTime::createFromFormat('d/m/Y', $this->Departure)->format('Y-m-d');
$from = $this->Arrival;
$to = $this->Departure;
$datenow = date('Y-m-d');
$sql = "insert into tblreservation (Customer_ID,CategoryName,Room_ID,ReservationDate,Arrival,Departure,NumberofDay,No_Adult,No_Child,Status, " . "AddonPayable,Downpayment,Payable,Confirmation,transaction) values (" . "'{$this->CustomerID}','{$this->CategoryName}','{$this->RoomID}','{$datenow}','" . $from . "','" . $to . "','{$this->NumberofDays}','{$this->NumberofAdult}','{$this->NumberofChild}','{$this->Status}','{$this->Addonpayable}','{$this->Downpayment}','{$this->Payable}','{$this->Confirmation}',null)";
try {
include '../../connection.php';
$query = mysqli_query($conn, $sql);
$success = true;
} catch (mysqliException $ex) {
$success = false;
$ex - getMesssage();
}
mysqli_close($conn);
return $success;
}
public static function commentDelete($comment_ID)
{
$success = false;
$sql = "DELETE FROM tblcomment WHERE Comment_ID='{$comment_ID}'";
try {
include '../../connection.php';
$query = mysqli_query($conn, $sql);
$success = true;
} catch (mysqliException $ex) {
$success = false;
$ex - getMesssage();
}
mysqli_close($conn);
return $success;
}
