private bool DoesThisSubjectExist(StudentResult aStudentResult) { List<Course> courses = new List<Course>(); aStudentManager = new StudentManager(); courses = aStudentManager.GetStudentCourses(aStudentResult.RegistationNo); foreach (Course course in courses) { if (course.CourseId == aStudentResult.CourseId) { return true; } } return false; }
private bool DoesThisSubjectExist(StudentResult aStudentResult) { List <Course> courses = new List <Course>(); aStudentManager = new StudentManager(); courses = aStudentManager.GetStudentCourses(aStudentResult.RegistationNo); foreach (Course course in courses) { if (course.CourseId == aStudentResult.CourseId) { return(true); } } return(false); }
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; } }
private void ShowStudentAndCourseInfo() { try { StudentManager aStudentManager = new StudentManager(); string regNo = registationNoTextBox.Text; ViewStudentInformation aViewStudentInformation = new ViewStudentInformation(); aViewStudentInformation = aStudentManager.GetStudentInfo(regNo); if(aViewStudentInformation.Name==null) { msgLabel.ForeColor = Color.Red; msgLabel.Text = "Invalid registation Number"; return; } nameTextBox.Text = aViewStudentInformation.Name; emailTextBox.Text = aViewStudentInformation.Email; departmentTextBox.Text = aViewStudentInformation.DepartmentName; Course aCourse = new Course(); List<Course> courses = new List<Course>(); courses = aStudentManager.GetStudentCourses(regNo); enrollsubjectGridView.DataSource = courses; enrollsubjectGridView.DataBind(); List<Course> courseList = new List<Course>(); courseList = aStudentManager.GetAllcourses(aViewStudentInformation); enrollDropDownList.DataSource = courseList; enrollDropDownList.DataBind(); } catch (Exception exception) { throw exception; } }
protected void showAllCourseOfUniversityButton_Click(object sender, EventArgs e) { try { string departmentCode = departmentTextBox.Text; string regNo = registationNoTextBox.Text; StudentManager aStudentManager = new StudentManager(); List<Course> courseList = new List<Course>(); courseList = aStudentManager.GetStudentMinorCourses(departmentCode, regNo); enrollDropDownList.DataSource = courseList; enrollDropDownList.DataBind(); } 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; } }
protected void searchButton_Click(object sender, EventArgs e) { if(!IsValid) { return; } try { string regNo = regNoTextBox.Value; int depeartmentId = Convert.ToInt16(departmentDropDownList.Text); StudentManager aStudentManager = new StudentManager(); Student aStudent = new Student(); aStudent = aStudentManager.GetStudentInformation(regNo, depeartmentId); if (aStudent.RegistationNo == null) { msgLabel.ForeColor = Color.Red; msgLabel.Text = "Invalid Registation Number"; } nameTextBox.Value = aStudent.Name; emailTextBox.Value = aStudent.Email; } 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; } }
private void GetResult(string regNo) { try { StudentManager aStudentManager = new StudentManager(); ResultManager aResultManager = new ResultManager(); ViewStudentInformation aViewStudentInformation = new ViewStudentInformation(); aViewStudentInformation = aStudentManager.GetStudentInformation(regNo); if (aViewStudentInformation.Name ==null) { msgLabel.ForeColor = Color.Red; msgLabel.Text = "Invalid Registation Number"; return; } nameTextBox.Value = aViewStudentInformation.Name; emailTextBox.Value = aViewStudentInformation.Email; departmentTextBox.Value = aViewStudentInformation.DepartmentName; ViewResult aViewResult = new ViewResult(); List<ViewCourseGradeAndCredit> viewCourseGradeAndCreditList = new List<ViewCourseGradeAndCredit>(); viewCourseGradeAndCreditList = aResultManager.GetCourseResult(regNo); detailsResultGridView.DataSource = viewCourseGradeAndCreditList; detailsResultGridView.DataBind(); aViewResult = aResultManager.GetSubjectCGPA(regNo); noOfEnrolledCoursesTextBox.Value = aViewResult.NoOfEnrolledCourses.ToString(); noOfRemainingCoursesTextBox.Value = (aViewResult.NoOfEnrolledCourses - aViewResult.NoOfCompletedCourses).ToString(); noOfCompletedCoursesTextBox.Value = aViewResult.NoOfCompletedCourses.ToString(); totalCreditEnrolledCoursesTextBox.Value = aViewResult.EnrolledCredit.ToString(); completedCreditTextBox.Value = aViewResult.CompletedCredit.ToString(); remainingCreditTextBox.Value = (aViewResult.EnrolledCredit - aViewResult.CompletedCredit).ToString(); gradeLetterTextBox.Value = aViewResult.GradeLetter; cgpaTextBox.Value = aViewResult.Cgpa.ToString(); if (aViewResult.NoOfEnrolledCourses != aViewResult.NoOfCompletedCourses||aViewResult.NoOfCompletedCourses==0) { resultLabel.ForeColor = Color.Red; resultLabel.Text = "You are not eligible to get the certificate"; } else { resultLabel.ForeColor = Color.Green; resultLabel.Text = "You are eligible to get the certificate"; } } 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; } }
private Student GetStudentInfo() { try { aStudentManager = new StudentManager(); aStudent = new Student(); aStudent.Name = nameText.Value; aStudent.Email = emailText.Value; aStudent.ContactNo = contactNoText.Value; aStudent.DepartmentId = departmentDropDownList.Text; aStudent.RegistationDate = dateText.Value; string year = aStudentManager.GetYear(dateText.Value); aStudent.Address = addressText.Value; string id = aStudentManager.GetStudentRegistationNO(aStudent); aStudent.RegistationNo = year + departmentDropDownList.SelectedItem.Text + id; return aStudent; } catch (Exception exception) { throw exception; } }
protected void registerButton_Click(object sender, EventArgs e) { if(!IsValid) { return; } try { aStudentManager = new StudentManager(); Student aStudent = (Student)Session["aStudent"]; certificates = (List<Certificate>)ViewState["Certificates"]; aStudent.Certificates = certificates; string msg = aStudentManager.SaveStudent(aStudent); if (msg == "Saved") { msgLabel.ForeColor = Color.Green; Response.Redirect("~/UI/ShowStudentRegistationNoUI.aspx"); } 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; } }