* 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(); }