/*----- Private Methods -----*/
private void GetEnrolledCourses(string email)
{
//**************
// Uses TODO 06 *
//**************
DataTable dtEnrolledCourses = myUniversityDB.GetEnrolledCourses(email);
// Attributes expected to be returned by the query result.
var attributeList = new List <string> {
"COURSEID", "COURSENAME", "GRADE", "CREDITS", "INSTRUCTOR"
};
// Display the query result if it is valid.
if (myHelperMethods.IsQueryResultValid("TODO 06", dtEnrolledCourses, attributeList, lblResultMessage))
{
if (dtEnrolledCourses.Rows.Count != 0)
{
gvEnrolledCourses.DataSource = dtEnrolledCourses;
gvEnrolledCourses.DataBind();
pnlEnrolledCourses.Visible = true;
}
else // Display a no result message.
{
myHelperMethods.DisplayMessage(lblResultMessage, "You are not enrolled in any courses.");
}
}
}
protected void btnFindEnrolledCourses_Click(object sender, EventArgs e)
{
pnlEnrolledCourses.Visible = false;
if (Page.IsValid)
{
// Hide the search result.
lblResultMessage.Visible = false;
string studentId = myHelpers.CleanInput(txtStudentId.Text);
//**************
// Uses TODO 5 *
//**************
DataTable dtEnrolledCourses = myUniversityDB.GetEnrolledCourses(studentId);
// Show the enrolled courses if the query result is not null and something was retrieved.
if (dtEnrolledCourses != null)
{
if (dtEnrolledCourses.Rows.Count != 0)
{
gvEnrolledCourses.DataSource = dtEnrolledCourses;
gvEnrolledCourses.DataBind();
pnlEnrolledCourses.Visible = true;
}
else // Display a no result message.
{
myHelpers.ShowMessage(lblResultMessage, "Student " + studentId + " is not enrolled in any courses.");
}
}
else //An SQL error occurred.
{
myHelpers.ShowMessage(lblResultMessage, "*** There is an error in the SQL statement of TODO 5.");
}
}
}
