protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = DatabaseHelper.Retrieve(@"
select BorrowedId, BookCopy.Id, Title, ISBN, Author.FirstName+' '+Author.LastName as AuthorName, BranchName,
Patron.FirstName+' '+Patron.LastName as PatronName, BorrowedDate, DueDate, ReturnDate
from BookCopy join Book on (BookCopy.BookId = Book.Id)
join Author on (Book.AuthorId = Author.Id)
join Library on (BookCopy.LibraryId = Library.Id)
join Borrowed on (BookCopy.Id = Borrowed.BookCopyId)
join Patron on (Borrowed.PatronId = Patron.LibraryCardNumber)
order by DueDate desc
");
BorrowedBooks.DataSource = dt.Rows;
BorrowedBooks.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt;
int libraryCardNumber = int.Parse(CustomUser.Identity.Name);
if (CustomUser.IsPatron)
{
dt = DatabaseHelper.Retrieve(@"
select BorrowedId, BookCopy.Id, Title, ISBN, Author.FirstName+' '+Author.LastName as AuthorName, BranchName,
Patron.FirstName+' '+Patron.LastName as PatronName, BorrowedDate, DueDate, ReturnDate
from BookCopy join Book on (BookCopy.BookId = Book.Id)
join Author on (Book.AuthorId = Author.Id)
join Library on (BookCopy.LibraryId = Library.Id)
join Borrowed on (BookCopy.Id = Borrowed.BookCopyId)
join Patron on (Borrowed.PatronId = Patron.LibraryCardNumber)
where ReturnDate is null and Patron.LibraryCardNumber = @LibraryCardNumber
order by DueDate desc
", new SqlParameter("@LibraryCardNumber", libraryCardNumber));
}
else
{
dt = DatabaseHelper.Retrieve(@"
select BorrowedId, BookCopy.Id, Title, ISBN, Author.FirstName+' '+Author.LastName as AuthorName, BranchName,
Patron.FirstName+' '+Patron.LastName as PatronName, BorrowedDate, DueDate, ReturnDate
from BookCopy join Book on (BookCopy.BookId = Book.Id)
join Author on (Book.AuthorId = Author.Id)
join Library on (BookCopy.LibraryId = Library.Id)
join Borrowed on (BookCopy.Id = Borrowed.BookCopyId)
join Patron on (Borrowed.PatronId = Patron.LibraryCardNumber)
where ReturnDate is null
order by DueDate desc
");
}
BorrowedBooks.DataSource = dt.Rows;
BorrowedBooks.DataBind();
}
}