public IHttpActionResult GetListStudentInClass(ExportStudentViewModel studentViewModel)
{
var listStudentHaveClass = _dbContext.ClassStudent.Where(a => a.YearId == studentViewModel.YearId && a.ClassId == studentViewModel.ClassId).AsEnumerable();
var student = _dbContext.Students.Where(a => listStudentHaveClass.Any(s => s.StudentId == a.Id)).AsEnumerable();
//var listStudent = _dbContext.Students.Where(i => !listStudentHaveClass.Any(a=>a.StudentId==i.Id)).AsQueryable();
return(Ok(student));
}
public ActionResult ExportCSV(ExportStudentViewModel exportStudentViewModel)
{
try
{
var stream = new MemoryStream();
var writer = new StreamWriter(stream);
var csv = new CsvWriter(writer);
csv.WriteRecords(db.Students.Include("ApplicationUser").Include("Parent").AsEnumerable());
writer.Flush();
stream.Position = 0;
TempData["Feedback"] = "Xuất file thành công";
return(File(stream, "text/csv", "export.csv"));
}
catch (Exception ex)
{
log.Error(ex);
TempData["Feedback"] = ex.Message;
return(RedirectToAction("Index"));
}
}