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));
}
