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));
}
}
