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