/*----- Protected Methods -----*/
protected void DdlDepartments_SelectedIndexChanged(object sender, EventArgs e)
{
// Hide previous results.
lblResultMessage.Visible = false;
pnlSearchResult.Visible = false;
Page.Validate();
if (IsValid)
{
// Get the department id from the dropdown list.
string departmentId = ddlDepartments.SelectedItem.Value;
//***************
// Uses TODO 03 *
//***************
DataTable dtStudentRecords = myUniversityDB.GetDepartmentStudentRecords(departmentId);
// Attributes expected to be returned by the query result.
var attributeList = new List <string> {
"STUDENTID", "LASTNAME", "FIRSTNAME", "EMAIL", "CGA"
};
// Display the query result if it is valid.
if (myHelperMethods.IsQueryResultValid("TODO 03", dtStudentRecords, attributeList, lblResultMessage))
{
if (dtStudentRecords.Rows.Count != 0)
{
gvFindStudentRecordsResult.DataSource = dtStudentRecords;
gvFindStudentRecordsResult.DataBind();
pnlSearchResult.Visible = true;
}
else // Display a no result message.
{
myHelperMethods.DisplayMessage(lblResultMessage, "There are no students in the " + ddlDepartments.SelectedItem.Text + " department.");
}
}
}
}
protected void btnFindStudentRecords_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
// Reset the page.
lblResultMessage.Visible = false;
pnlSearchResult.Visible = false;
// Get the department id from the dropdown list.
string departmentId = ddlDepartments.SelectedItem.Value;
//**************
// Uses TODO 3 *
//**************
DataTable dtStudentRecords = myUniversityDB.GetDepartmentStudentRecords(departmentId);
// Show the student records if the query result is not null and something was retrieved.
if (dtStudentRecords != null)
{
if (dtStudentRecords.Rows.Count != 0)
{
gvFindStudentRecordsResult.DataSource = dtStudentRecords;
gvFindStudentRecordsResult.DataBind();
pnlSearchResult.Visible = true;
}
else // Display a no result message.
{
myHelpers.ShowMessage(lblResultMessage, "There are no students in the " + ddlDepartments.SelectedItem.Text + " department.");
}
}
else // An SQL error occurred.
{
myHelpers.ShowMessage(lblResultMessage, "*** There is an error in the SQL statement of TODO 3.");
}
}
}
