public IEnumerable <Product> Get() { using (Store2DoorEntities entities = new Store2DoorEntities()) { return(entities.Products.ToList()); } }
public HttpResponseMessage Put(int id, [FromBody] Product product) { try { using (Store2DoorEntities entities = new Store2DoorEntities()) { var entity = entities.Products.FirstOrDefault(e => e.id == id); entities.ProductImages.FirstOrDefault(x => x.product_id == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Product with id " + id.ToString() + " not found to edit")); } else { entity.name = product.name; entity.price = product.price; entity.product_type = product.product_type; entity.quantity_type = product.quantity_type; entity.stock = product.stock; entity.ProductImage.image = product.ProductImage.image; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } }catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.ExpectationFailed, ex)); } }
public HttpResponseMessage Delete(int id) { try { using (Store2DoorEntities entities = new Store2DoorEntities()) { var carts = entities.Cart_Item.Where(c => c.product_id == id).Select(c => c).ToList(); if (carts.Count() == 0) { return(Request.CreateResponse(HttpStatusCode.NotFound, "This product is not present in cart")); } else { foreach (var x in carts) { entities.Cart_Item.Remove(x); } entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, carts)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Put(int id, [FromBody] CategoryImage category) { try { using (Store2DoorEntities entities = new Store2DoorEntities()) { var entity = entities.CategoryImages.FirstOrDefault(e => e.category_id == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Category image with id " + id.ToString() + " not found to edit")); } else { entity.images = category.images; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.OK, ex)); } }
public HttpResponseMessage Get(int id) { using (Store2DoorEntities entities = new Store2DoorEntities()) { var result = ( from o in entities.Orders join c in entities.Cart_Item on o.order_id equals c.order_id join p in entities.Products on c.product_id equals p.id where c.order_id == id && o.order_id == id select new { CartId = c.cart_id, productId = c.product_id, order_id = o.order_id, productName = p.name, productPrice = p.price, cartQuantity = c.quantity, }).ToList(); if (result != null) { return(Request.CreateResponse(HttpStatusCode.OK, result)); } else { return(Request.CreateResponse(HttpStatusCode.OK, "No cart items for this order")); } } }
public IEnumerable <CategoryImage> Get() { using (Store2DoorEntities entities = new Store2DoorEntities()) { return(entities.CategoryImages.ToList()); } }
public HttpResponseMessage Get() { using (Store2DoorEntities entities = new Store2DoorEntities()) { //recieving all orders var result = ( from u in entities.AspNetUsers join o in entities.Orders on u.Id equals o.user_id where o.status != "delivered" orderby o.date descending select new { // userId = u.Id, userPhoneNumber = u.PhoneNumber, userName = u.DisplayName, UserEmail = u.Email, TotalBill = o.total_bill, OrderStatus = o.status, order_id = o.order_id, orderDate = o.date, orderLocation = o.location }).ToList(); if (result != null) { return(Request.CreateResponse(HttpStatusCode.OK, result)); } else { return(Request.CreateResponse(HttpStatusCode.OK, "No pending orders")); } } }
public HttpResponseMessage Delete(int id) { try { using (Store2DoorEntities entities = new Store2DoorEntities()) { var entity = entities.Orders.FirstOrDefault(e => e.order_id == id); var cart = entities.Cart_Item.FirstOrDefault(x => x.order_id == id); if (cart == null) { if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Order with id " + id.ToString() + " not found to delete")); } else { entities.Orders.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } else { entities.Cart_Item.Remove(cart); entities.Orders.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Get() { using (Store2DoorEntities entities = new Store2DoorEntities()) { //recieving all carts var result = ( from p in entities.Products join c in entities.Cart_Item on p.id equals c.product_id select new { id = c.cart_id, productName = p.name, productPrice = p.price, productQuantity = c.quantity, }).ToList(); if (result != null) { return(Request.CreateResponse(HttpStatusCode.OK, result)); } else { return(Request.CreateResponse(HttpStatusCode.OK, "NO carts")); } } }
public HttpResponseMessage Delete(int id) { try { using (Store2DoorEntities entities = new Store2DoorEntities()) { var entity = entities.Products.FirstOrDefault(e => e.id == id); var cart = entities.Cart_Item.Where(x => x.product_id == id).Select(x => x).ToList(); var img = entities.ProductImages.FirstOrDefault(y => y.product_id == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Product with id " + id.ToString() + " not found to delete")); } else { if (cart.Count == 0) { if (img != null) { entities.ProductImages.Remove(img); entities.SaveChanges(); } entities.Products.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { foreach (var x in cart) { entities.Cart_Item.Remove(x); } if (img != null) { entities.ProductImages.Remove(img); entities.SaveChanges(); } entities.Products.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } }catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.ExpectationFailed, ex)); } }
public HttpResponseMessage Get(int id) { using (Store2DoorEntities entities = new Store2DoorEntities()) { var entity = entities.Products.Where(e => e.category_id == id).ToList(); if (entity.Count != 0) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Product with category " + id.ToString() + " not found")); } } }
public HttpResponseMessage Get(int id) { using (Store2DoorEntities entities = new Store2DoorEntities()) { var entity = entities.CategoryImages.FirstOrDefault(e => e.category_id == id); { if (entity != null) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Category image with id " + id.ToString() + " not found")); } } } }
public HttpResponseMessage Delete(int id) { try { using (Store2DoorEntities entities = new Store2DoorEntities()) { var entity = entities.ProductImages.FirstOrDefault(e => e.product_id == id); entities.ProductImages.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } }catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Post([FromBody] CategoryImage category) { try { using (Store2DoorEntities entities = new Store2DoorEntities()) { entities.CategoryImages.Add(category); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, category); message.Headers.Location = new Uri(Request.RequestUri + category.category_id.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Post([FromBody] Product product) { try { using (Store2DoorEntities entities = new Store2DoorEntities()) { entities.Products.Add(product); entities.ProductImages.Add(product.ProductImage); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, product); message.Headers.Location = new Uri(Request.RequestUri + product.id.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.ExpectationFailed, ex)); } }
public HttpResponseMessage Post([FromBody] Cart_Item[] cart) { try { using (Store2DoorEntities entities = new Store2DoorEntities()) { foreach (var x in cart) { entities.Cart_Item.Add(x); entities.SaveChanges(); } var message = Request.CreateResponse(HttpStatusCode.Created, cart); message.Headers.Location = new Uri(Request.RequestUri + cart.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage GetUserOrders(string id) { try { using (Store2DoorEntities entities = new Store2DoorEntities()) { var orders = entities.Orders.Where(o => o.user_id == id).ToList(); if (orders != null) { return(Request.CreateResponse(HttpStatusCode.OK, orders)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NoContent, "No orders")); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Get(int id) { using (Store2DoorEntities entities = new Store2DoorEntities()) { //recieving orders return(Request.CreateResponse(HttpStatusCode.OK, ( from u in entities.AspNetUsers join o in entities.Orders on u.Id equals o.user_id where o.order_id == id select new { // Userid = u.Id, UserName = u.DisplayName, UserEmail = u.Email, userPhone = u.PhoneNumber, TotalBill = o.total_bill, OrderStatus = o.status, order_id = o.order_id, orderLocation = o.location }).ToList())); } }
public HttpResponseMessage Put(int id, [FromBody] Category category) { try { using (Store2DoorEntities entities = new Store2DoorEntities()) { var entity = entities.Categories.FirstOrDefault(e => e.id == id); entities.CategoryImages.FirstOrDefault(e => e.category_id == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Category with id " + id.ToString() + " not found to edit")); } else { entity.category1 = category.category1; entity.CategoryImage.images = category.CategoryImage.images; //entity1.images= category.CategoryImage.images; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (System.Data.Entity.Core.UpdateException e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e)); } catch (System.Data.Entity.Infrastructure.DbUpdateException exc) //DbContext { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, exc)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Post([FromBody] Order order) { try { using (Store2DoorEntities entities = new Store2DoorEntities()) { Order n = new Order(); n.status = "pending"; n.total_bill = Convert.ToDecimal(order.total_bill); n.user_id = order.user_id; n.date = DateTime.Now.AddHours(5); n.location = order.location; entities.Orders.Add(n); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, n); message.Headers.Location = new Uri(Request.RequestUri + n.order_id.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Delete(int id) { try { using (Store2DoorEntities entities = new Store2DoorEntities()) { var entity = entities.Categories.FirstOrDefault(e => e.id == id); var products = entities.Products.Where(p => p.category_id == id).Select(c => c).ToList(); var cart = entities.Cart_Item.Where(crt => crt.Product.category_id == id).Select(crt => crt).ToList(); // var product = entities.Products.FirstOrDefault(x => x.category_id == id); var image = entities.CategoryImages.FirstOrDefault(y => y.category_id == id); // var cart = entities.Cart_Item.FirstOrDefault(z => z.product_id == product.id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Category with id " + id.ToString() + " not found to delete")); } else if (products.Count == 0) { entities.CategoryImages.Remove(image); entities.SaveChanges(); entities.Categories.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "Category Deleted")); } else if (cart.Count == 0) { foreach (var x in products) { var pimage = entities.ProductImages.FirstOrDefault(i => i.product_id == x.id); entities.ProductImages.Remove(pimage); entities.SaveChanges(); entities.Products.Remove(x); entities.SaveChanges(); } entities.CategoryImages.Remove(image); entities.SaveChanges(); entities.Categories.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { foreach (var x in cart) { entities.Cart_Item.Remove(x); } entities.SaveChanges(); foreach (var x in products) { var pimage = entities.ProductImages.FirstOrDefault(i => i.product_id == x.id); entities.ProductImages.Remove(pimage); entities.SaveChanges(); entities.Products.Remove(x); entities.SaveChanges(); } entities.CategoryImages.Remove(image); entities.SaveChanges(); entities.Categories.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }