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)); }