public ActionResult CourseDetails(int courseId) { CourseTeacherViewModel model = new CourseTeacherViewModel(); Course course = db.Courses.Find(courseId); model.Course = course; List <ParagraphTeacherViewModel> paragraphsModel = new List <ParagraphTeacherViewModel>(); var listPar = db.Paragraphs.Where(p => p.CourseId == courseId).ToList(); foreach (var paragraph in listPar) { List <TestTeacherViewModel> testsModel = new List <TestTeacherViewModel>(); var listTest = db.Tests.Where(t => t.ParagraphId == paragraph.Id).ToList(); foreach (var test in listTest) { List <Question> queModel = new List <Question>(); var listQue = db.Questions.Where(q => q.TestId == test.Id).ToList(); TestTeacherViewModel testM = new TestTeacherViewModel() { Test = test, QuestionModels = queModel }; testsModel.Add(testM); } ParagraphTeacherViewModel paragraphM = new ParagraphTeacherViewModel() { Paragraph = paragraph, TestsModel = testsModel }; paragraphsModel.Add(paragraphM); } model.ParagraphsModwl = paragraphsModel; List <CourseTeacherViewModel> list = new List <CourseTeacherViewModel>(); list.Add(model); return(View(model)); }
public List <CourseTeacherViewModel> GetAllCourses(CourseTeacherViewModel courseTeacherViewModel) { Command.CommandText = @"select c.Code as CourseCode,c.Name CourseName,s.Name as SemesterName,c.CourseAssignTo as CourseTeacher,c.Status as CourseStatus from Course c left join Department d on c.DepartmentId=d.Id left join Semester s on c.SemesterId=s.Id where d.Id='" + courseTeacherViewModel.DepartmentId + "' order by c.Name"; Connection.Open(); SqlDataReader reader = Command.ExecuteReader(); List <CourseTeacherViewModel> courseTeacherViewModels = new List <CourseTeacherViewModel>(); CourseTeacherViewModel ect = null; //temp.Code = reader["Code"] != null ? reader["Code"].ToString() : "-1"; if (reader.HasRows) { while (reader.Read()) { ect = new CourseTeacherViewModel(); ect.CourseCode = reader["CourseCode"].ToString(); ect.CourseName = reader["CourseName"].ToString(); ect.SemesterName = reader["SemesterName"].ToString(); ect.TeacherName = reader["CourseTeacher"].ToString(); ect.CourseStatus = reader["CourseStatus"].ToString(); courseTeacherViewModels.Add(ect); } } reader.Close(); Connection.Close(); return(courseTeacherViewModels); }
// GET: Courses public async Task <IActionResult> Index(string SearchTitle, string SearchSemester, string SearchProgramme) { IQueryable <Course> courses = _context.Course.AsQueryable(); IQueryable <Teacher> teachers = _context.Teacher.AsQueryable(); if (!string.IsNullOrEmpty(SearchTitle)) { courses = courses.Where(s => s.Title.Contains(SearchTitle)); } if (!string.IsNullOrEmpty(SearchSemester)) { courses = courses.Where(s => s.Semester.ToString().Contains(SearchSemester)); } if (!string.IsNullOrEmpty(SearchProgramme)) { courses = courses.Where(s => s.Programme.ToString().Contains(SearchProgramme)); } //courses = courses.Include(m => m.FirstTeacher) var courseTeacherVM = new CourseTeacherViewModel { Courses = await courses.ToListAsync(), Teachers = await teachers.ToListAsync() }; return(View(courseTeacherVM)); }
public ActionResult CourseTeacher() { var courseTeacher = new CourseTeacherViewModel(); var teacherList = context.Users.Where(m => m.TeacherUserProfile != null).Select(m => m.TeacherUserProfile).ToList <TeacherUserProfile>(); courseTeacher.TeacherCollection = teacherList; courseTeacher.CourseCollection = context.Courses.ToList(); return(View(courseTeacher)); }
public void Test_GetFirstTeacher_Should_Return_Non_Null() { // Arrange const string username = "******"; // Act CourseTeacherViewModel teacherVm = this.coursesService.GetFirstTeacher(); // Assert Assert.IsNotNull(teacherVm); Assert.AreEqual(username, teacherVm.UserName); }
public ActionResult CourseTeacher(CourseTeacherViewModel model) { if (ModelState.IsValid) { var course = context.Courses.Include(c => c.TeacherUserProfile).Single(m => m.Id.ToString() == model.CourseID); var teacherList = context.Users.Where(m => m.TeacherUserProfile != null).Select(m => m.TeacherUserProfile).ToList <TeacherUserProfile>(); var teacher = teacherList.Single(s => s.Id.ToString() == model.TeacherID); course.TeacherUserProfile.Add(teacher); context.SaveChanges(); return(RedirectToAction("Home", "Portal")); } return(View(model)); }
public ActionResult Index(CourseTeacherViewModel model) { if (model.searchText != null && model.searchText.Trim().Length > 0) { model.teacherPagedList = db.CourseTeacher .Where(t => t.name.Contains(model.searchText) || t.orgName.Contains(model.searchText)) .OrderBy(t => t.name) .ToPagedList(model.pageNumber - 1, model.pageSize); } else { model.teacherPagedList = db.CourseTeacher.OrderBy(t => t.name).ToPagedList(model.pageNumber - 1, model.pageSize); } return(View(model)); }
public string Save(CourseTeacherViewModel aCourseTeacherViewModel) { CourseAssignTeacher aCourseAssignTeacher = new CourseAssignTeacher(); aCourseAssignTeacher.TeacherId = aCourseTeacherViewModel.TeacherId; aCourseAssignTeacher.DepartmentId = aCourseTeacherViewModel.DepartmentId; aCourseAssignTeacher.CourseId = aCourseTeacherViewModel.CourseId; aCourseAssignTeacher.CreditTaken = aCourseTeacherViewModel.CourseCredit; aCourseAssignTeacher.IsActive = true; bool flag = aUnitOfWork.Repository <CourseAssignTeacher>().InsertModel(aCourseAssignTeacher); aUnitOfWork.Save(); return("Assigned Successfully"); }
public ActionResult Create(CourseTeacherViewModel aCourseTeacherViewModel) { try { IEnumerable <Department> departments = aDepartmentManager.GetAllDepartment(); ViewBag.DeptList = new SelectList(departments, "Id", "Name"); IEnumerable <Teacher> teachers = new List <Teacher>(); ViewBag.TeacherList = new SelectList(teachers, "Id", "Name"); IEnumerable <Course> courses = new List <Course>(); ViewBag.CourseList = new SelectList(courses, "Id", "Code"); string msg = aCourseAssignToTeacherManager.Save(aCourseTeacherViewModel); ViewBag.message = msg; ModelState.Clear(); return(View(new CourseTeacherViewModel())); } catch { return(View()); } }
public CourseViewModel getAllTeachersInCourse(int courseId) { //Sæki alla kennara námskeiðs var teacher = (from courses in _db.Course join courseTeacher in _db.CourseTeacher on courses.courseId equals courseTeacher.courseId join user in _db.User on courseTeacher.userId equals user.userId where courses.courseId == courseId select new { courses, user, courseTeacher }).ToList(); //Bý til lista af kennurum(CourseTeacherViewModel) List <CourseTeacherViewModel> teacherList; teacherList = new List <CourseTeacherViewModel>(); //Loopa í gegnum listann úr gagnagrunninum og set inn í áfanga listann foreach (var entity in teacher) { var result = new CourseTeacherViewModel { CourseTeacherId = entity.courseTeacher.courseTeacherId, CourseId = entity.courses.courseId, UserId = entity.courseTeacher.userId, MainTeacher = entity.courseTeacher.mainTeacher, TeacherName = entity.user.name, TeacherUserName = entity.user.userName }; teacherList.Add(result); } //Bý til nýtt CourseViewModel og set listann inn í það CourseViewModel viewModel = new CourseViewModel { TeacherList = teacherList }; //Returna viewModelinu með listanum return(viewModel); }
public ActionResult AssignCourse(EnrollCourseTeacher enrollCourseTeacher) { CourseTeacherViewModel ctvm = _courseManager.IsCourseAssigned(enrollCourseTeacher); if (ctvm == null) { bool rowAffected = _teacherManager.EnrollCourseAndTeacher(enrollCourseTeacher); if (rowAffected) { ViewBag.SuccessMessage = "Course and Teacher Enroll Successfullly"; } else { ViewBag.ErrorMessage = "Course and Teacher Enroll Failed"; } } else { ViewBag.ErrorMessage = "Assign Failed! " + ctvm.CourseName + " already enrolled to " + ctvm.TeacherName; } ViewBag.Department = _departmentManager.GetAllDepartments(); return(View()); }
public CourseTeacherViewModel IsCourseAssigned(EnrollCourseTeacher enrollCourseTeacher) { Command.CommandText = @"select c.Id as CourseId,c.Name as CourseName, c.CourseAssignTo as TeacherName from Course c where c.Id='" + enrollCourseTeacher.CourseId + "' and c.Status='assigned'"; Connection.Open(); SqlDataReader reader = Command.ExecuteReader(); CourseTeacherViewModel ect = null; if (reader.HasRows) { while (reader.Read()) { ect = new CourseTeacherViewModel(); ect.CourseId = (int)reader["CourseId"]; ect.CourseName = reader["CourseName"].ToString(); ect.TeacherName = reader["TeacherName"].ToString(); } } reader.Close(); Connection.Close(); return(ect); }
public ActionResult Index() { CourseTeacherViewModel model = new CourseTeacherViewModel(); return(Index(model)); }
public List <CourseTeacherViewModel> GetAllCourses(CourseTeacherViewModel courseTeacherViewModel) { return(_courseGateway.GetAllCourses(courseTeacherViewModel)); }
public JsonResult GetAllCourses(CourseTeacherViewModel courseTeacherViewModel) { List <CourseTeacherViewModel> courseTeacherViewModels = _courseManager.GetAllCourses(courseTeacherViewModel); return(Json(courseTeacherViewModels, JsonRequestBehavior.AllowGet)); }