protected void btnRefreshOverdues_Click(object sender, EventArgs e)
{
//All Overdue Books
LibrarianLogic ll = new LibrarianLogic();
ll.CreateOverdueLoan();
DataTable tblOverdues = ll.GetOverdueInformation();
GridView1.DataSource = tblOverdues;
GridView1.DataBind();
}
protected void btnExtend_Click(object sender, EventArgs e)
{
LibrarianLogic ll = new LibrarianLogic();
ll.UpdateLoanTableDueDate(int.Parse(txtLoanId.Text), 2);
DataTable tblExtensionRequests = ll.GetExtensionRequests();
GridView1.DataSource = tblExtensionRequests;
GridView1.DataBind();
}
protected void btnReturned_Click(object sender, EventArgs e)
{
LibrarianLogic ll = new LibrarianLogic();
int num = ll.UpdateLoanTableReturn(int.Parse(txtLoanId.Text), 4);
DataTable tblReturnRequests = ll.GetReturnRequests();
GridView1.DataSource = tblReturnRequests;
GridView1.DataBind();
}
protected void btnReport3_Click(object sender, EventArgs e)
{
btnRefreshOverdues.Visible = true;
//All Overdue Books
LibrarianLogic ll = new LibrarianLogic();
DataTable tblOverdues = ll.GetOverdueInformation();
GridView1.DataSource = tblOverdues;
GridView1.DataBind();
}
protected void btnReport2_Click(object sender, EventArgs e)
{
btnRefreshOverdues.Visible = false;
//ALL LOANS
LibrarianLogic ll = new LibrarianLogic();
DataTable tblLoan = ll.GetLoanInformation();
GridView1.DataSource = tblLoan;
GridView1.DataBind();
}
protected void btnRequest2_Click(object sender, EventArgs e)
{
lblMessage.Text = "";
PlaceHolderLoanId.Visible = true;
btnApprove.Visible = false;
btnReject.Visible = false;
btnExtension.Visible = false;
btnReturned.Visible = true;
LibrarianLogic ll = new LibrarianLogic();
DataTable tblReturn = ll.GetReturnRequests();
if (tblReturn.Rows.Count == 0)
{
lblMessage.Text = "No Return Requests Pending.";
return;
}
GridView1.DataSource = tblReturn;
GridView1.DataBind();
}
