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