/// <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());
}
