public ActionResult Index()
{
BookShopEntities db = new BookShopEntities();
List<Book> cheapBooks = db.Books.OrderBy(b => b.Price).Take(3).ToList();
return View(cheapBooks);
}
public ActionResult Details(int id)
{
BookShopEntities db = new BookShopEntities();
var book = db.Books.First(b => b.Id == id);
ViewData.Model = book;
return View();
}
public void CleanDatabase()
{
var db = new BookShopEntities();
foreach (var lineItem in db.OrderLines)
{
db.DeleteObject(lineItem);
}
foreach (var order in db.Orders)
{
db.DeleteObject(order);
}
foreach (var book in db.Books)
{
db.DeleteObject(book);
}
db.SaveChanges();
}
public void GivenTheFollowingBooks(Table givenBooks)
{
var db = new BookShopEntities();
foreach (var row in givenBooks.Rows)
{
Book book = new Book { Author = row["Author"], Title = row["Title"] };
if (givenBooks.Header.Contains("Price"))
book.Price = Convert.ToDecimal(row["Price"]);
else
book.Price = _bookDefaultPrice;
if (givenBooks.Header.Contains("Id"))
_catalogContext.ReferenceBooks.Add(row["Id"], book);
else
_catalogContext.ReferenceBooks.Add(book.Title, book);
db.AddToBooks(book);
}
db.SaveChanges();
}
public ActionResult Search(string searchTerm)
{
BookShopEntities db = new BookShopEntities();
//List<Book> books = db.Books.Where(b => b.Title.Contains(searchTerm)).ToList();
var terms = searchTerm.Split(' ');
var predicate = PredicateBuilder.False<Book>();
foreach (string term in terms)
{
string temp = term;
predicate = predicate.Or(p => p.Title.Contains(temp));
}
List<Book> books = db.Books.AsExpandable().Where(predicate).ToList();
ViewData.Model = books;
return View("List");
}
public ActionResult Add(int bookId)
{
BookShopEntities db = new BookShopEntities();
var shoppingCart = GetShoppingCart();
var existingLine = shoppingCart.Lines.SingleOrDefault(l => l.Book.Id == bookId);
if (existingLine != null)
{
existingLine.Quantity++;
}
else
{
var book = db.Books.First(b => b.Id == bookId);
OrderLine newOrderLine = new OrderLine();
newOrderLine.Book = book;
newOrderLine.Quantity = 1;
shoppingCart.AddLineItem(newOrderLine);
}
ViewData.Model = shoppingCart;
return RedirectToAction("Index");
}
