public ActionResult ReturnBook(int id)
        {
            StudentBookMapping studentBook = db.StudentBookMappings.Find(id);

            studentBook.SubmissioDate   = DateTime.Now;
            studentBook.Fine            = CalculateFine(studentBook.DueDate, (DateTime)studentBook.SubmissioDate);
            db.Entry(studentBook).State = EntityState.Modified;
            db.SaveChanges();
            return(RedirectToAction("TableView", new { Id = studentBook.StudentId }));
        }
        public ActionResult DeleteConfirm(int Id)
        {
            StudentBookMapping book = db.StudentBookMappings.Find(Id);


            db.StudentBookMappings.Remove(book);
            db.SaveChanges();


            return(RedirectToAction("TableView", new { Id = book.StudentId }));
        }
        public ActionResult Delete(int id)
        {
            StudentBookMapping bookMapping = db.StudentBookMappings.Find(id);


            if (bookMapping != null)
            {
                return(View(bookMapping));
            }
            return(RedirectToAction("Index"));
        }
        public ActionResult IssueBook(BookReleaseViewModel bookReleaseModel)
        {
            ViewBag.BookId = bookReleaseModel.BookId;
            Book existingBook = db.Books.Find(bookReleaseModel.BookId);

            if (existingBook != null)
            {
                StudentBookMapping newBookIssue = new StudentBookMapping
                {
                    BookId        = existingBook.Id,
                    StudentId     = bookReleaseModel.StudentId,
                    IssueDate     = DateTime.Now.Date,
                    DueDate       = bookReleaseModel.ToDate,
                    SubmissioDate = null
                };
                db.StudentBookMappings.Add(newBookIssue);
                db.SaveChanges();
                return(RedirectToAction("TableView", new { Id = bookReleaseModel.StudentId }));
            }


            return(RedirectToAction("TableView", new { Id = bookReleaseModel.StudentId }));
        }