<?php

class Travel_Model_TblICAccomdationRoomCancellationPolicy extends Zend_Db_Table_Abstract {
	
    private $db = NULL;
    public function __construct() {
        $request = Zend_Controller_Front::getInstance()->getRequest();
        $this->baseUrl = $request->getScheme() . '://' . $request->getHttpHost();
        $this->db = Zend_Db_Table::getDefaultAdapter();
    }

    public function __destruct() {
        $this->db->closeConnection();
    }
	public function addRoomCancellationPolicy(array $data) {
		$this->db->insert('TB_IC_Accomdation_Room_CancellationPolicy', $data);
		return $this->db->lastInsertId('TB_IC_Accomdation_Room_CancellationPolicy');
		return $lastID;
	}
	public function UpdateRoomCancellationPolicy(array $data, $where){
		$this->db->update('TB_IC_Accomdation_Room_CancellationPolicy', $data, $where);
	}
	public function ChkCancellationPolicyExist($AccomSysId,$RoomIndex){
		$select = $this->db->select();
		$select->from(array('tbl' => "TB_IC_Accomdation_Room_CancellationPolicy"));
		$select->where('tbl.Accosysid = ?', $AccomSysId);
		$select->where('tbl.roomindex = ?', $RoomIndex);
		$select->where("IsActive = ?", 1);
		$select->where("IsMarkForDel = ?", 0);
		$result = $this->db->fetchAll($select);
		return $result;
	
	}
	
}
?>