// Search student and books data for the current student.
private void Button_SearchBooksByStudentNo_Click(object sender, EventArgs e)
{
string enrollmentNo = this.textBox_EnrollmentNo.Text.Trim();
if (enrollmentNo != string.Empty)
{
DataTable studentIssuedBooks = issueBook.GetStudentIssuedBooks(enrollmentNo, out string errorMessage);
if (studentIssuedBooks.Rows.Count > 0)
{
this.dataGridView_NotReturnedBooks.DataSource = studentIssuedBooks;
}
else
{
if (errorMessage != string.Empty)
{
MessageBox.Show(errorMessage,
"Issued Books",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
DataTable studentReturnedBooks = issueBook.GetStudentReturnedBooks(enrollmentNo, out string errorMsg);
if (studentReturnedBooks.Rows.Count > 0)
{
this.dataGridView_ReturnedBooks.DataSource = studentReturnedBooks;
}
else
{
if (errorMessage != string.Empty)
{
MessageBox.Show(errorMsg,
"Returned Books",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
}
}
