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