public HttpResponseMessage Get(int orderId) { if (orderId != 0) { using (var context = new ordermgmtDBEntities()) { var resultObject = context.ORDERS.Where(s => s.ORD_NUM == orderId).FirstOrDefault(); return(Request.CreateResponse(HttpStatusCode.OK, resultObject)); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, orderId)); } }
public HttpResponseMessage InsertOrder([FromBody] ORDER oderdata) { if (oderdata != null) { using (var context = new ordermgmtDBEntities()) { var resultObject = context.ORDERS.Add(oderdata); int newlyinsertedOrderId = context.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, newlyinsertedOrderId)); } } else { return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Not Inserted")); } }
public HttpResponseMessage UpdateDeliveryStatus([FromBody] ORDER oderdata) { if (oderdata != null) { using (var context = new ordermgmtDBEntities()) { var newOrderData = new ORDER(); newOrderData = oderdata; var resultObject = context.ORDERS.Add(newOrderData); context.Entry(newOrderData).State = System.Data.Entity.EntityState.Modified; int newlyinsertedOrderId = context.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, newlyinsertedOrderId)); } } else { return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Not updated")); } }
public HttpResponseMessage GetOrdersByCustomerId(string customerId) { if (customerId != null) { using (var context = new ordermgmtDBEntities()) { var resultObject = from O in context.ORDERS.Where(x => x.CUST_CODE == customerId) select new { cusomerName = from c in context.CUSTOMERs.Where(x => x.CUST_CODE == customerId) select c.CUST_NAME, csutomerId = O.CUST_CODE, Orders = O }; return(Request.CreateResponse(HttpStatusCode.OK, resultObject.ToList())); } } else { return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Not valid Customer")); } }