コード例 #1
0
        /// <summary>
        /// Deletes given book from database.
        /// </summary>
        /// <param name="book">Book to be deleted</param>
        public void DeleteBook(Book book)
        {
            var db    = new LibraryDBEntities();
            var query = db.Book.Where(p => p.BookId.Equals(book.BookId)).FirstOrDefault();

            db.Book.Remove(query);
            db.SaveChanges();
        }
コード例 #2
0
        /// <summary>
        /// Assignes user to given book.
        /// </summary>
        /// <param name="user">user who loans a book</param>
        /// <param name="book">book to be loaned</param>
        public void setBookHolder(User user, Book book)
        {
            var db    = new LibraryDBEntities();
            var query = db.Book.Where(p => p.BookId.Equals(book.BookId)).First();

            query.User = user;
            db.SaveChanges();
        }
コード例 #3
0
        /// <summary>
        /// Makes a query to database to update given book's User and DueDate. Meaning that book is loaned out to given user by username for given timespan.
        /// </summary>
        /// <param name="book">Book to be updated</param>
        /// <param name="username">User's username who will loan given book</param>
        /// <param name="loanTime">Due date is calculated by DateTime.Now + loanTime</param>
        public void LoanBook(Book book, string username, TimeSpan loanTime)
        {
            var db    = new LibraryDBEntities();
            var query = db.Book.Where(p => p.BookId.Equals(book.BookId)).First();

            query.User    = db.User.Where(p => p.Username.Equals(username)).First();
            query.DueDate = DateTime.Now + loanTime;
            db.SaveChanges();
        }
コード例 #4
0
        /// <summary>
        /// Updates given book's User(holder) to null and DueDate to null. Meaning that User has returned that book.
        /// </summary>
        /// <param name="book">Book whose user is to be assigned to null</param>
        public void ReturnBook(Book book)
        {
            var db    = new LibraryDBEntities();
            var query = db.Book.Where(p => p.BookId.Equals(book.BookId)).First();

            query.BookHolderId = null;
            query.DueDate      = null;
            db.SaveChanges();
        }
コード例 #5
0
        /// <summary>
        /// Makes a query to database to update book's title. All books that have same title and author are updated.
        /// </summary>
        /// <param name="title">New title</param>
        /// <param name="book">Book to be updated</param>
        public void setBookTitle(string title, Book book)
        {
            var db    = new LibraryDBEntities();
            var query = db.Book.Where(p => p.BookTitle.Equals(book.BookTitle) && p.BookAuthorId.Equals(book.BookAuthorId)).Select(p => (Book)p);

            foreach (var _book in query)
            {
                _book.BookTitle = title;
            }
            db.SaveChanges();
        }
コード例 #6
0
        /// <summary>
        /// Adds author to database.
        /// </summary>
        /// <param name="author">Author to be added to database</param>
        public void setAuthor(Author author)
        {
            var db = new LibraryDBEntities();

            using (db)
            {
                var query = db.Author.Where(p => p.AuthorId.Equals(author.AuthorId)).FirstOrDefault();

                query.AuthorId        = author.AuthorId;
                query.AuthorFirstName = author.AuthorFirstName;
                query.AuthorLastName  = author.AuthorLastName;

                db.SaveChanges();
            }
        }
コード例 #7
0
 /// <summary>
 /// Makes a query to database to check if given book is over due.
 /// </summary>
 /// <param name="book">Book to be checked</param>
 /// <returns>True if book is over due</returns>
 public bool IsDue(Book book)
 {
     if (book != null)
     {
         var db    = new LibraryDBEntities();
         var query = db.Book.Where(p => p.BookId.Equals(book.BookId)).First();
         if (query.DueDate < DateTime.Now)
         {
             return(true);
         }
         else
         {
             return(false);
         }
     }
     else
     {
         return(false);
     }
 }
コード例 #8
0
        /// <summary>
        /// Adds given book to database. If book.Author's first name and last name are not found in database then new author is created.
        /// </summary>
        /// <param name="book">Book to be added to database</param>
        public void AddBook(Book book)
        {
            var  db      = new LibraryDBEntities();
            Book newBook = new Book()
            {
                BookTitle = book.BookTitle,
            };
            var author = db.Author.Where(p => p.AuthorFirstName.Equals(book.Author.AuthorFirstName) && p.AuthorLastName.Equals(book.Author.AuthorLastName)).FirstOrDefault();

            if (author == null)
            {
                newBook.Author = book.Author;
                db.Book.Add(newBook);
            }
            else
            {
                newBook.Author = author;
                db.Book.Add(newBook);
            }
            db.SaveChanges();
        }
コード例 #9
0
        /// <summary>
        /// Makes a query to database. Retrives FirstOrDefault() instance of book based on id.
        /// </summary>
        /// <param name="id">Id used to search a book</param>
        /// <returns>Book if found, otherwise null</returns>
        public Book getBookById(int id)
        {
            var query = new LibraryDBEntities().Book.Where(p => p.BookId.Equals(id)).FirstOrDefault();

            return(query);
        }
コード例 #10
0
        /// <summary>
        /// Checks if username is unique.
        /// </summary>
        /// <param name="username">username to be checked</param>
        /// <returns>True if username is unique</returns>
        public bool ValidateUsername(string username)
        {
            var query = new LibraryDBEntities().User.Where(p => p.Username.Equals(username)).FirstOrDefault();

            return(query == null ? true : false);
        }
コード例 #11
0
        /// <summary>
        /// Validates username and password for authentication.
        /// </summary>
        /// <param name="username">Username is used to search user from database</param>
        /// <param name="hashedPassword">HashedPassword is used to compare password from database</param>
        /// <returns>True if passwords match</returns>
        public bool ValidatePassword(string username, string hashedPassword)
        {
            var query = new LibraryDBEntities().User.Where(p => p.Username.Equals(username)).FirstOrDefault();

            return(query == null ? false : query.Password.Equals(hashedPassword) ? true : false);
        }
コード例 #12
0
        /// <summary>
        /// Makes a query to database to retrive all books in database.
        /// </summary>
        /// <returns>ICollection of Books</returns>
        public ICollection <Book> getBooks()
        {
            var query = new LibraryDBEntities().Book.Select(p => p as Book);

            return(query.ToList());
        }