protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = DatabaseHelper.Retrieve(@"
select Book.Id, Title, ISBN, FirstName, LastName
from Book inner join Author on (Book.AuthorId = Author.Id)
order by Title
");
Books.DataSource = dt.Rows;
Books.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (edit)
{
AddOrEdit.Text = "Edit Book Copy";
Cancel.Visible = true;
CheckedOutLabel.Visible = true;
CheckedOut.Visible = true;
AvailableLabel.Visible = true;
Available.Visible = true;
if (!int.TryParse(Request.QueryString["ID"], out bookCopyId))
{
Response.Redirect(BookCopyList);
}
if (!IsPostBack)
{
DataTable dt = DatabaseHelper.Retrieve(@"
select Book.Id as BookId, BookCopy.LibraryId as LibraryId, Out, Available
from BookCopy join Book on (BookCopy.BookId = Book.Id)
where BookCopy.Id = @BookCopyId
", new SqlParameter("@BookCopyId", bookCopyId));
if (dt.Rows.Count == 1)
{
int selectedBookId = dt.Rows[0].Field <int>("BookId");
int selectedLibraryId = dt.Rows[0].Field <int>("LibraryId");
bool selectedOut = dt.Rows[0].Field <bool>("Out");
bool selectedAvailable = dt.Rows[0].Field <bool>("Available");
Books.SelectedValue = selectedBookId.ToString();
Libraries.SelectedValue = selectedLibraryId.ToString();
CheckedOut.Checked = selectedOut;
Available.Checked = selectedAvailable;
}
else
{
Response.Redirect(BookCopyList);
}
}
}
else
{
AddOrEdit.Text = "Add Book Copy";
}
if (!IsPostBack)
{
DataTable dt = DatabaseHelper.Retrieve(@"
select Book.Id as BookId, Title + ' By: ' + FirstName + ' ' + LastName as BookName
from Book join Author on Book.AuthorId = Author.Id
");
Books.DataValueField = "BookId";
Books.DataTextField = "BookName";
Books.AppendDataBoundItems = true;
Books.Items.Add(new ListItem("Select Value...", string.Empty));
Books.DataSource = dt;
Books.DataBind();
DataTable dt2 = DatabaseHelper.Retrieve(@"
select BranchName, Id
from Library
");
Libraries.DataValueField = "Id";
Libraries.DataTextField = "BranchName";
Libraries.AppendDataBoundItems = true;
Libraries.Items.Add(new ListItem("Select Value...", string.Empty));
Libraries.DataSource = dt2;
Libraries.DataBind();
}
}
