public CourseModel GetSingleCourseModel(int courseId) { DepartmentManager aDepartmentManager = new DepartmentManager(); SemesterManager aSemesterManager = new SemesterManager(); SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM course_tbl WHERE courseId='" + courseId + "'"; SqlCommand command = new SqlCommand(query, connection); // command.Parameters.AddWithValue("@deptId", DeptId); connection.Open(); SqlDataReader reader = command.ExecuteReader(); CourseModel aCourseModel = new CourseModel(); while (reader.Read()) { aCourseModel.courseId = Convert.ToInt32(reader["courseId"].ToString()); aCourseModel.courseCode = reader["courseCode"].ToString(); aCourseModel.courseName = reader["courseName"].ToString(); aCourseModel.courseCredit = Convert.ToDouble(reader["courseCredit"].ToString()); aCourseModel.courseDescription = reader["courseDescription"].ToString(); aCourseModel.departmentId = int.Parse(reader["departmentId"].ToString()); aCourseModel.semesterId = int.Parse(reader["semesterId"].ToString()); } aCourseModel.Department = aDepartmentManager.GetDepartmentById(aCourseModel.departmentId); aCourseModel.Semester = aSemesterManager.GetSemesterById(aCourseModel.semesterId); connection.Close(); return(aCourseModel); }
public List <CourseModel> GetCourseListNotAssignedByDeptId(int deptId) { SemesterManager aSemesterManager = new SemesterManager(); DepartmentManager aDepartmentManager = new DepartmentManager(); SqlConnection con = new SqlConnection(connectionString); string query = "SELECT * FROM course_tbl WHERE departmentId=@departmentId and courseId not in (select CourseId from courseAssignToTeacher_tbl)"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@departmentId", deptId); con.Open(); SqlDataReader aSqlDataReader = cmd.ExecuteReader(); List <CourseModel> courses = new List <CourseModel>(); if (aSqlDataReader.HasRows) { while (aSqlDataReader.Read()) { CourseModel aCourseModel = new CourseModel(); aCourseModel.courseId = Convert.ToInt32(aSqlDataReader["courseId"].ToString()); aCourseModel.courseCode = aSqlDataReader["courseCode"].ToString(); aCourseModel.courseName = aSqlDataReader["courseName"].ToString(); aCourseModel.courseCredit = Convert.ToDouble(aSqlDataReader["courseCredit"].ToString()); aCourseModel.courseDescription = aSqlDataReader["courseDescription"].ToString(); aCourseModel.departmentId = int.Parse(aSqlDataReader["departmentId"].ToString()); aCourseModel.semesterId = int.Parse(aSqlDataReader["semesterId"].ToString()); aCourseModel.Department = aDepartmentManager.GetDepartmentById(aCourseModel.departmentId); aCourseModel.Semester = aSemesterManager.GetSemesterById(aCourseModel.semesterId); courses.Add(aCourseModel); } } con.Close(); return(courses); }
public EnrollCourseController() { _courseManager = new CourseManager(); _departmentManager = new DepartmentManager(); _semesterManager = new SemesterManager(); aEnrollCourseManager = new EnrollCourseManager(); }
public List <CourseModel> GetAllCoursesNotAssignedToTeacher() { DepartmentManager aDepartmentManager = new DepartmentManager(); SemesterManager aSemesterManager = new SemesterManager(); List <CourseModel> courses = new List <CourseModel>(); SqlConnection connection = new SqlConnection(connectionString); string query = "select * from course_tbl where courseid not in (select CourseId from courseAssignToTeacher_tbl)"; //string query = "SELECT course_tbl.courseId, course_tbl.courseCode,course_tbl.courseName, " + // "course_tbl.courseCredit, course_tbl.courseDescription, department_tbl.departmentName, " + // "semester_tbl.semester FROM course_tbl " + // "INNER JOIN department_tbl ON department_tbl.departmentId = course_tbl.departmentId " + // "INNER JOIN semester_tbl ON semester_tbl.id = course_tbl.semesterId; "; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { CourseModel aCourseModel = new CourseModel(); aCourseModel.courseId = Convert.ToInt32(reader["courseId"].ToString()); aCourseModel.courseCode = reader["courseCode"].ToString(); aCourseModel.courseName = reader["courseName"].ToString(); aCourseModel.courseCredit = Convert.ToDouble(reader["courseCredit"].ToString()); aCourseModel.courseDescription = reader["courseDescription"].ToString(); aCourseModel.departmentId = int.Parse(reader["departmentId"].ToString()); aCourseModel.semesterId = int.Parse(reader["semesterId"].ToString()); aCourseModel.Department = aDepartmentManager.GetDepartmentById(aCourseModel.departmentId); aCourseModel.Semester = aSemesterManager.GetSemesterById(aCourseModel.semesterId); courses.Add(aCourseModel); } connection.Close(); return(courses); }
protected void Page_Load(object sender, EventArgs e) { msgLabel.Text = ""; try { List <Department> departments = new List <Department>(); List <Semester> semester = new List <Semester>(); departmentDropDownList.DataTextField = "DepartmentCode"; departmentDropDownList.DataValueField = "departmentId"; semesterDropDownList.DataTextField = "SemesterName"; semesterDropDownList.DataValueField = "SemesterId"; aDepartmentManager = new DepartmentManager(); departments = aDepartmentManager.GetAllDepartments(); SemesterManager aSemesterManager = new SemesterManager(); semester = aSemesterManager.GetAllSemesters(); if (!IsPostBack) { departmentDropDownList.DataSource = departments; departmentDropDownList.DataBind(); semesterDropDownList.DataSource = semester; semesterDropDownList.DataBind(); } } catch (Exception exception) { msgLabel.ForeColor = Color.Red; msgLabel.Text = exception.Message; } }
public ActionResult <string> GetStudentsEnrolledToSubject(string id) { string semester = SemesterManager.GetCurrentSemester(); var students = _studentService.GetStudentsAttendedToSubject(id, semester); return(Ok(students)); }
public CourseController() { departmentManager = new DepartmentManager(); courseManager = new CourseManager(); semesterManager = new SemesterManager(); teacherManager = new TeacherManager(); }
public CourseController() { departmentManager = new DepartmentManager(); courseManager = new CourseManager(); semesterManager = new SemesterManager(); courseShowManager = new CourseShowManager(); enrollCourseManager = new EnrollCourseManager(); }
/// <summary> /// TODO Call Dispose Methods for each Manager. /// </summary> /// <param name="disposing"></param> protected override void Dispose(bool disposing) { if (disposing) { if (_pman != null) { _pman.Dispose(); _pman = null; } if (_sman != null) { _sman.Dispose(); _sman = null; } if (_sman != null) { _iman.Dispose(); _iman = null; } if (_dman != null) { _dman.Dispose(); _dman = null; } if (_cman != null) { _cman.Dispose(); _cman = null; } if (_tman != null) { _tman.Dispose(); _tman = null; } if (_aman != null) { _aman.Dispose(); _aman = null; } if (_pubman != null) { _pubman.Dispose(); _pubman = null; } if (_eman != null) { _eman.Dispose(); _eman = null; } if (_semman != null) { _semman.Dispose(); _semman = null; } base.Dispose(disposing); } }
public StudentResultController() { _courseManager = new CourseManager(); _departmentManager = new DepartmentManager(); _semesterManager = new SemesterManager(); aEnrollCourseManager = new EnrollCourseManager(); aGradeManager = new GradeManager(); aStudentResultManager = new StudentResultManager(); }
public ActionResult SaveCourse() { DepartmentManager aDepartmentManager = new DepartmentManager(); SemesterManager aSemesterManager = new SemesterManager(); ViewBag.departments = aDepartmentManager.GetAllDepartmentInfo(); ViewBag.semesters = aSemesterManager.GetAllSemester(); return(View()); }
protected void saveButton_Click(object sender, EventArgs e) { if (!IsValid) { return; } try { Course aCourse = new Course(); aCourse.CourseCode = codeTextBox.Value; aCourse.CourseName = titleTextBox.Value; aCourse.Credit = Convert.ToDouble(creditTextBox.Value); aCourse.Description = descriptionTextBox.Value; aCourse.CourseStatus = 0; aDepartmentManager = new DepartmentManager(); aCourse.ADepartment = aDepartmentManager.GetDepartment(Convert.ToInt16(departmentDropDownList.Text)); SemesterManager aSemesterManager = new SemesterManager(); aCourse.ASemester = aSemesterManager.GetSemester(Convert.ToInt16(semesterDropDownList.Text)); CourseManager aCourseManager = new CourseManager(); string msg = aCourseManager.SaveCourse(aCourse); if (msg == "Saved") { msgLabel.ForeColor = Color.Green; msgLabel.Text = msg; ClearAllTextBoxes(); } 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; } }
protected void Page_Load(object sender, EventArgs e) { msgLabel.Text = ""; try { departmentDropDownList.DataTextField = "DepartmentCode"; departmentDropDownList.DataValueField = "departmentId"; semesterDropDownList.DataTextField = "SemesterName"; semesterDropDownList.DataValueField = "SemesterId"; dayDropDownList.DataTextField = "dayName"; dayDropDownList.DataValueField = "dayId"; buildingDropDownList.DataTextField = "buildingName"; buildingDropDownList.DataValueField = "buildingId"; courseDropDownList.DataTextField = "courseCode"; courseDropDownList.DataValueField = "courseId"; roomDropDownList.DataTextField = "roomName"; roomDropDownList.DataValueField = "roomId"; if (!IsPostBack) { List <Course> courses = new List <Course>(); List <Day> days = new List <Day>(); List <Department> departments = new List <Department>(); List <Semester> semester = new List <Semester>(); List <Building> buildings = new List <Building>(); aDepartmentManager = new DepartmentManager(); departments = aDepartmentManager.GetAllDepartments(); SemesterManager aSemesterManager = new SemesterManager(); semester = aSemesterManager.GetAllSemesters(); aScheduleManager = new ScheduleManager(); buildings = aScheduleManager.GetAllBuildings(); days = aScheduleManager.GetAllDays(); aCourseManager = new CourseManager(); courses = aCourseManager.GetAllCourses(); dayDropDownList.DataSource = days; dayDropDownList.DataBind(); departmentDropDownList.DataSource = departments; departmentDropDownList.DataBind(); semesterDropDownList.DataSource = semester; semesterDropDownList.DataBind(); buildingDropDownList.DataSource = buildings; buildingDropDownList.DataBind(); courseDropDownList.DataSource = courses; courseDropDownList.DataBind(); } } catch (Exception exception) { msgLabel.ForeColor = Color.Red; msgLabel.Text = exception.Message; } }
public IEnumerable<StudentListItemDTO> GetStudentFromStudyGroupSearch(StudyGroupSearchDTO searchParams, string loggedInUserId) { if (loggedInUserId == null || !Guid.TryParse(loggedInUserId, out Guid userguid)) throw new ParameterException("user ID is invalid"); if (searchParams == null || searchParams.CourseID == null) throw new ParameterException("Search parameters cannot be null"); IEnumerable<Student> filteredStudents = new List<Student>(); var currentSemester = SemesterManager.GetCurrentSemester(); if (searchParams.IsHavingOtherCourseInCommonCurrently == true) { filteredStudents = _studentRepository.GetStudentsHavingCommonPracticalCoursesInCurrentSemester(loggedInUserId, searchParams.CourseID, currentSemester); } else { filteredStudents = _studentRepository.GetStudentsAttendingToCourseInCurrentSemester(loggedInUserId, searchParams.CourseID, currentSemester); } if (searchParams.IsSameCompletedSemesters && filteredStudents.Count() > 0) { //same completed semesters +-1 int userSemesterCnt = _studentRepository.GetStudentSemesterCount(loggedInUserId); var filteredOutStudents = new List<Student>(); foreach (var stud in filteredStudents) { int semesterCnt = _studentRepository.GetStudentSemesterCount(stud.UserID); if (Math.Abs(userSemesterCnt - semesterCnt) > 1) { filteredOutStudents.Add(stud); } } filteredStudents = filteredStudents.Where(x => !filteredOutStudents.Select(y => y.UserID).Contains(x.UserID)); } if (searchParams.IsSameGradeAverage && filteredStudents.Count() > 0) { //same avg +-0.5 double userGradeAvg = _studentRepository.GetStudentGradeAverage(loggedInUserId); var filteredOutStudents = new List<Student>(); foreach (var stud in filteredStudents) { double currStudAvg = _studentRepository.GetStudentGradeAverage(stud.UserID); if (Math.Abs(currStudAvg - userGradeAvg) > 0.5) { filteredOutStudents.Add(stud); } } filteredStudents = filteredStudents.Where(x => !filteredOutStudents.Select(y => y.UserID).Contains(x.UserID)); } var filteredStudentListDtos = filteredStudents.Select(x => MapStudent.MapStudentDBModelToStudentListItemDTO(x)); return filteredStudentListDtos; }
public IEnumerable <GeneralSelectionItem> GetAllLabourCoursesWithSubjectStudentEnrolledToCurrentSemester(string userID) { if (userID == null || !Guid.TryParse(userID, out Guid userGUID)) { throw new ParameterException("UserID is invalid"); } string currentSemester = SemesterManager.GetCurrentSemester(); var subjects = _courseRepository.FindLabourCoursesWithSubjectStudentCurrentlyEnrolledTo(userID, currentSemester); var subjectSelectionItems = subjects.Select(x => MapCourse.MapCourseProjectionToGeneralSelectionItem(x)); return(subjectSelectionItems); }
protected void Page_Load(object sender, EventArgs e) { msgLabel.Text = ""; try { departmentDropDownList.DataTextField = "DepartmentCode"; departmentDropDownList.DataValueField = "departmentId"; semesterDropDownList.DataTextField = "SemesterName"; semesterDropDownList.DataValueField = "SemesterId"; if (!IsPostBack) { List <Department> departments = new List <Department>(); List <Semester> semester = new List <Semester>(); aDepartmentManager = new DepartmentManager(); departments = aDepartmentManager.GetAllDepartments(); SemesterManager aSemesterManager = new SemesterManager(); semester = aSemesterManager.GetAllSemesters(); departmentDropDownList.DataSource = departments; departmentDropDownList.DataBind(); semesterDropDownList.DataSource = semester; semesterDropDownList.DataBind(); GetAllUnscheduleCourses(); } } 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 ActionResult SaveCourse(Course aCourse) { DepartmentManager aDepartmentManager = new DepartmentManager(); SemesterManager aSemesterManager = new SemesterManager(); ViewBag.departments = aDepartmentManager.GetAllDepartmentInfo(); ViewBag.semesters = aSemesterManager.GetAllSemester(); CourseManager aCourseManager = new CourseManager(); List <Course> alist = aCourseManager.GetAllCourse(); var coursecode = alist.FirstOrDefault(c => c.Code == aCourse.Code); var coursename = alist.FirstOrDefault(n => n.Name == aCourse.Name); if (coursecode != null || coursename != null) { if (coursecode != null && coursename != null) { ViewBag.message = "Code and Name Already Exist"; } else if (coursecode != null) { ViewBag.message = "Code Already Exist"; } else { ViewBag.message = "Name Already Exist"; } } else { if (aCourseManager.SaveCourse(aCourse) > 0) { ViewBag.message = "Course Saved Successfully"; } else { ViewBag.message = "Save Failed"; } } return(View()); }
public IEnumerable <SelectListItem> GetAllSemesterList() { List <SelectListItem> semesterLists = new List <SelectListItem>() { new SelectListItem() { Text = "---Select---", Value = "" }, }; List <Semester> semesters = new SemesterManager().GetAllSemesters(); foreach (Semester semester in semesters) { SelectListItem semesterListItem = new SelectListItem(); semesterListItem.Text = semester.SemesterName; semesterListItem.Value = semester.Id.ToString(); semesterLists.Add(semesterListItem); } return(semesterLists); }
public CourseController() { courseManager = new CourseManager(); departmentManager = new DepartmentManager(); semesterManager = new SemesterManager(); }
public CourseController() { aSemesterManager = new SemesterManager(); aDepartmentManager = new DepartmentManager(); aCourseManager = new CourseManager(); }
public SemesterController() { semesterManager = new SemesterManager(); }
public IEnumerable<StudentListItemDTO> GetStudentFromStudyBuddySearch(StudyBuddySearchDTO searchParams, string loggedInUserId) { if (searchParams == null) throw new ParameterException("Search parameters cannot be null"); if (searchParams.GoodInDiscipline < 0 || searchParams.GoodInDiscipline > Enum.GetValues(typeof(SubjectType)).Length) throw new ParameterException("Discipline value is invalid"); if (searchParams.ComletedWithGrade < 0 || searchParams.ComletedWithGrade > 5) throw new ParameterException("Grade value is invalid"); if (searchParams.SubjectID != "null" && !Guid.TryParse(searchParams.SubjectID, out Guid guid)) throw new ParameterException("Subject ID is invalid"); if (searchParams.IsAlreadyCompleted && searchParams.IsCurrentlyEnrolledTo) throw new ParameterException("Search parameters are invalid, already completed and currently enrolled to cant have true value at the same time."); List<Student> results = new List<Student>(); if (!(searchParams.SubjectID == null && searchParams.GoodInDiscipline == 0)) { if (searchParams.SubjectID != null) { if (!searchParams.IsAlreadyCompleted && !searchParams.IsCurrentlyEnrolledTo && !searchParams.IsCommonCourse) results = _studentRepository.GetStudentsEnrolledToSubject(searchParams.SubjectID).ToList(); string currentSemester = SemesterManager.GetCurrentSemester(); if (searchParams.IsCommonCourse) { results = _studentRepository.GetStudentsEnrolledToSubjectAndHavingCurrentlyCommonCourse(loggedInUserId, searchParams.SubjectID, currentSemester).ToList(); } if (searchParams.IsCurrentlyEnrolledTo) { if (results.Count != 0) { results = GetStudentsEnrolledToSubjectCurrently(searchParams.IsAttendingToAnotherTeacher, loggedInUserId, currentSemester, searchParams.SubjectID, results); } else if (searchParams.IsAttendingToAnotherTeacher) results = _studentRepository.GetStudentsCurrentlyEnrolledToSubjectWithStudentButHavingAnotherCurseTeacher(loggedInUserId, searchParams.SubjectID, currentSemester).ToList(); else results = _studentRepository.GetStudentsEnrolledToSubjectInSemester(searchParams.SubjectID, currentSemester).ToList(); } if (searchParams.IsAlreadyCompleted) { if (results.Count != 0) { results = GetStudentsAlreadyCompletedSubjectFromStudentList(searchParams.ComletedWithGrade, searchParams.SubjectID, results); } else if (searchParams.ComletedWithGrade != 0) results = _studentRepository.GetStudentsCompletedSubjectWithGrade(searchParams.SubjectID, searchParams.ComletedWithGrade).ToList(); else results = _studentRepository.GetStudentsCompletedSubject(searchParams.SubjectID).ToList(); } } if (searchParams.GoodInDiscipline != 0) { double betterThanAvg = 3.5; if (results.Count() != 0) results = GetStudentsGoodInDisciplineFromStudentList(results, searchParams.GoodInDiscipline, betterThanAvg); else results = _studentRepository.GetStudentsGoodInDiscipline(searchParams.GoodInDiscipline, betterThanAvg).ToList(); } } return results.Select(x => MapStudent.MapStudentDBModelToStudentListItemDTO(x)); }
public ActionResult SaveCourse(Course aCourse) { DepartmentManager aDepartmentManager = new DepartmentManager(); SemesterManager aSemesterManager = new SemesterManager(); ViewBag.departments = aDepartmentManager.GetAllDepartmentInfo(); ViewBag.semesters = aSemesterManager.GetAllSemester(); CourseManager aCourseManager = new CourseManager(); if (aCourse.Credit == 0.0 || aCourse.Code == null || aCourse.Name == null || aCourse.DepartmentId == 0 || aCourse.SemesterId == 0) { ViewBag.message = "Input Values"; } else { if (aCourse.Code.Length < 5 || (aCourse.Credit < 0.5 || aCourse.Credit > 5.0)) { if (aCourse.Code.Length < 5 && (aCourse.Credit < 0.5 || aCourse.Credit > 5.0)) { ViewBag.message = "Code length must be at least 5 characters and \n Credit range is from 0.5 to 5.0"; } else if (aCourse.Code.Length < 5) { ViewBag.message = "Code length must be at least 5 characters"; } else if (aCourse.Credit < 0.5 || aCourse.Credit > 5.0) { ViewBag.message = "Credit range is from 0.5 to 5.0"; } } else { List <Course> alist = aCourseManager.GetAllCourse(); var coursecode = alist.FirstOrDefault(c => c.Code == aCourse.Code); var coursename = alist.FirstOrDefault(n => n.Name == aCourse.Name); if (coursecode != null || coursename != null) { if (coursecode != null && coursename != null) { ViewBag.message = "Code and Name Already Exist"; } else if (coursecode != null) { ViewBag.message = "Code Already Exist"; } else if (coursename != null) { ViewBag.message = "Name Already Exist"; } } else { if (aCourseManager.SaveCourse(aCourse) > 0) { ViewBag.message = "Course Saved Successfully"; } else { ViewBag.message = "Save Failed"; } } } } return(View()); }
private void ProcessNeptunExports(Student student, IFormFile gradeBook, IFormFile courses) { //store file string courseServerPath = StoreFile(courses, "Exports"); string gradebookServerPath = StoreFile(gradeBook, "Exports"); string thisSemester = SemesterManager.GetCurrentSemester(); //TODO: execute these parallel //process subjects var gradebookExports = CSVProcesser.ProcessCSV <GradeBookExportModel>(gradebookServerPath); var createSubjects = GetNonExistingSubjectsFromExport(gradebookExports); //process course var courseExports = CSVProcesser.ProcessCSV <CourseExportModel>(courseServerPath); var createCourses = GetNonExistingCoursesFromExport(courseExports, thisSemester); //process teachers var createTeachers = GetNonExistingTeachersFromExport(courseExports); //write all to db if no error var subjectsNewlyCreated = new List <Subject>(); // todo: create list of nodes in neo4j level foreach (var sub in createSubjects) { subjectsNewlyCreated.Add(subjectRepository.Create(sub)); } var teachersNewlyCreated = new List <Teacher>(); foreach (var teacher in createTeachers) { teachersNewlyCreated.Add(teacherRepository.Create(teacher)); } //create relationships between nodes: //course-subject :BELONGS_TO foreach (var crs in createCourses) { courseRepository.CreateCourseBelongingToSubject(crs.Course, crs.SubjectCode); } //Teacher-course :TEACHES foreach (var courseExport in courseExports) { teacherRepository.CreateTeachesRelationshipWithCourseParams(courseExport.SubjectCode, courseExport.CourseCode, thisSemester, courseExport.TeacherName); } //Student-course :ATTENDS foreach (var cExp in courseExports) { var s = courseRepository.GetCourseWithSubject(cExp.CourseCode, cExp.SubjectCode, thisSemester); Guid courseID = s.CourseID; studentRepository.CreateAttendsToRelationShipWithCourse(Guid.Parse(student.UserID), courseID); } //Student-subject :ENROLLED_TO {grade: x} foreach (var item in gradebookExports) { Guid subjectID = Guid.Parse(subjectRepository.FindSubjectBySubjectCode(item.SubjectCode).SubjectID); var grade = item.GetGrade(); if (grade == null) { studentRepository.CreateEnrolledToRelationShipWithSubject(Guid.Parse(student.UserID), subjectID, item.Semester); } else { studentRepository.CreateEnrolledToRelationShipWithSubjectAndGrade(Guid.Parse(student.UserID), subjectID, item.Semester, (int)grade); } } Console.WriteLine(); }