public ActionResult EditBook(Books books)
        {
            mBookDAL bookDAL = new mBookDAL();

            bookDAL.EditBookData(books);
            return(RedirectToAction("GetView"));
        }
        public ActionResult AddNew(Books books)
        {
            mBookDAL bookDAL = new mBookDAL();

            bookDAL.AddBook(books);
            return(RedirectToAction("GetView"));
        }
        public ActionResult DeleteBook()
        {
            int      PassBid  = Convert.ToInt32(Request.QueryString["id"]);
            mBookDAL mBookDAL = new mBookDAL();

            mBookDAL.DelBookDAL(PassBid);
            return(RedirectToAction("GetView"));
        }
        public List <Books> GetBooks()
        {
            mBookDAL mBook = new mBookDAL();

            // mBook.Database.Initialize(true);


            return(mBook.Book.ToList());
        }
        public ActionResult UpdateBook()
        {
            string   stringB  = Request.QueryString["id"];
            int      PassB    = Convert.ToInt32(stringB);
            mBookDAL mBookDAL = new mBookDAL();
            Books    books    = new Books();

            books = mBookDAL.DispBook(PassB);
            return(View("EditBookView", books));
        }
        public List <Books> Search(string SearchQuery)
        {
            mBookDAL mBook = new mBookDAL();

            return(mBook.Book.Where(x => x.name.StartsWith(SearchQuery)).ToList());
        }