// The return type can be changed to IEnumerable, however to support // paging and sorting, the following parameters must be added: // int maximumRows // int startRowIndex // out int totalRowCount // string sortByExpression public IQueryable courseGrid_GetData() { PennCoursesEntities1 db = new PennCoursesEntities1(); string sort = Request.QueryString["sort"]; string asc = Request.QueryString["ASC"]; var query = db.course_evals.Select(s => s); if (sort.Equals("sort1") && asc.Equals("true")) { query = query.OrderBy(q => q.Difficulty); } else if (sort.Equals("sort1") && asc.Equals("false")) { query = query.OrderByDescending(q => q.Difficulty); } else if (sort.Equals("sort2") && asc.Equals("true")) { query = query.OrderBy(q => q.CourseQuality); } else if (sort.Equals("sort2") && asc.Equals("false")) { query = query.OrderByDescending(q => q.CourseQuality); } return(query); }
// The return type can be changed to IEnumerable, however to support // paging and sorting, the following parameters must be added: // int maximumRows // int startRowIndex // out int totalRowCount // string sortByExpression public IQueryable searchGrid_GetData() { PennCoursesEntities1 db = new PennCoursesEntities1(); string keyWord = Request.QueryString["keyword"]; if (!String.IsNullOrEmpty(keyWord)) { var query = db.course_evals.Where(c => c.InstructorName.Contains(keyWord) || c.CourseName.Contains(keyWord)); return(query); } return(null); }
// The return type can be changed to IEnumerable, however to support // paging and sorting, the following parameters must be added: // int maximumRows // int startRowIndex // out int totalRowCount // string sortByExpression public IQueryable instructorGrid_GetData() { PennCoursesEntities1 db = new PennCoursesEntities1(); var query = from s in db.course_evals group s.InstructorQuality by s.InstructorName into ins select new { Instructor = ins.Key, Average = ins.Average(), CourseNumber = ins.Count() }; query = query.OrderByDescending(q => q.Average); return(query); }
// The return type can be changed to IEnumerable, however to support // paging and sorting, the following parameters must be added: // int maximumRows // int startRowIndex // out int totalRowCount // string sortByExpression public IQueryable courseGrid_GetData() { PennCoursesEntities1 db = new PennCoursesEntities1(); var query = from s in db.course_evals group new { s.CourseQuality, s.StudentNumber } by s.CourseName into crs select new { Course = crs.Key, Average = crs.Average(s => s.CourseQuality), CourseNumber = crs.Count(), AverageSNum = crs.Average(s => s.StudentNumber) }; query = query.OrderByDescending(q => q.Average); return(query); }