public IActionResult Create(Book book) { if (ModelState.IsValid) { try { if (context.Books.Contains(book)) { context.Entry(book).State = Microsoft.EntityFrameworkCore.EntityState.Modified; } else { context.Books.Add(book); } context.SaveChanges(); } catch { return(View()); } return(RedirectToAction("Index")); } else { return(View()); } }
public ActionResult Create([Bind(Include = "ID,Title,Author,Pages,Genre,Price")] Novel novel) { if (ModelState.IsValid) { db.Novels.Add(novel); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(novel)); }
public ActionResult Create([Bind(Include = "userID,ISBN,Name,Author,Published")] Books books) { if (ModelState.IsValid) { db.Books.Add(books); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(books)); }
public ActionResult Create([Bind(Include = "userID,ISBN,imgPath")] Bookimage bookimage) { if (ModelState.IsValid) { db.Bookimage.Add(bookimage); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(bookimage)); }
public void Refresh() { var query = from r in db.Reservations where (r.EndOfReservation < DateTime.Now) select r; List <int> listID = new List <int>(); foreach (var item in query.ToList()) { listID.Add(item.BookID); db.Reservations.Remove(item); } db.SaveChanges(); var bookQry = from b in db.Books select b; foreach (var itm in bookQry.ToList()) { if (listID.Contains(itm.ID)) { itm.Quantity++; db.Entry(itm).State = EntityState.Modified; db.SaveChanges(); } } }
public ActionResult Index(int bookId, string category, string searchString, int resultsPerPage = 10, int page = 1) { var book = db.Books.Single(b => b.ID == bookId); BookCard bc; bool conflict = false; //no one is reading it? borrow! if (book.Reader == null) { bc = new BookCard { BookID = bookId, BorrowDate = DateTime.Now, Reader = User.Identity.Name }; book.Reader = User.Identity.Name; db.Cards.Add(bc); db.Entry(book).State = EntityState.Modified; } //user is the reader? return! else if (book.Reader == User.Identity.Name) { bc = db.Cards.Single(c => c.BookID == bookId && c.ReturnDate == null); bc.ReturnDate = DateTime.Now; book.Reader = null; db.Entry(bc).State = EntityState.Modified; db.Entry(book).State = EntityState.Modified; } else //this will probably only happen if the book was borrowed by someone else //after the page was loaded but before the button click { conflict = true; } db.SaveChanges(); if (Request.IsAjaxRequest()) { return(Content((HtmlHelpers.GetButton(bookId, book.Reader, User.Identity.Name, conflict)).ToHtmlString())); } var books = db.Books.Where(b => b.Status == true).ToList(); var model = BuildIndexViewModel(category, searchString, resultsPerPage, page, books); return(View(model)); }
public IActionResult Create(Book book) { int id = book.AutherID == 0 ? 1 : book.AutherID; book.AutherID = id; if (book != null) { //book.AutherID = id; // 不需要添加 myDBContext.Add(book); //myDBContext.Books.Add(book);// 建议一般这样写 比较具体不用推断类型 myDBContext.SaveChanges(); //return RedirectToAction(nameof(Index)); } return(Redirect("Index")); }
public IActionResult Index() { //var books = _BooksDBContext.Books.ToList(); var book = new Books() { Name = "zhangsan1", Price = 24, Author = "sanmao", }; _BooksDBContext.Books.Add(book); _BooksDBContext.SaveChanges(); //User user = new User() { Name = "Herry", CreateTime = DateTime.Now }; //context.User.Add(user); return(View()); }
public void AddBook(Book book) { _db.Add(book); _db.SaveChanges(); }