public IHttpActionResult PutCustomer(int id, Customer customer) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != customer.CustomerId) { return(BadRequest()); } db.Entry(customer).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CustomerExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutItem(int id, Item item) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != item.ItemId) { return(BadRequest()); } db.Entry(item).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ItemExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PostOrder(Order order) { try { //Order table if (order.OrderId == 0) { db.Order.Add(order); } else { //db.Order.Attach(order); db.Entry(order).State = EntityState.Modified; } //OrderItems table foreach (var item in order.OrderItems) { if (item.OrderItemId == 0) { db.OrderItems.Add(item); } else { db.Entry(item).State = EntityState.Modified; } } //Delete for OrderItems if (order.DeletedOrderItemIds != null) { foreach (var id in order.DeletedOrderItemIds.Split(',').Where(x => x != "")) { OrderItems x = db.OrderItems.Find(Convert.ToInt64(id)); db.OrderItems.Remove(x); } } db.SaveChanges(); return(Ok()); } catch (Exception ex) { throw ex; } }
public IHttpActionResult UpdateQty(int ID, int Qty) { var user_id = User.Identity.GetUserId(); var DB = new AngularDemoEntities(); try { var Cart_item = DB.Cart_Master.Where(x => x.CartID == ID).FirstOrDefault(); if (Cart_item != null) { var Product = DB.Product_Master.Where(x => x.ProductID == Cart_item.ProductID).FirstOrDefault(); if (Qty < Product.ProductQuantity) { if (Qty <= Product.ProductQuantity && Qty >= Cart_item.ProductQuantity) { Product.ProductQuantity -= Math.Abs(Qty); Cart_item.ProductQuantity += Math.Abs(Qty); DB.SaveChanges(); return(Ok("success")); } else { Product.ProductQuantity -= Qty; Cart_item.ProductQuantity += Qty; DB.SaveChanges(); return(Ok("success")); } } else { return(Ok("OutOfStock")); } } else { return(NotFound()); } } catch (Exception ex) { throw ex.InnerException; } }
public IHttpActionResult Checkout(Order_Master O) { var DB = new AngularDemoEntities(); try { var user_id = User.Identity.GetUserId(); O.OrderDate = DateTime.Now; O.DeliveryDate = DateTime.Now.AddDays(5); O.UserID = user_id; DB.Order_Master.Add(O); DB.SaveChanges(); int InsertedOrderID = O.OrderID; List <Cart_Master> C = DB.Cart_Master.Where(x => x.UserID == user_id).ToList(); if (C.Count > 0) { foreach (var i in C) { OrderItems_Master OI = new OrderItems_Master { OrderID = InsertedOrderID, ProductID = Convert.ToInt32(i.ProductID), Quantity = Convert.ToDecimal(i.ProductQuantity), UserID = i.UserID, UnitPrice = Convert.ToDecimal(i.Product_Master.ProductPrice) }; DB.OrderItems_Master.Add(OI); DB.Cart_Master.Remove(i); DB.SaveChanges(); } return(Ok("success")); } else { return(Ok("Some problem")); } } catch (Exception ex) { throw ex.InnerException; } }
public IHttpActionResult DeleteProduct(int P_ID) { try { var DB = new AngularDemoEntities(); var Product = DB.Product_Master.Where(x => x.ProductID == P_ID).FirstOrDefault(); if (Product != null) { DB.Product_Master.Remove(Product); DB.SaveChanges(); return(Ok("success")); } else { return(Ok("Record not found")); } } catch (Exception ex) { throw ex.InnerException; } }
public IHttpActionResult AddProfile(Profile P) { var DB = new AngularDemoEntities(); try { if (P != null) { byte[] ImageFile = null; if (!string.IsNullOrEmpty(P.ProfilePicture)) { ImageFile = Convert.FromBase64String(P.ProfilePicture.Split(',')[1]); } var user_id = User.Identity.GetUserId(); UserProfile_Master UP = new UserProfile_Master { UserID = user_id, FirstName = P.FirstName, City = P.City, Gender = P.Gender, LastName = P.LastName, Mobile = P.Mobile, ProfilePicture = ImageFile, State = P.State }; DB.UserProfile_Master.Add(UP); DB.SaveChanges(); return(Ok("success")); } else { return(NotFound()); } } catch (Exception ex) { throw ex.InnerException; } }
public IHttpActionResult AddToCart(Cart_Master C) { var DB = new AngularDemoEntities(); try { if (C != null) { var user_id = User.Identity.GetUserId(); bool IsThere = DB.Cart_Master.Any(x => x.ProductID == C.ProductID && x.UserID == user_id); if (!IsThere) { C.UserID = User.Identity.GetUserId(); DB.Cart_Master.Add(C); var Products = DB.Product_Master.Where(x => x.ProductID == C.ProductID).SingleOrDefault(); if (Products != null) { Products.ProductQuantity--; } DB.SaveChanges(); return(Ok("success")); } else { return(Ok("already")); } } else { return(NotFound()); } } catch (Exception ex) { throw ex.InnerException; } }
public IHttpActionResult AddProduct(Products P) { var DB = new AngularDemoEntities(); try { if (P != null) { byte[] ImageFile = null; if (!string.IsNullOrEmpty(P.ProductImage)) { ImageFile = Convert.FromBase64String(P.ProductImage.Split(',')[1]); } Product_Master Obj_P = new Product_Master { CategoryID = P.CategoryID, InStock = P.InStock, ProductImage = ImageFile, ProductName = P.ProductName, ProductPrice = P.ProductPrice, ProductQuantity = P.ProductQuantity, ProductDescription = P.ProductDescription }; DB.Product_Master.Add(Obj_P); DB.SaveChanges(); return(Ok("success")); } else { return(NotFound()); } } catch (Exception ex) { throw ex.InnerException; } }
public IHttpActionResult RemoveCartItem(int ID) { var user_id = User.Identity.GetUserId(); var DB = new AngularDemoEntities(); try { var Cart_item = DB.Cart_Master.Where(x => x.CartID == ID).FirstOrDefault(); if (Cart_item != null) { DB.Cart_Master.Remove(Cart_item); DB.SaveChanges(); return(Ok("success")); } else { return(NotFound()); } } catch (Exception ex) { throw ex.InnerException; } }