public void CreateBooksCollection()
{
ListsViewModel listsViewModel = new ListsViewModel();
ObservableCollection <Book> books = listsViewModel.GetBooks();
Assert.AreEqual(books.Count, BookCRUD.countBooks());
}
public ActionResult UpdateBook(FormCollection collection)
{
Book newBook = new Book();
newBook.BookID = Int32.Parse(collection["BookID"]);
newBook.Title = collection["Title"];
newBook.Synopsis = collection["Synopsis"];
newBook.Publisher = collection["Publisher"];
newBook.Category = collection["Category"];
newBook.Price = Int32.Parse(collection["Price"]);
newBook.Stock = Int32.Parse(collection["Stock"]);
newBook.Discount = (double.Parse(collection["Discount"])) / 100;
newBook.SubStatus = Convert.ToBoolean(collection["SubStatus"]);
newBook.Authors = collection["Authors"].Split(',').ToList();
newBook.Genres = collection["Genres"].Split(',').ToList();
if (BookCRUD.UpdateBook(newBook))
{
return(Content("<script>alert('Book has been Updated Successfully.');window.location.href=document.referrer;</script>"));
}
else
{
return(Content("<script>alert('Book could not be Update.');window.location.href=document.referrer</script>"));
}
}
public ListsViewModel()
{
BorrowBookCommand = new DelegateCommand(BorrowBook);
BookAddCommand = new DelegateCommand(BookAdd);
CustomerAddCommand = new DelegateCommand(CustomerAdd);
CustomerSaveCommand = new DelegateCommand(CustomerSave);
BookSaveCommand = new DelegateCommand(BookSave);
BookViewCommand = new DelegateCommand(BookView);
BookDeleteCommand = new DelegateCommand(BookDelete);
BookEditCommand = new DelegateCommand(BookEdit);
CustomerViewCommand = new DelegateCommand(CustomerView);
CustomerDeleteCommand = new DelegateCommand(CustomerDelete);
CustomerEditCommand = new DelegateCommand(CustomerEdit);
ViewCommand = new DelegateCommand(ViewDetails);
ReturnBookCommand = new DelegateCommand(ReturnBook);
EditReturnDateCommand = new DelegateCommand(EditReturnDate);
b = GetBooks()[1];
int _id = CustomerCRUD.getMaxId() + 1;
customer = new Customer(_id, "name", 0);
int _id2 = BookCRUD.getMaxId() + 1;
book = new Book(_id2, "title", "author", "type", 0, DateTime.Today, 0);
}
public void GetBookInfoTest()
{
BorrowedBook b = new BorrowedBook(1);
Assert.AreEqual(b.BookInfo(), "\r\nTitle: " + BookCRUD.getTitle(1) + "\r\nAuthor: " + BookCRUD.getAuthor(1)
+ "\r\nType: " + BookCRUD.getType(1) + "\r\nPenalty Cost: " + BookCRUD.getPenaltyCost(1)
+ "\r\nReturn Date: " + BookCRUD.getReturnDate(1));
}
public void DeleteBookFromDatabase()
{
Books book = new Books()
{
id = 104, author = "Jane Austin", title = "Awesome book", type = "Classic", penaltyCost = 20, state = 1
};
Assert.IsTrue(BookCRUD.addBook(book.id, book.title, book.author, book.type, book.penaltyCost, DateTime.Today, (int)book.state));
Assert.IsTrue(BookCRUD.removeBook(book.id));
}
public Book(int _id)
{
BookId = _id;
Title = BookCRUD.getTitle(_id);
Author = BookCRUD.getAuthor(_id);
Type = BookCRUD.getType(_id);
PenaltyCost = BookCRUD.getPenaltyCost(_id);
ReturnDate = BookCRUD.getReturnDate(_id);
State = BookCRUD.getState(_id);
}
public ActionResult RemoveBook(int id)
{
if (BookCRUD.DeleteBook(id))
{
return(Content("<script>alert('Book Deleted Successfully.');window.location.href=document.referrer;</script>"));
}
else
{
return(Content("<script>alert('Book could not be found.');window.location.href=document.referrer</script>"));
}
}
public void CheckContentOfBooksCollection()
{
ListsViewModel listsViewModel = new ListsViewModel();
ObservableCollection <Book> books = listsViewModel.GetBooks();
for (int i = 0; i < books.Count; i++)
{
Assert.AreEqual(books[i].Title, BookCRUD.getTitle(books[i].BookId));
Assert.AreEqual(books[i].Author, BookCRUD.getAuthor(books[i].BookId));
}
}
public void UpdateBookPenaltyCost()
{
Books book = new Books()
{
id = 108, author = "Jane Austin", title = "Awesome book", type = "Classic", penaltyCost = 20, state = 1
};
Assert.IsTrue(BookCRUD.addBook(book.id, book.title, book.author, book.type, book.penaltyCost, DateTime.Today, (int)book.state));
Assert.IsTrue(BookCRUD.updatePenaltyCost(book.id, 10));
book = BookCRUD.getBook(book.id);
Assert.AreEqual(book.penaltyCost, 10);
}
public List <Book> GetBooks()
{
books = new List <Book>();
for (int i = 1; i <= BookCRUD.countBooks(); i++)
{
Book b = new Book(i);
if (b.State == 1)
{
books.Add(b);
}
}
return(books);
}
public ObservableCollection <Book> GetBooks()
{
books = new ObservableCollection <Book>();
for (int i = 1; i <= BookCRUD.getMaxId(); i++)
{
Book b = new Book(i);
if (b.State != -1)
{
books.Add(b);
}
}
return(books);
}
public void AddBookToDatabase()
{
Books book = new Books()
{
id = 103, author = "Jane Austin", title = "Awesome book", type = "Classic", penaltyCost = 20, state = 1
};
Assert.IsTrue(BookCRUD.addBook(book.id, book.title, book.author, book.type, book.penaltyCost, DateTime.Today, (int)book.state));
Assert.AreEqual(BookCRUD.getBook(book.id).penaltyCost, 20);
Assert.AreEqual(BookCRUD.getBook(book.id).author, "Jane Austin");
Assert.AreEqual(BookCRUD.getBook(book.id).title, "Awesome book");
Assert.AreEqual(BookCRUD.getBook(book.id).type, "Classic");
Assert.AreEqual(BookCRUD.getBook(book.id).state, 1);
}
public void BorrowBorrowedBookToCustomerWithMoney()
{
Books book = new Books()
{
id = 204, author = "Jane Austin", title = "Awesome book", type = "Classic", penaltyCost = 20, state = 0
};
Assert.IsTrue(BookCRUD.addBook(book.id, book.title, book.author, book.type, book.penaltyCost, DateTime.Today, (int)book.state));
Customers c = new Customers()
{
id = 204, name = "Paul", money = 100
};
Assert.IsTrue(CustomerCRUD.addCustomer(c.id, c.name, c.money));
Assert.IsFalse(BorrowedBookCRUD.borrowBook(104, c.id, book.id));
}
//Shopping Cart and User Order related methods
public ActionResult Cart()
{
List <Tuple <int, int, int> > items = (List <Tuple <int, int, int> >)Session["OrderItems"];
List <Book> BooksList = new List <Book>();
foreach (var tuple in items)
{
Book getBook = BookCRUD.GetBook(tuple.Item1);
getBook.Stock = tuple.Item2; //place item quanity in stock var only for display
if (getBook != null)
{
BooksList.Add(getBook);
}
}
return(View(BooksList));
}
public void BorrowExistingBookToCustomerWithMoney()
{
Books book = new Books()
{
id = 201, author = "Jane Austin", title = "Awesome book", type = "Classic", penaltyCost = 20, state = 1
};
Assert.IsTrue(BookCRUD.addBook(book.id, book.title, book.author, book.type, book.penaltyCost, DateTime.Today, (int)book.state));
Customers c = new Customers()
{
id = 201, name = "Paul", money = 100
};
Assert.IsTrue(CustomerCRUD.addCustomer(c.id, c.name, c.money));
Assert.IsTrue(BorrowedBookCRUD.borrowBook(101, c.id, book.id));
Assert.AreEqual(BookCRUD.getBook(book.id).returnDate, DateTime.Today.AddDays(14));
Assert.AreEqual(BorrowedBookCRUD.getBorrowedBooks(book.id).customerId, c.id);
}
public ActionResult SearchBy(FormCollection collection)
{
string svalue = collection["searchString"];
string scat = collection["searchBy"];
switch (scat)
{
case "Title":
return(View("~/Views/User/Books.cshtml", BookCRUD.TitleSearch(svalue)));
case "Genre":
return(View("~/Views/User/Books.cshtml", BookCRUD.GenreSearch(svalue)));
case "Author":
return(View("~/Views/User/Books.cshtml", BookCRUD.AuthorSearch(svalue)));
case "Category":
return(View("~/Views/User/Books.cshtml", BookCRUD.CategorySearch(svalue)));
}
return(View("~/Views/User/Books.cshtml"));
}
private void BookSave()
{
int _id = BookCRUD.getMaxId() + 1;
BookCRUD.addBook(_id, this.Title, this.Author, this.Type, this.PenaltyCost, this.ReturnDate, this.State);
}
private void BookDelete()
{
BookCRUD.removeBook(this.BookId);
}
public string BookInfo()
{
return("\r\nTitle: " + BookCRUD.getTitle(BBookId) + "\r\nAuthor: " + BookCRUD.getAuthor(BBookId)
+ "\r\nType: " + BookCRUD.getType(BBookId) + "\r\nPenalty Cost: " + BookCRUD.getPenaltyCost(BBookId)
+ "\r\nReturn Date: " + BookCRUD.getReturnDate(BBookId));
}
public LibraryDB()
{
bookCrud = new BookCRUD();
authorCrud = new AuthorCRUD();
categoryCrud = new CategoryCRUD();
}
public ActionResult BookDetails(int id)
{
return(View(BookCRUD.GetBookReviews(id, 0)));
}
public ActionResult DashBoard()
{
//displaying books in best seller section and recommended section
return(View(new Tuple <List <Book>, List <Book> >(BookCRUD.BestSellers(), BookCRUD.UserRecommendations((int)Session["UserID"]))));
}
public ActionResult BookDetails(int id)
{
return(View(BookCRUD.GetBookReviews(id, (int)Session["UserID"])));
}
//Books related methods
public ActionResult Books()
{
return(View(BookCRUD.GetAllBooks()));
}
public ActionResult EditBook(int id)
{
Book mybook = BookCRUD.GetBook(id);
return(PartialView("_EditBook", mybook));
}
public Book(int _id)
{
Title = BookCRUD.getTitle(_id);
}
