// // GET: /Book/ public ActionResult Index() { sbartoszak_bookwormsEntities ent = new sbartoszak_bookwormsEntities(); var book = from b in ent.Books orderby b.Author select new BookVM() { Title = b.Title, Author = b.Author, GenreName = b.Genre.Name, AddDate = b.AddDate, IdBook = b.IdBook }; return View(book); }
public ActionResult Details(int id) { sbartoszak_bookwormsEntities ent = new sbartoszak_bookwormsEntities(); BookVM book = (from b in ent.Books where b.IdBook == id select new BookVM() { Title = b.Title, Author = b.Author, GenreName = b.Genre.Name, AddDate = b.AddDate, IdBook = b.IdBook }).FirstOrDefault(); book.Reviews = (from r in ent.Reviews where r.IdBook == book.IdBook select r).ToList(); return View(book); }
public ActionResult Add(FormCollection form) { sbartoszak_bookwormsEntities ent = new sbartoszak_bookwormsEntities(); Review review = new Review(); if (TryUpdateModel(review)) { review.CreateDate = DateTime.Now; ent.Reviews.AddObject(review); ent.SaveChanges(); } return RedirectToAction("Details", "Book", new { id = review.IdBook }); }
public ActionResult Add(FormCollection form) { sbartoszak_bookwormsEntities ent = new sbartoszak_bookwormsEntities(); ViewBag.BookGenres = ent.Genres.OrderBy(g => g.Name).ToSelectListItem(1, g => g.IdGenre, g => g.Name, g => g.Name, g => g.IdGenre.ToString()); Book book = new Book(); if (TryUpdateModel(book)) { book.AddDate = DateTime.Now; ent.Books.AddObject(book); ent.SaveChanges(); } return RedirectToAction("Index"); }
public ActionResult Add() { sbartoszak_bookwormsEntities ent = new sbartoszak_bookwormsEntities(); ViewBag.BookGenres = ent.Genres.OrderBy(g => g.Name).ToSelectListItem(1, g => g.IdGenre, g => g.Name, g => g.Name, g => g.IdGenre.ToString()); return View(); }