public async Task <IActionResult> Edit(int id, [Bind("Id,CourseId,StudentId")] StudentCourses studentCourses) { if (id != studentCourses.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(studentCourses); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!StudentCoursesExists(studentCourses.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index", "Courses")); } ViewData["CourseId"] = new SelectList(_context.Courses, "Id", "Title", studentCourses.CourseId); ViewData["StudentId"] = new SelectList(_context.Students, "Id", "Name", studentCourses.StudentId); return(View(studentCourses)); }
public List <StudentCourses> GetAllStudentsView() { string query = "SELECT * FROM VW_StudentCoursesGrade"; SqlCommand.CommandText = query; SqlConnection.Open(); SqlDataReader reader = SqlCommand.ExecuteReader(); List <StudentCourses> studentCourseses = new List <StudentCourses>(); while (reader.Read()) { StudentCourses studentCourse = new StudentCourses { StudentId = Convert.ToInt32(reader["Student_Id"].ToString()), CourseId = Convert.ToInt32(reader["Course_Id"].ToString()), CourseCode = reader["Code"].ToString(), CourseName = reader["Name"].ToString(), GradeName = reader["GradeName"].ToString() != string.Empty ? reader["GradeName"].ToString() : "Not Graded Yet", EnrollDate = DateTime.Parse(reader["EnrollDate"].ToString()) }; studentCourseses.Add(studentCourse); } reader.Close(); SqlConnection.Close(); return(studentCourseses); }
public void AssignCourseToStudent(int courseId, int studentId) { Course course = db.Courses.Include(c => c.StudentCourses).ThenInclude(sc => sc.Student).FirstOrDefault(c => c.Id == courseId); Member student = db.Members.Include(m => m.StudentCourses).ThenInclude(sc => sc.Course).FirstOrDefault(m => m.Id == studentId); if (student.StudentCourses.Any(sc => sc.CourseId == courseId)) { throw new Exception("The course you are trying to add is already in your schedule."); } else if (student.StudentCourses.Any(sc => sc.Course.StartTime == course.StartTime && sc.Course.StartDate == course.StartDate)) { throw new Exception("This course is at the same time as another course in your schedule."); } else if (((student.StudentCourses.Sum(sc => sc.Course.CreditHours) + course.CreditHours) > MaxCreditHours)) { throw new Exception("Adding this course to your schedule will exceed the amount of credit hours allowed."); } else if (course.StudentCourses.Count() >= course.StudentCapacity) { throw new Exception("The course you are attemptint to add is already full."); } StudentCourses studentCourses = new StudentCourses() { StudentId = studentId, Student = student, CourseId = courseId, Course = course }; course.StudentCourses.Add(studentCourses); db.SaveChanges(); }
public ActionResult DeleteStudentCourse(int?id) { StudentCourses student = db.StudentCourseEntity.Find(id); db.StudentCourseEntity.Remove(student); db.SaveChanges(); return(RedirectToAction("StudentIndex")); }
public ActionResult DeleteConfirmed(int id) { StudentCourses studentcourses = db.StudentCourses.Find(id); db.StudentCourses.Remove(studentcourses); db.SaveChanges(); return(RedirectToAction("Index")); }
public int UpdateAllStudentCourse(StudentCourses studentCourses) { string query = "UPDATE StudentCourses SET GradeId = '" + studentCourses.GradeId + "' WHERE Student_Id = '" + studentCourses.StudentId + "' AND Course_Id = '" + studentCourses.CourseId + "'"; SqlCommand.CommandText = query; SqlConnection.Open(); int rowAffected = SqlCommand.ExecuteNonQuery(); SqlConnection.Close(); return(rowAffected); }
public void Fetch(string filepath1, string filepath2, string filepath3) { FetchStudent(filepath1); FetchCourse(filepath2); FetchStudentCourse(filepath3); foreach (string line in StudentList) { if (line == StudentList[0]) { continue; } else { string[] properties = line.Split(','); Students.Add(new Student { StudentID = Int32.Parse(properties[0]), StudentName = properties[1], StudentAddress = properties[2], PhoneNumber = properties[3] }); } } foreach (string line in CourseList) { if (line == CourseList[0]) { continue; } else { string[] properties = line.Split(','); Courses.Add(new Course { CourseID = Int32.Parse(properties[0]), CourseName = properties[1] }); } } foreach (string line in StudentCourseList) { if (line == StudentCourseList[0]) { continue; } else { string[] properties = line.Split(','); StudentCourses.Add(new StudentCourse { id = Int32.Parse(properties[0]), StudentID = Int32.Parse(properties[1]), CourseID = Int32.Parse(properties[2]) }); } } }
public async Task <IActionResult> Create([Bind("StudentCourseId,StudentId,CourseName")] StudentCourses studentCourses) { if (ModelState.IsValid) { _context.Add(studentCourses); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["StudentId"] = new SelectList(_context.Students, "StudentId", "StudentId", studentCourses.StudentId); return(View(studentCourses)); }
public ActionResult Edit([Bind(Include = "ID,StudentID,CourseID,AssignedOn")] StudentCourses studentcourses) { if (ModelState.IsValid) { db.Entry(studentcourses).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseID = new SelectList(db.Courses, "ID", "Code", studentcourses.CourseID); ViewBag.StudentID = new SelectList(db.Students, "ID", "Name", studentcourses.StudentID); return(View(studentcourses)); }
// GET: /StudentCourses/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentCourses studentcourses = db.StudentCourses.Find(id); if (studentcourses == null) { return(HttpNotFound()); } return(View(studentcourses)); }
public void CoursesforStudent(int id) { // IEnumerable<StudentCourse> result = new List<StudentCourse>(); IEnumerable <StudentCourse> studentcourse = new List <StudentCourse>(); studentcourse = StudentCourses.Where(s => s.StudentID == id); foreach (StudentCourse scourse in studentcourse) { // course = Courses.Where(c => c.CourseID == scourse.CourseID).ToList(); Course course = new Course(); course = Courses.Find(c => c.CourseID == scourse.CourseID); result.Add(course); } }
public async Task <StudentCourses> GetCourseToStudentAsync(Guid studentId) { var student = await GetStudentAsync(studentId); var model = new StudentCourses { Student = new StudentsForDisplay { Id = student.Id, Name = student.FirstName }, CurrentCourseIds = _uow.GetRepository <CourseUser>().Where(x => x.UserId == studentId).Select(x => x.CourseId).ToArray(), Courses = GetList().ToDictionary(x => x.Id, x => x.Name) }; return(model); }
public void AssignStudentToCourse(int studentId, int courseId) { Course course = GetCourse(courseId); Member student = GetStudent(studentId); StudentCourses studentCourses = new StudentCourses() { StudentId = studentId, Student = student, CourseId = courseId, Course = course }; course.StudentCourses.Add(studentCourses); db.SaveChanges(); }
public void RemoveStudentFromCourse(int studentId, int courseId) { Member student = db.Members.FirstOrDefault(m => m.Id == studentId); Course course = db.Courses.FirstOrDefault(c => c.Id == courseId); StudentCourses studentCourses = new StudentCourses() { StudentId = studentId, Student = student, CourseId = courseId, Course = course }; course.StudentCourses.Remove(studentCourses); db.SaveChanges(); }
// GET: /StudentCourses/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentCourses studentcourses = db.StudentCourses.Find(id); if (studentcourses == null) { return(HttpNotFound()); } ViewBag.CourseID = new SelectList(db.Courses, "ID", "Code", studentcourses.CourseID); ViewBag.StudentID = new SelectList(db.Students, "ID", "Name", studentcourses.StudentID); return(View(studentcourses)); }
public async Task <bool> AddStudentCourse(StudentCourseInputDto input) { if (input != null) { foreach (var course in input.Courses) { StudentCourses s1 = new StudentCourses(); s1.CourseGuid = course.Id.Value; s1.StudentGuid = input.StudentGuid; _context.Add(s1); } } await _context.SaveChangesAsync(); return(true); }
public void AddStudentToCourse(int studentId, int courseId) { StudentCourses studentCourses = new StudentCourses() { CourseId = courseId, StudentId = studentId }; try { data.studentCourses.Add(studentCourses); } catch (Exception ex) { logger.Log(ex.Message); } }
public ActionResult courseSelected(string[] courses) { string course_id = Request["course"]; string student_id = Request["user_id"]; // int[] nums = Array.ConvertAll(course_id.Split(','), int.Parse); for (int i = 0; i < courses.Length; i++) { StudentCourses coursess = new StudentCourses(); coursess.SID = student_id; coursess.CID = courses[i]; db.StudentCourses.Add(coursess); db.SaveChanges(); } return(Content(student_id)); }
public static void Seed(ModelBuilder modelBuilder) { //create arrays for each entity var teachers = new Teacher[] { //put teachers here new Teacher{Id=1,Firstname="TopDog",Lastname="Soete" }, new Teacher{Id=2,Firstname="Willie",Lastname="Schokellé" }, new Teacher{Id=3,Firstname="Sieggie",Lastname="Derdeyn" } }; var students = new Student[] { //put students here new Student{Id=1,Firstname="Jimmy",Lastname="Page" }, new Student{Id=2,Firstname="Rory",Lastname="Gallagher" }, new Student{Id=3,Firstname="Pino",Lastname="Daniele" }, }; var courses = new Course[] { //put courses here new Course{Id=1,Title="WBA",TeacherId=3 }, new Course{Id=2,Title="WFA",TeacherId=2 }, new Course{Id=3,Title="DBS",TeacherId=1 } }; var studentCourses = new StudentCourses[] { //put studentCourses here new StudentCourses{StudentId=1,CourseId=2}, new StudentCourses{StudentId=1,CourseId=1}, new StudentCourses{StudentId=1,CourseId=3}, new StudentCourses{StudentId=2,CourseId=1}, new StudentCourses{StudentId=2,CourseId=2}, new StudentCourses{StudentId=2,CourseId=3}, new StudentCourses{StudentId=3,CourseId=1}, new StudentCourses{StudentId=3,CourseId=2}, new StudentCourses{StudentId=3,CourseId=3}, }; //add the seeding data to the entity HasData() modelBuilder.Entity<Teacher>().HasData(teachers); modelBuilder.Entity<Student>().HasData(students); modelBuilder.Entity<Course>().HasData(courses); modelBuilder.Entity<StudentCourses>().HasData(studentCourses); }
public async Task <IActionResult> DeleteStudentCourses([FromBody] StudentCourses studentCourses) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var studentCoursesEntry = await _context.StudentCourses.FindAsync(studentCourses.StudentId, studentCourses.CourseId); if (studentCoursesEntry == null) { return(NotFound()); } _context.StudentCourses.Remove(studentCoursesEntry); await _context.SaveChangesAsync(); return(Ok(studentCoursesEntry)); }
public async Task <IActionResult> PostStudentCourses([FromBody] StudentCourses studentCourses) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var course = _context.Courses.FirstOrDefault(c => c.Id == studentCourses.CourseId); var student = _context.Students.FirstOrDefault(s => s.Id == studentCourses.StudentId); if (course == null || student == null) { return(BadRequest()); } var studentCoursesEntry = new StudentCourses { CourseId = course.Id, StudentId = student.Id, Course = course, Student = student }; _context.StudentCourses.Add(studentCoursesEntry); try { await _context.SaveChangesAsync(); } catch (DbUpdateException) { if (StudentCoursesExists(studentCourses.StudentId)) { return(new StatusCodeResult(StatusCodes.Status409Conflict)); } else { throw; } } return(CreatedAtAction("GetStudentCourses", new { id = studentCoursesEntry.StudentId }, studentCoursesEntry)); }
public ActionResult StudentIndex(String Courses) { int courseID = Int32.Parse(Courses); Courses course = db.CoursesEntity.Find(courseID); StudentCourses student = new StudentCourses(); student.Username = User.Identity.Name; student.CourseId = courseID; student.CourseName = course.CourseName; student.CourseCredits = course.CourseCredits; student.LecturerId = course.LecturerId; student.LecturerName = course.LecturerName; student.LecturerLastname = course.LecturerLastname; db.StudentCourseEntity.Add(student); db.SaveChanges(); return(RedirectToAction("StudentIndex")); }
public ActionResult SaveResult(StudentCourses studentCourses) { List <StudentCourses> studentIds = studentCoursesManager.GetAllStudentCourse().Where(a => a.StudentId == studentCourses.StudentId && a.CourseId == studentCourses.CourseId).ToList(); if (ModelState.IsValid) { var count = studentIds.Count; if (count == 1) { foreach (var item in studentIds) { if (item.GradeId == string.Empty) { ViewBag.Message = studentCoursesManager.UpdateAllStudentCourse(studentCourses) ? " Student result saved Successfully" : "Student result is not Saved"; } else { ViewBag.FailMessage = "Result has Already asigned to this student"; } } } else { ViewBag.FailMessage = "You are not enrolled in the course! Please enrolled first!!"; } } else { ViewBag.FailMessage = "Please Fill Up Data properly!!"; } List <Student> students = studentMangager.GetAllStudents(); ViewBag.studentsList = students; List <Grade> grades = gradeManager.GetAllGrades(); ViewBag.gradesList = grades; return(View()); }
public IActionResult Assign(int id) { var record = _teacherCoursesRepository.GetById(id); if (record == null) { return(NotFound()); } var user = _usersRepository.GetByName(HttpContext.User.Identity.Name).GetAwaiter().GetResult(); var item = new StudentCourses { CourseId = id, UserId = user.Id }; _teacherCoursesRepository.AssignToCourse(item); return(Ok()); }
public int SaveAllStudentCourses(StudentCourses studentCourses) { string query = "INSERT INTO StudentCourses(Student_Id,Course_Id,EnrollDate) VALUES(@studentId,@courseId,@enrollDate)"; SqlCommand.CommandText = query; SqlCommand.Parameters.Clear(); SqlCommand.Parameters.Add("@studentId", SqlDbType.Int); SqlCommand.Parameters["@studentId"].Value = studentCourses.StudentId; SqlCommand.Parameters.Add("@courseId", SqlDbType.Int); SqlCommand.Parameters["@courseId"].Value = studentCourses.CourseId; SqlCommand.Parameters.Add("@enrollDate", SqlDbType.Date); SqlCommand.Parameters["@enrollDate"].Value = studentCourses.EnrollDate; SqlConnection.Open(); int rowaffected = SqlCommand.ExecuteNonQuery(); SqlConnection.Close(); return(rowaffected); }
public ActionResult EnrollCourse(StudentCourses studentCourses) { List <StudentCourses> studentIds = studentCoursesManager.GetAllStudentCourse().Where(a => a.StudentId == studentCourses.StudentId && a.CourseId == studentCourses.CourseId).ToList(); if (ModelState.IsValid) { if (studentIds.Count == 0) { ViewBag.Message = studentCoursesManager.SaveAllStudentCourse(studentCourses) ? "Student enrolled into department successfully!" : "Student Enrolled is not Saved Successfully"; } else { ViewBag.FailMessage = "Student has already enrolled in this course."; } } List <Student> students = studentMangager.GetAllStudents(); ViewBag.studentsList = students; return(View()); }
public List <StudentCourses> GetAllStudentCourse() { string query = "SELECT * FROM StudentCourses"; SqlCommand.CommandText = query; SqlConnection.Open(); SqlDataReader reader = SqlCommand.ExecuteReader(); List <StudentCourses> studentCourseses = new List <StudentCourses>(); while (reader.Read()) { StudentCourses studentCourse = new StudentCourses { StudentId = Convert.ToInt32(reader["Student_Id"].ToString()), CourseId = Convert.ToInt32(reader["Course_Id"].ToString()), GradeId = reader["GradeId"].ToString(), }; studentCourseses.Add(studentCourse); } reader.Close(); SqlConnection.Close(); return(studentCourseses); }
public async Task <IActionResult> PutStudentCourses([FromRoute] string IdentityId, [FromRoute] int CourseId, [FromBody] StudentCourses studentCourses) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } // IdentityId should replaced with StudentId if (IdentityId != studentCourses.Student.IdentityId || CourseId != studentCourses.CourseId) { return(BadRequest()); } _context.Entry(studentCourses).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { // studentCourses.StudentId should be StudentId that will have to be in the parameters instead of IdentityId if (!StudentCoursesExists(studentCourses.StudentId, CourseId)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public bool UpdateAllStudentCourse(StudentCourses studentCourses) { return(studentCoursesGateway.UpdateAllStudentCourse(studentCourses) > 0); }
public bool SaveAllStudentCourse(StudentCourses studentCourses) { return(studentCoursesGateway.SaveAllStudentCourses(studentCourses) > 0); }