/// <summary> /// Funkcja odpowiadająca za pobranie odpowiednich wartości z bazy danych /// i przypisanie ich do tabeli /// </summary> private void RefreshDataGridViewBooks() { DataTable booksToLend = booksRepository.GetBooks(1, "Brak"); // przypisz przypisz książki do wypożyczenia do DataGridView dataGridViewBooks.DataSource = booksToLend; }
public IActionResult Index() { InitializeViewBagGenresDropdown(); var booksList = _booksRepository.GetBooks(); return(View(booksList)); }
// GET: Books public ActionResult Index() { BooksViewModel vm = db.GetBooks(); var books = vm.Books; return(View(books)); }
/// <summary> /// Metoda odświeżająca dane w DataGridViewBooks /// </summary> private void RefreshDataGridViewBooks() { //Pobierz wszystkie książki z bazy danych DataTable books = booksRepository.GetBooks(); //Przypisz wszystkie książki do DataGridView dataGridViewBooks.DataSource = books; }
public ActionResult Books(string title, string order) { var bookEntities = _booksRepository.GetBooks(title, order); return(PartialView(model: new ResultsModel() { Books = bookEntities, SortOrder = order, SortTitle = title })); }
private void Update() { var promoCode = (Guid)Session["PromoCode"]; ViewBag.PromoCode = promoCode; ViewBag.Books = BooksRepository.GetBooks(); ViewBag.OrderedBooks = OrdersRepository.GetBooks(promoCode); ViewBag.Cost = OrdersRepository.Cost(promoCode); }
public IActionResult Index() { ViewBag.Genres = new GenreRepository().GetAll().Select(x => new SelectListItem { Text = x.Name, Value = x.Id.ToString() }); var booksList = _booksRepository.GetBooks(); return(View(booksList)); }
public void Books_GetBooks_OneBook() { // Arrange var repo = new BooksRepository(context); // Act var books = repo.GetBooks(); // Assert Assert.AreEqual(1, books.Count()); Assert.AreEqual("The Lord of The Rings", books.Where(b => b.Title == "The Lord of The Rings").SingleOrDefault().Title); }
/// <summary> /// Metoda odświeżająca dane w DataGridViewBooks /// </summary> private void RefreshDataGridViewBooks() { DataTable booksToLend; // pobierz wszystkie dostępne dla Ciebie książki z bazy danych if (age <= 18) { booksToLend = booksRepository.GetBooks(1, firstName); } else { booksToLend = booksRepository.GetBooks(3, firstName); } // pobierz wszystkie Twoje książki DataTable booksPerson = booksRepository.GetBooks(4, firstName); // przypisz przypisz książki do wypożyczenia do DataGridView dataGridViewBooksToLend.DataSource = booksToLend; // przypisz książki, które posiadasz do DataGridView dataGridViewPersonBooks.DataSource = booksPerson; }
public HttpResponseMessage GetAllBooks() { BooksRepository ctxBook = new BooksRepository(); IEnumerable <Book> lsBooks; lsBooks = ctxBook.GetBooks(); if (lsBooks.Count() > 0) { return(Request.CreateResponse(HttpStatusCode.OK, lsBooks)); } { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Item not found")); } }
public HttpResponseMessage GetBookByID(int id) { BooksRepository ctxBook = new BooksRepository(); Book _Book = ctxBook.GetBooks().FirstOrDefault(x => x.BookID == id); if (_Book != null) { return(Request.CreateResponse(HttpStatusCode.OK, _Book)); } { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Item not found")); } }
public void Books_GetBooks_FourBooks() { // Arrange var repo = new BooksRepository(context); List <Book> booksToAdd = new List <Book> (); booksToAdd.Add(new Book { Title = "A Game Of Thrones", Author = "George R.R. Martin", ReleaseDate = new DateTime(1996, 8, 1), ISBN = "214124235", Available = true, Deleted = false }); booksToAdd.Add(new Book { Title = "The Hobbit", Author = "Tolkien", ReleaseDate = new DateTime(1996, 8, 1), ISBN = "541312312", Available = true, Deleted = false }); booksToAdd.Add(new Book { Title = "Programming with c++", Author = "Bjarne Stoustrup", ReleaseDate = new DateTime(1996, 8, 1), ISBN = "2423423123", Available = true, Deleted = false }); context.Books.AddRange(booksToAdd); context.SaveChanges(); // Act var books = repo.GetBooks(); // Assert Assert.AreEqual(4, books.Count()); Assert.AreEqual("The Lord of The Rings", books.Where(b => b.Title == "The Lord of The Rings").SingleOrDefault().Title); Assert.AreEqual("A Game Of Thrones", books.Where(b => b.Title == "A Game Of Thrones").SingleOrDefault().Title); Assert.AreEqual("The Hobbit", books.Where(b => b.Title == "The Hobbit").SingleOrDefault().Title); Assert.AreEqual("Programming with c++", books.Where(b => b.Title == "Programming with c++").SingleOrDefault().Title); }
public BooksQuery(BooksRepository booksRepository) { Field <ListGraphType <BookType> >( "books", resolve: context => booksRepository.GetBooks() ); Field <BookType>( "book", arguments: new QueryArguments(new QueryArgument <NonNullGraphType <StringGraphType> > { Name = "iSBN" }), resolve: context => { var isbn = context.GetArgument <string>("iSBN"); return(booksRepository.GetBook(isbn)); } ); }
public void Books_GetBooks_EmptyList() { // Arrange var repo = new BooksRepository(context); var booksToDelete = (from b in context.Books select b).ToList(); foreach (Book book in booksToDelete) { book.Deleted = true; } context.SaveChanges(); // Act var books = repo.GetBooks(); // Assert Assert.AreEqual(0, books.Count()); }
public void GetBooksList() { using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); using (var command = connection.CreateCommand()) { command.CommandText = "insert into Books (ISBN, Name, Author, PublishingYear, Price, Count) " + "values('test', 'test', 'test', 1, 1, 1)"; command.ExecuteNonQuery(); } } TempBooks.Add("test"); var booksList = new List <Book>(BooksRepository.GetBooks()); var book = booksList.Find(x => x.ISBNCode == "test"); Assert.AreEqual(book.ISBNCode, "test"); Assert.AreEqual(book.Name, "test"); Assert.AreEqual(book.Author, "test"); Assert.AreEqual(book.PublishingYear, 1); Assert.AreEqual(book.Price, 1); Assert.AreEqual(book.Count, 1); }
/// <summary> /// Metoda odświeżająca dane w DataGridViewBooks /// </summary> private void RefreshDataGridViewBooks() { dataGridViewBooks.DataSource = booksRepository.GetBooks(); //dataGridViewBooks.DataSource = booksRepository.GetBooksSimpleViewModel(); }
/// <summary> /// Metoda odświeżająca dane w DataGridViewBooks /// </summary> private void RefreshDataGridViewBooks() { dataGridViewBooks.DataSource = booksRepository.GetBooks(); }
public Task <List <Book> > Get() { return(_booksRepository.GetBooks()); }