public static function addResource(en\resource $rs)
{
$conn = connection::getConnectionObject();
$con = $conn->getConnection();
$sql = $con->prepare("INSERT INTO resource VALUES (?,?)");
$resid = $rs->getResourceId();
$supid = $rs->getSupplierId();
$sql->bind_param("ss", $resid, $supid);
if ($sql->execute() == TRUE) {
echo "New record created successfully in RESOURCE table";
} else {
echo "Error in resource adding: <br>";
}
}
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');
}
public function addNewEquipmentSaveAction()
{
$eqpm = new en\equipment();
$eqpm->setEquipmentName($_POST["equipmentName"]);
$eqpm->setDate($_POST["date"]);
echo $eqpm->getDate();
$eqpm->setQuantity($_POST["quantity"]);
$eqpm->setResourceId($_POST["resourceId"]);
$rs = new en\resource();
$rs->setResourceId($_POST["resourceId"]);
$rs->setSupplierId($_POST["supplierId"]);
$added = cont\EquipmentDBacess::saveToEquipment($eqpm, $rs);
if ($added) {
return $this->render('applicationequipmentBundle:Forms:addedSuccessfullyMessage.html.twig');
} else {
echo "not added";
return $this->render('applicationMainBundle:Default:index.html.twig');
}
}