public static function getAllLocations()
{
try {
$conn = connection::getConnectionObject();
$con = $conn->getConnection();
$stm = $con->stmt_init();
$stm->prepare("SELECT resource_id ,locationName FROM location");
//
//
$stm->execute();
$result = $stm->get_result();
//
$locationarray = array();
$count = 0;
while ($row = $result->fetch_assoc()) {
$location = new Location();
$location->setName($row["locationName"]);
$location->setResourceid($row["resource_id"]);
$locationarray[] = $location;
}
return $locationarray;
} catch (Exception $e) {
return "error";
} finally {
//$conn->close();
$stm->close();
}
}
public function saveLocationAction()
{
$eqpm = new en\Location();
$rs = new en\resource();
$eqpm->setResourceId($_POST["resource_id"]);
$eqpm->setType($_POST["locationtype"]);
$eqpm->setSession($_POST["sessionlimit"]);
$eqpm->setName($_POST["locationName"]);
$rs->setResourceId($_POST["resource_id"]);
$rs->setSupplierId($_POST["supplier_id"]);
cont\ResourceDBaccess::addResource($rs);
cont\LocationDBaccess::addLocation($eqpm);
return $this->render('applicationLocationsBundle:Default:index.html.twig');
}