public List <ViewModelChooseCourse> ChooseCourse(ViewModelTeacherOfCheckboxGroup viewModelTeacherOfCheckboxGroup)
{
int studentid = int.Parse(viewModelTeacherOfCheckboxGroup.StudentId);
var data = (from u in unitOfWork.TeacherRepository.Get()
join ur in unitOfWork.TeacherCourseRepository.Get() on u.ID equals ur.TeacherId
join r in unitOfWork.CourseRepository.Get() on ur.CourseId equals r.ID
select new ViewModelChooseCourse {
CourseId = r.CourseId, CourseName = r.CourseName, CoursePlace = r.CoursePlace, WeekDay = r.WeekDay, StartTime = r.StartTime, OverTime = r.OverTime, Teachername = u.Name, TeacherCourseId = ur.ID
}).ToList();
var data2 = (from u in unitOfWork.TeacherRepository.Get()
join ur in unitOfWork.TeacherCourseRepository.Get() on u.ID equals ur.TeacherId
join r in unitOfWork.CourseRepository.Get() on ur.CourseId equals r.ID
select new ViewModelChooseCourse {
CourseId = r.CourseId, CourseName = r.CourseName, CoursePlace = r.CoursePlace, WeekDay = r.WeekDay, StartTime = r.StartTime, OverTime = r.OverTime, Teachername = u.Name, TeacherCourseId = ur.ID
}).ToList();
for (int i = 0; i < data.Count; i++)
{
var courseSelectInformation = unitOfWork.CourseSelectInformationRepository.Get().Where(s => s.TeacherCourseId.Equals(data[i].TeacherCourseId)).ToList();
for (int j = 0; j < courseSelectInformation.Count; j++)
{
if (courseSelectInformation[j].StudentId.Equals(studentid))
{
int index = data2.FindIndex(item => item.TeacherCourseId.Equals(data[i].TeacherCourseId));
data2.Remove(data2[index]);
break;
}
}
}
return(data2);
}
public List <ViewModelAllCourse> CheckboxGroupCourse(ViewModelTeacherOfCheckboxGroup viewModelTeacherOfCheckboxGroup)
{
var teacher = unitOfWork.TeacherRepository.Get().Where(s => s.Name.Equals(viewModelTeacherOfCheckboxGroup.TeacherName)).FirstOrDefault();
var data = (from u in unitOfWork.CourseRepository.Get()
select new ViewModelAllCourse {
CourseId = u.CourseId, CourseName = u.CourseName, CoursePlace = u.CoursePlace, StartTime = u.StartTime, OverTime = u.OverTime, WeekDay = u.WeekDay, ID = u.ID
}).ToList();
var data2 = (from u in unitOfWork.CourseRepository.Get()
select new ViewModelAllCourse {
CourseId = u.CourseId, CourseName = u.CourseName, CoursePlace = u.CoursePlace, StartTime = u.StartTime, OverTime = u.OverTime, WeekDay = u.WeekDay, ID = u.ID
}).ToList();
for (int i = 0; i < data.Count; i++)
{
var teacherscourse = unitOfWork.TeacherCourseRepository.Get().Where(s => s.CourseId.Equals(data[i].ID)).ToList();
for (int j = 0; j < teacherscourse.Count; j++)
{
if (teacherscourse[j].TeacherId.Equals(teacher.ID))
{
int index = data2.FindIndex(item => item.ID.Equals(data[i].ID));
data2.Remove(data2[index]);
break;
}
}
}
return(data2);
}
public List <ViewModelAllCourse> CourseOfTeacher(ViewModelTeacherOfCheckboxGroup viewModelTeacherOfCheckboxGroup)
{
var teacher = unitOfWork.TeacherRepository.Get().Where(s => s.Name.Equals(viewModelTeacherOfCheckboxGroup.TeacherName)).FirstOrDefault();
var data = (from u in unitOfWork.TeacherRepository.Get()
join ur in unitOfWork.TeacherCourseRepository.Get() on u.ID equals ur.TeacherId
join r in unitOfWork.CourseRepository.Get() on ur.CourseId equals r.ID
where ur.TeacherId.Equals(teacher.ID)
select new ViewModelAllCourse {
CourseId = r.CourseId, CourseName = r.CourseName, CoursePlace = r.CoursePlace, WeekDay = r.CoursePlace, StartTime = r.StartTime, OverTime = r.OverTime
}).ToList();
return(data);
}
public List <ViewModelChooseCourse> SelectedCourse(ViewModelTeacherOfCheckboxGroup viewModelTeacherOfCheckboxGroup)
{
var data = (from u in unitOfWork.StudentRepository.Get()
join ur in unitOfWork.CourseSelectInformationRepository.Get() on u.ID equals ur.StudentId
join r in unitOfWork.TeacherCourseRepository.Get() on ur.TeacherCourseId equals r.ID
join vr in unitOfWork.CourseRepository.Get() on r.CourseId equals vr.ID
join wr in unitOfWork.TeacherRepository.Get() on r.TeacherId equals wr.ID
where ur.StudentId.Equals(int.Parse(viewModelTeacherOfCheckboxGroup.StudentId))
select new ViewModelChooseCourse {
CourseId = vr.CourseId, CourseName = vr.CourseName, CoursePlace = vr.CoursePlace, WeekDay = vr.WeekDay, StartTime = vr.StartTime, OverTime = vr.OverTime, Teachername = wr.Name, TeacherCourseId = r.ID
}).ToList();
return(data);
}
