public ActionResult DeleteCartItem(int id) { if (Session["kullanici"] == null) { sessionClass.sessionValue = true; return(Json(sessionClass, JsonRequestBehavior.AllowGet)); } kullaniciID = Convert.ToInt32(Session["kullanici"]); sessionClass.sessionValue = false; //Book book = db.Books.Find(id); //ShoppingCart shoppingCart = (db.Customers.Where(x => x.ID == 1).FirstOrDefault()).ShoppingCart; //ICollection<Book> books = shoppingCart.Books; Book book = db.Books.Find(id); //books.Remove(book); //shoppingCart.Books = books; // ShoppingCart shoppingCart = (db.Customers.Where(x => x.ID == 1).FirstOrDefault()).ShoppingCart; ShoppingCartBook shoppingCartBook = db.ShoppingCartBooks.Where(x => x.ShoppingCart.Customer.ID == kullaniciID && x.BookID == book.ID).FirstOrDefault(); if (db.ShoppingCartBooks.Any(x => x.BookID == book.ID)) { db.ShoppingCartBooks.Remove(shoppingCartBook); } else { return(Json("başarısız")); } db.SaveChanges(); return(Json("başarılı")); }
public List <ShoppingCartBook> GetUsersShoppingCart(int UserID) { string query = "SELECT * FROM ShoppingCartBook where UserId == " + UserID; List <ShoppingCartBook> shoppingcart = new List <ShoppingCartBook>(); SQLiteCommand command = new SQLiteCommand(query, dbConnection); SQLiteDataReader rdr = command.ExecuteReader(); try { ShoppingCartBook s = new ShoppingCartBook(UserID); while (rdr.Read()) { s = new ShoppingCartBook(UserID); s.bookID = rdr.GetInt32(2); //s.Date = rdr.GetString(4); shoppingcart.Add(s); } } catch (Exception ex) { throw ex; } return(shoppingcart); }
public ActionResult AddCart(int id, int?quantity) { if (Session["kullanici"] == null) { sessionClass.sessionValue = true; return(Json(sessionClass, JsonRequestBehavior.AllowGet)); } kullaniciID = Convert.ToInt32(Session["kullanici"]); sessionClass.sessionValue = false; ShoppingCartBook shoppingCartBook; Book book = db.Books.Find(id); ShoppingCart shoppingCart = (db.Customers.Where(x => x.ID == kullaniciID).FirstOrDefault()).ShoppingCart; // List<ShoppingCartBook> shoppingCartBooks = db.ShoppingCartBooks.Where(x => x.ShoppingCart.Customer.ID == 1).ToList(); //shoppingCartBooks.Any(x => x.BookID == book.ID) if (db.ShoppingCartBooks.Any(x => x.ShoppingCart.ID == shoppingCart.ID && x.BookID == book.ID)) { shoppingCartBook = db.ShoppingCartBooks.Where(x => x.ShoppingCart.ID == shoppingCart.ID && x.BookID == book.ID).FirstOrDefault(); shoppingCartBook.ShoppingCart = shoppingCart; if (quantity == null) { shoppingCartBook.Quantity += 1; } else { shoppingCartBook.Quantity = (int)quantity; } } //if (shoppingCartBook.BookID==book.ID) //{ // shoppingCartBook.ShoppingCart = shoppingCart; // shoppingCartBook.Quantity += quantity; //} else { shoppingCartBook = new ShoppingCartBook(); shoppingCartBook.Book = book; shoppingCartBook.ShoppingCart = shoppingCart; if (quantity == null) { shoppingCartBook.Quantity = 1; } else { shoppingCartBook.Quantity = (int)quantity; } db.ShoppingCartBooks.Add(shoppingCartBook); } db.SaveChanges(); //ICollection<Book> books = (shoppingCart.ShoppingCartBook.FirstOrDefault()).; //shoppingCart.Customer=db.Customers.Find(1); //shoppingCart.Books= books; //shoppingCart.IsConfirmed = false; return(Json("başarılı")); }