public ActionResult TestIndex()
{
var kurs = new Course()
{
Id = 1, Name = "Komple Uygulamalı Web Geliştirme Kursu"
};
var ogrenciler = new List <StudentData>()
{
new StudentData()
{
name = "Ali"
},
new StudentData()
{
name = "Termos"
},
new StudentData()
{
name = "Ali"
},
new StudentData()
{
name = "Termos"
}
};
var viewmodel = new CourseStudentsViewModel();
viewmodel.Course = kurs;
viewmodel.Students = ogrenciler;
return(View(viewmodel));
}
public IActionResult Index()
{
var kurs = new Course()
{
Id = 1, Name = "Komple Uygulamalı Web Geliştirme Eğitimi"
};
var ogrenciler = new List <Student>()
{
new Student()
{
Name = "Ahmet"
},
new Student()
{
Name = "Ayşe"
},
new Student()
{
Name = "Mehmet"
},
new Student()
{
Name = "Fatma"
}
};
var viewmodel = new CourseStudentsViewModel();
viewmodel.Course = kurs;
viewmodel.Students = ogrenciler;
return(View(viewmodel));
}
public async Task <IActionResult> Enrollment(string searchString)
{
IQueryable <Enrollment> enrollments = _context.Enrollment.AsQueryable();
if (!string.IsNullOrEmpty(searchString))
{
enrollments = enrollments.Where(s => s.Course.FirstTeacher.FirstName.Contains(searchString) || s.Course.SecondTeacher.FirstName.Contains(searchString));
}
enrollments = enrollments.Include(m => m.Course).Include(m => m.Student);
var teachercourseVM = new CourseStudentsViewModel
{
Enrollments = await enrollments.ToListAsync()
};
return(View(teachercourseVM));
}
// GET: Student
public async Task <IActionResult> Index(string searchString)
{
IQueryable <Enrollment> enrollments = _context.Enrollment.AsQueryable();
if (!string.IsNullOrEmpty(searchString))
{
enrollments = enrollments.Where(s => s.Student.FirstName.Contains(searchString));
}
enrollments = enrollments.Include(m => m.Course).Include(m => m.Student);
if (enrollments == null)
{
return(NotFound());
}
var StudentsVM = new CourseStudentsViewModel
{
Enrollments = await enrollments.ToListAsync()
};
return(View(StudentsVM));;
}
public async Task <IActionResult> GetStudentsByCourse(int id, string enrollmentYear)
{
IQueryable <int> year = _context.Enrollment.OrderBy(m => (int)m.Year).Select(m => (int)m.Year).Distinct();
IQueryable <Course> courses = _context.Course.AsQueryable();
IQueryable <Enrollment> enrollments = _context.Enrollment.Where(m => m.CourseId == id);
if (!string.IsNullOrEmpty(enrollmentYear))
{
enrollments = enrollments.Where(x => x.Year.ToString() == enrollmentYear);
}
courses = courses.Where(m => m.id == id)
.Include(m => m.Students).ThenInclude(m => m.Student);
var viewModel = new CourseStudentsViewModel
{
Years = new SelectList(await year.ToListAsync()),
Courses = await courses.ToListAsync(),
Enrollments = await enrollments.ToListAsync()
};
return(View(viewModel));
}
