private List <Book> GetAllBooks() { var db = new BookLibrary.Models.BookLibraryContext(); List <Book> books = db.Books.ToList(); return(books); }
public IQueryable GetAuthors() { var db = new BookLibrary.Models.BookLibraryContext(); IQueryable query = db.Authors; return(query); }
private List <Author> GetAllAuthors() { var db = new BookLibrary.Models.BookLibraryContext(); List <Author> authors = db.Authors.ToList(); return(authors); }
public IQueryable GetBookCategories() { var db = new BookLibrary.Models.BookLibraryContext(); IQueryable query = db.BookCategories; return(query); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string errorPage = "~/404"; ViewState["ReferrerUrl"] = Request.UrlReferrer.ToString(); if (Request.Params.AllKeys.Contains("id")) { int bookID = Convert.ToInt32(Request["id"]); var db = new BookLibrary.Models.BookLibraryContext(); Book book = db.Books.First(a => a.BookID == bookID); ISBN.Text = book.ISBN; BookTitle.Text = book.Title; Category.SelectedValue = book.CategoryID.ToString(); Author.SelectedValue = book.AuthorID.ToString(); Publisher.Text = book.Publisher; PublicationYear.Text = book.PublicationYear; Price.Text = book.Price.ToString(); } else { Response.Redirect(errorPage); } } }
public IQueryable <Member> Members_GetData() { var db = new BookLibrary.Models.BookLibraryContext(); string searchText = Convert.ToString(ViewState["SearchText"]); if (string.IsNullOrEmpty(searchText)) { return(db.Members.OrderBy(member => member.MemberID)); } else { return(db.Members.Where(member => member.FirstName.Contains(searchText) || member.LastName.Contains(searchText) || member.IdentityID.Contains(searchText) || member.Email.Contains(searchText)).OrderBy(member => member.MemberID)); } }
private List <Book> GetCurrentBooks(string sortColumn, string sortDirection) { var db = new BookLibrary.Models.BookLibraryContext(); if (string.IsNullOrEmpty(sortColumn)) { sortColumn = "BookID"; } if (string.IsNullOrEmpty(sortDirection)) { sortDirection = "ASC"; } sortDirection = sortDirection.ToUpper(); List <Book> currentBooks = (this.FilterMode) ? GetFilteredBooks(this.LastSearchTerm) : GetAllBooks(); if (sortColumn == "BookID") { currentBooks = (sortDirection == "ASC") ? currentBooks.OrderBy(book => book.BookID).ToList() : currentBooks.OrderByDescending(book => book.BookID).ToList(); } else if (sortColumn == "ISBN") { currentBooks = (sortDirection == "ASC") ? currentBooks.OrderBy(book => book.ISBN).ToList() : currentBooks.OrderByDescending(book => book.ISBN).ToList(); } else if (sortColumn == "Title") { currentBooks = (sortDirection == "ASC") ? currentBooks.OrderBy(book => book.Title).ToList() : currentBooks.OrderByDescending(book => book.Title).ToList(); } else if (sortColumn == "Category.BookCategoryName") { currentBooks = (sortDirection == "ASC") ? currentBooks.OrderBy(book => book.Category.BookCategoryName).ToList() : currentBooks.OrderByDescending(book => book.Category.BookCategoryName).ToList(); } else if (sortColumn == "Author.AuthorName") { currentBooks = (sortDirection == "ASC") ? currentBooks.OrderBy(book => book.Author.AuthorName).ToList() : currentBooks.OrderByDescending(book => book.Author.AuthorName).ToList(); } else if (sortColumn == "Publisher") { currentBooks = (sortDirection == "ASC") ? currentBooks.OrderBy(book => book.Publisher).ToList() : currentBooks.OrderByDescending(book => book.Publisher).ToList(); } else if (sortColumn == "PublicationYear") { currentBooks = (sortDirection == "ASC") ? currentBooks.OrderBy(book => book.PublicationYear).ToList() : currentBooks.OrderByDescending(book => book.PublicationYear).ToList(); } return(currentBooks); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string errorPage = "~/404"; ViewState["ReferrerUrl"] = Request.UrlReferrer.ToString(); if (Request.Params.AllKeys.Contains("id")) { int authorID = Convert.ToInt32(Request["id"]); var db = new BookLibrary.Models.BookLibraryContext(); Author author = db.Authors.First(a => a.AuthorID == authorID); AuthorName.Text = author.AuthorName; AuthorName.Focus(); } else { Response.Redirect(errorPage); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string errorPage = "~/404"; ViewState["ReferrerUrl"] = Request.UrlReferrer.ToString(); if (Request.Params.AllKeys.Contains("id")) { int memberID = Convert.ToInt32(Request["id"]); var db = new BookLibrary.Models.BookLibraryContext(); Member member = db.Members.First(m => m.MemberID == memberID); FirstName.Text = member.FirstName; LastName.Text = member.LastName; IdentityID.Text = member.IdentityID; Email.Text = member.Email; } else { Response.Redirect(errorPage); } } }
public IQueryable <BookLibrary.Models.Borrowing> Borrowings_GetData() { var db = new BookLibrary.Models.BookLibraryContext(); IQueryable <Borrowing> borrowings = null; if (Convert.ToBoolean(ViewState["Active"])) { borrowings = db.Borrowings.Where(b => b.To.HasValue == false).OrderBy(b => b.BorrowingID); } else { borrowings = db.Borrowings.OrderBy(b => b.BorrowingID); } string searchText = Convert.ToString(ViewState["SearchText"]); if (!string.IsNullOrEmpty(searchText)) { borrowings = borrowings.Where(b => b.Member.FirstName.Contains(searchText) || b.Member.LastName.Contains(searchText) || b.Book.ISBN.Contains(searchText) || b.Book.Title.Contains(searchText)); } return(borrowings); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string errorPage = "~/404"; ViewState["ReferrerUrl"] = Request.UrlReferrer.ToString(); if (Request.Params.AllKeys.Contains("id")) { int borrowingID = Convert.ToInt32(Request["id"]); var db = new BookLibrary.Models.BookLibraryContext(); Borrowing borrowing = db.Borrowings.First(b => b.BorrowingID == borrowingID); Member.Text = borrowing.Member.DisplayName; Book.Text = borrowing.Book.DisplayName; FromDate.Text = borrowing.From.ToString("MM/dd/yyyy"); ToDate.Text = DateTime.Now.ToString("MM/dd/yyyy"); ToDate.Focus(); } else { Response.Redirect(errorPage); } } }