public JsonResult AllDefaulterStudents()
{
//List<int?> DefaulterStudentIds = new List<int?>();
//var StudentsIds = from student in db.StudentFeeMonths
// group student by student.StudentId into grp
// where grp.Count() == 1 && grp.Any(x => x.FeePayable != 0)
// select grp.Key;
//var result1 = (from std in db.AspNetStudents
// join usr in db.AspNetUsers on std.StudentID equals usr.Id
// join fee_mon in db.StudentFeeMonths on std.Id equals fee_mon.StudentId
// where StudentsIds.Contains(fee_mon.StudentId)
// select new
// {
// usr.Name,
// usr.PhoneNumber,
// usr.Email,
// usr.UserName,
// std.AspNetClass.ClassName,
// fee_mon.Months,
// fee_mon.Status,
// fee_mon.FeePayable,
// fee_mon.StudentId,
// }).ToList();
//var FindDefaulterStudent = db.DefaulterStudents().ToList();
//DefaulterStudentIds.AddRange(StudentsIds);
//foreach (var student in FindDefaulterStudent)
//{
// DateTime studentDateTime = Convert.ToDateTime(student.IssueDate);
// int TotalDays = DateTime.Now.Subtract(studentDateTime).Days;
// if (TotalDays > 30)
// {
// DefaulterStudentIds.Add(student.StudentId);
// }
//}
//var DefaulterStudentsData = (from std in db.AspNetStudents
// join usr in db.AspNetUsers on std.StudentID equals usr.Id
// join fee_mon in db.StudentFeeMonths on std.Id equals fee_mon.StudentId
// where DefaulterStudentIds.Contains(fee_mon.StudentId)
// group fee_mon by fee_mon.StudentId into grp
// select new
// {
// grp
// }).ToList();
//db.AspNetStudents.Where(x=> x.c)
// var min_payable = result1.Where(x => x.FeePayable = min(x.FeePayable));
// var results = DefaulterStudentsData.GroupBy(x => x.StudentId).Select(x => x);
//var StudentsIdsMoreThanOne = from student in db.StudentFeeMonths
// group student by student.StudentId into grp
// where grp.Count() < 1 && grp.Any(x => x.FeePayable != 0)
// select grp.Key;
// return Json(result1, JsonRequestBehavior.AllowGet);
var result = db.DefaulterStudents().ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
