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); }