public IEnumerable <ClassInfoViewModel> GetAllClasses()
{
var classes = new List <ClassInfoViewModel>();
try
{
var courses = _dbQueries.GetAllCourses();
foreach (var course in courses)
{
var studentClass = new ClassInfoViewModel();
var professorInfo = _dbQueries.GetProfessorInfo(course.Prof_Id.Value);
var taInfo = _dbQueries.GetTaInCourse(course.Id);
if (course.Name != null && professorInfo.Name != null)
{
studentClass.UserId = -1;
studentClass.ClassCodeName = course.Id;
studentClass.ClassName = course.Name;
studentClass.Instructor = professorInfo.Name;
studentClass.TeachingAssistant = taInfo == null ? "" : taInfo.Name;
}
classes.Add(studentClass);
}
return(classes);
}
catch (Exception e)
{
Console.WriteLine(e);
return(classes);
}
}
public IEnumerable <ClassInfoViewModel> GetClassInfo(int studentId)
{
var classes = new List <ClassInfoViewModel>();
try
{
var studentTakesCourses = _dbQueries.GetStudentCourses(studentId);
foreach (var course in studentTakesCourses)
{
var studentClass = new ClassInfoViewModel();
var courseInfo = _dbQueries.GetCourseInfo(course.Course_Id);
var professorInfo = _dbQueries.GetProfessorInfo(courseInfo.Prof_Id.Value);
if (courseInfo.Name != null && professorInfo.Name != null)
{
studentClass.UserId = studentId;
studentClass.ClassCodeName = courseInfo.Id;
studentClass.ClassName = courseInfo.Name;
studentClass.Instructor = professorInfo.Name;
}
classes.Add(studentClass);
}
return(classes);
}
catch (Exception e) {
Console.WriteLine(e);
return(classes);
}
}
