public HttpResponseMessage EditOrder(int id, [FromBody] OrderDTO orderDTO) { try { eShop = new EShopEntities(); Order order = FindOrder(id); if (order != null) { order.OrderDate = orderDTO.OrderDate; order.ShipAddress = orderDTO.ShipAddress; eShop.SaveChanges(); foreach (OrderDetail od in orderDTO.Details) { OrderDetail item = FindOrderDeatail(order.OrderID, od.ProductID); item.Quantity = od.Quantity; item.Discount = od.Discount; eShop.SaveChanges(); } return(Request.CreateResponse(HttpStatusCode.Accepted, eShop.Orders)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message)); } }
public HttpResponseMessage AddOrder([FromBody] OrderDTO orderDTO) { try { eShop = new EShopEntities(); Order order = new Order(); order.OrderID = orderDTO.OrderID; order.CustomerID = orderDTO.CustomerID; order.OrderDate = orderDTO.OrderDate; order.ShipAddress = orderDTO.ShipAddress; eShop.Orders.Add(order); eShop.SaveChanges(); foreach (OrderDetail od in orderDTO.Details) { OrderDetail item = new OrderDetail(); item.OrderID = orderDTO.OrderID; item.ProductID = od.ProductID; item.Quantity = od.Quantity; item.Discount = od.Discount; eShop.OrderDetails.Add(item); eShop.SaveChanges(); } return(Request.CreateResponse(HttpStatusCode.Created, eShop.Orders)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// POST: api/Customer public HttpResponseMessage Post([FromBody] Customer customer) { try { Customer cus = eshopentities.Customers.Add(customer); eshopentities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created, cus)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// POST: api/Category public HttpResponseMessage Post([FromBody] Category category) { try { Category cate = eshopentities.Categories.Add(category); eshopentities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created, cate)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// POST: api/Product public HttpResponseMessage Post([FromBody] Product product) { try { Product pro = eshopentities.Products.Add(product); eshopentities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created, pro)); } catch (Exception ex) { return(Request.CreateResponse(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)); } }
// 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/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)); } }
//Update customer public HttpResponseMessage EditCustomer(int id, [FromBody] Customer cus) { try { eShop = new EShopEntities(); Customer customer = FinCustomer(id); if (customer != null) { customer.Fullname = cus.Fullname; customer.Gender = cus.Gender; customer.Birthday = cus.Birthday; customer.Address = cus.Address; customer.Email = cus.Email; customer.PhoneNumber = cus.PhoneNumber; eShop.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Accepted, eShop.Customers)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message)); } }
//Remove product by id public void RemoveProduct(int productId) { using (var context = new EShopEntities()) { context.Products.Remove(context.Products.First(p => p.Id == productId)); context.SaveChanges(); } }
public void Update(User newUser) { //Replacing the plain password with the encrypted newUser.Password = hashing.EncryptPass(newUser.Password); using (var context = new EShopEntities()) { var user = context.Users.First(u => u.Id == newUser.Id); //Update row context.Entry(user).CurrentValues.SetValues(newUser); context.SaveChanges(); } }
public void AddProduct(Product product, byte[] image1, byte[] image2, byte[] image3) { product.ProductImage = new ProductImage(); product.ProductImage.Picture1 = image1; product.ProductImage.Picture2 = image2; product.ProductImage.Picture3 = image3; using (var context = new EShopEntities()) { context.Products.Add(product); context.SaveChanges(); } }
//Add Customer public HttpResponseMessage AddCustomer([FromBody] Customer cus) { try { eShop = new EShopEntities(); eShop.Customers.Add(cus); eShop.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created, eShop.Customers)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// POST: api/Category public HttpResponseMessage Post([FromBody] Category cate) { try { using (EShopEntities db = new EShopEntities()) { db.Categories.Add(cate); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
public void Save() { using (var trans = _context.Database.BeginTransaction()) { try { _context.SaveChanges(); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new Exception(ex.Message); } } }
// POST: api/AddCustomer public HttpResponseMessage AddCustomer([FromBody] Customer cus) { try { using (EShopEntities db = new EShopEntities()) { db.Customers.Add(cus); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// DELETE: api/Category/5 public HttpResponseMessage Delete(int id) { try { using (EShopEntities db = new EShopEntities()) { Category s = db.Categories.SingleOrDefault(x => x.CategoryID == id); db.Categories.Remove(s); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
public bool TryRegister(User user) { //Replacing the plain password with the encrypted user.Password = hashing.EncryptPass(user.Password); using (var context = new EShopEntities()) { var isExist = context.Users.Any(u => u.Id == user.Id); if (isExist) { return(false); } context.Users.Add(user); context.SaveChanges(); } return(true); }
// DELETE: api/Category/5 public HttpResponseMessage Delete(int id) { try { eShop = new EShopEntities(); Category cate = FindCategory(id); if (cate != null) { eShop.Categories.Remove(cate); eShop.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, eShop.Categories)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message)); } }
public HttpResponseMessage DeleteOrder(int id) { try { eShop = new EShopEntities(); Order order = FindOrder(id); if (order != null) { eShop.Orders.Remove(order); eShop.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, eShop.Orders)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// PUT: api/Category/5 public HttpResponseMessage Put(int id, [FromBody] Category category) { try { eShop = new EShopEntities(); Category cate = FindCategory(id); if (cate != null) { cate.CategoryName = category.CategoryName; cate.Description = category.Description; eShop.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Accepted, eShop.Categories)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message)); } }