// PUT: api/Category/5 public HttpResponseMessage Put(int id, [FromBody] Category value) { try { using (EshopEntities db = new EshopEntities()) { Category s = db.Categories.SingleOrDefault(b => b.CategoryID == id); if (s != null) { s.CategoryID = id; s.CategoryName = value.CategoryName; s.Description = value.Description; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, s)); } else { return(null); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// PUT: api/EditOrder/5 public HttpResponseMessage EditOrder(int id, [FromBody] Order order) { try { using (EshopEntities db = new EshopEntities()) { Order s = db.Orders.SingleOrDefault(b => b.OrderID == id); if (s != null) { s.OrderID = id; s.CustomerID = order.CustomerID; s.OrderDate = order.OrderDate; s.ShipAddress = order.ShipAddress; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, s)); } else { return(null); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// PUT: api/Product/5 public HttpResponseMessage Put(int id, [FromBody] Product value) { try { using (EshopEntities db = new EshopEntities()) { Product s = db.Products.SingleOrDefault(b => b.ProductID == id); if (s != null) { s.ProductID = id; s.CategoryID = value.CategoryID; s.UnitPrice = value.UnitPrice; s.ProductName = value.ProductName; s.Quantity = value.Quantity; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, s)); } else { return(null); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
public List <Customer> GetCustomerByAddress(string address) { using (EshopEntities db = new EshopEntities()) { List <Customer> listcus = new List <Customer>(); listcus = db.Customers.Where(s => s.Address.Contains(address)).ToList(); return(listcus); } }
// GET: api/GetOrderByID/5 public HttpResponseMessage GetOrderByID(int id) { using (EshopEntities db = new EshopEntities()) { Order o = db.Orders.SingleOrDefault(x => x.OrderID == id); if (o != null) { return(Request.CreateResponse(HttpStatusCode.OK, o)); } else { return(null); } } }
// GET: api/GetAllOrders public HttpResponseMessage GetAllOrders() { using (EshopEntities db = new EshopEntities()) { var result = db.Orders.ToList(); if (result != null) { return(Request.CreateResponse(HttpStatusCode.OK, result.ToList())); } else { return(null); } } }
// GET: api/Product/5 public ProductDTO Get(int id) { using (EshopEntities db = new EshopEntities()) { Product c = db.Products.SingleOrDefault(x => x.ProductID == id); if (c != null) { return(new ProductDTO(c.ProductID, c.CategoryID, c.ProductName, c.UnitPrice, c.Quantity)); } else { return(null); } } }
// GET: api/Category/5 public CategoryDTO Get(int id) { using (EshopEntities db = new EshopEntities()) { Category c = db.Categories.SingleOrDefault(x => x.CategoryID == id); if (c != null) { return(new CategoryDTO(c.CategoryID, c.CategoryName, c.Description)); } else { return(null); } } }
// GET: api/GetCustomerByID/5 public HttpResponseMessage GetCustomerByID(int id) { using (EshopEntities db = new EshopEntities()) { Customer c = db.Customers.SingleOrDefault(x => x.CustomerID == id); if (c != null) { return(Request.CreateResponse(HttpStatusCode.OK, c)); } else { return(null); } } }
// POST: api/AddOrder public HttpResponseMessage AddOrder([FromBody] Order order) { try { using (EshopEntities db = new EshopEntities()) { db.Orders.Add(order); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// POST: api/Product public HttpResponseMessage Post([FromBody] Product value) { try { using (EshopEntities db = new EshopEntities()) { db.Products.Add(value); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// DELETE: api/DeleteOrder/5 public HttpResponseMessage DeleteOrder(int id) { try { using (EshopEntities db = new EshopEntities()) { Order o = db.Orders.SingleOrDefault(x => x.OrderID == id); db.Orders.Remove(o); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }