public HttpResponseMessage PutDecreaseCartItembyProidAndUserid(int proID, int userID, int state) { try { using (STUDY_SHOPEntities dbContext = new STUDY_SHOPEntities()) { var entity = dbContext.CartItems.FirstOrDefault(e => e.Cart.UserId == userID && e.ProId == proID && e.Cart.IsPaid == state); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Không thể tim thấy cartitem với id = " + proID.ToString())); } else { if (entity.Quantity > 1) { entity.Quantity = entity.Quantity - 1; dbContext.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateResponse(HttpStatusCode.Conflict, entity)); } } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.ToString())); } }
public IEnumerable <testAPIDataAccess.returnListCartOfUser_Result> getListCartOfUser(int userID, int isPaid) { using (STUDY_SHOPEntities entity = new STUDY_SHOPEntities()) { return(entity.returnListCartOfUser(userID, isPaid).ToList()); } }
public HttpResponseMessage Put(int id, [FromBody] Product product) { try { using (STUDY_SHOPEntities dbContext = new STUDY_SHOPEntities()) { var entity = dbContext.Products.FirstOrDefault(e => e.Id == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Không thể tim thấy product với id = " + id.ToString())); } else { entity.Name = product.Name; entity.Price = product.Price; entity.Discount = product.Discount; entity.CateId = product.CateId; entity.Description = product.Description; entity.Information = product.Information; entity.Image = product.Image; dbContext.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.ToString())); } }
public List <CartItem> getCartitemByCart(int cartID) { using (STUDY_SHOPEntities entity = new STUDY_SHOPEntities()) { return(entity.CartItems.Where(x => x.Cart.Id == cartID).ToList()); } }
public IEnumerable <User> getAllUser() { using (STUDY_SHOPEntities entity = new STUDY_SHOPEntities()) { return(entity.Users.ToList()); } }
public List <Cart> getAllProductOfUserCartAndisPaid(int userID2, int ispaid) { using (STUDY_SHOPEntities entity = new STUDY_SHOPEntities()) { return(entity.Carts.Where(x => x.UserId == userID2 && x.IsPaid == ispaid).ToList()); } }
public IEnumerable <Product> get8ProductByIdCategoryAndPage(int idCategory, int page) { STUDY_SHOPEntities db = new STUDY_SHOPEntities(); List <Product> Listprore = db.Products.Where(x => x.Category.CateId == idCategory).OrderByDescending(x => x.Id).ToList(); List <Product> Listkqre = new List <Product>(); int i = 0; foreach (Product k in Listprore) { if ((page - 1) * 8 <= i && page * 8 > i) { Product p = new Product(); p.Id = k.Id; p.Name = k.Name; p.Price = k.Price; p.Discount = k.Discount; p.CateId = k.CateId; p.Description = k.Description; p.Information = k.Information; p.Image = k.Image; Listkqre.Add(p); } i++; } return(Listkqre.ToList()); }
public IEnumerable <Cart> getAllProductUserCartd(int userID3) { using (STUDY_SHOPEntities entity = new STUDY_SHOPEntities()) { return(entity.Carts.Where(x => x.UserId == userID3).ToList()); } }
public int getAmountOfProductUserCart(int userID) { using (STUDY_SHOPEntities entity = new STUDY_SHOPEntities()) { return(entity.Carts.Where(x => x.UserId == userID).Count()); } }
public IEnumerable <Cart> getCartByCartID(int cartID) { using (STUDY_SHOPEntities entity = new STUDY_SHOPEntities()) { return(entity.Carts.Where(x => x.Id == cartID).ToList()); } }
public int getSoluongOfProductUserCartAndIsPaid(int userID1, int isPaid) { using (STUDY_SHOPEntities entity = new STUDY_SHOPEntities()) { return(entity.Carts.Where(x => x.UserId == userID1 && x.IsPaid == isPaid).Count()); } }
public IEnumerable <Cart> getAllCart() { using (STUDY_SHOPEntities entity = new STUDY_SHOPEntities()) { return(entity.Carts.ToList()); } }
public IEnumerable <Product> getNewestProduct(int amount) { STUDY_SHOPEntities db = new STUDY_SHOPEntities(); List <Product> Listprore = db.Products.OrderByDescending(x => x.Id).ToList(); List <Product> Listkqre = new List <Product>(); int i = 0; foreach (Product k in Listprore) { Product p = new Product(); p.Id = k.Id; p.Name = k.Name; p.Price = k.Price; p.Discount = k.Discount; p.CateId = k.CateId; p.Description = k.Description; p.Information = k.Information; p.Image = k.Image; Listkqre.Add(p); i++; if (i == amount) { return(Listkqre.ToList()); } } return(Listkqre.ToList()); }
public IEnumerable <testAPIDataAccess.returnAllProducts_Result> getAllProduct() { using (STUDY_SHOPEntities entity = new STUDY_SHOPEntities()) { return(entity.returnAllProducts().ToList()); } }
public void Post([FromBody] Product product) { using (STUDY_SHOPEntities dbContext = new STUDY_SHOPEntities()) { dbContext.Products.Add(product); dbContext.SaveChanges(); } }
public void Post([FromBody] User user) { using (STUDY_SHOPEntities dbContext = new STUDY_SHOPEntities()) { dbContext.Users.Add(user); dbContext.SaveChanges(); } }
public void Post([FromBody] CartItem cartItem) { using (STUDY_SHOPEntities dbContext = new STUDY_SHOPEntities()) { dbContext.CartItems.Add(cartItem); dbContext.SaveChanges(); } }
public int getAmountProductByIdCategory(int idTypeCategory) { STUDY_SHOPEntities db = new STUDY_SHOPEntities(); List <Product> Listprore = db.Products.Where(x => x.CateId == idTypeCategory).ToList(); List <Product> Listkqre = new List <Product>(); int temp = 0; foreach (Product k in Listprore) { temp++; } return(temp); }
public IHttpActionResult getProductById(int id) { using (STUDY_SHOPEntities dbContext = new STUDY_SHOPEntities()) { var entity = dbContext.Products.FirstOrDefault(e => e.Id == id); if (entity != null) { return(Ok(entity)); } else { return(NotFound()); } } }
public IEnumerable <Category> getAllCategory() { STUDY_SHOPEntities db = new STUDY_SHOPEntities(); List <Category> Listprore = db.Categories.Where(x => x.CateId != 0).ToList(); List <Category> Listkqre = new List <Category>(); foreach (Category k in Listprore) { Category c = new Category(); c.CateId = k.CateId; c.CateImage = k.CateImage; c.CateName = k.CateName; Listkqre.Add(c); } return(Listkqre.ToList()); }
public IEnumerable <Product> getAllProductByIdCategory(int idType) { STUDY_SHOPEntities db = new STUDY_SHOPEntities(); List <Product> Listprore = db.Products.Where(x => x.CateId == idType).ToList(); List <Product> Listkqre = new List <Product>(); foreach (Product k in Listprore) { Product p = new Product(); p.Id = k.Id; p.Name = k.Name; p.Price = k.Price; p.Discount = k.Discount; p.CateId = k.CateId; p.Description = k.Description; p.Information = k.Information; p.Image = k.Image; Listkqre.Add(p); } return(Listkqre.ToList()); }
public HttpResponseMessage getUserByEmail(String email) { try { using (STUDY_SHOPEntities dbContext = new STUDY_SHOPEntities()) { var entity = dbContext.Users.FirstOrDefault(e => e.Email == email); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Không thể tim thấy user với email = " + email.ToString())); } else { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.ToString())); } }
public int getAmountOfPageCategory(int idCategory) { using (STUDY_SHOPEntities entity = new STUDY_SHOPEntities()) { int temp = entity.Products.Where(x => x.Category.CateId == idCategory).Count(); if (temp == 0) { return(0); } if (temp < 9) { return(1); } else if (temp % 8 == 0) { return(temp / 8); } else { return(temp / 8 + 1); } } }
public HttpResponseMessage DeleteByCartitemID(int idCartitem) { try { using (STUDY_SHOPEntities dbContext = new STUDY_SHOPEntities()) { var entity = dbContext.CartItems.FirstOrDefault(e => e.CartId == idCartitem); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Không thể tim thấy cartitem với id = " + idCartitem.ToString())); } else { dbContext.CartItems.Remove(entity); dbContext.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "Xóa thành công!")); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.ToString())); } }
public HttpResponseMessage PutIncreaseCartItem(int idCartItem) { try { using (STUDY_SHOPEntities dbContext = new STUDY_SHOPEntities()) { var entity = dbContext.CartItems.FirstOrDefault(e => e.Id == idCartItem); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Không thể tim thấy cartitem với id = " + idCartItem.ToString())); } else { entity.Quantity = entity.Quantity + 1; dbContext.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.ToString())); } }