public List <ScheduleSubjectResponseDto> GetScheduleSubjectsByStudentId(int id, SemesterIdDto semesterId)
{
try
{
var student = db.Students.FirstOrDefault(x => !x.DelFlag && x.UserId == id);
if (student == null)
{
return(null);
}
var classId = student.ClassId;
return(GetScheduleSubjectsByClassId(classId, semesterId));
}
catch (Exception e)
{
throw e;
}
}
public List <TeachingScheduleResponseDto> GetTeachingScheduleByTeacherId(int id, SemesterIdDto semesterId)
{
try
{
var teacher = db.Teachers.FirstOrDefault(x => !x.DelFlag && x.UserId == id);
if (teacher == null)
{
return(null);
}
var list = db.ScheduleSubjects.Include(t => t.Teacher).Include(c => c.Class).Include(s => s.Subject).Include(d => d.DayOfWeekLesson)
.Where(x => !x.DelFlag && x.Teacher.UserId == id && x.SemesterId == semesterId.id).ToList()
.Select(y => new TeachingScheduleResponseDto
{
Id = y.Id,
ClassName = y.Class.Name,
Room = GetRoomNumber(y.ClassId),
DayOfWeek = y.DayOfWeekLesson.DayOfWeek,
Lesson = y.DayOfWeekLesson.Lesson
}).OrderBy(x => x.DayOfWeek).ToList();
return(list ?? new List <TeachingScheduleResponseDto>());
}
catch (Exception e)
{
throw e;
}
}
public List <ScheduleSubjectResponseDto> GetScheduleSubjectsByClassId(int id, SemesterIdDto semesterId)
{
try
{
var Class = db.Classes.FirstOrDefault(x => !x.DelFlag && x.Id == id);
if (Class == null)
{
return(null);
}
var list = db.ScheduleSubjects.Include(t => t.Teacher).Include(c => c.Class).Include(s => s.Subject).Include(d => d.DayOfWeekLesson)
.Where(x => !x.DelFlag && x.ClassId == id && x.SemesterId == semesterId.id).ToList()
.Select(y => new ScheduleSubjectResponseDto
{
Id = y.Id,
SubjectName = y.Subject.Name,
ClassName = y.Class.Name,
TeacherName = _teacherService.GetTeacherName(y.TeacherId),
DayOfWeek = y.DayOfWeekLesson.DayOfWeek,
Lesson = y.DayOfWeekLesson.Lesson
}).OrderBy(x => x.DayOfWeek).OrderBy(x => x.Lesson).ToList();
return(list ?? new List <ScheduleSubjectResponseDto>());
}
catch (Exception e)
{
throw e;
}
}
