public List <ProjectForListDto> GetProjectsTop20Score()
{
var data = new List <ProjectForListDto>();
foreach (var project in _context.Projects.Where(p => p.Status > 0).OrderByDescending(m => m.ProjectScore))
{
var proje = new ProjectForListDto();
proje.ProjectScore = project.ProjectScore;
var student = _context.Students.FirstOrDefault(f => f.StudentID == project.StudentID);
proje.StudentNameandSurname = student.StudentName + " " + student.StudentLastName;
proje.ProjectDescription = project.ProjectDescription;
proje.ProjectName = project.ProjectName;
proje.StudentID = student.StudentID;
proje.ProjectID = project.ProjectID;
proje.AcademicalPersonalName = project.AcademicalPersonalName;
data.Add(proje);
}
return(data);
}
public List <ProjectForListDto> GetProjectsInDepartment(int id)
{
var data = new List <ProjectForListDto>();
foreach (var project in _context.Projects.Where(d => d.DepartmentID == id).Where(p => p.Status > 0).ToList())
{
var proje = new ProjectForListDto();
proje.ProjectScore = project.ProjectScore;
var department = _context.Departments.FirstOrDefault(d => d.DepartmentID == project.DepartmentID);
proje.DepartmentName = department.DepartmentName;
var student = _context.Students.FirstOrDefault(f => f.StudentID == project.StudentID);
proje.StudentNameandSurname = student.StudentName + " " + student.StudentLastName;
proje.ProjectDescription = project.ProjectDescription;
proje.ProjectName = project.ProjectName;
proje.StudentID = student.StudentID;
proje.ProjectID = project.ProjectID;
proje.AcademicalPersonalName = project.AcademicalPersonalName;
data.Add(proje);
}
return(data);
}
