public bool EditBook(int bookId, Book newBook)
{
var bookToEdit = database.books.Where((book) => book.Id == bookId).First();
if (bookToEdit == null)
{
return(false);
}
database.Entry(bookToEdit).CurrentValues.SetValues(DBToLibrary.LibraryToBook(newBook));
database.SaveChanges();
return(true);
}
public bool EditPerson(int oldPersonId, Person newPerson)
{
var personToEdit = database.users.Where((person) => person.Id == oldPersonId).First();
if (personToEdit == null)
{
return(false);
}
database.Entry(personToEdit).CurrentValues.SetValues(DBToLibrary.LibraryToUser(newPerson));
database.SaveChanges();
return(true);
}
public Person GetPersonByNameSurnamePassword(string name, string surname, string password)
{
var personByData = database.users.Where((person) => person.Name.Equals(name) && person.Surname.Equals(surname) && person.Password.Equals(password)).First();
return(DBToLibrary.UserToLibrary(personByData));
}
public Person GetPersonByID(int id)
{
var personById = database.users.Where((person) => person.Id == id).First();
return(DBToLibrary.UserToLibrary(personById));
}
public bool AddNewPerson(Person person)
{
database.users.Add(DBToLibrary.LibraryToUser(person));
database.SaveChanges();
return(true);
}
public List <Person> GetAllPersons()
{
var personsFromDB = database.users;
return(DBToLibrary.UserListToLibrary(personsFromDB.ToList <DatabaseWithEntity.users>()));
}
public List <Book> Find(string search)
{
var booksFound = database.books.Where((book) => book.Name.Contains(search) || book.Author.Contains(search));
return(DBToLibrary.BookListToLibrary(booksFound.ToList <DatabaseWithEntity.books>()));
}
public List <Book> GetReadersBooks(int readerId)
{
var readersBooks = database.books.Where((book) => book.IsTaken == true && book.UserId == readerId);
return(DBToLibrary.BookListToLibrary(readersBooks.ToList <DatabaseWithEntity.books>()));
}
public List <Book> GetAllBooks()
{
var booksFromDB = database.books;
return(DBToLibrary.BookListToLibrary(booksFromDB.ToList <DatabaseWithEntity.books>()));
}
public Book GetBookByIsbn(string isbn)
{
var bookByIsbn = database.books.Where((book) => book.Isbn == isbn).First();
return(DBToLibrary.BookToLibrary(bookByIsbn));
}
public Book GetBookByCode(string isbn, string code)
{
var bookByCode = database.books.Where((book) => book.Isbn == isbn && book.Code == code).First();
return(DBToLibrary.BookToLibrary(bookByCode));
}
public Book GetBookById(int id)
{
var bookById = database.books.Where((book) => book.Id == id).First();
return(DBToLibrary.BookToLibrary(bookById));
}
public bool AddNewBook(Book book)
{
database.books.Add(DBToLibrary.LibraryToBook(book));
database.SaveChanges();
return(true);
}