protected void btnSubmit_Click(object sender, EventArgs e)
{
lblResultMessage.Visible = false;
if (Page.IsValid)
{
string studentId = myHelpers.CleanInput(txtStudentId.Text);
int coursesEnrolled = 0;
// Search each row of the GridView to determine if any courses were selected.
foreach (GridViewRow row in gvAvailableCourses.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkRow = (row.Cells[0].FindControl("chkRow") as CheckBox);
if (chkRow != null && chkRow.Checked)
{
coursesEnrolled = coursesEnrolled + 1;
// Get the course id of the selected course.
string courseId = myHelpers.CleanInput(row.Cells[1].Text);
//**************
// Uses TODO 7 *
//**************
if (!myUniversityDB.EnrollInCourses(studentId, courseId))
{
myHelpers.ShowMessage(lblResultMessage, "*** There is an error in the SQL statement of TODO 7.");
return;
}
}
}
// Display a message indicating result of enrollment.
if (coursesEnrolled != 0)
{
if (coursesEnrolled == 1)
{
myHelpers.ShowMessage(lblResultMessage, "The student has successfully enrolled in "
+ coursesEnrolled.ToString() + " course.");
}
else
{
myHelpers.ShowMessage(lblResultMessage, "The student has successfully enrolled in "
+ coursesEnrolled.ToString() + " courses.");
}
pnlAvailableCourses.Visible = false;
}
else
{
myHelpers.ShowMessage(lblResultMessage, "Please select a course to enroll in.");
}
}
}
}
/*----- Protected Methods -----*/
protected void BtnSubmit_Click(object sender, EventArgs e)
{
// Hide previous results.
lblResultMessage.Visible = false;
if (IsValid)
{
//**************
// Uses TODO 07 *
//**************
DataTable dtStudentId = myUniversityDB.GetStudentId(email);
// Attributes expected to be returned by the query result.
var attributeList = new List <string> {
"STUDENTID"
};
// Display the query result if it is valid.
if (myHelperMethods.IsQueryResultValid("TODO 07", dtStudentId, attributeList, lblResultMessage))
{
if (dtStudentId.Rows.Count == 1)
{
string studentId = dtStudentId.Rows[0]["STUDENTID"].ToString();
int coursesEnrolled = 0;
// Search each row of the GridView to determine if any courses were selected.
foreach (GridViewRow row in gvAvailableCourses.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkRow = (row.Cells[0].FindControl("chkRow") as CheckBox);
if (chkRow != null && chkRow.Checked)
{
coursesEnrolled += 1;
// Get the course id of the selected course.
string courseId = myHelperMethods.CleanInput(row.Cells[1].Text);
//***************
// Uses TODO 09 *
//***************
if (!myUniversityDB.EnrollInCourses(studentId, courseId))
{
myHelperMethods.DisplayMessage(lblResultMessage, "*** SQL error in TODO 09: " + Global.sqlError);
return;
}
}
}
// Display a message indicating enrollment result.
if (coursesEnrolled != 0)
{
string successMessage = "You have successfully enrolled in " + coursesEnrolled.ToString();
if (coursesEnrolled == 1)
{
successMessage += " course.";
}
else
{
successMessage += " courses.";
}
myHelperMethods.DisplayMessage(lblResultMessage, successMessage);
pnlAvailableCourses.Visible = false;
}
else
{
myHelperMethods.DisplayMessage(lblResultMessage, "Please select one or more courses to enroll in.");
}
}
}
else // Incorrect query result.
{
myHelperMethods.DisplayMessage(lblResultMessage, "*** SQL error in TODO 07: Only one student id should be retrieved.");
}
}
}
}
