public IEnumerable <Book> GetBookByUserID(int userID)
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
return(_context.Books.Include("Genre").Include("Language").Where(m => m.UserID == userID).ToList());
}
}
public IEnumerable <Book> GetOrderedBookBySellerID(int userID)
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
IList <Book> sellerBooks = _context.Books.Where(m => m.UserID == userID).ToList();
IList <Book> orderedSellerBooks = new List <Book>();
foreach (Book book in sellerBooks)
{
IList <CartBook> cartBooks = _context.CartBooks.Where(m => m.BookID == book.BookID).ToList();
foreach (CartBook cartBook in cartBooks)
{
IList <Order> orders = _context.Orders.Where(m => m.CartID == cartBook.CartID).ToList();
foreach (Order order in orders)
{
if (order.CartID == cartBook.CartID)
{
Book orderedBook = _context.Books.Include("Genre").Include("Language").Where(m => m.BookID == cartBook.BookID).SingleOrDefault();
orderedSellerBooks.Add(orderedBook);
}
}
}
}
if (orderedSellerBooks == null)
{
return(null);
}
return(orderedSellerBooks);
}
}
public string Add(Book book)
{
using (BookShoppeDBContext booksContext = new BookShoppeDBContext())
{
// Transaction Meathod Testing
using (DbContextTransaction dbTran = booksContext.Database.BeginTransaction())
{
try
{
if (book.UserID == 0)
{
return("User ID needed");
}
booksContext.Books.Add(book);
booksContext.SaveChanges();
dbTran.Commit();
}
catch (Exception)
{
dbTran.Rollback();
return(null);
}
}
}
return(null);
}
public IEnumerable <Book> GetBooksByLanguage(int id)
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
return(_context.Books.Include("Genre").Include("Language").Where(b => b.LanguageID == id).ToList());
}
}
public IEnumerable <Book> GetAllBooks()
{
using (BookShoppeDBContext booksContext = new BookShoppeDBContext())
{
return(booksContext.Books.Include("Genre").Include("Language").ToList());
}
}
public IEnumerable <Language> GetAllLanguages()
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
return(_context.Languages.ToList());
}
}
public IEnumerable <Book> GetUserCartDetails(int id)
{
List <Book> books = new List <Book>();
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
try
{
Cart cart = new Cart();
cart = GetCartNotInOrder(id);
if (cart != null)
{
int cartID = cart.CartID;
List <CartBook> cartBooks = _context.CartBooks.Where(cb => cb.CartID == cartID).ToList();
foreach (var item in cartBooks)
{
Book book = _context.Books.Where(ID => ID.BookID == item.BookID).SingleOrDefault();
books.Add(book);
}
return(books);
}
else
{
return(null);
}
}
catch (Exception)
{
return(null);
}
}
}
public Book GetBookDetails(int bookID)
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
return(_context.Books.Include("Genre").Where(ID => ID.BookID == bookID).SingleOrDefault());
}
}
public IEnumerable <Genre> GetAllGenres()
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
return(_context.Genres.ToList());
}
}
public Book GetBookByID(int bookID)
{
using (BookShoppeDBContext booksContext = new BookShoppeDBContext())
{
Book book = booksContext.Books.Include("Genre").Include("Language").SingleOrDefault(ID => ID.BookID == bookID);
return(book);
}
}
public User ValidateLogIn(string userName, string password)
{
User _user = null;
BookShoppeDBContext _Context = new BookShoppeDBContext();
_user = _Context.Users.Include("Role").Where(u => u.UserName == userName && u.Password == password).SingleOrDefault();
return(_user);
}
public string GetLanguageByLanguageID(int id)
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
Language language = _context.Languages.Where(l => l.LanguageID == id).SingleOrDefault();
return(language.LanguageName);
}
}
public string GetGenreByGenreID(int id)
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
Genre genre = _context.Genres.Where(ID => ID.GenreID == id).SingleOrDefault();
return(genre.GenreName);
}
}
public void Delete(int BookID)
{
using (BookShoppeDBContext bookContext = new BookShoppeDBContext())
{
Book book = bookContext.Books.Where(id => id.BookID == BookID).FirstOrDefault();
bookContext.Books.Remove(book);
bookContext.SaveChanges();
}
}
public void RemoveBookFormUserCart(int id)
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
CartBook cartBooks = _context.CartBooks.Where(cb => cb.BookID == id).SingleOrDefault();
_context.CartBooks.Remove(cartBooks);
_context.SaveChanges();
}
}
public string Edit(Book book)
{
using (BookShoppeDBContext booksContext = new BookShoppeDBContext())
{
booksContext.Entry(book).State = EntityState.Modified;
booksContext.SaveChanges();
return(null);
}
}
public void RemoveBookFormWishlist(int id)
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
WishList wishlist = _context.WishList.Where(w => w.BookID == id).SingleOrDefault();
_context.WishList.Remove(wishlist);
_context.SaveChanges();
}
}
public bool Delete(int id)
{
using (var Context = new BookShoppeDBContext())
{
User user = Context.Users.Where(ID => ID.UserID == id).FirstOrDefault();
Context.Users.Remove(user);
Context.SaveChanges();
return(true);
}
}
public string DeleteGenre(int id)
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
Genre genre = _context.Genres.Where(Id => Id.GenreID == id).FirstOrDefault();
_context.Genres.Remove(genre);
_context.SaveChanges();
return("Genre Removed Successfully");
}
}
public string DeleteLanguage(int id)
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
Language language = _context.Languages.Where(l => l.LanguageID == id).SingleOrDefault();
_context.Languages.Remove(language);
_context.SaveChanges();
return("Language Removed Successfully");
}
}
public string AddUser(User user)
{
BookShoppeDBContext _Context = new BookShoppeDBContext();
_Context.Users.Add(user);
_Context.SaveChanges();
return(null);
}
public bool CheckBookInWishList(int userID, int bookID)
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
WishList wishlist = _context.WishList.Where(ID => ID.UserID == userID && ID.BookID == bookID).SingleOrDefault();
if (wishlist == null)
{
return(false);
}
return(true);
}
}
public bool CheckCartInOrders(int id)
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
Cart cart = _context.Carts.Where(c => c.UserID == id).SingleOrDefault();
Order order = _context.Orders.Where(o => o.CartID == cart.CartID).Single();
if (order == null)
{
return(false); // Return false when the Cart is not in the orders
}
return(true); // Return true when the cart is available in the orders
}
}
public string AddToWishList(int userID, int bookID)
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
WishList wishlist = new WishList()
{
UserID = userID,
BookID = bookID
};
_context.WishList.Add(wishlist);
_context.SaveChanges();
return(null);
}
}
public int GetCartRate(int cartID)
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
int cartRate = 0;
List <CartBook> cartBooks = _context.CartBooks.Where(cb => cb.CartID == cartID).ToList();
foreach (var item in cartBooks)
{
Book book = _context.Books.Where(ID => ID.BookID == item.BookID).SingleOrDefault();
cartRate = cartRate + book.Price;
}
return(cartRate);
}
}
public IEnumerable <Book> GetUserWishlist(int id)
{
List <Book> books = new List <Book>();
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
List <WishList> wishlist = _context.WishList.Where(ID => ID.UserID == id).ToList();
foreach (var item in wishlist)
{
Book book = _context.Books.Where(ID => ID.BookID == item.BookID).SingleOrDefault();
books.Add(book);
}
return(books);
}
}
public string AddGenre(Genre genre)
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
_context.Genres.Add(genre);
try
{
_context.SaveChanges();
}
catch (DbUpdateException e)
{
return(e.Message);
}
return(null);
}
}
// Not Used In Function
private Cart CheckCartInOrder(int cartID)
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
Cart cart = _context.Carts.Where(c => c.UserID == cartID).SingleOrDefault();
Order order = _context.Orders.Where(o => o.CartID == cartID).SingleOrDefault();
if (order == null)
{
return(cart);
}
return(null);
}
}
public bool PlaceOrder(Shipment shipment)
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
Order order = new Order();
order.ShipmentID = shipment.ShipmentID;
Cart cart = _context.Carts.Where(c => c.UserID == shipment.UserID && c.IsOrdered == false).SingleOrDefault();
order.CartID = cart.CartID;
_context.Orders.Add(order);
cart.IsOrdered = true;
_context.SaveChanges();
return(true);
}
}
public string AddLanguage(Language language)
{
using (BookShoppeDBContext _context = new BookShoppeDBContext())
{
_context.Languages.Add(language);
try
{
_context.SaveChanges();
}
catch (Exception e)
{
return(e.Message);
}
return(null);
}
}