public List <BooksViewModel> booksViews(LibraryContext _context) { List <BooksViewModel> books = new List <BooksViewModel>(); var libraryContext = _context.Book.Include(b => b.Author); foreach (var book in libraryContext) { BooksViewModel model = new BooksViewModel(); AuthorDropDown author = new AuthorDropDown(); author.Author = book.Author.Name + book.Author.Surname; model.Author = author; model.BookId = book.BookId; model.BookType = book.BookType; model.Description = book.Description; model.Title = book.Title; var lease = _context.Lease.Where(l => l.BookId == book.BookId).FirstOrDefault(); if (lease == null) { model.Availability = "Dostępna"; } else { model.Availability = "Wypożyczona"; } books.Add(model); } return(books); }
public List <AuthorDropDown> GetAuthors(LibraryContext _context) { var authorList = (from Author in _context.Author select Author).ToList(); List <AuthorDropDown> authors = new List <AuthorDropDown>(); foreach (var author in authorList) { AuthorDropDown authorDropDown = new AuthorDropDown(); authorDropDown.Author = author.Name + author.Surname; authorDropDown.ID = author.AuthorId; authors.Add(authorDropDown); } return(authors); }
protected void Page_Load(object sender, EventArgs e) { if (!User.IsInRole("Librarian")) { Response.Redirect(SitePages.GetUrl(LibraryPage.NotAuthorized)); } if (!IsPostBack) { AuthorDropDown.ListDataSource = () => { DataTable dt = DatabaseHelper.Retrieve(GetAuthorsQuery); AuthorDropDown.SetTextAndValueFields("AuthorName", "Id"); return(dt); }; } }
public BooksViewModel getBookDetails(LibraryContext _context, int?id) { var book = _context.Book.FindAsync(id); var author = _context.Author.Find(book.Result.AuthorId); BooksViewModel model = new BooksViewModel(); AuthorDropDown authorModel = new AuthorDropDown(); authorModel.Author = author.Name + author.Surname; authorModel.ID = author.AuthorId; model.Author = authorModel; model.Title = book.Result.Title; model.BookId = book.Result.BookId; model.BookType = book.Result.BookType; model.Description = book.Result.Description; return(model); }
protected void Page_Load(object sender, EventArgs e) { if (!User.IsInRole("Librarian")) { Response.Redirect(SitePages.GetUrl(LibraryPage.NotAuthorized)); } if (!int.TryParse(Request.QueryString["ID"], out bookId)) { Response.Redirect(BooksUrl); } if (!IsPostBack) { AuthorDropDown.ListDataSource = () => { DataTable authorsTable = DatabaseHelper.Retrieve(GetAuthorsQuery); AuthorDropDown.SetTextAndValueFields("AuthorName", "Id"); return(authorsTable); }; DataTable bookTable = DatabaseHelper.Retrieve( GetBookQuery, new SqlParameter("@BookId", bookId)); if (bookTable.Rows.Count == 1) { string oldTitle = bookTable.Rows[0].Field <string>("Title"); string oldAuthor = bookTable.Rows[0].Field <string>("AuthorName"); string oldIsbn = bookTable.Rows[0].Field <string>("Isbn"); int oldAuthorId = bookTable.Rows[0].Field <int>("AuthorId"); OldTitle.Text = oldTitle; OldAuthor.Text = oldAuthor; OldIsbn.Text = oldIsbn; TitleTextBox.Text = oldTitle; AuthorDropDown.SelectedValue = oldAuthorId.ToString(); IsbnTextBox.Text = oldIsbn; } else { Response.Redirect(BooksUrl); } } }