* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
* OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
* WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
* OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
* EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
/**
*
* This is a sample application to show how to add a link between Customers
* entity instance and Orders Entity Intance.
*/
require_once 'NorthwindEntities.php';
require_once 'urldef.php';
echo "<h3>Sample8: Add a link between a customer entity and Order entity</h3>";
try {
$proxy = new NorthwindEntities(NORTHWIND_SERVICE_URL);
$cust = new Customers();
$cust->CustomerID = 'CHAN9';
$cust->CompanyName = 'channel9';
$proxy->AddToCustomers($cust);
$newO = new Orders();
$proxy->AddToOrders($newO);
$proxy->AddLink($cust, "Orders", $newO);
$proxy->SaveChanges();
echo "Link between a customer entity with ID CHAN9 and a new Order entity has been added";
echo "<br/>New order id is:" . $newO->OrderID;
} catch (ODataServiceException $e) {
echo "Error:" . $e->getError() . "<br>" . "Detailed Error:" . $e->getDetailedError();
} catch (InvalidOperation $e) {
echo $e->getError();
}
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
* THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
* PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
* CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
* EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
* OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
* WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
* OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
* EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
require_once 'NorthwindEntities.php';
require_once 'urldef.php';
echo "<h3>Sample6: Update the CompanyName of customer entity added in Sample5 to 'Channel8'</h3>";
try {
$svc = new NorthwindEntities(NORTHWIND_SERVICE_URL);
$response = $svc->Customers()->filter("CustomerID eq 'CHAN9'")->Execute();
if (count($response->Result)) {
$customer = $response->Result[0];
$customer->CompanyName = 'Channel8';
$svc->UpdateObject($customer);
$svc->SaveChanges();
echo 'Company name of Customer with ID CHAN9 has been updated to Channel8';
} else {
echo 'Customer with CustomerID CHAN9 not found';
}
} catch (ODataServiceException $e) {
echo "Error:" . $e->getError() . "<br>" . "Detailed Error:" . $e->getDetailedError();
} catch (InvalidOperation $e) {
echo $e->getError();
}