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