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