public ActionResult DeleteConfirmed(int id)
        {
            Book_To_Authors book_To_Authors = db.Book_To_Authors.Find(id);

            db.Book_To_Authors.Remove(book_To_Authors);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "id,Book_ID,Author_ID,Status")] Book_To_Authors book_To_Authors)
 {
     if (ModelState.IsValid)
     {
         db.Entry(book_To_Authors).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.Author_ID = new SelectList(db.Authors, "id", "Name", book_To_Authors.Author_ID);
     ViewBag.Book_ID   = new SelectList(db.Books, "id", "Name", book_To_Authors.Book_ID);
     return(View(book_To_Authors));
 }
        // GET: Admin/Book_To_Authors/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Book_To_Authors book_To_Authors = db.Book_To_Authors.Find(id);

            if (book_To_Authors == null)
            {
                return(HttpNotFound());
            }
            return(View(book_To_Authors));
        }
        // GET: Admin/Book_To_Authors/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Book_To_Authors book_To_Authors = db.Book_To_Authors.Find(id);

            if (book_To_Authors == null)
            {
                return(HttpNotFound());
            }
            ViewBag.Author_ID = new SelectList(db.Authors, "id", "Name", book_To_Authors.Author_ID);
            ViewBag.Book_ID   = new SelectList(db.Books, "id", "Name", book_To_Authors.Book_ID);
            return(View(book_To_Authors));
        }
        public ActionResult BookDetails(int bookID)
        {
            //Kitabi Tapdim Ashagida
            Book selectedBook = db.Books.FirstOrDefault(bk => bk.id == bookID && bk.Status == 1);
            //Muellif Listi Yaradiram asagida
            List <Author> ListAuthors = new List <Author>();
            //Kitab Muellif cedvelinden secilen kitablar olan rowlari tapiram foreachin icinde
            List <Book_To_Authors> ListBta = new List <Book_To_Authors>();

            //secilen rowlari yaratdigim muellif kitab tipinde olan liste elave edirem
            foreach (Book_To_Authors bta in db.Book_To_Authors)
            {
                if (bta.Book_ID == selectedBook.id)
                {
                    //burada elave edirem
                    ListBta.Add(bta);
                }
            }
            if (ListBta.Count == 0)
            {
                ListAuthors.Add(new Author
                {
                    Name     = "Book's Author is",
                    Lastname = "anonumys",
                    Image    = null,
                    Status   = 1
                });
            }
            else
            {
                foreach (var item in ListBta)
                {
                    if (item.Book_ID == selectedBook.id)
                    {
                        ListAuthors.Add(new Author
                        {
                            Name     = item.Author.Name,
                            Lastname = item.Author.Lastname,
                            Image    = item.Author.Image,
                            Status   = item.Author.Status
                        });
                    }
                }
            }

            Book_To_Authors selectedRow = db.Book_To_Authors.FirstOrDefault(bta => bta.Book_ID == selectedBook.id && bta.Status == 1);
            List <Book>     ListBooks   = new List <Book>();

            ListBooks.Add(new Book
            {
                id          = selectedBook.id,
                Name        = selectedBook.Name,
                Image       = selectedBook.Image,
                PDF         = selectedBook.PDF,
                TotalCount  = selectedBook.TotalCount,
                BusyCount   = selectedBook.BusyCount,
                Description = selectedBook.Description,
                Status      = selectedBook.Status
            });
            var result = new { BookList = ListBooks, AuthorList = ListAuthors };

            //return Json(result, JsonRequestBehavior.AllowGet);

            return(Json(new
            {
                status = 200,
                error = "",
                data = result
            }, JsonRequestBehavior.AllowGet));
        }