/// <summary> /// Gets the list of data for use by the jqgrid plug-in /// </summary> public IActionResult OnGetGridData(string sidx, string sord, int _page, int rows, bool isforJqGrid = true) { int totalRecords = CourseEnrollment.GetRecordCount(); int startRowIndex = ((_page * rows) - rows); List <CourseEnrollment> objCourseEnrollmentCol = CourseEnrollment.SelectSkipAndTake(rows, startRowIndex, sidx + " " + sord); int totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows); if (objCourseEnrollmentCol is null) { return(new JsonResult("{ total = 0, page = 0, records = 0, rows = null }")); } var jsonData = new { total = totalPages, _page, records = totalRecords, rows = ( from objCourseEnrollment in objCourseEnrollmentCol select new { id = objCourseEnrollment.EnrollmentId, cell = new string[] { objCourseEnrollment.EnrollmentId.ToString(), objCourseEnrollment.CourseName.ToString(), objCourseEnrollment.StudentName.ToString(), objCourseEnrollment.Comments } }).ToArray() }; return(new JsonResult(jsonData)); }
public void GetData(string sidx, string sord, int?_page) { int rows = Functions.GetGridNumberOfRows(); int numberOfPagesToShow = Functions.GetGridNumberOfPagesToShow(); int currentPage = _page is null ? 1 : Convert.ToInt32(_page); int startRowIndex = ((currentPage * rows) - rows); int totalRecords = CourseEnrollment.GetRecordCount(); int totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows); List <CourseEnrollment> objCourseEnrollmentCol = CourseEnrollment.SelectSkipAndTake(rows, startRowIndex, sidx + " " + sord); // fields and titles string[,] fieldNames = new string[, ] { { "EnrollmentId", "Enrollment Id" }, { "CourseName", "Course Name" }, { "StudentName", "Student Name" }, { "Comments", "Comments" } }; // assign properties CourseEnrollmentData = objCourseEnrollmentCol; CourseEnrollmentFieldNames = fieldNames; TotalPages = totalPages; CurrentPage = currentPage; FieldToSort = String.IsNullOrEmpty(sidx) ? "EnrollmentId" : sidx; FieldSortOrder = String.IsNullOrEmpty(sord) ? "asc" : sord; FieldToSortWithOrder = String.IsNullOrEmpty(sidx) ? "EnrollmentId" : (sidx + " " + sord).Trim(); NumberOfPagesToShow = numberOfPagesToShow; StartPage = Functions.GetPagerStartPage(currentPage, numberOfPagesToShow, totalPages); EndPage = Functions.GetPagerEndPage(StartPage, currentPage, numberOfPagesToShow, totalPages); }
/// <summary> /// Gets the list of data for use by the jqgrid plug-in /// </summary> public IActionResult OnGetGridDataGroupedByCourseName(string sidx, string sord, int _page, int rows) { // using a groupField in the jqgrid passes that field // along with the field to sort, remove the groupField string groupBy = "CourseName asc, "; sidx = sidx.Replace(groupBy, ""); int totalRecords = CourseEnrollment.GetRecordCount(); int startRowIndex = ((_page * rows) - rows); List <CourseEnrollment> objCourseEnrollmentCol = CourseEnrollment.SelectSkipAndTake(rows, startRowIndex, sidx + " " + sord); int totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows); if (objCourseEnrollmentCol is null) { return(new JsonResult("{ total = 0, page = 0, records = 0, rows = null }")); } var jsonData = new { total = totalPages, _page, records = totalRecords, rows = ( from objCourseEnrollment in objCourseEnrollmentCol select new { id = objCourseEnrollment.EnrollmentId, cell = new string[] { objCourseEnrollment.EnrollmentId.ToString(), objCourseEnrollment.CourseName.ToString(), objCourseEnrollment.StudentName.ToString(), objCourseEnrollment.Comments, objCourseEnrollment.CourseNameNavigation.CourseName } }).ToArray() }; return(new JsonResult(jsonData)); }
/// <summary> /// Shows how to get the total number of records /// </summary> private void GetRecordCount() { // get the total number of records in the CourseEnrollment table int totalRecordCount = CourseEnrollment.GetRecordCount(); }