// PUT api/Order/5
        public HttpResponseMessage PutOrder(int id, Order order)
        {
            if (!ModelState.IsValid)
            {
                return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
            }

            if (id != order.OrderId)
            {
                return Request.CreateResponse(HttpStatusCode.BadRequest);
            }

            db.Orders.Attach(order);
            db.ObjectStateManager.ChangeObjectState(order, EntityState.Modified);

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException ex)
            {
                return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex);
            }

            return Request.CreateResponse(HttpStatusCode.OK);
        }
        // POST api/Order
        public HttpResponseMessage PostOrder(Order order)
        {
            if (ModelState.IsValid)
            {
                db.Orders.AddObject(order);
                db.SaveChanges();

                HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, order);
                response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = order.OrderId }));
                return response;
            }
            else
            {
                return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
            }
        }
 /// <summary>
 /// Deprecated Method for adding a new object to the Orders EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToOrders(Order order)
 {
     base.AddObject("Orders", order);
 }
 /// <summary>
 /// Create a new Order object.
 /// </summary>
 /// <param name="orderId">Initial value of the OrderId property.</param>
 /// <param name="customerName">Initial value of the CustomerName property.</param>
 /// <param name="orderedItem">Initial value of the OrderedItem property.</param>
 /// <param name="orderedQuantity">Initial value of the OrderedQuantity property.</param>
 /// <param name="unitPrice">Initial value of the UnitPrice property.</param>
 /// <param name="totalBill">Initial value of the TotalBill property.</param>
 public static Order CreateOrder(global::System.Int32 orderId, global::System.String customerName, global::System.String orderedItem, global::System.Int32 orderedQuantity, global::System.Int32 unitPrice, global::System.Int32 totalBill)
 {
     Order order = new Order();
     order.OrderId = orderId;
     order.CustomerName = customerName;
     order.OrderedItem = orderedItem;
     order.OrderedQuantity = orderedQuantity;
     order.UnitPrice = unitPrice;
     order.TotalBill = totalBill;
     return order;
 }