/// <summary>
        /// Add Book
        /// </summary>
        /// <param name="books"></param>
        /// <returns></returns>
        public int AddBook(Books books)
        {
            tbl_Books tbl_books = new tbl_Books();

            using (IUnitOfWorks unitOfWorks = new UnitOfWorks())
                try
                {
                    tbl_books.Author      = books.Author;
                    tbl_books.AvailStatus = books.AvailStatus;
                    //tbl_books.BookId = books.BookId;
                    tbl_books.Category    = books.Category;
                    tbl_books.Description = books.Description;
                    tbl_books.ISBNNumber  = books.ISBNNumber;
                    tbl_books.Title       = books.Title;
                    tbl_books.Price       = books.Price;
                    tbl_books.Publisher   = books.Publisher;
                    tbl_books.AvailStatus = true;
                    unitOfWorks.BookRepository.Insert(tbl_books);
                    unitOfWorks.Save();
                    return(1);
                }

                catch (Exception ex)
                {
                    return(0);
                }
        }
        /// <summary>
        /// Update Book
        /// </summary>
        /// <param name="books"></param>
        /// <returns></returns>
        public int UpdateBook(Books books)
        {
            tbl_Books updateBook = new tbl_Books();

            using (IUnitOfWorks unitOfWorks = new UnitOfWorks())
                try
                {
                    updateBook.Author      = books.Author;
                    updateBook.AvailStatus = books.AvailStatus;
                    updateBook.Category    = books.Category;
                    updateBook.Description = books.Description;
                    updateBook.ISBNNumber  = books.Description;
                    updateBook.Title       = books.Title;
                    updateBook.Price       = books.Price;
                    updateBook.Publisher   = books.Publisher;
                    updateBook.BookId      = books.BookId;
                    unitOfWorks.BookRepository.Update(updateBook);
                    unitOfWorks.Save();
                    return(1);
                }
                catch (Exception ex)
                {
                    return(0);
                }
        }