public ActionResult SearchBook(int id, string name, string author, string type, string genre)
{
using (var db = new LIBRARYEntities())
{
var books = new List <Book>();
var notBorrowed = db.Books.Where(x => x.IsBorrowed == false).ToList();
foreach (var book in notBorrowed)
{
if (((book.BookName.ToUpper().Contains(name.ToUpper())) || (name == "")) && ((book.BookAuthor.ToUpper().Contains(author.ToUpper())) || (author == "")) && ((book.BookType.ToUpper().Contains(type.ToUpper())) || (type == "")) && ((book.BookGenre.ToUpper().Contains(genre.ToUpper())) || (genre == "")))
{
books.Add(book);
}
}
if (books.Count == 0)
{
ViewBag.Message = "There is no book that match";
return(View(id));
}
else
{
var model = new Models.Readers.SearchedBooks
{
id = id,
SearchedBook = books
};
return(View("SearchBookResult", model));
}
}
}
public ActionResult DisplayBooks(int id)
{
using (var db = new LIBRARYEntities())
{
var notBorrowed = new List <Book>();
foreach (var book in db.Books)
{
if (book.IsBorrowed == false)
{
notBorrowed.Add(book);
}
}
if (notBorrowed.Count == 0)
{
ViewBag.Message = "No books to display";
}
var account = db.Accounts.Where(x => x.AccountID == id).Single();
var reader = db.Readers.Where(x => x.ReaderID == account.ReaderID).Single();
var model = new Models.Readers.SearchedBooks
{
id = id,
SearchedBook = notBorrowed,
Count = reader.NrOfBooks()
};
return(View(model));
}
}
public ActionResult DisplayBooks(int id, int code)
{
using (var db = new LIBRARYEntities())
{
try {
var account = db.Accounts.Where(x => x.AccountID == id).Single();
var reader = db.Readers.Where(x => x.ReaderID == account.ReaderID).Single();
var book = db.Books.Where(x => x.BookID == code).Single();
var bbook = new BorrowedBook
{
BookID = book.BookID,
ReaderID = reader.ReaderID,
BorrowedDate = DateTime.Now,
ExpectDate = DateTime.Now.AddMonths(1)
};
book.IsBorrowed = true;
db.BorrowedBooks.Add(bbook);
db.SaveChanges();
var notBorrowed = new List <Book>();
foreach (var item in db.Books)
{
if (item.IsBorrowed == false)
{
notBorrowed.Add(item);
}
}
if (notBorrowed.Count == 0)
{
ViewBag.Message = "No books to display";
}
var model = new Models.Readers.SearchedBooks
{
id = id,
SearchedBook = notBorrowed,
Count = reader.NrOfBooks()
};
return(View(model));
}
catch (Exception)
{
ViewBag.Message = "No account with the give id";
return(View("Login"));
}
}
}
