protected void enrollButton_Click(object sender, EventArgs e)
{
if(!IsValid)
{
return;
}
try
{
StudentCourse aStudentCourse = new StudentCourse();
aStudentCourse.RegistrationNo = registationNoTextBox.Text;
aStudentCourse.EnrollDate = dateTextBox.Text;
aStudentCourse.CourseId = Convert.ToInt16(enrollDropDownList.Text);
aStudentCourse.Status = 0;
StudentManager aStudentManager = new StudentManager();
string msg = aStudentManager.SaveStudentCourse(aStudentCourse);
if(msg=="Saved")
{
msgLabel.ForeColor = Color.Green;
msgLabel.Text = msg;
ShowStudentAndCourseInfo();
}
else
{
msgLabel.ForeColor = Color.Red;
msgLabel.Text = msg;
}
}
catch (SqlException sqlException)
{
msgLabel.ForeColor = Color.Red;
msgLabel.Text = "Database error.See details error: " + sqlException.Message;
}
catch (Exception exception)
{
msgLabel.ForeColor = Color.Red;
string errorMessage = "Unknow error occured.";
errorMessage += exception.Message;
if (exception.InnerException != null)
{
errorMessage += exception.InnerException.Message;
}
msgLabel.Text = errorMessage;
}
}
public string SaveStudentCourse(StudentCourse aStudentCourse)
{
try
{
connection.Open();
string query = "INSERT INTO t_StudentCourseEnroll VALUES(@regNo,@date,@courseId,@status)";
command.CommandText = query;
command.Parameters.Clear();
command.Parameters.AddWithValue("@regNo", aStudentCourse.RegistrationNo);
command.Parameters.AddWithValue("@date", aStudentCourse.EnrollDate);
command.Parameters.AddWithValue("@courseId", aStudentCourse.CourseId);
command.Parameters.AddWithValue("@status", aStudentCourse.Status);
command.ExecuteNonQuery();
return "Saved";
}
finally
{
connection.Close();
}
}
public string SaveStudentCourse(StudentCourse aStudentCourse)
{
aStudentGateway = new StudentGateway();
return aStudentGateway.SaveStudentCourse(aStudentCourse);
}