public List <Book> getAll()
{
using (BookshopEntities bs = new BookshopEntities())
{
return(bs.Books.ToList());
}
}
public Order getOrder(int orderID)
{
using (BookshopEntities bs = new BookshopEntities())
{
return(bs.Orders.SingleOrDefault(o => o.OrderID == orderID));
}
}
public List <OrderDetail> getOrderDetails(int orderID)
{
using (BookshopEntities bs = new BookshopEntities())
{
return(bs.OrderDetails.Where(o => o.OrderID == orderID).ToList());
}
}
public int getCount()
{
using (BookshopEntities bs = new BookshopEntities())
{
return(bs.Books.Count());
}
}
public Order getPendingOrder(string username)
{
using (BookshopEntities bs = new BookshopEntities())
{
return(bs.Orders.SingleOrDefault(o => o.UserName == username && o.Status == "PENDING"));
}
}
public List <Order> getCompletedOrders(string username)
{
using (BookshopEntities bs = new BookshopEntities())
{
return(bs.Orders.Where(o => o.UserName == username && o.Status == "PENDING").ToList());
}
}
public List <Order> getAllOrders()
{
using (BookshopEntities bs = new BookshopEntities())
{
return(bs.Orders.OrderByDescending(o => o.OrderID).ToList());
}
}
public List <Order> getOrders(string username)
{
using (BookshopEntities bs = new BookshopEntities())
{
return(bs.Orders.Where(o => o.UserName == username).OrderByDescending(o => o.OrderID).ToList());
}
}
public List <string> ListBooks()
{
using (BookshopEntities bs = new BookshopEntities())
{
return(bs.Books.Select <Book, String>(b => b.BookID.ToString()).ToList <String>());
}
}
public Book getBook(string isbn)
{
using (BookshopEntities bs = new BookshopEntities())
{
return(bs.Books.SingleOrDefault(b => b.ISBN == isbn));
}
}
public OrderDetail getOrderDetail(int orderID, int bookId)
{
using (BookshopEntities bs = new BookshopEntities())
{
return(bs.OrderDetails.SingleOrDefault(o => o.OrderID == orderID && o.BookID == bookId));
}
}
public List <Book> searchBookByCategory(int categoryID)
{
using (BookshopEntities bs = new BookshopEntities())
{
return(bs.Books.Where(b => b.CategoryID == categoryID).ToList());
}
}
public string getCategory(int catID)
{
using (BookshopEntities bs = new BookshopEntities())
{
return(bs.Categories.Where(c => c.CategoryID == catID).First().Name.ToString());
}
}
public Book getBook(int bookID)
{
using (BookshopEntities bs = new BookshopEntities())
{
return(bs.Books.SingleOrDefault(b => b.BookID == bookID));
}
}
public List <Category> getAllCategory()
{
using (BookshopEntities bs = new BookshopEntities())
{
return(bs.Categories.ToList());
}
}
public List <User> getAllUsers()
{
using (BookshopEntities bs = new BookshopEntities())
{
return(bs.Users.ToList());
}
}
public void updateOrderDetail(OrderDetail orderDetail)
{
using (BookshopEntities bs = new BookshopEntities())
{
bs.Entry(orderDetail).State = EntityState.Modified;
bs.SaveChanges();
}
}
public User GetUser(string userName, string password)
{
using (BookshopEntities bs = new BookshopEntities())
{
var user = bs.Users.SingleOrDefault(u => u.UserName == userName && u.Password == password);
return(user);
}
}
public void deleteOrder(Order order)
{
using (BookshopEntities bs = new BookshopEntities())
{
bs.Entry(order).State = EntityState.Deleted;
bs.SaveChanges();
}
}
public void addOrder(Order order)
{
using (BookshopEntities bs = new BookshopEntities())
{
bs.Orders.Add(order);
bs.SaveChanges();
}
}
public void addOrderDetail(OrderDetail orderDetail)
{
using (BookshopEntities bs = new BookshopEntities())
{
bs.OrderDetails.Add(orderDetail);
bs.SaveChanges();
}
}
public void AddUser(User user)
{
using (BookshopEntities bs = new BookshopEntities())
{
bs.Users.Add(user);
bs.SaveChanges();
}
}
public User GetUser(string userName)
{
using (BookshopEntities bs = new BookshopEntities())
{
var user = bs.Users.SingleOrDefault(u => u.UserName == userName);
return(user);
}
}
public void updateBook(Book book)
{
using (BookshopEntities bs = new BookshopEntities())
{
bs.Entry(book).State = EntityState.Modified;
bs.SaveChanges();
}
}
public List <Book> searchBook(string searchText, string type)
{
using (BookshopEntities bs = new BookshopEntities())
{
if (type == "Title")
{
return(bs.Books.Where(b => b.Title.ToUpper().Contains(searchText.Trim().ToUpper())).ToList());
}
if (type == "Author")
{
return(bs.Books.Where(b => b.Author.ToUpper().Contains(searchText.Trim().ToUpper())).ToList());
}
return(bs.Books.ToList());
}
}
public void deleteOrderDetail(OrderDetail orderDetail)
{
using (BookshopEntities bs = new BookshopEntities())
{
int orderId = orderDetail.OrderID;
bs.Entry(orderDetail).State = EntityState.Deleted;
bs.SaveChanges();
List <OrderDetail> orderDetails = getOrderDetails(orderId);
if (orderDetails.Count < 1)
{
deleteOrder(getOrder(orderId));
}
}
}
