public IHttpActionResult PutBook(int id, Book book)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != book.BookId)
{
return(BadRequest());
}
db.Entry(book).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!BookExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create([Bind(Include = "ISBN,Name,Author,Genre,Image,OnLoan")] Book book)
{
if (ModelState.IsValid)
{
db.Books.Add(book);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(book));
}
public ActionResult Create([Bind(Include = "Book_U,Title,Writer,Summary,Publisher,Published_data")] Book book)
{
if (ModelState.IsValid)
{
db.Books.Add(book);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(book));
}
public ActionResult Create([Bind(Include = "Id,Name")] Book book)
{
if (ModelState.IsValid)
{
db.Books.Add(book);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(book));
}
public ActionResult Create([Bind(Include = "MemberId,Name")] Member member)
{
if (ModelState.IsValid)
{
db.Members.Add(member);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(member));
}
public ActionResult CleanDb()
{
var books = _db.Books.ToList();
foreach (var book in books)
{
_db.Books.Remove(book);
_db.SaveChanges();
}
ViewBag.Message = "Baza danych została wyczyszczona!";
return(View());
}
public ActionResult AddBook(Book Book)
{
try
{
_db.Add(Book);
_db.SaveChanges();
ModelState.Clear();
ViewData["Message"] = "1";
}
catch
{
ViewData["Message"] = "0";
}
return(View("../index/addbook"));
}
/// <summary>
/// Take a book
/// </summary>
/// <param name="title">Book's title</param>
/// <returns></returns>
public Books TakeBook(string title)
{
// Take - user takes a book providing its title. Validation if book exists. Validation if book is
// still available(check number of copies). Book is added to the user's list and available
// book count is decreased.
using (var db = new LibraryDb())
{
// 1. Look for book inside table 'Books' by Title
var book = db.Books.FirstOrDefault(b => b.Title.ToLower() == title.ToLower());
// 2. If book is found and is still available:
if (book != null && book.Copies > 0)
{
// 2.1. Decrease available copies
book.Copies--;
// 2.2. Insert new record in table 'UserBooks'
db.UserBooks.Add(new UserBooks()
{
Author = book.Author,
Title = book.Title,
Year = book.Year,
});
db.SaveChanges();
return(book);
}
}
return(null);
}
public static void UpdateBook(BOOK book, LibraryDb dbContext = null)
{
using (LibraryDb db = LibraryDb.GetDbContext(dbContext))
{
using (TransactionScope transaction = new TransactionScope())
{
if (book == null)
{
throw new ArgumentNullException($"book: {nameof(book)}");
}
BOOK dbBook = db.BOOKS.SingleOrDefault(b => b.ID == book.ID);
if (dbBook == null)
{
throw new Exception($"Книга с {book.ID} не найдена!");
}
dbBook.ISBN = book.ISBN;
dbBook.NAME = book.NAME;
dbBook.AUTHOR = book.AUTHOR;
dbBook.PUBLISHING = book.PUBLISHING;
dbBook.COUNT = book.COUNT;
dbBook.STATUS = book.STATUS;
dbBook.PRICE = book.PRICE;
dbBook.DESCRIPTION = book.DESCRIPTION;
db.SaveChanges();
transaction.Complete();
}
}
}
public static void UpdateViewer(VIEWER viewer, LibraryDb dbContext = null)
{
using (LibraryDb db = LibraryDb.GetDbContext(dbContext))
{
using (TransactionScope transaction = new TransactionScope())
{
if (viewer == null)
{
throw new ArgumentNullException($"book: {nameof(viewer)}");
}
VIEWER dbViewer = db.VIEWERS.SingleOrDefault(v => v.ID == viewer.ID);
if (dbViewer == null)
{
throw new Exception($"Книга с {viewer.ID} не найдена!");
}
dbViewer.NAME = viewer.NAME;
dbViewer.SURNAME = viewer.SURNAME;
dbViewer.MIDDLE_NAME = viewer.MIDDLE_NAME;
dbViewer.ADDRESS = viewer.ADDRESS;
dbViewer.PHONE = viewer.PHONE;
dbViewer.EMAIL = viewer.EMAIL;
db.SaveChanges();
transaction.Complete();
}
}
}
/// <summary>
/// User returns a book
/// </summary>
/// <param name="title">Book's title</param>
/// <returns>Book returned (if found)</returns>
public UserBooks ReturnBook(string title)
{
// Return - user returns a book providing its title. Validation if the book is in the user’s list.
// Book is removed from the user’s list and the available count is increased.
// 1. Use the DB
// 2. Find the book in 'UserBooks' by title
// 3. If book is found:
// 3.1. Delete it from 'UserBooks'
// 3.2. Increase Copies count for the same book inside the 'Books' table
using (var db = new LibraryDb())
{
var userBook = db.UserBooks.FirstOrDefault(b => b.Title.ToLower() == title.ToLower());
if (userBook != null)
{
db.UserBooks.Remove(userBook);
// increase availabe count
var libraryBook = db.Books.FirstOrDefault(b => b.Title.ToLower() == title.ToLower());
libraryBook.Copies++;
db.SaveChanges();
return(userBook);
}
}
return(null);
}
public IActionResult Delete(Book book)
{
using (var db = new LibraryDb())
{
db.Books.Remove(book);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public static void AddNewCard(BOOK book, LibraryDb dbContext = null)
{
using (LibraryDb db = LibraryDb.GetDbContext(dbContext))
{
using (TransactionScope transaction = new TransactionScope())
{
db.BOOKS.Add(book);
db.SaveChanges();
transaction.Complete();
}
}
}
public static void AddNewViewer(VIEWER viewer, LibraryDb dbContext = null)
{
using (LibraryDb db = LibraryDb.GetDbContext(dbContext))
{
using (TransactionScope transaction = new TransactionScope())
{
db.VIEWERS.Add(viewer);
db.SaveChanges();
transaction.Complete();
}
}
}
public IActionResult Create(string title, string author, double price)
{
if (string.IsNullOrEmpty(title) || string.IsNullOrEmpty(author) || price < 1)
{
return(RedirectToAction("Index"));
}
using (var db = new LibraryDb())
{
Book book = new Book
{
Title = title,
Author = author,
Price = price
};
db.Books.Add(book);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public static void BooksRemove(decimal[] booksId, LibraryDb dbContext = null)
{
using (LibraryDb db = LibraryDb.GetDbContext(dbContext))
{
using (TransactionScope transaction = new TransactionScope())
{
foreach (decimal id in booksId)
{
BOOK book = db.BOOKS.SingleOrDefault(b => b.ID == id);
if (book != null)
{
db.BOOKS.Remove(book);
}
}
db.SaveChanges();
transaction.Complete();
}
}
}
public static void ViewersRemove(decimal[] idViewers, LibraryDb dbContext = null)
{
using (LibraryDb db = LibraryDb.GetDbContext(dbContext))
{
using (TransactionScope transaction = new TransactionScope())
{
foreach (decimal id in idViewers)
{
VIEWER viewer = db.VIEWERS.SingleOrDefault(b => b.ID == id);
if (viewer != null)
{
db.VIEWERS.Remove(viewer);
}
}
db.SaveChanges();
transaction.Complete();
}
}
}
public ActionResult ReturnBook(int id, Loan loan)
{
var loanQuery = from item in db.Loans
where item.LoanId == id
select item;
if (ModelState.IsValid)
{
var book = db.Loans.FirstOrDefault(s => s.LoanId == id);
if (book != null)
{
book.Book.OnLoan = 0;
//book.FinePrice = 0.00M;
db.Entry(book).State = EntityState.Modified;
db.Loans.Remove(book);
db.SaveChanges();
// return RedirectToAction("Index");
}
}
return(View());
// return View("Index");
}
public void Save()
{
_db.SaveChanges();
}
