protected void btnFindStudent_Click(object sender, EventArgs e)
{
// Reset the page.
lblResultMessage.Visible = false;
pnlStudentRecord.Visible = false;
if (Page.IsValid)
{
string studentId = myHelpers.CleanInput(txtStudentId.Text);
//**************
// Uses TODO 1 *
//**************
DataTable dtStudentRecord = myUniversityDB.GetStudentRecord(studentId);
// Show the student record if the query result is not null and something was retrieved.
if (dtStudentRecord != null)
{
// Display a no result message if nothing was retrieved from the database.
if (dtStudentRecord.Rows.Count != 0)
{
gvStudentRecord.DataSource = dtStudentRecord;
gvStudentRecord.DataBind();
pnlStudentRecord.Visible = true;
}
else // Display a no result message.
{
myHelpers.ShowMessage(lblResultMessage, "No record for the student was found.");
}
}
else // An SQL error occurred.
{
myHelpers.ShowMessage(lblResultMessage, "*** There is an error in the SQL statement of TODO 1.");
}
}
}
/*----- Protected Methods -----*/
protected void BtnFindStudent_Click(object sender, EventArgs e)
{
// Hide previous results.
lblResultMessage.Visible = false;
pnlStudentRecord.Visible = false;
string studentId = myHelperMethods.CleanInput(txtStudentId.Text);
if (IsValid && StudentIdIsValid(studentId))
{
//***************
// Uses TODO 01 *
//***************
DataTable dtStudentRecord = myUniversityDB.GetStudentRecord(studentId);
// Attributes expected to be returned by the query result.
var attributeList = new List <string> {
"STUDENTID", "FIRSTNAME", "LASTNAME", "EMAIL",
"PHONENO", "CGA", "DEPARTMENTID", "ADMISSIONYEAR"
};
// Display the query result if it is valid.
if (myHelperMethods.IsQueryResultValid("TODO 01", dtStudentRecord, attributeList, lblResultMessage))
{
// Display a no result message if nothing was retrieved from the database.
if (dtStudentRecord.Rows.Count != 0)
{
gvStudentRecord.DataSource = dtStudentRecord;
gvStudentRecord.DataBind();
pnlStudentRecord.Visible = true;
}
else // Display a no result message.
{
myHelperMethods.DisplayMessage(lblResultMessage, "No record for the student was found.");
}
}
}
}
