// 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)); } }
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)); } }
//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)); } }
// 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 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)); } }
// 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)); } }
//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 Product Find(string id) { int intId = int.Parse(id); var product = new Product(); using (var context = new EShopEntities()) { product = context.Products.Where(p => p.Id == intId).First(); } return(product); }
//Find customer private Customer FinCustomer(int id) { try { eShop = new EShopEntities(); return(eShop.Customers.Find(id)); } catch (Exception ex) { throw new Exception(ex.Message); } }
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 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/Category public HttpResponseMessage Get() { try { eShop = new EShopEntities(); return(Request.CreateResponse(HttpStatusCode.OK, eShop.Categories)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message)); } }
/// <summary> /// Return all images of specific product /// </summary> /// <param name="productId"></param> /// <returns></returns> public ProductImage GetImages(int productId) { var images = new ProductImage(); using (var context = new EShopEntities()) { images = (from p in context.Products where p.Id == productId select p.ProductImage).First(); } return(images); }
private OrderDetail FindOrderDeatail(int orderID, int productID) { try { eShop = new EShopEntities(); return(eShop.OrderDetails.SingleOrDefault(dt => dt.OrderID == orderID && dt.ProductID == productID)); } catch (Exception ex) { throw new Exception(ex.Message); } }
private List <OrderDetail> getDetails(int idOrder) { try { eShop = new EShopEntities(); return(eShop.OrderDetails.Where(dt => dt.OrderID == idOrder).ToList()); } catch (Exception ex) { throw new Exception(ex.Message); } }
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(); } }
public User Find(string id) { User user; using (var context = new EShopEntities()) { //Searching for user with same id user = context.Users.FirstOrDefault(u => u.Id == id); } //Do not return password user.Password = string.Empty; return(user); }
private Order FindOrder(int id) { try { eShop = new EShopEntities(); Order order = eShop.Orders.Find(id); return(order); } catch (Exception ex) { throw new Exception(ex.Message); } }
//Search public HttpResponseMessage GetCustomerByAddress(string address) { try { eshopentities = new EShopEntities(); IQueryable <Customer> result = eshopentities.Customers.Where(cus => cus.Address.ToLower().IndexOf(address.ToLower()) >= 0); return(Request.CreateResponse(HttpStatusCode.OK, result)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message)); } }
private Category FindCategory(int categoryID) { try { eShop = new EShopEntities(); Category cate = eShop.Categories.Find(categoryID); return(cate); } catch (Exception ex) { throw new Exception(ex.Message); } }
// POST: api/Category public HttpResponseMessage Post([FromBody] Category category) { try { eShop = new EShopEntities(); eShop.Categories.Add(category); eShop.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created, eShop.Categories)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message)); } }
//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)); } }
// 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/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); } } }
// 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/Category public HttpResponseMessage Get() { using (EShopEntities db = new EShopEntities()) { var result = db.Categories.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); } } }
// 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)); } }
// 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)); } }
public static bool Login(string user, string pass) { using (EShopEntities db = new EShopEntities()) { var account = db.Accounts.SingleOrDefault(u => u.Username == user && u.Password == pass); if (account != null) { return(true); } else { return(false); } } }